public ActionResult CreateForm(formscreator formCreated) { db.formscreators.Add(formCreated); db.SaveChanges(); System.Web.HttpContext.Current.Session["SelectedFormId"] = formCreated.FormsCreatorID; return(Json(new { success = true })); }
public ActionResult SaveFormData(SaveForm formData) { if (formData.SaveAllProperties == 0) { var getFormsPrintable = db.forms_printable.Where(x => x.PropertyID == formData.PropertyID && x.FormCreatorID == formData.FormCreatorID).FirstOrDefault(); // Insert if (getFormsPrintable == null) { if (formData.FormCreatorID == 2) { // Lease Agreement var data1 = formData.Form.Substring(0, 64000); var data2 = formData.Form.Substring(64001); // First Data forms_printable fp1 = new forms_printable(); fp1.Form = data1; fp1.FormCreatorID = 2; fp1.PropertyID = formData.PropertyID; fp1.Form_Name = "Lease_Agreement"; db.forms_printable.Add(fp1); db.SaveChanges(); // Second Data forms_printable fp2 = new forms_printable(); fp2.Form = data2; fp2.FormCreatorID = 2; fp2.PropertyID = formData.PropertyID; fp2.Form_Name = "Lease_Agreement"; db.forms_printable.Add(fp2); db.SaveChanges(); } else { forms_printable fp = new forms_printable(); // Get Form Name var getFormName = db.formscreators.Where(x => x.FormsCreatorID == formData.FormCreatorID).FirstOrDefault(); fp.Form = formData.Form; fp.FormCreatorID = formData.FormCreatorID; fp.PropertyID = formData.PropertyID; fp.Form_Name = getFormName.FormName; db.forms_printable.Add(fp); db.SaveChanges(); } } // Update else { if (formData.FormCreatorID == 2) { // Lease Agreement var data1 = formData.Form.Substring(0, 64000); var data2 = formData.Form.Substring(64001); var getLeaseAgreement = db.forms_printable.Where(x => x.PropertyID == formData.PropertyID && x.FormCreatorID == 2).ToList(); int count = 0; foreach (var lease in getLeaseAgreement) { if (count == 0) { lease.Form = data1; db.SaveChanges(); } else { lease.Form = data2; db.SaveChanges(); } count++; } } else { getFormsPrintable.Form = formData.Form; db.SaveChanges(); } } } else { // All the Company Properties var companyID = (from p in db.properties where p.PropertyID == formData.PropertyID select new { p.CompanyID }).FirstOrDefault(); var getProperties = db.properties.Where(p => p.CompanyID == companyID.CompanyID && p.Active == 0).ToList(); foreach (var property in getProperties) { int formsCreatorID = (int)formData.FormCreatorID; // Get Form Name var getFormName = db.formscreators.Where(x => x.FormsCreatorID == formData.FormCreatorID).FirstOrDefault(); // 12 defaults if (formsCreatorID > 12) { var getFormsCreator = db.formscreators.Where(x => x.PropertyID == property.PropertyID && x.FormsCreatorID == formData.FormCreatorID).FirstOrDefault(); if (getFormsCreator == null) { formscreator fc = new formscreator(); fc.FormName = getFormName.FormName; fc.PropertyID = property.PropertyID; db.formscreators.Add(fc); db.SaveChanges(); formsCreatorID = fc.FormsCreatorID; } else { formsCreatorID = getFormsCreator.FormsCreatorID; } } var getFormsPrintable = db.forms_printable.Where(x => x.PropertyID == property.PropertyID && x.FormCreatorID == formsCreatorID).FirstOrDefault(); if (getFormsPrintable == null) { if (formsCreatorID == 2) { // Lease Agreement var data1 = formData.Form.Substring(0, 64000); var data2 = formData.Form.Substring(64001); // First Data forms_printable fp1 = new forms_printable(); fp1.Form = data1; fp1.FormCreatorID = 2; fp1.PropertyID = property.PropertyID; fp1.Form_Name = "Lease_Agreement"; db.forms_printable.Add(fp1); db.SaveChanges(); // Second Data forms_printable fp2 = new forms_printable(); fp2.Form = data2; fp2.FormCreatorID = 2; fp2.PropertyID = property.PropertyID; fp2.Form_Name = "Lease_Agreement"; db.forms_printable.Add(fp2); db.SaveChanges(); } else { forms_printable fp = new forms_printable(); fp.Form = formData.Form; fp.FormCreatorID = formsCreatorID; fp.PropertyID = property.PropertyID; fp.Form_Name = getFormName.FormName; db.forms_printable.Add(fp); db.SaveChanges(); } } else { if (formsCreatorID == 2) { // Lease Agreement var data1 = formData.Form.Substring(0, 64000); var data2 = formData.Form.Substring(64001); var getLeaseAgreement = db.forms_printable.Where(x => x.PropertyID == property.PropertyID && x.FormCreatorID == 2).ToList(); int count = 0; foreach (var lease in getLeaseAgreement) { if (count == 0) { lease.Form = data1; db.SaveChanges(); } else { lease.Form = data2; db.SaveChanges(); } count++; } } else { getFormsPrintable.Form = formData.Form; db.SaveChanges(); } } } } System.Web.HttpContext.Current.Session["SelectedFormId"] = formData.FormCreatorID; return(Json(new { success = true })); }