public string SaveUsers(List <Model_UpdateUser> AddTemp)
{
DAL_AddUser adduser = new DAL_AddUser();
GlobalSettings gs = new GlobalSettings();
string result = "";
int cnt = 0;
try
{
foreach (var det in AddTemp)
{
Model_UpdateUser empDet = new Model_UpdateUser();
empDet.EmpID = det.EmpID;
empDet.EmpName = det.EmpName;
empDet.V_Rights = det.V_Rights;
empDet.U_Rights = det.U_Rights;
empDet.UserType = det.UserType;
result = adduser.AddUser(empDet, Request.Cookies["User"].Values[0]);
if (result == "Success")
{
}
else
{
}
}
}
catch (Exception Ex)
{
return(Ex.Message.ToString());
}
return(result);
}
public string AddUser(Model_UpdateUser userDet, string CreatedBy)
{
List <Model_UpdateUser> Branch = new List <Model_UpdateUser>();
string result = "";
GlobalSettings gs = new GlobalSettings();
try {
result = DB_AddUser(new SqlParameter("@mode", "InsertNewUser"), new SqlParameter("@UserID", userDet.EmpID),
new SqlParameter("@UserTypeID", Convert.ToInt32(userDet.UserType)), new SqlParameter("@ViewRights", Convert.ToInt32(userDet.V_Rights)),
new SqlParameter("@UpdateRights", Convert.ToInt32(userDet.U_Rights)), new SqlParameter("@Createdby", CreatedBy));
if (result == "Success")
{
return("Success");
}
else
{
return(result);
}
}
catch (Exception Ex)
{
return(Ex.Message.ToString());;
}
}
public ActionResult AddWebUsers(List <Model_UpdateUser> Tbldata, List <Model_UpdateUser> Additonaldata)
{
List <Model_UpdateUser> allUser = new List <Model_UpdateUser>();
int cnt = 0;
string[] aa = { "", "", "" };
if (Tbldata == null)
{
return(Json(JsonConvert.SerializeObject(Additonaldata), JsonRequestBehavior.AllowGet));
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("EmpID"); dt.Columns.Add("EmpName"); dt.Columns.Add("V_Rights"); dt.Columns.Add("U_Rights");
int cnt2 = 0;
foreach (var det in Tbldata)
{
dt.Rows.Add();
dt.Rows[cnt2][0] = det.EmpID;
dt.Rows[cnt2][1] = det.EmpName;
dt.Rows[cnt2][2] = det.V_Rights;
dt.Rows[cnt2][3] = det.U_Rights;
cnt2 += 1;
}
if (Additonaldata != null)
{
dt.Rows.Add();
dt.Rows[cnt2][0] = Additonaldata[0].EmpID;
dt.Rows[cnt2][1] = Additonaldata[0].EmpName;
dt.Rows[cnt2][2] = Additonaldata[0].V_Rights;
dt.Rows[cnt2][3] = Additonaldata[0].U_Rights;
}
if (dt != null)
{
//allUser = (from DataRow dr in dt.Rows
// select new Model_UpdateUser()
// {
// EmpID = Convert.ToString(dr["EmpID"]),
// EmpName = Convert.ToString(dr["EmpName"]),
// V_Rights = Convert.ToString(dr["V_Rights"]),
// U_Rights = Convert.ToString(dr["U_Rights"])
// }
// ).ToList();
foreach (DataRow dr in dt.Rows)
{
if (Convert.ToString(dr["EmpID"]).Trim() == "")
{
}
else
{
Model_UpdateUser user = new Model_UpdateUser();
user.EmpID = Convert.ToString(dr["EmpID"]);
user.EmpName = Convert.ToString(dr["EmpName"]);
user.V_Rights = Convert.ToString(dr["V_Rights"]);
user.U_Rights = Convert.ToString(dr["U_Rights"]);
allUser.Add(user);
}
cnt += 1;
}
return(Json(JsonConvert.SerializeObject(allUser), JsonRequestBehavior.AllowGet));
}
}
return(Json(JsonConvert.SerializeObject(allUser), JsonRequestBehavior.AllowGet));
//return aa;
}
