public void saveClass(Dictionary <int, dgvClass_ViewModel> datadgvAdd, Dictionary <int, dgvClass_ViewModel> datadgvUpdate) { using (var dataContext = new AccessDB_DAO()) { int IdClass; try { IdClass = dataContext.Classes.Max(s => s.ID_Class); } catch { IdClass = 0; } foreach (var dataClass in datadgvAdd) { Class data = new Class(); data.ID_Class = ++IdClass; data.Class_Name = dataClass.Value.txtName; data.Start_Time = DateTime.Parse(dataClass.Value.txtStartTime); data.End_Time = DateTime.Parse(dataClass.Value.txtFinishTime); data.Monday = dataClass.Value.cbMonday; data.Tuesday = dataClass.Value.cbTuesday; data.Wednesday = dataClass.Value.cbWednesday; data.Thursday = dataClass.Value.cbThursday; data.Friday = dataClass.Value.cbFriday; data.Saturday = dataClass.Value.cbSarturday; data.Sunday = dataClass.Value.cbSunday; data.Day_Create = DateTime.Now; data.Day_Update = DateTime.MinValue; data.Delete_Flag = false; dataContext.Classes.Add(data); dataContext.SaveChanges(); } foreach (var dataClass in datadgvUpdate) { Class data = dataContext.Classes.FirstOrDefault(s => s.ID_Class == dataClass.Value.ID); data.Class_Name = dataClass.Value.txtName; data.Start_Time = DateTime.Parse(dataClass.Value.txtStartTime); data.End_Time = DateTime.Parse(dataClass.Value.txtFinishTime); data.Monday = dataClass.Value.cbMonday; data.Tuesday = dataClass.Value.cbTuesday; data.Wednesday = dataClass.Value.cbWednesday; data.Thursday = dataClass.Value.cbThursday; data.Friday = dataClass.Value.cbFriday; data.Saturday = dataClass.Value.cbSarturday; data.Sunday = dataClass.Value.cbSunday; data.Day_Update = DateTime.Now; dataContext.Classes.Update(data); dataContext.SaveChanges(); } } }
public void SaveSetting(byte[] arrimage) { using (var db = new AccessDB_DAO()) { if (arrimage != null) { if (db.SettingImage.FirstOrDefault(c => c.key == 1) == null) { db.SettingImage.Add(new StoreSettingImage_Model() { ImageSetting = arrimage }); } else { var x = db.SettingImage.Single(c => c.key == 1); x.ImageSetting = arrimage; } } else { var x = db.SettingImage.Single(c => c.key == 1); x.ImageSetting = null; } db.SaveChanges(); } }
public void deleteClass(int ID) { using (var dataContext = new AccessDB_DAO()) { Class upClass = dataContext.Classes.FirstOrDefault(s => s.ID_Class == ID); upClass.Delete_Flag = true; dataContext.Classes.Update(upClass); dataContext.SaveChanges(); } }
public void EditLevel(Dictionary <string, DateTime> listLevel, int RegisterNumber) { using (var db = new AccessDB_DAO()) { foreach (var i in listLevel) { //Add case if (i.Value != DateTime.MinValue) { int Level_ID = db.Dai_Dans.Where(x => x.Name.Contains(i.Key)).Select(c => c.ID).First(); var LevelUpdate = db.Provide_Dai_Dans.SingleOrDefault(c => c.RegisterNumber == RegisterNumber && c.ID_DAI_DAN == Level_ID); if (LevelUpdate == null) { db.Provide_Dai_Dans.Add(new Provide_DAI_DAN() { RegisterNumber = RegisterNumber, ID_DAI_DAN = Level_ID, Day_Provide = i.Value, Day_Create = DateTime.Now, Delete_FLag = false }); } else { LevelUpdate.Day_Provide = i.Value; LevelUpdate.Delete_FLag = false; LevelUpdate.Day_Update = DateTime.Now; } db.SaveChanges(); } else //Edit case { int Level_ID = db.Dai_Dans.Where(x => x.Name.Contains(i.Key)).Select(c => c.ID).First(); var LevelUpdate = db.Provide_Dai_Dans.SingleOrDefault(c => c.RegisterNumber == RegisterNumber && c.ID_DAI_DAN == Level_ID); if (LevelUpdate != null) { LevelUpdate.Day_Provide = i.Value; LevelUpdate.Delete_FLag = false; LevelUpdate.Day_Update = DateTime.Now; db.SaveChanges(); } } } } }
//Save Class which New Member register //public void SaveRegisterClass(int RegisterNumber, int ClassID, DateTime RegisterDay) //{ // using (var db = new AccessDB_DAO()) // { // db.Learns.Add(new Learn() { ID_Class = ClassID, RegisterNumber = RegisterNumber, Fee_January = 0, Fee_February = 0, Fee_March = 0, Fee_April = 0, Fee_May = 0, Fee_June = 0, Fee_July = 0, Fee_August = 0, Fee_September = 0, Fee_October = 0, Fee_December = 0, Fee_November = 0, RegisterDay = RegisterDay, Day_Create = DateTime.Now, Delete_Flag = false }); // db.SaveChanges(); // } //} public void EditRegisterClass(int RegisterNumber, int ClassID, DateTime RegisterDay) { using (var db = new AccessDB_DAO()) { var classUpdate = db.Fees.Where(c => c.RegisterNumber == RegisterNumber); List <Fee_Model> listFee = new List <Fee_Model>(); listFee = classUpdate.ToList(); foreach (var i in listFee) { i.Day_Update = DateTime.Now; i.ID_Class = ClassID; } db.SaveChanges(); } }
//Save Level Dai Dan Of Member public void SaveLevel(Dictionary <string, DateTime> listLevel, int RegisterNumber) { using (var db = new AccessDB_DAO()) { foreach (var i in listLevel) { if (i.Value != DateTime.MinValue) { int Level_ID = db.Dai_Dans.Where(x => x.Name.Contains(i.Key)).Select(c => c.ID).First(); db.Provide_Dai_Dans.Add(new Provide_DAI_DAN() { RegisterNumber = RegisterNumber, ID_DAI_DAN = Level_ID, Day_Provide = i.Value, Day_Create = DateTime.Now, Delete_FLag = false }); db.SaveChanges(); } } } }
public void EditMember(int RegisterNumber, string SKU, string Name, string Nation, string address, string Phone, DateTime RegisterDay, DateTime Birthday, string Birthplace, DateTime Day_Create, Boolean DeleteFlag, byte[] arrImage) { using (var db = new AccessDB_DAO()) { var MemberUpdate = db.Students.Single(c => c.RegisterNumber == RegisterNumber); MemberUpdate.FullName = Name; MemberUpdate.SKU = SKU; MemberUpdate.Nation = Nation; MemberUpdate.Address = address; MemberUpdate.PhoneNumber = Phone; MemberUpdate.Place_of_Birth = Birthplace; MemberUpdate.Day_of_Birth = Birthday; MemberUpdate.Delete_Flag = DeleteFlag; MemberUpdate.Day_Update = DateTime.Now; MemberUpdate.Image = arrImage; MemberUpdate.Day_Create = RegisterDay; db.SaveChanges(); } }
//Save New Member's Info public void SaveNewMember(string SKU, string Name, string Nation, string address, string Phone, DateTime RegisterDay, DateTime Birthday, string Birthplace, DateTime Day_Create, Boolean DeleteFlag, byte[] arrImage) { using (var db = new AccessDB_DAO()) { if (arrImage == null) { db.Students.Add(new Student() { FullName = Name, SKU = SKU, Nation = Nation, Address = address, PhoneNumber = Phone, Place_of_Birth = Birthplace, Day_Create = RegisterDay, Day_of_Birth = Birthday, Delete_Flag = DeleteFlag }); } else { db.Students.Add(new Student() { Image = arrImage, FullName = Name, SKU = SKU, Nation = Nation, Address = address, PhoneNumber = Phone, Place_of_Birth = Birthplace, Day_Create = RegisterDay, Day_of_Birth = Birthday, Delete_Flag = DeleteFlag }); } db.SaveChanges(); } }
//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); } } }