public string EditTemplate(TemplateModel model) { int TFDID = model.TemplateID; int TemplateID = model.FormID; string template_Name = model.FormName; string table_Name = model.DataFrom; string template_FileName = model.Template_FileName; string template_Url = model.Template_Url; string templatedetail_Name = model.TemplateDetail_Name; string Message = "OK"; try { using (SysContext db = new SysContext()) { fl_FormTemplate entity_fl_FormTemplate = null; if (TFDID != 0) { entity_fl_FormTemplate = db.fl_FormTemplate.Single(d => d.TemplateID == TFDID); entity_fl_FormTemplate.Template_Name = templatedetail_Name; entity_fl_FormTemplate.Template_FileName = template_FileName; entity_fl_FormTemplate.Template_Url = template_Url; entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID; entity_fl_FormTemplate.ModifiedTime = DateTime.Now; entity_fl_FormTemplate.ResetUpdated(); } else { entity_fl_FormTemplate = new fl_FormTemplate(); entity_fl_FormTemplate.FormID = TemplateID; entity_fl_FormTemplate.Template_Name = templatedetail_Name; entity_fl_FormTemplate.Template_FileName = template_FileName; entity_fl_FormTemplate.Template_Url = template_Url; entity_fl_FormTemplate.CreatedUser = LoginInfo.UserID; entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID; entity_fl_FormTemplate.ResetCreated(); db.fl_FormTemplate.Add(entity_fl_FormTemplate); } fl_Form entity_fl_Form = db.fl_Form.Single(t => t.FormID == entity_fl_FormTemplate.FormID); entity_fl_Form.FormName = template_Name; entity_fl_Form.DataFrom = table_Name; entity_fl_Form.ModifiedUser = LoginInfo.UserID; entity_fl_Form.ModifiedTime = DateTime.Now; entity_fl_Form.ResetUpdated(); db.SaveChanges(); } } catch { Message = "Error"; } return(Message); }
public ActionResult SaveTemplate() { var FormID = Convert.ToInt32(Request["FormID"]); var TemplateDetail_Name = Request["TemplateDetail_Name"]; var TemplateID = Request["TemplateID"]; var Template_Url = Request["Template_Url"]; var Template_FileName = Request["Template_FileName"]; var Temp = TemplateID.Split(','); var TempName = TemplateDetail_Name.Split(','); var TempFileName = Template_FileName.Split(','); var TempUrl = Template_Url.Split(','); string Message = "OK"; try { using (SysContext db = new SysContext()) { for (var i = 0; i < Temp.Length; i++) { if (Temp[i] != "") { var tempid = Convert.ToInt32(Temp[i]); var Template = db.fl_FormTemplate.SingleOrDefault(ft => ft.TemplateID.Equals(tempid)); Template.Template_Name = TempName[i]; Template.ResetUpdated(); db.SaveChanges(); } else { if (TempName[i] != "") { fl_FormTemplate FormTemplate = new fl_FormTemplate { FormID = FormID, Template_Name = TempName[i], Template_FileName = TempFileName[i], Template_Url = TempUrl[i], }; FormTemplate.ResetCreated(); db.fl_FormTemplate.Add(FormTemplate); db.SaveChanges(); } } } return(Json(Message, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(Message = e.Message, JsonRequestBehavior.AllowGet)); } }
public string AddTemplate(TemplateModel model) { string template_Name = model.FormName; string table_Name = model.DataFrom; string template_FileName = model.Template_FileName; string template_Url = model.Template_Url; string templatedetail_Name = model.TemplateDetail_Name; string Message = "OK"; using (SysContext db = new SysContext()) { System.Data.Entity.DbContextTransaction tran = db.Database.BeginTransaction(); try { fl_Form entity_fl_Form = db.fl_Form.FirstOrDefault(t => t.FormName == template_Name && t.DataFrom == table_Name); if (entity_fl_Form == null) { entity_fl_Form = new fl_Form(); entity_fl_Form.Companys = ""; entity_fl_Form.FormName = template_Name; entity_fl_Form.DataFrom = table_Name; entity_fl_Form.CreatedUser = LoginInfo.UserID; entity_fl_Form.ModifiedUser = LoginInfo.UserID; entity_fl_Form.ResetCreated(); db.fl_Form.Add(entity_fl_Form); db.SaveChanges(); } fl_FormTemplate entity_fl_FormTemplate = new fl_FormTemplate(); entity_fl_FormTemplate.FormID = entity_fl_Form.FormID; entity_fl_FormTemplate.Template_Name = templatedetail_Name; entity_fl_FormTemplate.Template_FileName = template_FileName; entity_fl_FormTemplate.Template_Url = template_Url; entity_fl_FormTemplate.CreatedUser = LoginInfo.UserID; entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID; entity_fl_FormTemplate.ResetCreated(); db.fl_FormTemplate.Add(entity_fl_FormTemplate); db.SaveChanges(); tran.Commit(); Message = "OK," + entity_fl_Form.FormID; } catch { tran.Rollback(); Message = "Error"; } } return(Message); }