public IActionResult Index_3(string id)
{
HttpContext.Session.SetString("_ProjectId", id);
LayOutViewModel view = _projectOperations.GetProjectUnitsStatusCount(id);
view.Type = GetSessionId();
view.ProjectId = id;
view.lstAgents = _operations.GetAgentsData();
return(View(view));
}
public IActionResult Index_1(string id)
{
LayOutViewModel view = _projectOperations.GetProjectUnitsStatusCount(id);
view.Type = GetSessionId();
view.ProjectId = id;
view.lstAgents = _operations.GetAgentsData();
view.Name = GetProjectsName(id);
return(View(view));
}
public LayOutViewModel GetProjectUnitsStatusCount(string projectId)
{
LayOutViewModel objData = new LayOutViewModel();
List <ProjectUnitsData> lstUnits = _context.ProjectUnitsData.Where(x => x.Projectuuid == projectId).ToList();
if (lstUnits != null && lstUnits.Count > 0)
{
objData.BolckedUnits = lstUnits.Count();
objData.AvailableUnits = lstUnits.Where(x => x.status == StatusEnum.Available.ToString() || x.status == null).Count();
objData.BolckedUnits = lstUnits.Where(x => x.status == StatusEnum.Reserved.ToString()).Count();
objData.BookedUnits = lstUnits.Where(x => x.status == StatusEnum.Booked.ToString()).Count();
return(objData);
}
return(null);
}
public List <LayOutViewModel> GetProjectUnitsStatusCount()
{
List <LayOutViewModel> lstData = new List <LayOutViewModel>();
List <ProjectsData> lstProjects = _context.ProjectsData.ToList();
if (lstProjects != null && lstProjects.Count > 0)
{
foreach (var data in lstProjects)
{
LayOutViewModel objData = new LayOutViewModel();
objData = GetProjectUnitsStatusCount(data.projectuuid);
objData.Name = data.ProjectName;
objData.ProjectId = data.projectuuid;
lstData.Add(objData);
}
return(lstData);
}
return(null);
}
private LayOutViewModel LayOut()
{
var userId = User.Identity.GetUserId();
int CompanyId = User.Identity.GetDefaultCompany();
var db = new UserContext();
var result = new LayOutViewModel();
try
{
result.Companies = (User.Identity.Name.ToLower() == "hradmin" ? db.Database.SqlQuery <LayOutCompanyViewModel>("SELECT c.Id, ISNULL(dbo.fn_TrlsName(c.Name,'" + Language + "') , c.Name) Name from Companies c").ToList() : db.Database.SqlQuery <LayOutCompanyViewModel>("SELECT c.Id ,ISNULL(dbo.fn_TrlsName(c.Name,'" + Language + "'),c.Name) Name from Companies c inner join UserCompanyRoles ac on c.Id = ac.CompanyId where ac.UserId='" + userId + "'").ToList());
//result.Menus = db.Database.SqlQuery<LayOutMenuViewModel>("SELECT Q1.Id, Q1.Name,Q1.ParentId, Q1.NodeType, Q1.Url, Q1.Sort, Q1.Icon, Q1.RoleId, Q1.Title, Q1.DataLevel,Q1.Version, Q1.SSMenu FROM (SELECT Menus.Id,Menus.Version, Menus.Name,Menus.ParentId ,Menus.NodeType, Menus.Url, Menus.Sort, Menus.Icon, Menus.SSMenu, RoleMenus.RoleId, ISNULL(NamesTbl.Title, Menus.Name) Title, ISNULL(RoleMenus.DataLevel,0) DataLevel FROM Menus INNER JOIN RoleMenus ON Menus.Id = RoleMenus.MenuId INNER JOIN AspNetUserRoles ON RoleMenus.RoleId = AspNetUserRoles.RoleId LEFT OUTER JOIN NamesTbl ON (NamesTbl.Name = Menus.Name + CAST(Menus.Sequence AS VARCHAR(5)) AND NamesTbl.Culture = '" + Language + "') WHERE (AspNetUserRoles.UserId = N'" + userId + "') AND (Menus.CompanyId = " + CompanyId + ") AND (Menus.IsVisible = 1) AND (Menus.NodeType < 2 )) AS Q1, (SELECT RoleMenus.MenuId, RoleMenus.RoleId, RoleMenus.DataLevel, ROW_NUMBER() OVER (PARTITION BY RoleMenus.MenuId ORDER BY RoleMenus.DataLevel DESC) RNK FROM RoleMenus inner join AspNetUserRoles ON AspNetUserRoles.RoleId = RoleMenus.RoleId and AspNetUserRoles.UserId = N'" + userId + "') AS Q2 WHERE Q1.RoleId = Q2.RoleId And Q1.Id = Q2.MenuId And Q2.RNK = 1 ORDER BY Q1.Sort").ToList();
result.Menus = db.Database.SqlQuery <LayOutMenuViewModel>("SELECT M.Id, M.Name,M.ParentId, M.NodeType, M.Url, M.Sort, M.Icon, UR.RoleId RoleId, ISNULL(NamesTbl.Title, M.Name) Title, ISNULL(RM.DataLevel,0) DataLevel, M.[Version], M.SSMenu FROM Menus M LEFT OUTER JOIN NamesTbl ON (NamesTbl.Name = M.Name + CAST(M.Sequence AS VARCHAR(5)) AND NamesTbl.Culture = '" + Language + "'), RoleMenus RM, UserCompanyRoles UR WHERE UR.UserId = N'" + userId + "' AND UR.CompanyId = " + CompanyId + " AND UR.RoleId = RM.RoleId AND M.Id = RM.MenuId AND M.CompanyId = " + CompanyId + " AND M.IsVisible = 1 AND M.NodeType < 2 ORDER BY M.Sort").ToList();
result.Tabs = db.Database.SqlQuery <LayOutMenuViewModel>("SELECT M.Id, M.Name,M.ParentId, M.NodeType, M.Url, M.Sort, M.Icon, UR.RoleId RoleId, ISNULL(NamesTbl.Title, M.Name) Title, ISNULL(RM.DataLevel,0) DataLevel, M.[Version], M.SSMenu FROM Menus M LEFT OUTER JOIN NamesTbl ON (NamesTbl.Name = M.Name + CAST(M.Sequence AS VARCHAR(5)) AND NamesTbl.Culture = '" + Language + "'), RoleMenus RM, UserCompanyRoles UR WHERE UR.UserId = N'" + userId + "' AND UR.CompanyId = " + CompanyId + " AND UR.RoleId = RM.RoleId AND M.Id = RM.MenuId AND M.CompanyId = " + CompanyId + " AND M.IsVisible = 1 AND M.NodeType = 2 ORDER BY M.Sort").ToList();
result.Functions = db.Database.SqlQuery <LayOutFunctionViewModel>("SELECT Rm.RoleMenu_MenuId MenuId, F.Name FROM Functions F, RoleMenuFunctions RM, Menus M, UserCompanyRoles UC WHERE UC.UserId = N'" + userId + "' And UC.CompanyId = " + CompanyId + " And UC.RoleId = RM.RoleMenu_RoleId And M.CompanyId = " + CompanyId + " And M.Id = RM.RoleMenu_MenuId And F.Id = RM.Function_Id").ToList();
}
catch
{
Redirect("~/Account/Login");
}
return(result);
}
