.NET (Core and Framework)

1. Read the question carefully
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
4. If the question is inappropriate then click the 'vote to remove message' button

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
   
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
   
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
   
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
   
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
   
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
   
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
   
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
   
   
9. Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
   
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
    
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
    
    
12. No advertising or soliciting.
    
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

@Html.Raw(rec.MailBodyHtml)

<div>
    <div class="container">
        <div class="row">
            <div class="col-md-12">
                <div class="panel panel-default">
                    <div style="text-align:right;padding: 5px 5px 0 0;font-size: 14px;">
                        
                        <a href="#" class="text-decoration-none" onclick="printDivContent();">
                            Imprimer 
                            
                        </a>
                    </div>

                    <div id="printContent">
                        @foreach (var rec in Model)

                        {
                            @Html.Raw(rec.MailBodyHtml)
                        }
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="tab-content">
    <!--Start Historique Email-->
    <div id="Historique_Email" class="tab-pane active">
        <div class="sf-bs-data-table">
            <div class="table-responsive">
                <table class="table table-striped table-bordered example-dt-table" style="width:100%">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Sujet</th>
                            <th>Nombres</th>
                            <th>Nom</th>
                            <th>Email</th>
                            <th>Type</th>
                        </tr>
                    </thead>
                    <tbody>
                        @{
                            //foreach (var rec in Model.ReceivedAlerts.OrderBy(c => c.Date))
                            //foreach (var rec in Model.ReceivedAlerts.Where(t => t.Email != null))
                            foreach (var rec in Model)

                            {
                                <tr>
                                    <td>@rec.Date.ToString("dd-MM-yyyy hh:ss")</td>
                                    <td>
                            
                                    <a href="@Url.Action("BodyHtml", "Entreprise", new { Id = rec.UserId })" target="_blank"> @rec.MailSubject </a>
                                    </td>
                                    <td>@rec.Nb</td>
                                    <td>@rec.NomAlerte</td>
                                    <td>@rec.Email</td>
                                    <td>@rec.TypeAlerte</td>
                                </tr>
                            }
                        }
                    </tbody>
                </table>
            </div>
        </div>
    </div>

Hello all.

I need to create a gantt chart using data from employee table. It need to display the period of time, start date, end date and the name of the task. 

Can someone help me with this?

