public ActionResult Index()
{
string MgrId = System.Web.HttpContext.Current.Session["swgId"] as String;
LoginCredentials LG = new LoginCredentials();
LG.swg = System.Web.HttpContext.Current.Session["swgId"] as String;
LG.getRole();
System.Web.HttpContext.Current.Session["role"] = LG.role;
if (System.Web.HttpContext.Current.Session["role"].ToString() == "null")
{
return(Content("Not Authorized User"));
}
//todoRK
ViewBag.MgrId = MgrId;
List <RequestData> rdl = new List <RequestData>();
string query = @"WITH tree (SWG, name, level) AS (SELECT SWG, name, 1 as level FROM emp WHERE SWG = '" + LG.swg + "' ) Select Requests.ReqId, JobTitle.JobTitle, Product.ProductName,Requests.Vacancies, Status.StatusValue, Requests.Criticality, Requests.StatusId,Emp.Name From Requests Inner Join JobTitle On Requests.JobId = JobTitle.JobId inner join Product on Requests.ProductID = Product.ProductID inner join Status on Requests.StatusId = Status.StatusId inner join tree on Requests.CreatedbyEmpId= tree.SWG inner join RequestComments on Requests.ReqId= RequestComments.ReqId inner join emp on RequestComments.EmpId = emp.Swg where requestcomments.datetime=(select max(datetime) from requestcomments req2 where req2.reqid=requestcomments.reqid) and Requests.StatusId!=6 ORDER BY CONVERT(DateTime, Requests.lastmodifiedDate,101) DESC";
var obj = context.Database.SqlQuery <MyEntity>(query).ToList();
foreach (var ob in obj)
{
RequestData rd = new RequestData();
rd.SWGId = LG.swg;
rd.ReqId = ob.ReqId;
rd.JobTitle = ob.JobTitle;
rd.ProductName = ob.ProductName;
rd.vacancies = ob.Vacancies;
rd.StatusValue = ob.StatusValue;
rd.criticality = ob.criticality;
if (rd.criticality == 1)
{
rd.CriticalityName = "Normal";
}
else if (rd.criticality == 2)
{
rd.CriticalityName = "Urgent";
}
rd.Status = ob.StatusId;
rd.LastReviewedBy = ob.Name;
rdl.Add(rd);
}
//var data = BusinessComponents.Request.GetMyRequest(LG);
ViewBag.Department = BusinessComponents.Request.DeptNames();
ViewBag.pageInfo = "MyRequests";
System.Web.HttpContext.Current.Session["pageInfo"] = "MyRequests";
ViewBag.IsSubmitted = false;
return(View("Index", rdl));
}
public static string role()
{
if (System.Web.HttpContext.Current.Session["role"] == null || String.IsNullOrEmpty(System.Web.HttpContext.Current.Session["role"].ToString()))
{
if (System.Web.HttpContext.Current.Session["swgId"] == null || String.IsNullOrEmpty(System.Web.HttpContext.Current.Session["swgId"].ToString()))
{
System.Web.HttpContext.Current.Session["swgId"] = System.Web.HttpContext.Current.User.Identity.Name.ToString();
}
LoginCredentials login = new LoginCredentials();
login.swg = System.Web.HttpContext.Current.Session["swgId"].ToString();
login.getRole();
string condition = login.role;
//BusinessComponents.Request.DepartmentId(System.Web.HttpContext.Current.User.Identity.Name.ToString());
if (String.IsNullOrEmpty(condition))
{
System.Web.HttpContext.Current.Session["role"] = "null";
}
else
{
System.Web.HttpContext.Current.Session["role"] = condition;
}
}
return(System.Web.HttpContext.Current.Session["role"].ToString());
}