//lấy dữ liệu public List <Search_Model> GetStudent() { using (var dbContext = new AccessDB_DAO()) { List <Search_Model> datas = new List <Search_Model>(); try { var query = dbContext.Fees.GroupBy(c => new { c.RegisterNumber, c.ID_Class }).Select(g => g.First()); //Minh modified 4/8/2018 foreach (var i in query) { var MemberInfo = dbContext.Students.Single(c => c.RegisterNumber == i.RegisterNumber); var ClassInfo = dbContext.Classes.Single(l => l.ID_Class == i.ID_Class); Search_Model data = new Search_Model(); data.RegisterNumber = i.RegisterNumber; data.SKU = MemberInfo.SKU; data.FullName = MemberInfo.FullName; data.Nation = MemberInfo.Nation; data.Address = MemberInfo.Address; data.PhoneNumber = MemberInfo.PhoneNumber; data.Day_of_Birth = MemberInfo.Day_of_Birth.Date; data.Place_of_birth = MemberInfo.Place_of_Birth; data.Day_Create = MemberInfo.Day_Create.Date; data.class_ID = ClassInfo.ID_Class; data.Class_Name = ClassInfo.Class_Name; data.Image = MemberInfo.Image; //Lấy Mã DAI DAN foreach (var dd in dbContext.Provide_Dai_Dans.Where(s => s.RegisterNumber == i.RegisterNumber)) { var na = dbContext.Dai_Dans.Where(s => s.ID == dd.ID_DAI_DAN).First(); if (na.Name.Equals("Cap6")) { data.DAI_Cap_6 = dd.Day_Provide; } if (na.Name.Equals("Cap5")) { data.DAI_Cap_5 = dd.Day_Provide; } if (na.Name.Equals("Cap4")) { data.DAI_Cap_4 = dd.Day_Provide; } if (na.Name.Equals("Cap3")) { data.DAI_Cap_3 = dd.Day_Provide; } if (na.Name.Equals("Cap2")) { data.DAI_Cap_2 = dd.Day_Provide; } if (na.Name.Equals("Cap1")) { data.DAI_Cap_1 = dd.Day_Provide; } if (na.Name.Equals("DANVN1")) { data.DAN_VN_1 = dd.Day_Provide; } if (na.Name.Equals("DANVN2")) { data.DAN_VN_2 = dd.Day_Provide; } if (na.Name.Equals("DANVN3")) { data.DAN_VN_3 = dd.Day_Provide; } if (na.Name.Equals("DANVN4")) { data.DAN_VN_4 = dd.Day_Provide; } if (na.Name.Equals("DANVN5")) { data.DAN_VN_5 = dd.Day_Provide; } if (na.Name.Equals("DANVN6")) { data.DAN_VN_6 = dd.Day_Provide; } if (na.Name.Equals("DANVN7")) { data.DAN_VN_7 = dd.Day_Provide; } if (na.Name.Equals("DANVN8")) { data.DAN_VN_8 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI1")) { data.DAN_AIKIKAI_1 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI2")) { data.DAN_AIKIKAI_2 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI3")) { data.DAN_AIKIKAI_3 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI4")) { data.DAN_AIKIKAI_4 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI5")) { data.DAN_AIKIKAI_5 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI6")) { data.DAN_AIKIKAI_6 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI7")) { data.DAN_AIKIKAI_7 = dd.Day_Provide; } if (na.Name.Equals("DANAIKIKAI8")) { data.DAN_AIKIKAI_8 = dd.Day_Provide; } } datas.Add(data); } } catch { } return(datas); } }
//public void saveFeeD(List<dgvFee_ViewModel> UpdateFeeD) //{ // using (var dataContext = new AccessDB_DAO()) // { // int r = DateTime.Now.Month; // try // { // foreach (var dataFee in UpdateFeeD) // { // switch (r) // { // case 1: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_January = dataFee.lblmonthHT; // learn.FeeD_February = dataFee.lblmonthHT1P; // learn.FeeD_March = dataFee.lblmonthHT2P; // learn.FeeD_April = dataFee.lblmonthHT3P; // learn.FeeD_May = dataFee.lblmonthHT4P; // learn.FeeD_June = dataFee.lblmonthHT5P; // learn.FeeD_July = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // //Learn learn1 = dataContext.Learns.Where(s => s.RegisterNumber == dataFee.RegisterNumber && s.Day_Create.Year == r - 1 && s.Delete_Flag == false).Last(); // break; // } // case 2: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_January = dataFee.lblmonthHT1A; // learn.FeeD_February = dataFee.lblmonthHT; // learn.FeeD_March = dataFee.lblmonthHT1P; // learn.FeeD_April = dataFee.lblmonthHT2P; // learn.FeeD_May = dataFee.lblmonthHT3P; // learn.FeeD_June = dataFee.lblmonthHT4P; // learn.FeeD_July = dataFee.lblmonthHT5P; // learn.FeeD_August = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 3: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_January = dataFee.lblmonthHT2A; // learn.FeeD_February = dataFee.lblmonthHT1A; // learn.FeeD_March = dataFee.lblmonthHT; // learn.FeeD_April = dataFee.lblmonthHT1P; // learn.FeeD_May = dataFee.lblmonthHT2P; // learn.FeeD_June = dataFee.lblmonthHT3P; // learn.FeeD_July = dataFee.lblmonthHT4P; // learn.FeeD_August = dataFee.lblmonthHT5P; // learn.FeeD_September = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 4: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_January = dataFee.lblmonthHT3A; // learn.FeeD_February = dataFee.lblmonthHT2A; // learn.FeeD_March = dataFee.lblmonthHT1A; // learn.FeeD_April = dataFee.lblmonthHT; // learn.FeeD_May = dataFee.lblmonthHT1P; // learn.FeeD_June = dataFee.lblmonthHT2P; // learn.FeeD_July = dataFee.lblmonthHT3P; // learn.FeeD_August = dataFee.lblmonthHT4P; // learn.FeeD_September = dataFee.lblmonthHT5P; // learn.FeeD_October = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 5: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_February = dataFee.lblmonthHT3A; // learn.FeeD_March = dataFee.lblmonthHT2A; // learn.FeeD_April = dataFee.lblmonthHT1A; // learn.FeeD_May = dataFee.lblmonthHT; // learn.FeeD_June = dataFee.lblmonthHT1P; // learn.FeeD_July = dataFee.lblmonthHT2P; // learn.FeeD_August = dataFee.lblmonthHT3P; // learn.FeeD_September = dataFee.lblmonthHT4P; // learn.FeeD_October = dataFee.lblmonthHT5P; // learn.FeeD_November = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 6: // { // Learn learn = dataContext.Learns.Where(s => s.ID_Learn == dataFee.ID_Learn).Last(); // learn.FeeD_March = dataFee.lblmonthHT3A; // learn.FeeD_April = dataFee.lblmonthHT2A; // learn.FeeD_May = dataFee.lblmonthHT1A; // learn.FeeD_June = dataFee.lblmonthHT; // learn.FeeD_July = dataFee.lblmonthHT1P; // learn.FeeD_August = dataFee.lblmonthHT2P; // learn.FeeD_September = dataFee.lblmonthHT3P; // learn.FeeD_October = dataFee.lblmonthHT4P; // learn.FeeD_November = dataFee.lblmonthHT5P; // learn.FeeD_December = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 7: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_April = dataFee.lblmonthHT3A; // learn.FeeD_May = dataFee.lblmonthHT2A; // learn.FeeD_June = dataFee.lblmonthHT1A; // learn.FeeD_July = dataFee.lblmonthHT; // learn.FeeD_August = dataFee.lblmonthHT1P; // learn.FeeD_September = dataFee.lblmonthHT2P; // learn.FeeD_October = dataFee.lblmonthHT3P; // learn.FeeD_November = dataFee.lblmonthHT4P; // learn.FeeD_December = dataFee.lblmonthHT5P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 8: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_May = dataFee.lblmonthHT3A; // learn.FeeD_June = dataFee.lblmonthHT2A; // learn.FeeD_July = dataFee.lblmonthHT1A; // learn.FeeD_August = dataFee.lblmonthHT; // learn.FeeD_September = dataFee.lblmonthHT1P; // learn.FeeD_October = dataFee.lblmonthHT2P; // learn.FeeD_November = dataFee.lblmonthHT3P; // learn.FeeD_December = dataFee.lblmonthHT4P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 9: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_June = dataFee.lblmonthHT3A; // learn.FeeD_July = dataFee.lblmonthHT2A; // learn.FeeD_August = dataFee.lblmonthHT1A; // learn.FeeD_September = dataFee.lblmonthHT; // learn.FeeD_October = dataFee.lblmonthHT1P; // learn.FeeD_November = dataFee.lblmonthHT2P; // learn.FeeD_December = dataFee.lblmonthHT3P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 10: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_July = dataFee.lblmonthHT3A; // learn.FeeD_August = dataFee.lblmonthHT2A; // learn.FeeD_September = dataFee.lblmonthHT1A; // learn.FeeD_October = dataFee.lblmonthHT; // learn.FeeD_November = dataFee.lblmonthHT1P; // learn.FeeD_December = dataFee.lblmonthHT2P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 11: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_August = dataFee.lblmonthHT3A; // learn.FeeD_September = dataFee.lblmonthHT2A; // learn.FeeD_October = dataFee.lblmonthHT1A; // learn.FeeD_November = dataFee.lblmonthHT; // learn.FeeD_December = dataFee.lblmonthHT1P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 12: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.FeeD_September = dataFee.lblmonthHT3A; // learn.FeeD_October = dataFee.lblmonthHT2A; // learn.FeeD_November = dataFee.lblmonthHT1A; // learn.FeeD_December = dataFee.lblmonthHT; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // } // } // } // catch(Exception ex) // { // MessageBox.Show(ex.Message); // } // } //} //public void saveFee(List<dgvFee_ViewModel> UpdateFee) //{ // using (var dataContext = new AccessDB_DAO()) // { // int r = DateTime.Now.Month; // try // { // foreach (var dataFee in UpdateFee) // { // switch (r) // { // case 1: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_January = dataFee.lblmonthHT; // learn.Fee_February = dataFee.lblmonthHT1P; // learn.Fee_March = dataFee.lblmonthHT2P; // learn.Fee_April = dataFee.lblmonthHT3P; // learn.Fee_May = dataFee.lblmonthHT4P; // learn.Fee_June = dataFee.lblmonthHT5P; // learn.Fee_July = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // //Learn learn1 = dataContext.Learns.Where(s => s.RegisterNumber == dataFee.RegisterNumber && s.Day_Create.Year == r - 1 && s.Delete_Flag == false).Last(); // break; // } // case 2: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_January = dataFee.lblmonthHT1A; // learn.Fee_February = dataFee.lblmonthHT; // learn.Fee_March = dataFee.lblmonthHT1P; // learn.Fee_April = dataFee.lblmonthHT2P; // learn.Fee_May = dataFee.lblmonthHT3P; // learn.Fee_June = dataFee.lblmonthHT4P; // learn.Fee_July = dataFee.lblmonthHT5P; // learn.Fee_August = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 3: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_January = dataFee.lblmonthHT2A; // learn.Fee_February = dataFee.lblmonthHT1A; // learn.Fee_March = dataFee.lblmonthHT; // learn.Fee_April = dataFee.lblmonthHT1P; // learn.Fee_May = dataFee.lblmonthHT2P; // learn.Fee_June = dataFee.lblmonthHT3P; // learn.Fee_July = dataFee.lblmonthHT4P; // learn.Fee_August = dataFee.lblmonthHT5P; // learn.Fee_September = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 4: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_January = dataFee.lblmonthHT3A; // learn.Fee_February = dataFee.lblmonthHT2A; // learn.Fee_March = dataFee.lblmonthHT1A; // learn.Fee_April = dataFee.lblmonthHT; // learn.Fee_May = dataFee.lblmonthHT1P; // learn.Fee_June = dataFee.lblmonthHT2P; // learn.Fee_July = dataFee.lblmonthHT3P; // learn.Fee_August = dataFee.lblmonthHT4P; // learn.Fee_September = dataFee.lblmonthHT5P; // learn.Fee_October = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 5: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_February = dataFee.lblmonthHT3A; // learn.Fee_March = dataFee.lblmonthHT2A; // learn.Fee_April = dataFee.lblmonthHT1A; // learn.Fee_May = dataFee.lblmonthHT; // learn.Fee_June = dataFee.lblmonthHT1P; // learn.Fee_July = dataFee.lblmonthHT2P; // learn.Fee_August = dataFee.lblmonthHT3P; // learn.Fee_September = dataFee.lblmonthHT4P; // learn.Fee_October = dataFee.lblmonthHT5P; // learn.Fee_November = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 6: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_March = dataFee.lblmonthHT3A; // learn.Fee_April = dataFee.lblmonthHT2A; // learn.Fee_May = dataFee.lblmonthHT1A; // learn.Fee_June = dataFee.lblmonthHT; // learn.Fee_July = dataFee.lblmonthHT1P; // learn.Fee_August = dataFee.lblmonthHT2P; // learn.Fee_September = dataFee.lblmonthHT3P; // learn.Fee_October = dataFee.lblmonthHT4P; // learn.Fee_November = dataFee.lblmonthHT5P; // learn.Fee_December = dataFee.lblmonthHT6P; // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 7: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_April = dataFee.lblmonthHT3A; // learn.Fee_May = dataFee.lblmonthHT2A; // learn.Fee_June = dataFee.lblmonthHT1A; // learn.Fee_July = dataFee.lblmonthHT; // learn.Fee_August = dataFee.lblmonthHT1P; // learn.Fee_September = dataFee.lblmonthHT2P; // learn.Fee_October = dataFee.lblmonthHT3P; // learn.Fee_November = dataFee.lblmonthHT4P; // learn.Fee_December = dataFee.lblmonthHT5P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 8: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_May = dataFee.lblmonthHT3A; // learn.Fee_June = dataFee.lblmonthHT2A; // learn.Fee_July = dataFee.lblmonthHT1A; // learn.Fee_August = dataFee.lblmonthHT; // learn.Fee_September = dataFee.lblmonthHT1P; // learn.Fee_October = dataFee.lblmonthHT2P; // learn.Fee_November = dataFee.lblmonthHT3P; // learn.Fee_December = dataFee.lblmonthHT4P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 9: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_June = dataFee.lblmonthHT3A; // learn.Fee_July = dataFee.lblmonthHT2A; // learn.Fee_August = dataFee.lblmonthHT1A; // learn.Fee_September = dataFee.lblmonthHT; // learn.Fee_October = dataFee.lblmonthHT1P; // learn.Fee_November = dataFee.lblmonthHT2P; // learn.Fee_December = dataFee.lblmonthHT3P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 10: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_July = dataFee.lblmonthHT3A; // learn.Fee_August = dataFee.lblmonthHT2A; // learn.Fee_September = dataFee.lblmonthHT1A; // learn.Fee_October = dataFee.lblmonthHT; // learn.Fee_November = dataFee.lblmonthHT1P; // learn.Fee_December = dataFee.lblmonthHT2P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 11: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_August = dataFee.lblmonthHT3A; // learn.Fee_September = dataFee.lblmonthHT2A; // learn.Fee_October = dataFee.lblmonthHT1A; // learn.Fee_November = dataFee.lblmonthHT; // learn.Fee_December = dataFee.lblmonthHT1P; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // case 12: // { // Learn learn = dataContext.Learns.FirstOrDefault(s => s.ID_Learn == dataFee.ID_Learn); // learn.Fee_September = dataFee.lblmonthHT3A; // learn.Fee_October = dataFee.lblmonthHT2A; // learn.Fee_November = dataFee.lblmonthHT1A; // learn.Fee_December = dataFee.lblmonthHT; // // // learn.Day_Update = DateTime.Now; // dataContext.Learns.Update(learn); // dataContext.SaveChanges(); // break; // } // } // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // } //} public void saveFee(Fee_Model dataFee) { using (var dataContext = new AccessDB_DAO()) { try { Fee_Model fee1 = dataContext.Fees.FirstOrDefault(s => s.ID_Class == dataFee.ID_Class && s.RegisterNumber == dataFee.RegisterNumber && s.Month == dataFee.Month && s.Year == dataFee.Year && s.Fee_Type.Equals("Hội Phí") == true); Fee_Model fee2 = dataContext.Fees.FirstOrDefault(s => s.ID_Class == dataFee.ID_Class && s.RegisterNumber == dataFee.RegisterNumber && s.Month == dataFee.Month && s.Year == dataFee.Year && s.Fee_Type.Equals("Phí Khác") == true); if (fee1 == null) { Fee_Model feeadd1 = new Fee_Model(); //int Id = dataContext.Fees.Max(s => s.ID_Learn); //feeadd1.ID_Learn = ++Id; feeadd1.ID_Class = dataFee.ID_Class; feeadd1.RegisterNumber = dataFee.RegisterNumber; feeadd1.Fee_Type = "Hội Phí"; feeadd1.Month = dataFee.Month; feeadd1.Year = dataFee.Year; feeadd1.Fee_Value = dataFee.Fee_Value; feeadd1.Day_Create = DateTime.Now; //feeadd1.Day_Update = DateTime.MinValue; feeadd1.Delete_Flag = false; dataContext.Fees.Add(feeadd1); Fee_Model feeadd2 = new Fee_Model(); feeadd2.ID_Class = dataFee.ID_Class; feeadd2.RegisterNumber = dataFee.RegisterNumber; feeadd2.Fee_Type = "Phí Khác"; feeadd2.Month = dataFee.Month; feeadd2.Year = dataFee.Year; feeadd2.Fee_Value = 0; feeadd2.Day_Create = DateTime.Now; // feeadd2.Day_Update = DateTime.MinValue; feeadd2.Delete_Flag = false; dataContext.Fees.Add(feeadd2); dataContext.SaveChanges(); } else if (fee2 == null) { Fee_Model feeadd1 = new Fee_Model(); // int Id = dataContext.Fees.Max(s => s.ID_Learn); // feeadd1.ID_Learn = ++Id; feeadd1.ID_Class = dataFee.ID_Class; feeadd1.RegisterNumber = dataFee.RegisterNumber; feeadd1.Fee_Type = "Phí Khác"; feeadd1.Month = dataFee.Month; feeadd1.Year = dataFee.Year; feeadd1.Fee_Value = dataFee.Fee_Value; feeadd1.Day_Create = DateTime.Now; // feeadd1.Day_Update = DateTime.MinValue; feeadd1.Delete_Flag = false; dataContext.Fees.Add(feeadd1); dataContext.SaveChanges(); } else if (fee1 != null && fee2 != null) { if (dataFee.Fee_Type.Equals("Hội Phí") == true) { fee1.Fee_Value = dataFee.Fee_Value; fee1.Day_Update = DateTime.Now; dataContext.Fees.Update(fee1); dataContext.SaveChanges(); } else { fee2.Fee_Value = dataFee.Fee_Value; fee2.Day_Update = DateTime.Now; dataContext.Fees.Update(fee2); dataContext.SaveChanges(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }