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);
}
