public static string GetReportStatusByOrderId(int orderId) { using (EknowIDContext ctx = new EknowIDContext()) { var invitationorderStatus = (from order in ctx.Orders where order.OrderId == orderId select order.Status).FirstOrDefault(); var orderStatus = (from oderStatus in ctx.OrderStates where oderStatus.OrderId == orderId select oderStatus.TazWorksStatus).FirstOrDefault(); if (invitationorderStatus == 1) { return("Email Invite Sent"); } else if (orderStatus == 10) { return("Completed"); } else if (orderStatus == 7) { return("Applicant Pending"); } else if (orderStatus == 12) { return("Research under way"); } else if (orderStatus == 2) { return("Pending"); } else if (orderStatus == 3) { return("Failed"); } else if (orderStatus == 4) { return("Completed"); } else if (orderStatus == 6) { return("Canceled"); } else if (orderStatus == 8) { return("Applicant Process"); } else if (orderStatus == 9) { return("Error"); } else { return(string.Empty); } } }
public static List <string> GetAdditionalReportNameList(int orderID) { List <string> lstReport = new List <string>(); using (EknowIDContext ctx = new EknowIDContext()) { lstReport = (from alacartReports in ctx.AlacartReport join report in ctx.Reports on new { alacartReports.ReportId } equals new { report.ReportId } where alacartReports.OrderId == orderID select report.Name).ToList <string>(); } return(lstReport); }
public static List <string> GetReportList(int orderID) { List <string> lstReport = new List <string>(); using (EknowIDContext ctx = new EknowIDContext()) { lstReport = (from order in ctx.Orders join planReport in ctx.PlanReports on new { order.PlanId } equals new { planReport.PlanId } join report in ctx.Reports on new { planReport.ReportId } equals new { report.ReportId } where order.OrderId == orderID select report.Name).ToList <string>(); } return(lstReport); }
public static bool UpdateOrderStatus(int orderId, int orderStatus) { using (EknowIDContext ctx = new EknowIDContext()) { var orderDetail = ctx.Orders.Where(odr => odr.OrderId == orderId).FirstOrDefault(); if (orderDetail != null) { orderDetail.Status = orderStatus; return(ctx.SaveChanges() > 0); } return(false); } }
public static List <OrderHistory> GetPendingOrderState(int userID, bool isAdmin) { List <int> orderStateIDs = null; List <Order> orderData = new List <Order>(); List <OrderHistory> orderHistoryList = new List <OrderHistory>(); using (EknowIDContext ctx = new EknowIDContext()) { orderStateIDs = (from ordstate in ctx.OrderStates where ordstate.TazWorksStatus == 2 select ordstate.OrderId).Distinct().ToList <int>(); } if (isAdmin) { foreach (int orderID in orderStateIDs) { ISpecification <Order> orderSpc = new Specification <Order>(u => u.OrderId == orderID); Repository <Order> orderRep = new Repository <Order>(); IList <Order> order = orderRep.SelectAll(orderSpc); if (order.Count > 0) { orderData.Add(order[0]); } } } else { foreach (int orderID in orderStateIDs) { ISpecification <Order> orderSpc = new Specification <Order>(u => u.UserId == userID && u.OrderId == orderID); Repository <Order> orderRep = new Repository <Order>(); IList <Order> order = orderRep.SelectAll(orderSpc); if (order.Count > 0) { orderData.Add(order[0]); } } } foreach (Order or in orderData) { orderHistoryList.Add(GetOrderHistoryByPlanId(or)); } return(orderHistoryList); }
public static List <int> GetPendingOrders() { using (EknowIDContext ctx = new EknowIDContext()) { var applicantOrderType = ctx.OrderType.Where(o => o.OrderTypeName == "Applicant/Candidate").FirstOrDefault(); if (applicantOrderType == null) { return(null); } var query = (from order in ctx.Orders join orderStates in ctx.OrderStates on new { order.OrderId } equals new { orderStates.OrderId } where order.OrderTypeID != applicantOrderType.OrderTypeID && orderStates.TazWorksStatus == 2 select orderStates.OrderId); return(query.Distinct().ToList()); } }
public static List <OrderHistory> GetSearchResult(int userID, bool isAdmin, string purchasedDate, string applicantName, string purchasedPlan) { var orderData = new List <Order>(); var orderHistoryList = new List <OrderHistory>(); using (EknowIDContext ctx = new EknowIDContext()) { var query = (from ordstate in ctx.OrderStates join order in ctx.Orders on ordstate.OrderId equals order.OrderId join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId select new { Order = order, Candidate = candidate, OrderState = ordstate }); if (applicantName != string.Empty && purchasedDate == string.Empty && purchasedPlan != string.Empty) { query = query.Where(t => t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)); } else if (purchasedDate != string.Empty && applicantName == string.Empty && purchasedPlan == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt)); } else if (purchasedPlan != string.Empty && applicantName == string.Empty && purchasedPlan == string.Empty) { query = query.Where(t => t.Order.Plan.Name.Contains(purchasedPlan)); } else if (applicantName != string.Empty && purchasedDate != string.Empty && purchasedPlan == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt)); } else if (applicantName != string.Empty && purchasedPlan != string.Empty && purchasedDate == string.Empty) { query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && t.Order.Plan.Name.Contains(purchasedPlan)); } else if (purchasedDate != string.Empty && purchasedPlan != string.Empty && applicantName == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt) && t.Order.Plan.Name.Contains(purchasedPlan)); } else if (applicantName != string.Empty && purchasedDate != string.Empty && purchasedPlan != string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt) && t.Order.Plan.Name.Contains(purchasedPlan)); } if (!isAdmin) { query = query.Where(t => t.Order.UserId == userID); } orderData = query.Select(t => t.Order).Distinct().ToList(); } foreach (Order or in orderData) { orderHistoryList.Add(GetOrderHistoryByPlanId(or)); } return(orderHistoryList); #region old //using (EknowIDContext ctx = new EknowIDContext()) //{ // if (applicantName != string.Empty && purchasedDate == string.Empty && purchasedPlan == string.Empty) // { // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && (candidate.FirstName.Contains(applicantName) || candidate.LastName.Contains(applicantName))) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else if (purchasedDate != string.Empty && applicantName == string.Empty && purchasedPlan == string.Empty) // { // DateTime dt = DateTime.Parse(purchasedDate); // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && EntityFunctions.TruncateTime(order.PurchasedDate) == EntityFunctions.TruncateTime(dt)) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else if (purchasedPlan != string.Empty && applicantName == string.Empty && purchasedDate == string.Empty) // { // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && (order.Plan.Name.Contains(purchasedPlan))) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else if (applicantName != string.Empty && purchasedDate != string.Empty) // { // DateTime dt = DateTime.Parse(purchasedDate); // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && ((candidate.FirstName.Contains(applicantName) || candidate.LastName.Contains(applicantName)) && // (EntityFunctions.TruncateTime(order.PurchasedDate) == EntityFunctions.TruncateTime(dt)))) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else if (applicantName != string.Empty && purchasedPlan != string.Empty) // { // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && (candidate.FirstName.Contains(applicantName) || candidate.LastName.Contains(applicantName)) && // (order.Plan.Name == purchasedPlan)) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else if (purchasedDate != string.Empty && purchasedPlan != string.Empty) // { // DateTime dt = DateTime.Parse(purchasedDate); // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where (ordstate.TazWorksStatus == 2 && (order.Plan.Name.Contains(purchasedPlan)) && // (EntityFunctions.TruncateTime(order.PurchasedDate) == EntityFunctions.TruncateTime(dt))) // select ordstate.OrderId).Distinct().ToList<int>(); // } // else // { // orderStateIDs = (from ordstate in ctx.OrderStates // join order in ctx.Orders on ordstate.OrderId equals order.OrderId // join candidate in ctx.Candidate on order.OrderId equals candidate.OrderId // where ordstate.TazWorksStatus == 2 // select ordstate.OrderId).Distinct().ToList<int>(); // } //} //if (isAdmin) //{ // foreach (int orderID in orderStateIDs) // { // ISpecification<Order> orderSpc = new Specification<Order>(u => u.OrderId == orderID); // Repository<Order> orderRep = new Repository<Order>(); // IList<Order> order = orderRep.SelectAll(orderSpc); // if (order.Count > 0) // { // orderData.Add(order[0]); // } // } //} //else //{ // foreach (int orderID in orderStateIDs) // { // ISpecification<Order> orderSpc = new Specification<Order>(u => u.UserId == userID && u.OrderId == orderID); // Repository<Order> orderRep = new Repository<Order>(); // IList<Order> order = orderRep.SelectAll(orderSpc); // if (order.Count > 0) // { // orderData.Add(order[0]); // } // } //} #endregion }
public static List <OrderHistory> GetOrders(int userID, bool isAdmin, string purchasedDate, string applicantName, string purchasedPlan) { var orderData = new List <Order>(); var orderHistoryList = new List <OrderHistory>(); using (EknowIDContext ctx = new EknowIDContext()) { var query = (from ordstate in ctx.OrderStates join order in ctx.Orders on ordstate.OrderId equals order.OrderId from candidate in ctx.Candidate select new { Order = order, Candidate = candidate, OrderState = ordstate }); if (applicantName != string.Empty && purchasedDate == string.Empty && purchasedPlan == string.Empty) { query = query.Where(t => t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)); } else if (purchasedDate != string.Empty && applicantName == string.Empty && purchasedPlan == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt)); } else if (purchasedPlan != string.Empty && applicantName == string.Empty && purchasedDate == string.Empty) { query = query.Where(t => t.Order.Plan.Name.Contains(purchasedPlan)); } else if (applicantName != string.Empty && purchasedDate != string.Empty && purchasedPlan == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt)); } else if (applicantName != string.Empty && purchasedPlan != string.Empty && purchasedDate == string.Empty) { query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && t.Order.Plan.Name.Contains(purchasedPlan)); } else if (purchasedDate != string.Empty && purchasedPlan != string.Empty && applicantName == string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt) && t.Order.Plan.Name.Contains(purchasedPlan)); } else if (applicantName != string.Empty && purchasedDate != string.Empty && purchasedPlan != string.Empty) { DateTime dt = DateTime.Parse(purchasedDate); query = query.Where(t => (t.Candidate.FirstName.Contains(applicantName) || t.Candidate.LastName.Contains(applicantName)) && EntityFunctions.TruncateTime(t.Order.PurchasedDate) == EntityFunctions.TruncateTime(dt) && t.Order.Plan.Name.Contains(purchasedPlan)); } if (!isAdmin) { query = query.Where(t => t.Order.UserId == userID); } orderData = query.Select(t => t.Order).Distinct().ToList(); } foreach (Order or in orderData) { orderHistoryList.Add(GetOrderHistoryByPlanId(or)); } return(orderHistoryList); }