public static int SaveHisDetail(ref HisDetail hd) { _context = new NCPDPContext(new DbContextOptionsBuilder <NCPDPContext>().Options); _context.HisDetails.Add(hd); _context.SaveChanges(); return(hd.DetailID); }
public static int SaveHisHeader(HisHeader FH) { _context = new NCPDPContext(new DbContextOptionsBuilder <NCPDPContext>().Options); _context.HisHeaders.Add(FH); _context.SaveChanges(); return(FH.FileID); }
public static void UpdateHisHeader(HisHeader hh) { _context = new NCPDPContext(new DbContextOptionsBuilder <NCPDPContext>().Options); HisHeader header = _context.HisHeaders.Find(hh.FileID); header.Total_Gross_Amount_Due = hh.Total_Gross_Amount_Due; header.Total_Net_Amount_Due = hh.Total_Net_Amount_Due; header.Total_Patient_Pay_Amount = hh.Total_Patient_Pay_Amount; header.Total_Record_Count = hh.Total_Record_Count; _context.SaveChanges(); }
public static void SaveHisCompound2(ref HisCompound2 hc2) { _context = new NCPDPContext(new DbContextOptionsBuilder <NCPDPContext>().Options); _context.HisCompound2.Add(hc2); _context.SaveChanges(); }