public string EditMapping(MappingModel model) { string table_Name = model.Table_Name; string FormID = model.FormID; int Approved = model.Approved; int MappingFormID = model.MappingFormID; string Message = "OK"; using (SysContext db = new SysContext()) { try { fl_MappingForm entity_fl_MappingForm = db.fl_MappingForm.Single(d => d.MappingFormID == MappingFormID); if (entity_fl_MappingForm != null) { entity_fl_MappingForm.FormNo = FormID; entity_fl_MappingForm.Table_Name = table_Name; entity_fl_MappingForm.Approved = Approved; entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID; entity_fl_MappingForm.ModifiedTime = DateTime.Now; entity_fl_MappingForm.ResetUpdated(); db.SaveChanges(); } } catch { Message = "Error"; } } return(Message); }
public string AddMapping(MappingModel model) { string table_Name = model.Table_Name; string FormID = model.FormID; int Approved = model.Approved; string Message = "OK"; using (SysContext db = new SysContext()) { System.Data.Entity.DbContextTransaction tran = db.Database.BeginTransaction(); try { fl_MappingForm entity_fl_MappingForm = new fl_MappingForm(); entity_fl_MappingForm.FormNo = FormID; entity_fl_MappingForm.Table_Name = table_Name; entity_fl_MappingForm.Approved = Approved; entity_fl_MappingForm.ApprovedDate = DateTime.Now; entity_fl_MappingForm.TemplateUrl = ""; entity_fl_MappingForm.CreatedUser = LoginInfo.UserID; entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID; entity_fl_MappingForm.ResetCreated(); db.fl_MappingForm.Add(entity_fl_MappingForm); db.SaveChanges(); tran.Commit(); } catch { tran.Rollback(); Message = "Error"; } } return(Message); }