(Please, i`m in the last year of college and i need to finish it in time )

I have created tables using ASP.NET Core Identity. I need to refer my `AspNetUser` table to my `Job` table. I have created a `CustomIdentity` class which inherits from `IdentityUser`.

This is my code:

    using Microsoft.AspNetCore.Identity;

    namespace InventoryManagement.Models
    {
        public class CustomIdentity :IdentityUser
        {
            public string  IsEngineer { get; set; }
            public string  authpassword { get; set; }
        }
    }

And this is my `DbContext` class for `IdentityDbContext`:

    using Microsoft.AspNetCore.Identity;
    using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
    using Microsoft.EntityFrameworkCore;

    namespace InventoryManagement.Models.Data
    {
        public class AuthDbContext : IdentityDbContext<CustomIdentity>
        {
            public AuthDbContext(DbContextOptions<AuthDbContext> options) :base(options)
            {
            }
        }
    }

`ASPNETUser` table got created and I am able to insert values into it using `UserManager` to register users. I need to refer this user in my Job table. And here is my code for `Jobdbcontext` where I declare all my other tables:

    using Microsoft.EntityFrameworkCore;

    namespace InventoryManagement.Models.Data
    {
        public class JobDBcontext : DbContext
        {
           public JobDBcontext(DbContextOptions<JobDBcontext> options) : base(options) 
           {
           }

           public DbSet<Job> Jobs { get; set; }
           public DbSet<Customer> Customers { get; set; }
           public DbSet<JobType> Jobtype { get; set; }
           public DbSet<ManufacturingBay> Manufacturingbay { get; set; }
           public DbSet<ProjectCategory> Projectcategory { get; set; }
           public DbSet<Currency> Currency { get; set; }
           public DbSet<Category> ItemCategory { get; set; }
           public DbSet<Budget> ItemBudget { get; set; }
           public DbSet<SubCategory> ItemSubcategory { get; set; }
           public DbSet<ItemMaster> ItemMaster { get; set; }
           public DbSet<Bom> Bom { get; set; }
           public DbSet<Test> Test { get; set; }
           public DbSet<UOM> UomMaster { get; set; }
           public DbSet<PR> PR { get; set; }
           public DbSet<PRDetails> PRDetails { get; set; }
           public DbSet<Supplier> Supplier { get; set; }
           public DbSet<Purchase> Purchase { get; set; }
           public DbSet<PurchaseDetails> PurchaseDetails { get; set; }

           protected override void OnModelCreating(ModelBuilder modelBuilder)
           {
                if (modelBuilder == null)
                {
                    throw new ArgumentNullException(nameof(modelBuilder));
                }

                modelBuilder.Entity<JobType>().HasKey(jt => jt.Jobtypeid);
                modelBuilder.Entity<ProjectCategory>().HasKey(jt => jt.Pid);
                modelBuilder.Entity<Currency>().HasKey(jt => jt.cid);
                modelBuilder.Entity<Bom>().HasKey(jt => jt.BID);

                modelBuilder.Entity<Budget>()
                            .HasKey(b => b.ID);

                modelBuilder.Entity<Category>()
                    .HasKey(c => c.CategoryId);
                modelBuilder.Entity<SubCategory>()
                    .HasKey(s => s.SubCategoryId);
                 modelBuilder.Entity<ItemMaster>()
                    .HasKey(i => i.itemid);
                modelBuilder.Entity<UOM>()
                  .HasKey(i => i.uid);
                // Configure relationships
                modelBuilder.Entity<Budget>()
              .HasMany(b => b.categories)
              .WithOne(c => c.Budget)
              .OnDelete(DeleteBehavior.Cascade);
                modelBuilder.Entity<Category>()
                    .HasMany(c => c.SubCategories)
                    .WithOne(i => i.category)
                     .OnDelete(DeleteBehavior.Cascade);

                //  modelBuilder.Entity<SubCategory>()
                //      .HasMany(s => s.ItemMasters)
                //      .WithOne(i => i.subcategory)
                //      .HasForeignKey(i => i.category)
                //      .OnDelete(DeleteBehavior.Cascade);

                // Other configurations for your entity can go here

                //modelBuilder.Entity<PR>()
                //              .HasKey(p => p.Prid);

                //modelBuilder.Entity<PRDetails>()
                //    .HasKey(d => d.Prtblid);

                //modelBuilder.Entity<PRDetails>()
                //    .Property(d => d.Prid);  // Ensure Prid property is properly configured, adjust as needed

                //modelBuilder.Entity<PRDetails>()
                //    .HasOne(d => d.PR)
                //    .WithMany(p => p.PRDetails)
                //    .HasForeignKey(d => d.Prid)
                //    .OnDelete(DeleteBehavior.Restrict); // or specify other actions as needed

                // Additional configurations for other entities and relationships

                modelBuilder.Entity<PR>()
                  .HasKey(p => p.Prid);

                modelBuilder.Entity<PRDetails>()
                    .HasKey(d => d.PrDetailId);

                modelBuilder.Entity<PRDetails>()
                    .HasOne(d => d.PR)
                    .WithMany(p => p.PRDetails)
                    .HasForeignKey(d => d.Prid)
                    .OnDelete(DeleteBehavior.NoAction); // Change this to NoAction or other options

                modelBuilder.Entity<PRDetails>()
                    .HasOne(d => d.Bom)
                    .WithMany() // Assuming Bom doesn't have a navigation property back to PRDetails
                    .HasForeignKey(d => d.Bomid)
                    .OnDelete(DeleteBehavior.Cascade);

                base.OnModelCreating(modelBuilder);

                modelBuilder.Entity<Purchase>()
                 .HasKey(p => p.POID);

                modelBuilder.Entity<PurchaseDetails>()
                    .HasKey(d => d.potblid);

                modelBuilder.Entity<PurchaseDetails>()
                    .HasOne(d => d.Purchase)
                    .WithMany(p => p.PurchaseDetails)
                    .HasForeignKey(d => d.POID)
                    .OnDelete(DeleteBehavior.NoAction); // Change this to NoAction or other options

                modelBuilder.Entity<PurchaseDetails>()
                    .HasOne(d => d.prdetails)
                    .WithMany() // Assuming Bom doesn't have a navigation property back to PRDetails
                    .HasForeignKey(d => d.PrDetailId)
                    .OnDelete(DeleteBehavior.Cascade);
                base.OnModelCreating(modelBuilder);
                modelBuilder.Entity<Job>()
               .HasOne(j => j.User)
               .WithMany()
               .HasForeignKey(j => j.UserId)
               .IsRequired();
            }
        }
    }

This is my `Job` model where I am referencing my CustomIdentity.

    namespace InventoryManagement.Models
    {
        public class Job
        {
            public int Jobsequenceno { get; set; }
            public int JobId { get; set; }

            public string JobName { get; set; } 
      
            public int Qty { get; set; }
            public Customer Customer { get; set; }

            public DateTime JobDate { get; set; }
            public JobType JobType { get; set; }

            public ManufacturingBay ManufacturingBay { get; set; }
            public ProjectCategory Projectcategory { get; set; }
            public Currency currency { get; set; }
            public Double JobRate { get; set; }
            public Double Ordervalue { get; set; }
            public Double Ordervalueinbasecurrency { get; set; }

            public string  JobDescription { get; set; }
            public string Paymentterms { get; set; }
            public string Deliveryterms { get; set; }

            public string UserId { get; set; }
            public CustomIdentity User { get; set; }
        }
    }

Upon running migrations of 2 `DbContext` tables are created ..but upon running migration of JobDBcontext another class called customidentity is created which has exactly same column like my ASPNetUser and my job table is referring to that class.

    ALTER TABLE [dbo].[Jobs] WITH CHECK 
        ADD CONSTRAINT [FK_Jobs_CustomIdentity_UserId] 
            FOREIGN KEY([UserId]) REFERENCES [dbo].[CustomIdentity] ([Id])
            ON DELETE CASCADE  

I want the Job  table to refer to the `ASPNETUSER` table which is having value instead of this CustomIdentity table.... I am able to insert user data to Job table.but upon listing job I am referring to `CustomIdentity` which is showing null..

     [HttpGet("List")]
     public async Task<IActionResult> List()
     {
         // use dbContext to read the tags
         var Joblist = await jobdbcontext.Jobs.Include(j => j.Customer).Include(j => j.JobType).Include(j => j.ManufacturingBay).
             Include(j => j.Projectcategory).
              Include(j => j.CustomIdentity).
              Include(j => j.currency).
         Include(j =>j.User).
             ToListAsync();
         return View(Joblist);
     }

How to resolve this?so that my Job table will refer ASPNetUser table which is having value instead of CustomIdentity table.CustomIdentity model is created to add extra columns in my ASPNetUser table.I am new to this ..can anyone help on this ?