public ActionResult Insert_Data(CommanMaster CM) { try { DataSet result = _objCM.insert_data(CM); if (result != null) { ViewBag.Message = result.Tables[0].Rows[0]["msg"].ToString(); if (result.Tables[0].Rows[0]["Help"].ToString() == "Save" || result.Tables[0].Rows[0]["Help"].ToString() == "Update") { ViewBag.Event = "success"; } else if (result.Tables[0].Rows[0]["Help"].ToString() == "Duplicate") { ViewBag.Event = "error"; } } var result1 = ViewBag.Message; return Json(new { success = result1, Event = ViewBag.Event }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public PartialViewResult _PartialCountry(string ViewId, string MasterCode, string corporate, string Unit, string Location, string Branch, string UserId, string Type) { DataSet dsList = _objCM.bindViewsControls(ViewId, MasterCode, corporate, Unit, Location, Branch, UserId, Type); CommanMaster CV = new CommanMaster(); Views _grid = new Views(); List<ViewsGridHearder> GridHearder = new List<ViewsGridHearder>(); List<ViewsGridColumn> GridColumn = new List<ViewsGridColumn>(); List<Views> lstGrid = new List<Views>(); if (dsList.Tables[0].Rows.Count > 0) { ViewBag.GridHearder = dsList.Tables[0]; ViewBag.GridColumn = dsList.Tables[1]; if (dsList.Tables[0] != null) { foreach (System.Data.DataRow dr in ViewBag.GridColumn.Rows) { GridColumn.Add(new ViewsGridColumn { column1 = @dr["column1"].ToString(), column2 = @dr["column2"].ToString(), column3 = @dr["column3"].ToString(), column4 = @dr["column4"].ToString() }); } } if (dsList.Tables[1] != null) { foreach (System.Data.DataRow dr in ViewBag.GridHearder.Rows) { GridHearder.Add(new ViewsGridHearder { Header = @dr["Header"].ToString(), DisplayOrder = @dr["DisplayOrder"].ToString(), Visibility = @dr["Visibility"].ToString(), TableColumn = @dr["TableColumn"].ToString() }); // var gf = GridColumn.Where(s => s.SrNo == dr["xcode"].ToString()).ToList(); } } } _grid.ViewsGridColumn = GridColumn.ToList(); _grid.ViewsGridHearder = GridHearder.ToList(); lstGrid.Add(_grid); return PartialView(lstGrid); }
/* insert Basic details ADMIN_MASTER */ public DataSet insert_data(CommanMaster CM) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_save_adminmaster", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@Type", CM.Type); _cmd.Parameters.AddWithValue("@xmaster", CM.xmaster); _cmd.Parameters.AddWithValue("@xname", CM.xname); _cmd.Parameters.AddWithValue("@drpCaption", CM.drpCaption); _cmd.Parameters.AddWithValue("@xlink", CM.xlink); _cmd.Parameters.AddWithValue("@xcross", CM.xcross); _cmd.Parameters.AddWithValue("@xcross1", CM.xcross1); _cmd.Parameters.AddWithValue("@xcross2", CM.xcross2); _cmd.Parameters.AddWithValue("@xcross3 ", CM.xcross3); _cmd.Parameters.AddWithValue("@xcross4", CM.xcross4); _cmd.Parameters.AddWithValue("@xreference1 ", CM.xreference1); _cmd.Parameters.AddWithValue("@xreference2 ", CM.xreference2); _cmd.Parameters.AddWithValue("@xreference3 ", CM.xreference3); _cmd.Parameters.AddWithValue("@xreference4 ", CM.xreference4); _cmd.Parameters.AddWithValue("@xreference5 ", CM.xreference5); _cmd.Parameters.AddWithValue("@xreference6 ", CM.xreference6); _cmd.Parameters.AddWithValue("@xdetail ", CM.xdetail); _cmd.Parameters.AddWithValue("@ENTRYCONTROL ", CM.ENTRYCONTROL); _cmd.Parameters.AddWithValue("@SEGMENT ", CM.SEGMENT); _cmd.Parameters.AddWithValue("@Attribute1", CM.Attribute1); _cmd.Parameters.AddWithValue("@Attribute2", CM.Attribute2); _cmd.Parameters.AddWithValue("@Attribute3", CM.Attribute3); _cmd.Parameters.AddWithValue("@Attribute4", CM.Attribute4); _cmd.Parameters.AddWithValue("@Attribute5", CM.Attribute5); _cmd.Parameters.AddWithValue("@Attribute6", CM.Attribute6); _cmd.Parameters.AddWithValue("@Attribute7", CM.Attribute7); _cmd.Parameters.AddWithValue("@Attribute8", CM.Attribute8); _cmd.Parameters.AddWithValue("@Attribute9", CM.Attribute9); _cmd.Parameters.AddWithValue("@Attribute10", CM.Attribute10); _cmd.Parameters.AddWithValue("@Rating1", CM.Rating1); _cmd.Parameters.AddWithValue("@Rating2", CM.Rating2); _cmd.Parameters.AddWithValue("@Rating3", CM.Rating3); _cmd.Parameters.AddWithValue("@Date1", CM.Date1); _cmd.Parameters.AddWithValue("@Date2", CM.Date2); _cmd.Parameters.AddWithValue("@Date3", CM.Date3); _cmd.Parameters.AddWithValue("@Email1", CM.Email1); _cmd.Parameters.AddWithValue("@Email2", CM.Email2); _cmd.Parameters.AddWithValue("@Email3", CM.Email3); _cmd.Parameters.AddWithValue("@Amount", CM.Amount); _cmd.Parameters.AddWithValue("@Amount2", CM.Amount2); _cmd.Parameters.AddWithValue("@Amount3", CM.Amount3); _cmd.Parameters.AddWithValue("@Time1", CM.Time1); _cmd.Parameters.AddWithValue("@Time2", CM.Time2); _cmd.Parameters.AddWithValue("@Html", CM.Html); _cmd.Parameters.AddWithValue("@Upload", CM.Upload); _cmd.Parameters.AddWithValue("@TextArea", CM.TextArea); _cmd.Parameters.AddWithValue("@MultiSelect1", CM.MultiSelect1); _cmd.Parameters.AddWithValue("@MultiSelect2", CM.MultiSelect2); _cmd.Parameters.AddWithValue("@MultiSelect3", CM.MultiSelect3); _cmd.Parameters.AddWithValue("@MultiSelect4", CM.MultiSelect4); _cmd.Parameters.AddWithValue("@MultiSelect5", CM.MultiSelect5); _cmd.Parameters.AddWithValue("@CreatedBy", CM.CreatedBy); if (CM.EntryDatetime == null) { _cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CM.EntryDatetime, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@EditedBy", CM.EditedBy); if (CM.EditDatetime == null) { _cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CM.EditDatetime, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@CorpcentreBy", CM.CorpcentreBy); _cmd.Parameters.AddWithValue("@UnitCorpBy", CM.UnitCorpBy); _cmd.Parameters.AddWithValue("@TerminalBy", CM.TerminalBy); _cmd.Parameters.AddWithValue("@language", CM.language); _cmd.Parameters.AddWithValue("@Corporate", CM.Corporate); //int i = _cmd.ExecuteNonQuery(); SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return _ds; } catch { throw; } finally { _cn.Close(); _cn.Dispose(); } }