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;
}
}
