//- To get the GetTechnicians for Check In Page
public IEnumerable<ServiceTechnician> GetTechnicians(string userName)
{
IAXHelper axHelper = ObjectFactory.GetInstance<IAXHelper>();
List<ServiceTechnician> techniciansList = new List<ServiceTechnician>();
try
{
DataTable resultTable = axHelper.GetTechnicians(userName);
foreach (DataRow row in resultTable.Rows)
{
ServiceTechnician technicianObject = new ServiceTechnician();
technicianObject.ServiceTechnicianName = row["Name"].ToString();
technicianObject.ServiceTechnicianNo = row["Number"].ToString();
techniciansList.Add(technicianObject);
}
}
catch (Exception ex)
{
throw ex;
}
return techniciansList.AsEnumerable<ServiceTechnician>();
}
//- To get the GetTechnicians for Check In Page
public IEnumerable <ServiceTechnician> GetTechnicians(string userName)
{
IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
List <ServiceTechnician> techniciansList = new List <ServiceTechnician>();
try
{
DataTable resultTable = axHelper.GetTechnicians(userName);
foreach (DataRow row in resultTable.Rows)
{
ServiceTechnician technicianObject = new ServiceTechnician();
technicianObject.ServiceTechnicianName = row["Name"].ToString();
technicianObject.ServiceTechnicianNo = row["Number"].ToString();
techniciansList.Add(technicianObject);
}
}
catch (Exception ex)
{
throw ex;
}
return(techniciansList.AsEnumerable <ServiceTechnician>());
}
//- To get the GetTechniciansParts for Service Order Process Page
public List <ServiceTechnician> GetTechniciansServiceOrderProcess(string transactionType, string specialityCode, string userName)
{
IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
List <ServiceTechnician> techniciansList = new List <ServiceTechnician>();
try
{
DataTable resultTable = axHelper.GetTechniciansServiceOrderProcess(transactionType, specialityCode, userName);
foreach (DataRow row in resultTable.Rows)
{
ServiceTechnician technicianObject = new ServiceTechnician();
technicianObject.ServiceTechnicianName = row["Name"].ToString();
technicianObject.ServiceTechnicianNo = row["Number"].ToString();
techniciansList.Add(technicianObject);
}
}
catch (Exception ex)
{
throw ex;
}
return(techniciansList);
}
//
// GET: /RepairLines/
public ActionResult RepairLines()
{
TempData["ServiceOrderId"] = Session["SID"];
TempData["RepairSiteId"]=Session["SiteID"];
RepairType repairTypeObj = new RepairType();
string userName = User.Identity.Name.ToString().Split('\\')[1];
try
{
if (HttpContext.Session != null)
{
if (Session["SiteID"] == null)
{
return RedirectToAction("ServiceOrderWithHistory", "WorkOrder");
}
}
if (TempData["ServiceOrderId"] != null)
{
ServiceOrderLine serviceOrderLineobj = new ServiceOrderLine();
repairTypeObj.ServiceOrderLine = serviceOrderLineobj;
SerivceOrderPartLine serviceOrderPartLineObj = new SerivceOrderPartLine();
IEnumerable<SerivceOrderPartLine> serviceOrderPartLineCollection = null;
serviceOrderPartLineCollection = serviceOrderPartLineObj.GetSerialNumberByServiceOrder(TempData["ServiceOrderId"].ToString(), userName);
serviceOrderPartLineObj.ServiceOrderPartLineList = new SelectList(serviceOrderPartLineCollection, "SerialNumber", "SerialNumber", null);
ViewData["SerialNumberList"] = serviceOrderPartLineObj.ServiceOrderPartLineList;
repairTypeObj.ConditionList = new SelectList(repairTypeObj.GetCondtions(userName), "ConditionId", "ConditionName", null);
ViewData["Condition"] = repairTypeObj.ConditionList;
repairTypeObj.SysmptomAreaList = new SelectList(repairTypeObj.GetSymptomArea(userName), "SymptomAreaId", "SymptomAreaName", null);
ViewData["SymptomArea"] = repairTypeObj.SysmptomAreaList;
repairTypeObj.DiagnosisAreaList = new SelectList(repairTypeObj.GetDiagnosisArea(userName), "DiagonsisAreaId", "DiagonsisAreaName", null);
ViewData["DiagnosisArea"] = repairTypeObj.DiagnosisAreaList;
repairTypeObj.ResolutionList = new SelectList(repairTypeObj.GetResolution(userName), "ResolutionId", "ResolutionName", null);
ViewData["Resolution"] = repairTypeObj.ResolutionList;
repairTypeObj.RepairStageList = new SelectList(repairTypeObj.GetRepairStages(userName), "RepairStageId", "RepairStageName", null);
ViewData["RepairStage"] = repairTypeObj.RepairStageList;
//ServiceTechnician serviceTechnician = new ServiceTechnician();
//serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnician.GetTechnicians(userName), "ServiceTechnicianNo", "ServiceTechnicianName", null);
//ViewData["ServiceTechnicianList"] = serviceTechnician.ServiceTechnicianList;
ServiceOrder ServiceOrder = new ServiceOrder();
ServiceOrder.ServiceOrderList = GetServiceOrderDetailsByServiceOrder(TempData["RepairSiteId"].ToString(), TempData["ServiceOrderId"].ToString());
repairTypeObj.ServiceOrders = ServiceOrder;
ViewData["ServiceOrderDetailsinRepairLines"] = repairTypeObj.ServiceOrders.ServiceOrderList;
ServiceTechnician serviceTechnician = new ServiceTechnician();
IEnumerable<ServiceTechnician> serviceTechnicianCollection = null;
serviceTechnicianCollection = serviceTechnician.GetTechnicians(userName);
if (!String.IsNullOrEmpty(TempData["Technician-No"].ToString()))
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", serviceTechnicianCollection.First<ServiceTechnician>().ServiceTechnicianNo = TempData["Technician-No"].ToString());
}
else
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", null);
}
ViewData["ServiceTechnicianList"] = serviceTechnician.ServiceTechnicianList;
//List<RepairType> RepairLineList = (new RepairType()).GetRepairLineDetails(TempData["ServiceOrderId"].ToString(), userName);
//repairTypeObj.RepairLineList = new SelectList(repairTypeObj.GetRepairLineDetails(TempData["ServiceOrderId"].ToString(), userName));
//ViewData["RepairLinesList"] = GetRepairLinesDetails(TempData["ServiceOrderId"].ToString());
TempData.Keep();
}
else
{
return RedirectToAction("ServiceOrderWithHistory","WorkOrder");
}
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
}
return View(repairTypeObj);
}
//- To get the GetTechniciansParts for Service Order Process Page
public List<ServiceTechnician> GetTechniciansServiceOrderProcess(string transactionType, string specialityCode, string userName)
{
IAXHelper axHelper = ObjectFactory.GetInstance<IAXHelper>();
List<ServiceTechnician> techniciansList = new List<ServiceTechnician>();
try
{
DataTable resultTable = axHelper.GetTechniciansServiceOrderProcess(transactionType, specialityCode, userName);
foreach (DataRow row in resultTable.Rows)
{
ServiceTechnician technicianObject = new ServiceTechnician();
technicianObject.ServiceTechnicianName = row["Name"].ToString();
technicianObject.ServiceTechnicianNo = row["Number"].ToString();
techniciansList.Add(technicianObject);
}
}
catch (Exception ex)
{
throw ex;
}
return techniciansList;
}
// GET: /ServiceOrderProcess/
public ActionResult ServiceOrderProcess()
{
string userName = "";
TempData["ServiceOrderId"] = Session["SID"];
TempData["WorkOrderSiteId"] = Session["SiteID"];
userName = User.Identity.Name.ToString().Split('\\')[1];
SerivceOrderPartLine serivceOrderPartLineObject = new SerivceOrderPartLine();
ServiceOrderLine serivceOrderLineObject = new ServiceOrderLine();
List<ServiceOrderLine> serviceOrderLineList = new List<ServiceOrderLine>();
try
{
if (HttpContext.Session != null)
{
if (Session["SiteID"] == null)
{
return RedirectToAction("ServiceOrderWithHistory");
}
}
if (TempData["ServiceOrderId"] != null)
{
serivceOrderLineObject.ServiceOrderLineList = serviceOrderLineList;
serivceOrderPartLineObject.ServiceOrderLine = serivceOrderLineObject;
FailureCode failureCodeObject = new FailureCode();
IEnumerable<FailureCode> failureCodeCollection = failureCodeObject.GetFailureCode(userName);
failureCodeObject.FailureCodeList = new SelectList(failureCodeCollection, "FailureCodeNo", "FailureDescription", null);
ViewData["FailureCodeList"] = failureCodeObject.FailureCodeList;
PartDetails partDetails = new PartDetails();
partDetails.PartDetailsList = new SelectList(partDetails.GetItemNumbers(userName), "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
LineProperty LinePropertyObject = new LineProperty();
IEnumerable<LineProperty> LinePropertyCollection = LinePropertyObject.GetLineProperty(userName);
LinePropertyObject.LinePropertyList = new SelectList(LinePropertyCollection, "LinePropertyCode", "LinePropertyDescription", null);
ViewData["LinePropertyList"] = LinePropertyObject.LinePropertyList;
IEnumerable<SerivceOrderPartLine> serviceOrderPartLineCollection = null;
serviceOrderPartLineCollection = serivceOrderPartLineObject.GetSerialNumberByServiceOrder(TempData["ServiceOrderId"].ToString(), userName);
serivceOrderPartLineObject.ServiceOrderPartLineList = new SelectList(serviceOrderPartLineCollection, "ServiceObjectRelation", "SerialNumber", null);
ViewData["SORelationList"] = serivceOrderPartLineObject.ServiceOrderPartLineList;
ViewData["WorkSerialNumberList"] = serivceOrderPartLineObject.ServiceOrderPartLineList;
ViewData["ServiceOrderPartLines"] = GetServiceOrderPartLinesByServiceOrderID(TempData["ServiceOrderId"].ToString());
ServiceOrder ServiceOrder = new ServiceOrder();
ServiceOrder.ServiceOrderList = GetServiceOrderDetailsByServiceOrder(TempData["WorkOrderSiteId"].ToString(), TempData["ServiceOrderId"].ToString());
serivceOrderPartLineObject.ServiceOrders = ServiceOrder;
ViewData["ServiceOrderLineinProcess"] = serivceOrderPartLineObject.ServiceOrders.ServiceOrderList;
ServiceTechnician serviceTechnician = new ServiceTechnician();
IEnumerable<ServiceTechnician> serviceTechnicianCollection = null;
serviceTechnicianCollection=serviceTechnician.GetTechnicians(userName);
if (!String.IsNullOrEmpty(TempData["Technician"].ToString()))
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", serviceTechnicianCollection.First<ServiceTechnician>().ServiceTechnicianNo = TempData["Technician"].ToString());
}
else
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", null);
}
ViewData["ServiceTechnicianLoadList"] = serviceTechnician.ServiceTechnicianList;
Site site = new Site();
IEnumerable<Site> siteCollection = null;
siteCollection = site.GetSites(userName);
if (!String.IsNullOrEmpty(TempData["WorkOrderSiteId"].ToString()))
{
site.SiteList = new SelectList(siteCollection, "SiteId", "SiteName", siteCollection.First<Site>().SiteID = TempData["WorkOrderSiteId"].ToString());
}
else
{
site.SiteList = new SelectList(siteCollection, "SiteId", "SiteName", siteCollection.First<Site>().SiteID);
}
ViewData["siteList"] = site.SiteList;
ViewData["TranasactionTypes"] = TransactionType.GetTransactionTypes();
TempData.Keep();
}
else
{
return RedirectToAction("ServiceOrderWithHistory");
// return View("ServiceOrderWithHistory", serivceOrderPartLineObject);
//throw new Exception("Select the service order number in Service Order with history page");
}
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
// throw new Exception("Select the service order number in Service Order with history page");
//return RedirectToAction("ServiceOrderWithHistory");
// return Json("Select the service order number in Service Order with history page",JsonRequestBehavior.AllowGet);
}
return View(serivceOrderPartLineObject);
}
public ActionResult CheckIn()
{
ServiceOrder serviceOrder = new ServiceOrder();
Customer customer = new Customer();
WOClassification woClassification = new WOClassification();
List<WOClassification> woClassificationCollection = new List<WOClassification>();
ServiceTechnician serviceTechnician = new ServiceTechnician();
List<ServiceTechnician> serviceTechnicianCollection = new List<ServiceTechnician>();
PartDetails partDetails = new PartDetails();
List<PartDetails> partDetailsCollection = new List<PartDetails>();
ServiceOrderLine serviceOrderLine = new ServiceOrderLine();
List<ServiceOrderLine> serviceOrderLineList = new List<ServiceOrderLine>();
List<Address> addressList = new List<Address>();
string userName = null;
userName = User.Identity.Name.ToString().Split('\\')[1];
try
{
if (HttpContext.Session != null)
{
if (Session["SiteID"] == null)
{
RedirectToAction("ServiceOrderWithHistory", "WorkOrder");
}
}
IEnumerable<Customer> customerCollection = customer.GetCustomers(User.Identity.Name.ToString().Split('\\')[1]);
customer.CustomerList = new SelectList(customerCollection, "CustomerAccount", "CustomerName", null);
serviceOrder.Customer = customer;
ViewData["CustomerList"] = customer.CustomerList;
woClassification.WOClassificationList = new SelectList(woClassificationCollection.AsEnumerable<WOClassification>(), "WOClassificationCode", "WOClassificationName", null);
serviceOrder.WOClassification = woClassification;
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection.AsEnumerable<ServiceTechnician>(), "ServiceTechnicianNo", "ServiceTechnicianName", null);
serviceOrder.ServiceTechnician = serviceTechnician;
serviceOrder.ServiceResponsible = serviceTechnician;
partDetails.PartDetailsList = new SelectList(partDetailsCollection.AsEnumerable<PartDetails>(), "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
serviceOrder.PartDetails = partDetails;
ViewData["ServiceOrderLine"] = serviceOrderLineList;
TempData["ServiceOrderLine"] = serviceOrderLineList;
serviceOrderLine.ServiceOrderLineList = serviceOrderLineList;
serviceOrder.ServiceOrderLine = serviceOrderLine;
ViewData["BillingAddress"] = addressList;
ViewData["ShippingAddress"] = addressList;
serviceOrder.BillingAddressList = addressList;
serviceOrder.ShippingAddressList = addressList;
ViewData["ServiceOrder"] = serviceOrder;
TempData.Keep();
}
catch(Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
}
return View(serviceOrder);
}
public JsonResult GetOtherDetails(string customerAccount)
{
WOClassification woClassification = new WOClassification();
ServiceTechnician serviceTechnician = new ServiceTechnician();
PartDetails partDetails = new PartDetails();
ServiceOrder serviceOrder = new ServiceOrder();
ServiceOrderLine serviceOrderLine = new ServiceOrderLine();
string userName = null;
try
{
if (customerAccount != null)
{
userName = User.Identity.Name.ToString().Split('\\')[1];
List<Address> addressList = (new Address()).GetCustomerAddress(customerAccount, userName);
List<Address> addressShipping = (from item1 in addressList
where item1.IsShipping == "1"
select item1).ToList<Address>();
List<Address> addressBilling = (from item1 in addressList
where item1.IsBilling == "1"
select item1).ToList<Address>();
if (addressShipping.Count >= 1)
{
for (int i=0; i <= addressShipping.Count-1; i++)
{
if (i == 0)
{
addressShipping[i].IsSelected = "checked";
}
else
{
addressShipping[i].IsSelected = null;
}
}
serviceOrder.ShippingAddressList = addressShipping;
}
//ViewData["BillingAddress"] = addressBilling;
//ViewData["ShippingAddress"] = addressShipping;
TempData["CustomerAccount"] = customerAccount;
serviceOrder.BillingAddressList = addressBilling;
IEnumerable<WOClassification> woClassificationCollection = woClassification.GetWOClassification(User.Identity.Name.ToString().Split('\\')[1]);
woClassification.WOClassificationList = new SelectList(woClassificationCollection, "WOClassificationCode", "WOClassificationName", null);
//ViewData["WOClassificationList"] = woClassification.WOClassificationList;
serviceOrder.WOClassification = woClassification;
IEnumerable<ServiceTechnician> serviceTechnicianCollection = serviceTechnician.GetTechnicians(User.Identity.Name.ToString().Split('\\')[1]);
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", null);
//ViewData["ServiceTechnicianList"] = serviceTechnician.ServiceTechnicianList;
//ViewData["ServiceResponsibleList"] = serviceTechnician.ServiceTechnicianList;
serviceOrder.ServiceTechnician = serviceTechnician;
serviceOrder.ServiceResponsible = serviceTechnician;
IEnumerable<PartDetails> partDetailsCollection = partDetails.GetItemNumbers(User.Identity.Name.ToString().Split('\\')[1]);
//partDetails.PartDetailsList1 = partDetailsCollection.ToList<PartDetails>();
partDetails.PartDetailsList = new SelectList(partDetailsCollection, "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
serviceOrder.PartDetails = partDetails;
serviceOrderLine.ServiceOrderLineList = new List<ServiceOrderLine>();
serviceOrder.ServiceOrderLine = serviceOrderLine;
}
TempData.Keep();
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
}
return Json(serviceOrder, JsonRequestBehavior.AllowGet);
}