public DataSet Insert(UserWiseRights _objUserWiseRights) { try { DataTable dt = new DataTable(); if (dt.Columns.Count == 0) { dt.Columns.Add("id", typeof(int)); dt.Columns.Add("Srno", typeof(string)); dt.Columns.Add("Modulecode", typeof(string)); dt.Columns.Add("Screencode", typeof(string)); dt.Columns.Add("Viewrights", typeof(string)); dt.Columns.Add("Addrights", typeof(string)); dt.Columns.Add("Updaterights", typeof(string)); dt.Columns.Add("Deleterights", typeof(string)); dt.Columns.Add("Attribute1", typeof(string)); dt.Columns.Add("Attribute2", typeof(string)); dt.Columns.Add("Attribute3", typeof(string)); dt.Columns.Add("Attribute4", typeof(string)); dt.Columns.Add("Attribute5", typeof(string)); dt.Columns.Add("Attribute6", typeof(string)); dt.Columns.Add("Attribute7", typeof(string)); dt.Columns.Add("Attribute8", typeof(string)); dt.Columns.Add("Attribute9", typeof(string)); dt.Columns.Add("Attribute10", typeof(string)); dt.Columns.Add("UnitCorpBy", typeof(string)); dt.Columns.Add("BranchBy", typeof(string)); dt.Columns.Add("CreatedBy", typeof(string)); dt.Columns.Add("EditedBy", typeof(string)); dt.Columns.Add("CorpcentreBy", typeof(string)); dt.Columns.Add("TerminalBy", typeof(string)); // dt.Columns.Add("LocationBy", typeof(string)); } string json = (_objUserWiseRights.GridAry); var items = JsonConvert.DeserializeObject<List<GridColumnScreen>>(json); var I = items.Count; foreach (GridColumnScreen item in items) { DataRow dr = dt.NewRow(); // dr["Srno"] = item.Module.ToString(); dr["Modulecode"] = item.Module.ToString(); dr["Screencode"] = item.SCR.ToString(); dr["Viewrights"] = item.view.ToString(); dr["Addrights"] = item.create.ToString(); dr["Updaterights"] = item.update.ToString(); dr["Deleterights"] = item.deletee.ToString(); dr["Attribute1"] = _objUserWiseRights.Attribute1; dr["Attribute2"] = _objUserWiseRights.Attribute2; dr["Attribute3"] = _objUserWiseRights.Attribute3; dr["Attribute4"] = _objUserWiseRights.Attribute4; dr["Attribute5"] = _objUserWiseRights.Attribute5; dr["Attribute6"] = _objUserWiseRights.Attribute6; dr["Attribute7"] = _objUserWiseRights.Attribute7; dr["Attribute8"] = _objUserWiseRights.Attribute8; dr["Attribute9"] = _objUserWiseRights.Attribute9; dr["Attribute10"] = _objUserWiseRights.Attribute10; dr["UnitCorpBy"] = _objUserWiseRights.UnitCorpBy; dr["BranchBy"] = _objUserWiseRights.BranchBy; dr["CreatedBy"] = _objUserWiseRights.CreatedBy; dr["EditedBy"] = _objUserWiseRights.CreatedBy; dr["CorpcentreBy"] = _objUserWiseRights.UnitCorpBy; dr["TerminalBy"] = _objUserWiseRights.TerminalBy; // dr["LocationBy"] = _objUserWiseRights.LocationBy; dt.Rows.Add(dr); } _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_save_RoleMaster", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@srno", _objUserWiseRights.srno); // _cmd.Parameters.AddWithValue("@UserId", _objUserWiseRights.UserId); _cmd.Parameters.AddWithValue("@Corporate", _objUserWiseRights.Corporate); _cmd.Parameters.AddWithValue("@Unit", _objUserWiseRights.Unit); _cmd.Parameters.AddWithValue("@Location", _objUserWiseRights.Location); _cmd.Parameters.AddWithValue("@Branch", _objUserWiseRights.Branch); _cmd.Parameters.AddWithValue("@Role", _objUserWiseRights.Role); _cmd.Parameters.AddWithValue("@RoleType", _objUserWiseRights.RoleType); if (_objUserWiseRights.EffectiveDate == null) { _cmd.Parameters.AddWithValue("@EffectiveDate", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EffectiveDate", DateTime.ParseExact(_objUserWiseRights.EffectiveDate, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@IsActive", (_objUserWiseRights.IsActive)); // _cmd.Parameters.AddWithValue("@IsDefault", bool.Parse(_objUserWiseRights.IsDefault)); _cmd.Parameters.AddWithValue("@Status", _objUserWiseRights.Status); _cmd.Parameters.AddWithValue("@Attribute1", _objUserWiseRights.Attribute1); _cmd.Parameters.AddWithValue("@Attribute2", _objUserWiseRights.Attribute2); _cmd.Parameters.AddWithValue("@Attribute3", _objUserWiseRights.Attribute3); _cmd.Parameters.AddWithValue("@Attribute4", _objUserWiseRights.Attribute4); _cmd.Parameters.AddWithValue("@Attribute5", _objUserWiseRights.Attribute5); _cmd.Parameters.AddWithValue("@Attribute6", _objUserWiseRights.Attribute6); _cmd.Parameters.AddWithValue("@Attribute7", _objUserWiseRights.Attribute7); _cmd.Parameters.AddWithValue("@Attribute8", _objUserWiseRights.Attribute8); _cmd.Parameters.AddWithValue("@Attribute9", _objUserWiseRights.Attribute9); _cmd.Parameters.AddWithValue("@Attribute10", _objUserWiseRights.Attribute10); _cmd.Parameters.AddWithValue("@CreatedBy", _objUserWiseRights.CreatedBy); _cmd.Parameters.AddWithValue("@EditedBy", _objUserWiseRights.CreatedBy); _cmd.Parameters.AddWithValue("@CorpcentreBy", _objUserWiseRights.CorpcentreBy); _cmd.Parameters.AddWithValue("@UnitCorpBy", _objUserWiseRights.UnitCorpBy); _cmd.Parameters.AddWithValue("@TerminalBy", _objUserWiseRights.TerminalBy); _cmd.Parameters.AddWithValue("@BranchBy", _objUserWiseRights.BranchBy); _cmd.Parameters.AddWithValue("@LocationBy", _objUserWiseRights.LocationBy); if (dt != null) { SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@TYPE"; parameter.SqlDbType = System.Data.SqlDbType.Structured; parameter.Value = dt; _cmd.Parameters.Add(parameter); } _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return _ds; } catch (Exception ex) { throw ex; } finally { _cn.Close(); _cn.Dispose(); } }
public DataSet Edit_AccessRights(UserWiseRights _objUserWiseRights) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Edit_RoleMaster", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@tablename", _objUserWiseRights.tablename); _cmd.Parameters.AddWithValue("@Corporate", _objUserWiseRights.CorpcentreBy); _cmd.Parameters.AddWithValue("@unit", _objUserWiseRights.Unit); _cmd.Parameters.AddWithValue("@Location", _objUserWiseRights.Location); _cmd.Parameters.AddWithValue("@Role", _objUserWiseRights.Role); _cmd.Parameters.AddWithValue("@UserId", _objUserWiseRights.UserId); _cmd.Parameters.AddWithValue("@Formcode", _objUserWiseRights.Formcode); _cmd.Parameters.AddWithValue("@Formtabcode", _objUserWiseRights.Formtabcode); _cmd.Parameters.AddWithValue("@srno", _objUserWiseRights.srno); _cmd.Parameters.AddWithValue("@Type", "EditMode"); _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 Insert(UserWiseRights _objUserWiseRights) { try { ViewBag.Message = ""; ViewBag.Event = ""; ViewBag.SrNo = ""; DataSet result = _objWhitelabelAccessRights.Insert(_objUserWiseRights); if (result.Tables[0].Rows.Count > 0) { 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"; } ViewBag.Srno = result.Tables[0].Rows[0]["SrNo"].ToString(); //ViewBag.SrNo = result.Tables[0].Rows[0]["SrNo"].ToString(); } var result1 = ViewBag.Message; return Json(new { success = result1, Event = ViewBag.Event, SrNo = ViewBag.SrNo }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_AccessRights(UserWiseRights _objUserWiseRights) { try { DataSet dsList = _objWhitelabelAccessRights.Edit_AccessRights(_objUserWiseRights); UserMaster CV = new UserMaster(); GridRights _grid = new GridRights(); List<GridColumnScreen> GridColumnScreen = new List<GridColumnScreen>(); List<GridRights> lstGrid = new List<GridRights>(); ViewBag.OtherData = ""; if (dsList != null) { if (dsList.Tables[1] != null) { if (dsList.Tables[1].Rows.Count > 0) { ViewBag.GridColumnScreen = dsList.Tables[1]; foreach (System.Data.DataRow dr in ViewBag.GridColumnScreen.Rows) { GridColumnScreen.Add(new GridColumnScreen { SrNo = @dr["Srno"].ToString(), SCR = @dr["Screencode"].ToString(), Module = @dr["Modulecode"].ToString(), view = @dr["Viewrights"].ToString(), update = @dr["Updaterights"].ToString(), deletee = @dr["Deleterights"].ToString(), create = @dr["Addrights"].ToString(), screen = @dr["Screencode"].ToString(), }); } } } if (dsList.Tables[0] != null) { if (dsList.Tables[0].Rows.Count > 0) { _objUserWiseRights.IsActive = dsList.Tables[0].Rows[0]["IsActive"].ToString(); _objUserWiseRights.EffectiveDate = dsList.Tables[0].Rows[0]["EffectiveDate"].ToString(); _objUserWiseRights.Status = dsList.Tables[0].Rows[0]["Isdefault"].ToString(); _objUserWiseRights.srno = dsList.Tables[0].Rows[0]["SrNo"].ToString(); // ViewBag.OtherData = dsList.Tables[0]; } } } // ViewBag.Columns = GridColumnScreen.ToList(); return Json(new { IsActive = _objUserWiseRights.IsActive, EffectiveDate = _objUserWiseRights.EffectiveDate, Status = _objUserWiseRights.Status, Grid = GridColumnScreen.ToList(), Srno = _objUserWiseRights.srno }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public ActionResult Edit_AccessRights(UserWiseRights _objUserWiseRights) { try { DataSet dsList = _objRoleRightsDb.Edit_AccessRights(_objUserWiseRights); UserMaster CV = new UserMaster(); GridRights _grid = new GridRights(); List<GridColumnScreen> GridColumnScreen = new List<GridColumnScreen>(); List<GridRights> lstGrid = new List<GridRights>(); List<UserWiseRights> UserWiseRights = new List<UserWiseRights>(); ViewBag.OtherData = ""; if (dsList != null) { if (dsList.Tables[1] != null) { if (dsList.Tables[1].Rows.Count > 0) { ViewBag.GridColumnScreen = dsList.Tables[1]; foreach (System.Data.DataRow dr in ViewBag.GridColumnScreen.Rows) { GridColumnScreen.Add(new GridColumnScreen { SrNo = @dr["Srno"].ToString(), SCR = @dr["Screencode"].ToString(), Module = @dr["Modulecode"].ToString(), view = @dr["Viewrights"].ToString(), update = @dr["Updaterights"].ToString(), deletee = @dr["Deleterights"].ToString(), create = @dr["Addrights"].ToString(), screen = @dr["Screencode"].ToString(), }); } } } if (dsList.Tables[0].Rows.Count > 0) { ViewBag.UserWiseRights = dsList.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.UserWiseRights.Rows) { UserWiseRights.Add(new UserWiseRights { srno = @dr["srno"].ToString(), Corporate = @dr["Corporate"].ToString(), Unit = @dr["Unit"].ToString(), Branch = @dr["Branch"].ToString(), Location = @dr["Location"].ToString(), Role = @dr["Role"].ToString(), // UserId = @dr["UserId"].ToString(), }); } } // if (dsList.Tables[0] != null) //{ // if (dsList.Tables[0].Rows.Count > 0) // { // _objUserWiseRights.Corporate = dsList.Tables[0].Rows[0]["Corporate"].ToString(); // _objUserWiseRights.Unit = dsList.Tables[0].Rows[0]["Unit"].ToString(); // _objUserWiseRights.Location = dsList.Tables[0].Rows[0]["Location"].ToString(); // _objUserWiseRights.srno = dsList.Tables[0].Rows[0]["SrNo"].ToString(); // // ViewBag.OtherData = dsList.Tables[0]; // } //} } var result = GridColumnScreen.ToList(); var result2 = UserWiseRights; // ViewBag.Columns = GridColumnScreen.ToList(); return Json(new { Grid = result, UserWiseRights = UserWiseRights }, JsonRequestBehavior.AllowGet); // return Json(new { Corporate = _objUserWiseRights.Corporate, Unit = _objUserWiseRights.Unit, Location = _objUserWiseRights.Location, Grid = GridColumnScreen.ToList(), Srno = _objUserWiseRights.srno }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }