public ActionResult CityUsers(string CityId, string[] Users)
{
Response res = new Response();
foreach (var city in CityId.Split(','))
{
try
{
DataTable Data = new DataTable();
Data.Columns.AddRange(new DataColumn[2]
{
new DataColumn("Id", typeof(int)),
new DataColumn("value", typeof(string))
});
foreach (var item in Users)
{
DataRow row;
row = Data.NewRow();
row["Id"] = Convert.ToInt32(city);
row["value"] = item;
Data.Rows.Add(row);
}
UserCityDL uctd = new UserCityDL();
uctd.Insert("CityUsers", Convert.ToInt32(city), Data);
res.Status = "success";
res.Message = "save successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public bool ByUser(int UserId, string[] PermissionIds, string[] Clients, string[] cities, int[] Scopes, int[] Projects, int[] DefinationType)
{
try
{
DataTable Data = new DataTable();
Data.Columns.AddRange(new DataColumn[2]
{
new DataColumn("Id", typeof(int)),
new DataColumn("value", typeof(string))
});
if (PermissionIds != null)
{
foreach (var item in PermissionIds)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
row["value"] = item;
Data.Rows.Add(row);
}
}
UserPermissionDL rpd = new UserPermissionDL();
if (rpd.Insert(UserId, Data))
{
// for save user Clints
Data.Rows.Clear();
if (Clients != null && Clients.Length > 0)
{
foreach (var item in Clients)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
row["value"] = item;
Data.Rows.Add(row);
}
UserClientsDL ucd = new UserClientsDL();
ucd.Insert(UserId, Data);
}
// for save user Cities
Data.Rows.Clear();
if (cities != null && cities.Length > 0)
{
var CityIds = cities.Where(m => m.Contains("r-")).ToArray();
foreach (var item in cities)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
if (item.Contains("r-"))
{
row["value"] = item.Remove(0, 2);
}
else
{
row["value"] = item.Remove(0, 4);
}
Data.Rows.Add(row);
}
UserCityDL uctd = new UserCityDL();
uctd.Insert("UserCities", UserId, Data);
}
if (Scopes != null && Scopes.Length > 0)
{
Data.Rows.Clear();
foreach (var item in Scopes)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
row["value"] = item;
Data.Rows.Add(row);
}
Sec_UserScopeDL usd = new Sec_UserScopeDL();
usd.Manage(UserId, Data);
}
if (DefinationType != null && DefinationType.Length > 0)
{
Data.Rows.Clear();
foreach (var item in DefinationType)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
row["value"] = item;
Data.Rows.Add(row);
}
Sec_UserDL usd = new Sec_UserDL();
usd.ManageUserDefinationTypes(UserId, Data);
}
//Projects
if (Projects != null && Projects.Length > 0)
{
Data.Rows.Clear();
foreach (var item in Projects)
{
DataRow row;
row = Data.NewRow();
row["Id"] = UserId;
row["value"] = item;
Data.Rows.Add(row);
}
Sec_UserProjectsDL usd = new Sec_UserProjectsDL();
usd.Manage(ViewBag.UserId, Data, UserId, "Insert");
}
Permission.ChangeUserId(UserId);
TempData["msg_success"] = "Save Successfully.";
}
return(true);
}
catch (Exception ex)
{
TempData["msg_error"] = ex.Message;
return(false);
}
}