public Sec_User DeviceLogin(string username, string password, string imei)
{
Sec_User rec = new Sec_User();
try
{
Sec_UserBL ubl = new Sec_UserBL();
rec = ubl.Single("DeviceLogin", username, imei);
if (rec != null)
{
Sec_PermissionBL pl = new Sec_PermissionBL();
rec.Permissions = pl.ToList("byUserId_ModuleId", rec.UserId.ToString(), "AIRVIEW_ANDROID");
string TempPass = Encryption.Decrypt(rec.Password, true);
rec.Message = true;
if (password != TempPass)
{
rec = new Sec_User();
rec.Message = false;
}
}
else
{
rec.Message = false;
}
}
catch (Exception ex)
{
rec = new Sec_User();
rec.Message = false;
}
return(rec);
}
public ActionResult New()
{
Sec_PermissionBL pl = new Sec_PermissionBL();
ViewBag.LastId = pl.GetLastId() + 1;
NewData();
ViewBag.Filter = "Insert";
return(View());
}
public ActionResult Delete(int Id)
{
Sec_PermissionBL pb = new Sec_PermissionBL();
Sec_Permission p = new Sec_Permission();
p.Id = Id;
pb.Manage("DeleteById", p);
return(RedirectToAction("all"));
}
public ActionResult Paging(int current, int rowCount, string searchPhrase)
{
Sec_PermissionBL pb = new Sec_PermissionBL();
current = (current == 0) ? 1 : current;
rowCount = (rowCount == 0) ? 5 : rowCount;
int offset = (current - 1) * rowCount;
int TotalRecord = 0;
var rec = pb.Paging(offset, rowCount, searchPhrase, ref TotalRecord);
return(Json(new { current = current, total = TotalRecord, rows = rec, rowCount = rowCount }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int id)
{
Sec_PermissionBL pl = new Sec_PermissionBL();
ViewBag.LastId = id;
NewData();
var rec = pl.Single("ById", id.ToString());
ViewBag.ModuleId = (rec != null) ? rec.ModuleId : 0;
ViewBag.Filter = "Update";
return(View("New", rec));
}
private void mySession(Sec_User user)
{
if (user != null)
{
LoginInformation li = new LoginInformation();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
var per = pl.ToList("byUserId_ModuleId", user.UserId.ToString(), "AIRIVEW_PORTAL");
var Pper = udl.GetDataTable("UserProjects", user.UserId.ToString(), null, null);
Session["user"] = null;
//System.Web.HttpContext.Current.Application["UserId"] = user.UserId.ToString();
//System.Web.HttpContext.Current.Application.Add(user.UserId.ToString(), user.UserId.ToString());
System.Web.HttpContext.Current.Application["User"] = li.set_user_data(user, per, Pper);
Session.Add("user", li.set_user_data(user, per, Pper));
}
}
public ActionResult New(Sec_Permission p, string Filter)
{
try
{
Sec_PermissionBL pb = new Sec_PermissionBL();
bool res = pb.Manage(Filter, p);
if (res)
{
TempData["msg_success"] = "save successfully";
}
return(RedirectToAction("all"));
}
catch (Exception ex)
{
TempData["msg_error"] = ex.Message;
return(View());
}
}
public static void UpdateSession(string Username)
{
Sec_User user = new Sec_User();
Sec_UserBL ubl = new Sec_UserBL();
user = ubl.Single("Login", Username);
if (user != null)
{
LoginInformation li = new LoginInformation();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
var per = pl.ToList("byUserId_ModuleId", user.UserId.ToString(), "AIRIVEW_PORTAL");
var Pper = udl.GetDataTable("UserProjects", user.UserId.ToString(), null, null);
var obj = li.set_user_data(user, per, Pper);
HttpContext.Current.Session["user"] = null;
HttpContext.Current.Session["user"] = obj;
}
}
public ActionResult ByRole(int id = 0)
{
ViewBag.RoleId = id;
Sec_PermissionBL pl = new Sec_PermissionBL();
var r = pl.ToList("byRoleId", id.ToString());
string PIds = null;
foreach (var item in r)
{
PIds += item.Id + ",";
}
ViewBag.PIds = PIds;
if (id == 0)
{
TempData["msg_error"] = "Please Select Role";
}
var rec = pl.ToList("ByStatus", "1");
return(View(rec));
}
public bool ManageStatus(int Id, bool status, string type)
{
try
{
Sec_PermissionBL pb = new Sec_PermissionBL();
Sec_Permission p = new Sec_Permission();
p.Id = Id;
if (type == "set_IsMenuItem")
{
p.IsMenuItem = status;
}
else if (type == "set_IsUsed")
{
p.IsUsed = status;
}
bool res = pb.Manage(type, p);
return(res);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(string Id = "")
{
ClientsBL cb = new ClientsBL();
UserClientsBL uchb = new UserClientsBL();
UserCityBL ucb = new UserCityBL();
AD_DefinationBL db = new AD_DefinationBL();
Sec_User user = new Sec_User();
Sec_UserBL ubl = new Sec_UserBL();
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserDefinationTypeBL udt = new Sec_UserDefinationTypeBL();
ViewBag.Titles = new List <SelectListItem> {
new SelectListItem {
Text = "Mr.", Value = "1"
},
new SelectListItem {
Text = "Mrs.", Value = "2"
},
new SelectListItem {
Text = "Miss.", Value = "3"
},
new SelectListItem {
Text = "Ms.", Value = "4"
},
new SelectListItem {
Text = "Sir.", Value = "5"
},
new SelectListItem {
Text = "DR", Value = "6"
}
};
ViewBag.Hide = false;
ViewBag.Team = false;
if (Id == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide = true;
List <OrgChart> rec = ubl.hierarchy("ByCompanyId", Convert.ToString(ViewBag.CompId));
List <Chart> Data2 = FlatToHierarchy(rec, ViewBag.UserId);
if (Data2.Count > 0)
{
ViewBag.Team = true;
}
else
{
ViewBag.Team = false;
}
}
SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList();
Sec_UserBL ud = new Sec_UserBL();
Sec_User User = ud.Single("ById", Id.ToString());
ViewBag.UserTitle = User.Title;
ViewBag.Hide2 = true;
if (User.ReportToId.ToString() == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide2 = false;
}
if (Id == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide2 = false;
}
ViewBag.User = User;
if (User == null)
{
}
if (User.IsAdmin == true)
{
ViewBag.Hide = false;
ViewBag.Hide2 = false;
ViewBag.Team = true;
}
NewData();
ViewBag.Id = User.CompanyId;
ViewBag.RoleId = User.RoleId;
ViewBag.Reports = sl.User("All");
ViewBag.ReportTo = ud.ToList("All");
ViewBag.Clients2 = sl.Clients("AllRecords");
/////permissions
user = ubl.Single("ById", Id.ToString());
///Project
DataTable Table = udl.GetDataTable("All_Projects", User.ReportToId.ToString(), null, null);
ViewBag.Projects = Table.ToList <PM_Projects>();
DataTable Table1 = udl.GetDataTable("UserProjects", Id.ToString(), null, null);
ViewBag.UserProjects = Table1.ToList <PM_Projects>();
var r = pl.ToList("byUserId", Id.ToString());
var d = udt.ToList("GetByUserId", Id.ToString());
string UDSelected = null;
foreach (var item in d)
{
UDSelected += item.DefinationTypeId + ",";
}
ViewBag.DIds = UDSelected;
string Selected = null;
foreach (var item in r)
{
Selected += item.Id + ",";
}
ViewBag.PIds = Selected;
ViewBag.UId = Id;
#region user Permissions on tab
//Clients
//ViewBag.Clients = cb.ToList("byStatus", User.ReportToId.ToString());
ViewBag.Clients = cb.ToList("byStatus", "True", User.ReportToId.ToString());
ViewBag.UserClients = uchb.ToList("byUserId", Id.ToString());
//Cities
ViewBag.Cities = db.ToList("AllCities");
//db.ToList("UserCities",User.ReportToId.ToString());
ViewBag.UserCities = ucb.ToList("byUserId", Id.ToString());
ViewBag.Region = db.RegionsToList(User.ReportToId.ToString());
//scope
ViewBag.Scopes = db.ToList("Scopes", User.ReportToId.ToString());
//ViewBag.Scopes = db.ToList("Scopes");
ViewBag.UserScopes = db.ToList("UserScopes", Id.ToString());
ViewBag.Permissions = pl.ToList("byRoleId", user.RoleId.ToString(), User.ReportToId.ToString());
#endregion
AD_DefinationTypesBL dtd = new AD_DefinationTypesBL();
ViewBag.DefinationTypes = dtd.ToList("All", User.ReportToId.ToString());
//User.RoleName = ViewBag.RoleName;
return(View("edit", User));
}
public ActionResult All()
{
Sec_PermissionBL pl = new Sec_PermissionBL();
return(View(pl.ToList("All")));
}
public ActionResult ByUser(int id = 0)
{
Sec_User user = new Sec_User();
Sec_UserBL ubl = new Sec_UserBL();
user = ubl.Single("ById", id.ToString());
if (user != null)
{
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserDefinationTypeBL ud = new Sec_UserDefinationTypeBL();
///Projects and User projects
DataTable Table = udl.GetDataTable("All_Projects", null, null, null);
ViewBag.Projects = Table.ToList <PM_Projects>();
DataTable Table1 = udl.GetDataTable("UserProjects", id.ToString(), null, null);
ViewBag.UserProjects = Table1.ToList <PM_Projects>();
var r = pl.ToList("byUserId", id.ToString());
var d = ud.ToList("GetByUserId", id.ToString());
string UDSelected = null;
foreach (var item in d)
{
UDSelected += item.DefinationTypeId + ",";
}
ViewBag.DIds = UDSelected;
string Selected = null;
foreach (var item in r)
{
Selected += item.Id + ",";
}
ViewBag.PIds = Selected;
ViewBag.UId = id;
// User Clients
ClientsBL cb = new ClientsBL();
ViewBag.Clients = cb.ToList("byStatus", "True");
// get selected user Clients
UserClientsBL uchb = new UserClientsBL();
ViewBag.UserClients = uchb.ToList("byUserId", id.ToString());
// get selected user Cities
UserCityBL ucb = new UserCityBL();
ViewBag.UserCities = ucb.ToList("byUserId", id.ToString());
// get Regions
AD_DefinationBL db = new AD_DefinationBL();
ViewBag.Region = db.RegionsToList();
ViewBag.Cities = db.ToList("AllCities");
ViewBag.Scopes = db.ToList("Scopes");
ViewBag.UserScopes = db.ToList("UserScopes", id.ToString());
// ViewBag.UserScopes = string.Join(",", Scopes.Select(n => n.DefinationId.ToString()).ToArray());
var Permissions = pl.ToList("byRoleId", user.RoleId.ToString());
return(View(Permissions));
}
else
{
TempData["msg_error"] = "User not Found.";
}
return(View());
}
private bool InsertPermissions(string Module, string Namespace)
{
List <string> Controllers = new List <string>();
Controllers = GetControllers(Namespace);
DataTable Permissions = new DataTable();
Permissions.Columns.AddRange(new DataColumn[6]
{
new DataColumn("Id", typeof(int)),
new DataColumn("ParentId", typeof(int)),
new DataColumn("Title", typeof(string)),
new DataColumn("URL", typeof(string)),
new DataColumn("Code", typeof(string)),
new DataColumn("In_menu", typeof(bool)),
});
Sec_PermissionBL pl = new Sec_PermissionBL();
int Id = pl.GetLastId() + 1;
int tempParentId = 0, ModuleId = 1;
ModuleId = Id;
PermissionDataRow(Permissions, Id, 0, Module, "#", null);
foreach (string Cont in Controllers)
{
var Actions = ActionNames(Cont);
bool Menu = true;
if (p.InMenuExist(Cont))
{
Menu = false;
}
if (Menu)
{
Id++; tempParentId = Id;
if (Actions.Count > 1)
{
PermissionDataRow(Permissions, Id, ModuleId, Cont, "#", Cont.Substring(0, 3), Menu);
foreach (var Action in Actions)
{
Menu = true;
if (p.InMenuExist(Action))
{
Menu = false;
}
if (!p.DropActionExist(Action))
{
Id++;
string code = Cont.Substring(0, 3) + Action.Substring(0, 3);
PermissionDataRow(Permissions, Id, tempParentId, Cont + " " + Action, "/" + Cont + "/" + Action, code, Menu);
}
}
}
else
{
string code = Cont.Substring(0, 3) + Actions[0].Substring(0, 3);
PermissionDataRow(Permissions, Id, ModuleId, Cont, "/" + Cont + "/" + Actions[0], code, Menu);
}
}
}
Sec_PermissionDL pd = new Sec_PermissionDL();
return(pd.Save(Permissions));
}
