public DataSet Edit_data(Edit_AdminMaster EA) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Edit_Form_Field_Master", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@tablename", EA.tablename); _cmd.Parameters.AddWithValue("@Corporate", EA.Corporate); _cmd.Parameters.AddWithValue("@unit", EA.unit); _cmd.Parameters.AddWithValue("@Formcode", EA.Formcode); _cmd.Parameters.AddWithValue("@Formtabcode", EA.Formtabcode); _cmd.Parameters.AddWithValue("@srno", EA.Xmaster); _cmd.Parameters.AddWithValue("@Type", EA.Type); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return _ds; } catch (Exception) { throw; } finally { _cn.Close(); _cn.Dispose(); } }
public ActionResult Edit_Data(Edit_AdminMaster EA) { try { DataSet ds = _objCM.Edit_data(EA); List<CommanMaster> Master = new List<CommanMaster>(); List<CommanMasterCaption> Caption = new List<CommanMasterCaption>(); List<CommanMasterPlaceholder> Placeholder = new List<CommanMasterPlaceholder>(); List<CommanMasterValidation> Validation = new List<CommanMasterValidation>(); List<CommanMasterHelp> Tooltip = new List<CommanMasterHelp>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { Master.Add(new CommanMaster { xmaster = @dr["xmaster"].ToString(), xname = @dr["xname"].ToString(), Corporate = @dr["Corporate"].ToString(), drpCaption = @dr["drpCaption"].ToString(), xlink = @dr["xlink"].ToString(), xcross = @dr["xcross"].ToString(), xcross1 = @dr["xcross1"].ToString(), xcross2 = @dr["xcross2"].ToString(), xcross3 = @dr["xcross3"].ToString(), xcross4 = @dr["xcross4"].ToString(), xreference1 = @dr["xreference1"].ToString(), xreference2 = @dr["xreference2"].ToString(), xreference3 = @dr["xreference3"].ToString(), xreference4 = @dr["xreference4"].ToString(), xreference5 = @dr["xreference5"].ToString(), xreference6 = @dr["xreference6"].ToString(), xdetail = @dr["xdetail"].ToString(), ENTRYCONTROL = @dr["ENTRYCONTROL"].ToString(), SEGMENT = @dr["SEGMENT"].ToString(), MultiSelect1 = @dr["MultiSelect1"].ToString(), MultiSelect2 = @dr["MultiSelect2"].ToString(), MultiSelect3 = @dr["MultiSelect3"].ToString(), MultiSelect4 = @dr["MultiSelect4"].ToString(), MultiSelect5 = @dr["MultiSelect5"].ToString() }); } } var result = Master; if (ds.Tables[1].Rows.Count > 0) { ViewBag.Caption = ds.Tables[1]; foreach (System.Data.DataRow dr in ViewBag.Caption.Rows) { Caption.Add(new CommanMasterCaption { xmastercaption = @dr["xmaster"].ToString(), //SEGMENTcaption = @dr["SEGMENT"].ToString(), Field1caption = @dr["Field1"].ToString(), Field2caption = @dr["Field2"].ToString(), Field3caption = @dr["Field3"].ToString(), Field4caption = @dr["Field4"].ToString(), Field5caption = @dr["Field5"].ToString(), Field6caption = @dr["Field6"].ToString(), Field7caption = @dr["Field7"].ToString(), Field8caption = @dr["Field8"].ToString(), Field9caption = @dr["Field9"].ToString(), Field10caption = @dr["Field10"].ToString(), Field11caption = @dr["Field11"].ToString(), Field12caption = @dr["Field12"].ToString(), Field13caption = @dr["Field13"].ToString(), Field14caption = @dr["Field14"].ToString(), Field15caption = @dr["Field15"].ToString(), Field16caption = @dr["Field16"].ToString(), Field17caption = @dr["Field17"].ToString(), Field18caption = @dr["Field18"].ToString(), Field19caption = @dr["Field19"].ToString(), Field20caption = @dr["Field20"].ToString(), Rating1caption = @dr["Rating1"].ToString(), Rating2caption = @dr["Rating2"].ToString(), Rating3caption = @dr["Rating3"].ToString(), Date1caption = @dr["Date1"].ToString(), Date2caption = @dr["Date2"].ToString(), Date3caption = @dr["Date3"].ToString(), Email1caption = @dr["Email1"].ToString(), Email2caption = @dr["Email2"].ToString(), Email3caption = @dr["Email3"].ToString(), Amountcaption = @dr["Amount"].ToString(), Amount2caption = @dr["Amount2"].ToString(), Amount3caption = @dr["Amount3"].ToString(), Time1caption = @dr["Time1"].ToString(), Time2caption = @dr["Time2"].ToString(), Htmlcaption = @dr["Html"].ToString(), Uploadcaption = @dr["Upload"].ToString(), TextAreacaption = @dr["TextArea"].ToString(), MultiSelect1caption = @dr["MultiSelect1"].ToString(), MultiSelect2caption = @dr["MultiSelect2"].ToString(), MultiSelect3caption = @dr["MultiSelect3"].ToString(), MultiSelect4caption = @dr["MultiSelect4"].ToString(), MultiSelect5caption = @dr["MultiSelect5"].ToString(), }); } } var caption = Caption; if (ds.Tables[2].Rows.Count > 0) { ViewBag.Placeholder = ds.Tables[2]; foreach (System.Data.DataRow dr in ViewBag.Placeholder.Rows) { Placeholder.Add(new CommanMasterPlaceholder { xmaster = @dr["xmaster"].ToString(), Field1 = @dr["Field1"].ToString(), Field2 = @dr["Field2"].ToString(), Field3 = @dr["Field3"].ToString(), Field4 = @dr["Field4"].ToString(), Field5 = @dr["Field5"].ToString(), Field6 = @dr["Field6"].ToString(), Field7 = @dr["Field7"].ToString(), Field8 = @dr["Field8"].ToString(), Field9 = @dr["Field9"].ToString(), Field10 = @dr["Field10"].ToString(), Field11 = @dr["Field11"].ToString(), Field12 = @dr["Field12"].ToString(), Field13 = @dr["Field13"].ToString(), Field14 = @dr["Field14"].ToString(), Field15 = @dr["Field15"].ToString(), Field16 = @dr["Field16"].ToString(), Field17 = @dr["Field17"].ToString(), Field18 = @dr["Field18"].ToString(), Field19 = @dr["Field19"].ToString(), Field20 = @dr["Field20"].ToString(), Rating1 = @dr["Rating1"].ToString(), Rating2 = @dr["Rating2"].ToString(), Rating3 = @dr["Rating3"].ToString(), Date1 = @dr["Date1"].ToString(), Date2 = @dr["Date2"].ToString(), Date3 = @dr["Date3"].ToString(), Email1 = @dr["Email1"].ToString(), Email2 = @dr["Email2"].ToString(), Email3 = @dr["Email3"].ToString(), Amount = @dr["Amount"].ToString(), Amount2 = @dr["Amount2"].ToString(), Amount3 = @dr["Amount3"].ToString(), Time1 = @dr["Time1"].ToString(), Time2 = @dr["Time2"].ToString(), Html = @dr["Html"].ToString(), Upload = @dr["Upload"].ToString(), TextArea = @dr["TextArea"].ToString(), MultiSelect1 = @dr["MultiSelect1"].ToString(), MultiSelect2 = @dr["MultiSelect2"].ToString(), MultiSelect3 = @dr["MultiSelect3"].ToString(), MultiSelect4 = @dr["MultiSelect4"].ToString(), MultiSelect5 = @dr["MultiSelect5"].ToString(), }); } } var placeholder = Placeholder; if (ds.Tables[3].Rows.Count > 0) { ViewBag.avalidation = ds.Tables[3]; foreach (System.Data.DataRow dr in ViewBag.avalidation.Rows) { Validation.Add(new CommanMasterValidation { xmaster = @dr["xmaster"].ToString(), Field1 = @dr["Field1"].ToString(), Field2 = @dr["Field2"].ToString(), Field3 = @dr["Field3"].ToString(), Field4 = @dr["Field4"].ToString(), Field5 = @dr["Field5"].ToString(), Field6 = @dr["Field6"].ToString(), Field7 = @dr["Field7"].ToString(), Field8 = @dr["Field8"].ToString(), Field9 = @dr["Field9"].ToString(), Field10 = @dr["Field10"].ToString(), Field11 = @dr["Field11"].ToString(), Field12 = @dr["Field12"].ToString(), Field13 = @dr["Field13"].ToString(), Field14 = @dr["Field14"].ToString(), Field15 = @dr["Field15"].ToString(), Field16 = @dr["Field16"].ToString(), Field17 = @dr["Field17"].ToString(), Field18 = @dr["Field18"].ToString(), Field19 = @dr["Field19"].ToString(), Field20 = @dr["Field20"].ToString(), Rating1 = @dr["Rating1"].ToString(), Rating2 = @dr["Rating2"].ToString(), Rating3 = @dr["Rating3"].ToString(), Date1 = @dr["Date1"].ToString(), Date2 = @dr["Date2"].ToString(), Date3 = @dr["Date3"].ToString(), Email1 = @dr["Email1"].ToString(), Email2 = @dr["Email2"].ToString(), Email3 = @dr["Email3"].ToString(), Amount = @dr["Amount"].ToString(), Amount2 = @dr["Amount2"].ToString(), Amount3 = @dr["Amount3"].ToString(), Time1 = @dr["Time1"].ToString(), Time2 = @dr["Time2"].ToString(), Html = @dr["Html"].ToString(), Upload = @dr["Upload"].ToString(), TextArea = @dr["TextArea"].ToString(), MultiSelect1 = @dr["MultiSelect1"].ToString(), MultiSelect2 = @dr["MultiSelect2"].ToString(), MultiSelect3 = @dr["MultiSelect3"].ToString(), MultiSelect4 = @dr["MultiSelect4"].ToString(), MultiSelect5 = @dr["MultiSelect5"].ToString(), }); } } var validation = Validation; if (ds.Tables[4].Rows.Count > 0) { ViewBag.Tooltip = ds.Tables[4]; foreach (System.Data.DataRow dr in ViewBag.Tooltip.Rows) { Tooltip.Add(new CommanMasterHelp { xmaster = @dr["xmaster"].ToString(), Field1 = @dr["Field1"].ToString(), Field2 = @dr["Field2"].ToString(), Field3 = @dr["Field3"].ToString(), Field4 = @dr["Field4"].ToString(), Field5 = @dr["Field5"].ToString(), Field6 = @dr["Field6"].ToString(), Field7 = @dr["Field7"].ToString(), Field8 = @dr["Field8"].ToString(), Field9 = @dr["Field9"].ToString(), Field10 = @dr["Field10"].ToString(), Field11 = @dr["Field11"].ToString(), Field12 = @dr["Field12"].ToString(), Field13 = @dr["Field13"].ToString(), Field14 = @dr["Field14"].ToString(), Field15 = @dr["Field15"].ToString(), Field16 = @dr["Field16"].ToString(), Field17 = @dr["Field17"].ToString(), Field18 = @dr["Field18"].ToString(), Field19 = @dr["Field19"].ToString(), Field20 = @dr["Field20"].ToString(), Rating1 = @dr["Rating1"].ToString(), Rating2 = @dr["Rating2"].ToString(), Rating3 = @dr["Rating3"].ToString(), Date1 = @dr["Date1"].ToString(), Date2 = @dr["Date2"].ToString(), Date3 = @dr["Date3"].ToString(), Email1 = @dr["Email1"].ToString(), Email2 = @dr["Email2"].ToString(), Email3 = @dr["Email3"].ToString(), Amount = @dr["Amount"].ToString(), Amount2 = @dr["Amount2"].ToString(), Amount3 = @dr["Amount3"].ToString(), Time1 = @dr["Time1"].ToString(), Time2 = @dr["Time2"].ToString(), Html = @dr["Html"].ToString(), Upload = @dr["Upload"].ToString(), TextArea = @dr["TextArea"].ToString(), MultiSelect1 = @dr["MultiSelect1"].ToString(), MultiSelect2 = @dr["MultiSelect2"].ToString(), MultiSelect3 = @dr["MultiSelect3"].ToString(), MultiSelect4 = @dr["MultiSelect4"].ToString(), MultiSelect5 = @dr["MultiSelect5"].ToString(), }); } } var tooltip = Tooltip; //return Json(result, JsonRequestBehavior.AllowGet); return Json(new { AMaster = result, ACaption = caption, Aplaceholder = placeholder, AValidation = validation, Atooltip = tooltip }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_Data(Edit_AdminMaster EA) { try { DataSet ds = _objDBViewSetup.Edit_data(EA); List<ViewSetup> frmset = new List<ViewSetup>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { frmset.Add(new ViewSetup { srno = dr["SrNo"].ToString(), Corporate = dr["Corporate"].ToString(), Module = dr["Module"].ToString(), Screen = dr["Screen"].ToString(), FormCode = dr["FormCode"].ToString(), TabCode = dr["TabCode"].ToString(), ViewName = dr["ViewName"].ToString(), RecordCountQuery = dr["RecordCountQuery"].ToString(), ColumnQuery = dr["ColumnQuery"].ToString(), WhereQuery = dr["WhereQuery"].ToString(), GroupQuery = dr["GroupQuery"].ToString(), IsMasterView = dr["IsMasterView"].ToString(), MasterTable = dr["MasterTable"].ToString(), }); } } var result = frmset; return Json(result, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_DataColumn(Edit_AdminMaster EA) { try { DataSet ds = _objDBViewSetup.Edit_dataColumn(EA); List<ColumnView> frmColumnView = new List<ColumnView>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { frmColumnView.Add(new ColumnView { srno = dr["SrNo"].ToString(), Corporate = dr["Corporate"].ToString(), ColumnCaption = dr["ColumnCaption"].ToString(), ColumnName = dr["ColumnName"].ToString(), FixedOrder = dr["FixedOrder"].ToString(), Visibility = dr["Visibility"].ToString(), ColumnUpdate = dr["ColumnUpdate"].ToString(), UpdateControl = dr["UpdateControl"].ToString(), UpdateQuery1 = dr["UpdateQuery1"].ToString(), UpdateQuery2 = dr["UpdateQuery2"].ToString(), UpdateQuery3 = dr["UpdateQuery3"].ToString(), UpdateQuery4 = dr["UpdateQuery4"].ToString(), UpdateQuery5 = dr["UpdateQuery5"].ToString(), Attribute1 = dr["Attribute1"].ToString() }); } } var result = frmColumnView; return Json(result, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_Data(Edit_AdminMaster EA) { try { DataSet ds = _objDCFS.Edit_data(EA); List<FrmControlSetup> frmsetup = new List<FrmControlSetup>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { frmsetup.Add(new FrmControlSetup { TabCode = dr["TabCode"].ToString(), SectionCode = dr["SectionCode"].ToString(), Corporate = dr["Corporate"].ToString(), FieldControlLabel = dr["FieldControlLabel"].ToString(), ControlId = dr["ControlId"].ToString(), FieldControlType = dr["FieldControlType"].ToString(), ValidationCode = dr["ValidationCode"].ToString(), PlaceholderText = dr["PlaceholderText"].ToString(), TooltipHelpText = dr["TooltipHelpText"].ToString(), RequiredField = dr["RequiredField"].ToString(), ReqValidationMsg = dr["ReqValidationMsg"].ToString(), ReglarExField = dr["ReglarExField"].ToString(), RegexValidationMsg = dr["RegexValidationMsg"].ToString(), GuidedTourText = dr["GuidedTourText"].ToString(), GuidedTourStepNo = dr["GuidedTourStepNo"].ToString(), FieldOrderNumber = dr["FieldOrderNumber"].ToString(), FieldCaptionName = dr["FieldCaptionName"].ToString(), Srno = dr["Srno"].ToString() }); } } var result = frmsetup; return Json(result, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }