public void UpdateHDM(HDM record)
        {
            var hdm = _context.HDMs.Where(e => e.HDM1 == record.HDM1).FirstOrDefault();

            hdm.Week1          = record.Week1;
            hdm.Week2          = record.Week2;
            hdm.Week3          = record.Week3;
            hdm.Week4          = record.Week4;
            hdm.Week5          = record.Week5;
            hdm.O_Week1        = record.O_Week1;
            hdm.O_Week2        = record.O_Week2;
            hdm.O_Week3        = record.O_Week3;
            hdm.O_Week4        = record.O_Week4;
            hdm.O_Week5        = record.O_Week5;
            hdm.Week1Rate      = record.Week1Rate;
            hdm.Week2Rate      = record.Week2Rate;
            hdm.Week3Rate      = record.Week3Rate;
            hdm.Week4rate      = record.Week4rate;
            hdm.Oweekrate      = record.Oweekrate;
            hdm.oweek2rate     = record.oweek2rate;
            hdm.oweek3rate     = record.oweek3rate;
            hdm.oweek4rate     = record.oweek4rate;
            hdm.oweek5rate     = record.oweek5rate;
            hdm.dailyrate1     = record.dailyrate1;
            hdm.dailyrate2     = record.dailyrate2;
            hdm.dailyrate3     = record.dailyrate3;
            hdm.dailyrate4     = record.dailyrate4;
            hdm.dailyrate5     = record.dailyrate5;
            hdm.hourlyrate1    = record.hourlyrate1;
            hdm.hourlyrate2    = record.hourlyrate2;
            hdm.hourlyrate3    = record.hourlyrate3;
            hdm.hourlyrate4    = record.hourlyrate4;
            hdm.daysworked     = record.daysworked;
            hdm.hoursworked    = record.hoursworked;
            hdm.Overtimeworked = record.Overtimeworked;
            hdm.Total          = record.Total;
            hdm.Week5rate      = record.Week5rate;
            hdm.hourlyrate5    = record.hourlyrate5;

            hdm.InvoiceNet = record.InvoiceNet;
            hdm.Vat        = record.Vat;
            hdm.C2_Fin     = record.C2_Fin;

            hdm.Xtramargin    = record.Xtramargin;
            hdm.Holdmargin    = record.Holdmargin;
            hdm.GrossMargin   = record.GrossMargin;
            hdm.Consultmargin = record.Consultmargin;
            hdm.AdminBonus    = record.AdminBonus;

            _context.Entry(hdm).State = EntityState.Modified;
            _context.SaveChanges();
        }
 public void InsertHDM(HDM record)
 {
     _context.HDMs.Add(record);
     _context.SaveChanges();
 }