public Response _LookupData(int _ProjectId) { Response _res = new Response(); PM_LookupData _lookup = new PM_LookupData(); try { PM_TaskEntryBL te = new PM_TaskEntryBL(); AD_DefinationBL db = new AD_DefinationBL(); _lookup.GroupResources = te.GET_Group_LIST("PopulateGroupResources").ToList(); _lookup.ProjectResources = te.GET_Group_LIST("PopulateUserResourcesProject", _ProjectId).Where(x => x.ResourceName != null && x.ResourceName != "").ToList(); _lookup.ProjectStatus = db.ToList("byDefinationType", "Project Task Status"); _lookup.Priorities = db.ToList("byDefinationType", "Priority"); Sec_UserBL ud = new Sec_UserBL(); _res.Message = "Ok"; _res.Status = "true"; _res.Value = _lookup; return(_res); } catch (Exception _ex) { _res.Message = _ex.Message; _res.Status = "false"; _res.Value = _lookup; return(_res); } }
public ActionResult New(string title, string Id = "") { if (Id == "") { return(RedirectToAction("All")); } SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList(); Sec_UserBL ud = new Sec_UserBL(); ViewBag.tit = title; ViewBag.Id = 0; ViewBag.Reports = sl.User("All"); ViewBag.ReportTo = ud.ToList("All"); if (Id != "") { ViewBag.Id = Convert.ToInt64(Id); } ClientsBL ub = new ClientsBL(); ViewBag.Clients2 = sl.Clients("AllRecords"); NewData(); return(View()); }
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 JsonResult ListUsers(string filter, string value) { Sec_UserBL db = new Sec_UserBL(); var listUsersNew = db.ToListNew(filter, value); return(Json(listUsersNew, JsonRequestBehavior.AllowGet)); }
public ActionResult hierarchy(string ID = "") { Chart Chart = new Chart(); Sec_UserBL ub = new Sec_UserBL(); List <OrgChart> rec = ub.hierarchy("ByCompanyId", Convert.ToString(ViewBag.CompId)); var parent = rec.Where(x => x.ReportToId == 0).FirstOrDefault(); var User = rec.Where(x => x.UserId.ToString() == Convert.ToString(ViewBag.UserId)).FirstOrDefault(); if (ID == "") { //by Company var Data = FlatToHierarchy(rec, parent.UserId); Chart.children = Data; Chart.text = Text(parent); Chart.image = parent.Picture; ViewBag.OC = Chart; } else { ///////By tEAM var Data2 = FlatToHierarchy(rec, User.UserId); Chart.children = Data2; Chart.text = Text(User); Chart.image = User.Picture; // ViewBag.Team = Chart; ViewBag.OC = Chart; } return(View()); }
public JsonResult ToList(string filter, string value) { Sec_UserBL ud = new Sec_UserBL(); List <Sec_User> rec = ud.ToList(filter, value); rec = rec.Select(c => { c.Password = ""; return(c); }).ToList(); return(Json(rec, JsonRequestBehavior.AllowGet)); }
public List <PM_CompanyHierarchy> ListCompanyUsers(string filter, string value) { Sec_UserBL db = new Sec_UserBL(); Client c = new Client(); var listUsersNew = db.ToListNew(filter, value); return(listUsersNew); }
public ActionResult GetSummryByDate(string currentDate, string id, string[] Markets) { List <Summary> res = new List <Summary>(); try { List <Summary> rs = new List <Summary>(); ViewBag.UserId = id; Sec_UserBL obj = new Sec_UserBL(); var u = obj.Single("ById", id); ViewBag.UserName = u.FirstName + " " + u.LastName; var a = currentDate.Split('-'); int i = 0; string StartDate = ""; string EndDate = ""; foreach (var item in a) { if (i == 0) { StartDate = item; i++; } else { EndDate = item; } } ViewBag.Defultdate = StartDate; rs = obj.SummaryList("GetUserSummary", StartDate, EndDate, id); if (Markets.Length != 0 || Markets != null) { foreach (var item in rs) { foreach (var itm in Markets) { if (int.Parse(itm) == item.DefinationId) { res.Add(item); } } } } else { res = rs; } return(PartialView("~\\Views\\User\\_PartialCalender.cshtml", res)); } catch (Exception ex) { res = null; return(Json(res, JsonRequestBehavior.AllowGet)); } // return Json(true, JsonRequestBehavior.AllowGet); }
public ActionResult Movement() { string TransType = ""; if (Request.QueryString["UEId"] != null) { ViewBag.UEId = Convert.ToInt32(Request.QueryString["UEId"]); } if (Request.QueryString["UserId"] != null) { ViewBag.UserId = Request.QueryString["UserId"]; } if (Request.QueryString["UETypeId"] != null) { ViewBag.UETypeId = Request.QueryString["UETypeId"]; } if (Request.QueryString["UEsts"] != null) { TransType = Request.QueryString["UEsts"]; } AD_DefinationBL db = new AD_DefinationBL(); ViewBag.UEStatus = db.SelectedList("byDefinationType", "UE Status", "-Transaction Type-"); foreach (var v in ViewBag.UEStatus) { if (v.Text == TransType) { ViewBag.UEsts = v.Value; } } ViewBag.UETypes = db.SelectedList("byDefinationType", "UE Type", "-select-"); AD_UserEquipmentsBL ueb = new AD_UserEquipmentsBL(); ViewBag.Equipments = ueb.SelectedList("All", "", "-select-"); Sec_UserBL ub = new Sec_UserBL(); ViewBag.Users = ub.SelectedList("ByStatus", true.ToString(), "-Users-"); ViewBag.IssueToUsers = ub.SelectedList("ByStatus", true.ToString(), "-Users-"); return(View()); }
public List <SelectListItem> UsersByRoleId(int Id) { List <SelectListItem> items = new List <SelectListItem>(); Sec_UserBL ub = new Sec_UserBL(); List <Sec_User> lst = ub.ToList("byRoleId", Id.ToString()); foreach (var item in lst) { items.Add(new SelectListItem { Text = item.FirstName + " " + item.LastName, Value = item.UserId.ToString() }); } return(items); }
public List <Sec_User> UsersList() { try { Sec_UserBL ub = new Sec_UserBL(); return(ub.ToList("byRoleName", "Tester").Select(m => new Sec_User { UserName = m.FirstName + " " + m.LastName, Id = Convert.ToInt32(m.UserId) }).ToList()); } catch (Exception) { throw; } }
//GET: Login public ActionResult Index(string tctl, string tact) { TempData["msg_error"] = null; ActionResult temp = null; try { HttpCookie myCookie = Request.Cookies["AirView"]; if (myCookie != null) { Sec_User user = new Sec_User(); Sec_UserBL ubl = new Sec_UserBL(); user = ubl.Single("Login", Encryption.DecryptSHA256(myCookie.Value)); if (user != null) { mySession(user); if (Session["PrevUrl"] != null) { string url = Session["PrevUrl"].ToString(); Session["PrevUrl"] = null; return(Redirect(url)); } else if (!string.IsNullOrEmpty(tctl) && !string.IsNullOrEmpty(tact)) { return(RedirectToAction(tact, tctl)); } else { temp = Redirect(user.DefaultUrl); } return(temp); } } } catch (Exception ex) { TempData["msg_error"] = ex.Message; } ViewBag.TController = tctl; ViewBag.TAction = tact; return(View()); }
public List <SelectListItem> User(string filter, string value = null) { List <SelectListItem> items = new List <SelectListItem>(); Sec_UserBL cb = new Sec_UserBL(); var lst = cb.ToList(filter, value); items.Add(new SelectListItem { Text = "--Select User--", Value = "0" }); foreach (var item in lst) { items.Add(new SelectListItem { Text = item.FirstName + "" + item.LastName, Value = item.UserId.ToString() }); } return(items); }
public void UserAssinged_Testers_Devices(int UserId, ref List <SelectListItem> LUsers, ref List <Sec_UserDevices> UserDevices) { Sec_UserBL ub = new Sec_UserBL(); List <Sec_User> Users = new List <Sec_User>(); ub.UserAssinged_Testers_Devices(UserId, ref Users, ref UserDevices); LUsers.Add(new SelectListItem { Text = "Select Tester", Value = "0" }); foreach (var item in Users) { LUsers.Add(new SelectListItem { Text = item.FirstName + " " + item.LastName, Value = item.UserId.ToString() }); } }
public ActionResult Details(int id = 0) { if (ViewBag.IsAdmin) { goto data; } if (ViewBag.UserId != id) { TempData["msg_error"] = "You have not permission to this panel.."; return(View()); } data: Sec_UserBL ud = new Sec_UserBL(); var data = ud.Single("ById", id.ToString()); return(View(data)); }
public ActionResult SelectableList(string filter, string value) { if (filter == "DevicesUsers") { Sec_UserDevicesBL udb = new Sec_UserDevicesBL(); var rec = udb.SelectedList("All", ""); return(Json(rec, JsonRequestBehavior.AllowGet)); } else if (filter == "All") { Sec_UserBL ub = new Sec_UserBL(); var rec = ub.SelectedList("ByStatus", true.ToString()); return(Json(rec, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult Index(Int64 ProjectId = 0) { Sec_UserSettingsDL udl = new Sec_UserSettingsDL(); DataTable UserProjects = udl.GetDataTable("UserProjects", ViewBag.UserId.ToString(), null, null); if (ProjectId == 0 || UserProjects.ToList <PM_Projects>().Where(x => x.ProjectId == ProjectId).Count() == 0) { return(RedirectToAction("all", "Defination")); } //DataTable Table = udl.GetDataTable("All_Projects", null, null, null); Sec_UserBL ud = new Sec_UserBL(); Sec_User user = ud.Single("ById", ViewBag.UserId.ToString()); return(View(user)); }
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 Summary(int Id) { List <Summary> res = new List <Summary>(); Sec_UserBL obj = new Sec_UserBL(); var u = obj.Single("ById", Id.ToString()); ViewBag.UserName = u.FirstName + " " + u.LastName; int thisWeekNumber = GetIso8601WeekOfYear(DateTime.Today); // 11/11/2013 DateTime firstDayOfWeek = FirstDateOfWeek(DateTime.Now.Year, thisWeekNumber, CultureInfo.CurrentCulture); // 11/12/2012 DateTime firstDayOfLastYearWeek = FirstDateOfWeek(DateTime.Now.Year, thisWeekNumber, CultureInfo.CurrentCulture); var StartDate = firstDayOfLastYearWeek.ToString(); var EndDate = firstDayOfLastYearWeek.AddDays(7).ToString(); res = obj.SummaryList("GetUserSummary", StartDate, EndDate, Id.ToString()); ViewBag.Defultdate = StartDate; ViewBag.UserId = Id; return(View(res)); }
public JsonResult Details(Int64 Id, string Key) { PM_ProjectBL pd = new PM_ProjectBL(); var Project = pd.ToSingle("ByProjectId", Id.ToString()); AD_DefinationBL db = new AD_DefinationBL(); var ProjectStatus = db.ToList("byDefinationType", "Project Status"); Int64 UserId = ViewBag.UserId; var UserScopes = db.ToList("UserScopes", UserId.ToString()); var Priorities = db.ToList("byDefinationType", "Priority"); var FormTypes = db.ToList("byDefinationType", "FormType"); var TaskTypes = db.ToList("byDefinationType", "Task Types"); Sec_UserBL ud = new Sec_UserBL(); List <Sec_User> Users = ud.ToList("ByProjectId", Id.ToString()); Users = Users.Select(c => { c.Password = ""; return(c); }).ToList(); return(Json(new { Project = Project, ProjectStatus = ProjectStatus, UserScopes = UserScopes , Priorities = Priorities, FormTypes = FormTypes, Users = Users, TaskTypes = TaskTypes }, JsonRequestBehavior.AllowGet)); }
public bool IsExist(string filter, string value) { Sec_UserBL ud = new Sec_UserBL(); Sec_User data = ud.Single(filter, value); if (data != null) { if (data.UserId > 0) { return(true); } else { return(false); } } else { return(false); } }
public ActionResult PlanProject(string Filter, Int64 ProjectId = 0, Int64 RevisionId = 0, DateTime?FromDate = null, DateTime?ToDate = null, string LocationIds = null, string TaskIds = null, string SiteStatus = null, Int64 UserId = 0) { PM_ProjectBL pal = new PM_ProjectBL(); AD_DefinationBL dbl = new AD_DefinationBL(); Sec_UserBL ud = new Sec_UserBL(); List <PM_ProjectSite> result = pal.PM_PlanProject(Filter, ProjectId, RevisionId, FromDate, ToDate, LocationIds, TaskIds, SiteStatus, UserId); List <SelectedList> listStatus = dbl.SelectedList("byDefinationType", "Project Status"); ViewBag.StatusId = listStatus; List <SelectedList> listUsers = ud.SelectedList("ByProjectId", ProjectId.ToString()); List <PM_CompanyHierarchy> lstCompUsers = ListCompanyUsers("ByProjectId", ProjectId.ToString()); List <Client> listOfClient = lstCompUsers.GroupBy(xx => xx.ClientId).Select(x => new Client() { ClientId = x.Key, ClientName = lstCompUsers.Where(XVC => XVC.ClientId == x.Key).FirstOrDefault().ClientName, userRolesList = lstCompUsers.Where(xr => xr.ClientId == x.Key).GroupBy(zx => zx.RoleId).Select(urol => new UserRoles() { RoleId = urol.Key, RoleName = lstCompUsers.FirstOrDefault(zzzz => zzzz.RoleId == urol.Key).RoleName, userList = lstCompUsers.Where(zzzz1 => zzzz1.RoleId == urol.Key && zzzz1.ClientId == x.Key).Select(usr => new Users() { FirstName = usr.FirstName, LastName = usr.LastName, UserId = usr.UserId, UserName = usr.UserName }).ToList() }).ToList() }).ToList(); foreach (var item in result) { item.SelectedListStatus = listStatus; item.Clients = listOfClient; //item.ActualEndDate = item.ActualStartDate!=null? Convert.ToDateTime(item.ActualStartDate).ToShortDateString():null; } return(PartialView("~/Areas/Project/Views/Task/_PlanProject.cshtml", result)); }
public ActionResult All() { string Id = null; Sec_UserBL ub = new Sec_UserBL(); ClientsBL cl = new ClientsBL(); TempData["CompanyId"] = Id; ViewBag.Id = Id; var User = Session["user"] as LoginInformation; TempData["UserId"] = User.UserId.ToString(); if (User.IsAdmin == true) { ViewBag.Client = null; if (Id == null) { TempData["CompanyId"] = Convert.ToString(ViewBag.CompId); ViewBag.Id = Convert.ToString(ViewBag.CompId); // var Client = cl.Single("ById", Id).ClientName; //ViewBag.Client =Client; } var Data = ub.ToList("All", Convert.ToString(ViewBag.UserId)); return(View(Data)); } else { ViewBag.Client = null; if (Id == null) { TempData["CompanyId"] = Convert.ToString(ViewBag.CompId); ViewBag.Id = Convert.ToString(ViewBag.CompId); // var Client = cl.Single("ById", Id).ClientName; //ViewBag.Client =Client; } return(View(ub.ToList("UserByUserId", Convert.ToString(User.UserId)))); } }
public ActionResult record(int current, int rowCount, string searchPhrase, string Id = null) { Sec_UserBL ub = new Sec_UserBL(); LoginInformation test = (LoginInformation)Session["user"]; string UserId = test.UserId.ToString(); string CompanyId = TempData["CompanyId"] as string; if (CompanyId == null) { CompanyId = "0"; } TempData.Keep("CompanyId"); current = (current == 0) ? 1 : current; rowCount = (rowCount == 0) ? 5 : rowCount; int offset = (current - 1) * rowCount; int TotalRecord = 0; //var rec = ub.Paging(offset, rowCount, searchPhrase, ref TotalRecord, CompanyId.ToString()); var rec = ub.Paging(offset, rowCount, searchPhrase, ref TotalRecord, UserId); return(Json(new { current = current, total = TotalRecord, rows = rec, rowCount = rowCount }, JsonRequestBehavior.AllowGet)); }
// GET: Market public ActionResult Configuration(int Id = 0) { ViewBag.CityId = Id; AD_DefinationBL db = new AD_DefinationBL(); if (ViewBag.IsAdmin) { ViewBag.Cities = db.SelectedList("AllCities"); } else { ViewBag.Cities = db.SelectedList("UserCities", Convert.ToString(ViewBag.UserId)); } Sec_UserBL ubl = new Sec_UserBL(); ViewBag.Users = ubl.SelectedList("All", null); ViewBag.MarketUsers = ubl.SelectedList("ByCityId", Id.ToString()); ViewBag.NetworkModes = db.SelectedList("NetworkModes", null, "-Select NetworkMode-"); UserClientsBL ucb = new UserClientsBL(); ViewBag.UserClients = ucb.SelectedList("byUserId", Convert.ToString(ViewBag.UserId)); ViewBag.Projects = db.SelectedList("UserProjects", Convert.ToString(ViewBag.UserId)); ViewBag.ReportTypes = db.SelectedList("ReportTypes", null, "-Report Types-"); ViewBag.Scopes = db.SelectedList("byDefinationType", "Scope"); ViewBag.PlotTypes = db.SelectedList("RFPlotTypes"); return(View()); }
public JsonResult Movement(List <AD_UEMovement> mov, string UEStatus) { Response res = new Response(); try { AD_UEMovementBL ueb = new AD_UEMovementBL(); foreach (var item in mov) { ueb.Manage(UEStatus, item); } //------------------------------ if (UEStatus == "Issue") { long UEId = mov.Select(x => x.UEId).Single(); long UserId = mov.Select(x => x.UserId).Single(); AD_UserEquipmentsBL uebl = new AD_UserEquipmentsBL(); AD_UserEquipment uEqu = uebl.ToSingle("ById", UEId.ToString()); Sec_UserBL u = new Sec_UserBL(); Sec_User usr = u.Single("ById", UserId.ToString()); WebConfig wc = new WebConfig(); string UeModel = uEqu.Model; string Manufacturer = uEqu.Manufacturer; string SerialNo = uEqu.SerialNo; string AVStoreURL = wc.AppSettings("AVStoreURL"); string Url = "<a href=" + AVStoreURL + ">AirView Store</a>"; string UserName = usr.UserName; string ToEmail = usr.Email; string Subject = "UE Device Issued"; string Body = "<h1>Hi, " + UserName + "</h1>" + "<p>A new device is issued to your account.</p>" + "<table border=" + 1 + " cellpadding=" + 2 + " cellspacing=" + 0 + " width = " + 400 + ">" + "<tr bgcolor='#F5F5F5'><td><strong>Model</strong></td><td>" + UeModel + "</td></tr>" + "<tr bgcolor='#F5F5F5'><td><strong>Manufacturer</strong></td><td>" + Manufacturer + "</td></tr>" + "<tr bgcolor='#F5F5F5'><td><strong>SerialNo</strong></td><td>" + SerialNo + "</td></tr>" + "</table>" + "<p>Please download and install AirView Store by clicking here: " + Url + "</p>"; Thread thread = new Thread(() => SendEmail(Subject, ToEmail, Body)); thread.Start(); //----------------------------- } res.Status = "success"; res.Message = "save successfully"; } catch (Exception ex) { res.Status = "danger"; res.Message = ex.Message; } return(Json(res, JsonRequestBehavior.AllowGet)); }
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()); }
public ActionResult Login(FormCollection frm, string tctl, string tact) { try { string Remember = frm["Remember"]; Sec_User user = new Sec_User(); Sec_UserBL ubl = new Sec_UserBL(); user = ubl.Single("Login", frm["UserName"]); string Password = Encryption.Encrypt(frm["Password"].ToString(), true); if (user != null) { if (user.Password != Password) { TempData["msg_error"] = "Wrong Password Entered."; return(RedirectToAction("index")); } else { if (Remember != "false") { HttpCookie c = new HttpCookie("AirView"); c.Expires = DateTime.Today.AddDays(7); c.Value = Convert.ToString(Encryption.EncryptSHA256(user.UserName)); //c.Values.Add("UserName", user.UserName); //c.Value = Convert.ToString(user.UserId); //c.Values.Add("UserName", user.UserName); Response.SetCookie(c); } mySession(user); if (Session["PrevUrl"] != null) { string url = Session["PrevUrl"].ToString(); Session["PrevUrl"] = null; return(Redirect(url)); } else if (!string.IsNullOrEmpty(tctl) && !string.IsNullOrEmpty(tact)) { return(RedirectToAction(tact, tctl)); } else { return(Redirect(user.DefaultUrl)); } } } else { TempData["msg_error"] = "Wrong Username Entered."; return(RedirectToAction("index")); } } catch (Exception ex) { TempData["msg_error"] = ex.Message; return(RedirectToAction("index")); } }
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)); }