Beispiel #1
0
        //- To get the GetCustomersAddress for Check In Page and Service Order Process

        public List <Address> GetCustomerAddress(string customerAccount, string userName)
        {
            IAXHelper      axHelper    = ObjectFactory.GetInstance <IAXHelper>();
            List <Address> addressList = new List <Address>();

            try
            {
                DataTable resultTable = axHelper.GetCustomerAddressList(customerAccount, userName);

                foreach (DataRow row in resultTable.Rows)
                {
                    Address addressObject = new Address();

                    addressObject.AddressId          = row["AddressId"].ToString();
                    addressObject.AddressDescription = row["AddressDesc"].ToString();
                    addressObject.AddressDetails     = row["Address"].ToString();
                    addressObject.AddresswithDesc    = addressObject.AddressDescription + " " + addressObject.AddressDetails;
                    addressObject.IsBilling          = row["IsBilling"].ToString();
                    addressObject.IsShipping         = row["IsShipping"].ToString();
                    addressList.Add(addressObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(addressList);
        }
Beispiel #2
0
        public List <WareHouse> GetWareHouses(string itemNumber, string site, string userName)
        {
            IAXHelper        axHelper      = ObjectFactory.GetInstance <IAXHelper>();
            List <WareHouse> wareHouseList = new List <WareHouse>();

            try
            {
                DataTable resultTable = axHelper.GetWareHouses(itemNumber, site, userName);

                foreach (DataRow row in resultTable.Rows)
                {
                    WareHouse wareHouseObject = new WareHouse();
                    wareHouseObject.WareHouseCode   = row["WareHouseID"].ToString();
                    wareHouseObject.WareHouseName   = row["WareHouseName"].ToString();
                    wareHouseObject.PhyiscalQty     = row["PhysicalQty"].ToString();
                    wareHouseObject.WareHouseandQty = wareHouseObject.WareHouseCode + " [Qty - " + wareHouseObject.PhyiscalQty + " ]";
                    wareHouseList.Add(wareHouseObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(wareHouseList);
        }
Beispiel #3
0
        //- 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>());
        }
        public IQueryable <RepairType> GetDiagnosisCode(string diagnosisArea, string userName)
        {
            IAXHelper         axHelper   = ObjectFactory.GetInstance <IAXHelper>();
            List <RepairType> repairList = new List <RepairType>();

            try
            {
                DataTable resultTable = axHelper.GetDiagnosisCodeList(diagnosisArea, userName);

                foreach (DataRow row in resultTable.Rows)
                {
                    RepairType repairObject = new RepairType();


                    repairObject.DiagonsisCodeId   = row["DiagnosisCodeId"].ToString();
                    repairObject.DiagonsisCodeName = row["Name"].ToString();
                    repairObject.DiagonsisAreaId   = row["DiagnosisAreaId"].ToString();
                    repairList.Add(repairObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(repairList.AsQueryable <RepairType>());
        }
        public List <RepairType> GetRepairStages(string userName)
        {
            IAXHelper         axHelper   = ObjectFactory.GetInstance <IAXHelper>();
            List <RepairType> repairList = new List <RepairType>();

            try
            {
                DataTable resultTable = axHelper.GetRespairStageList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    RepairType repairObject = new RepairType();

                    repairObject.RepairStageId   = row["RepairStageId"].ToString();
                    repairObject.RepairStageName = row["Name"].ToString();
                    repairList.Add(repairObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(repairList);
        }
        public IEnumerable <FailureCode> GetFailureCode(string userName)
        {
            IAXHelper          axHelper        = ObjectFactory.GetInstance <IAXHelper>();
            List <FailureCode> failureCodeList = new List <FailureCode>();

            try
            {
                DataTable resultTable = axHelper.GetFailureCodeList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    FailureCode failureCodeObject = new FailureCode();
                    failureCodeObject.FailureCodeNo      = row["FailureCode"].ToString();
                    failureCodeObject.FailureDescription = row["FailureCode"].ToString() + " - " + row["FailureDescription"].ToString();

                    failureCodeList.Add(failureCodeObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(failureCodeList.AsEnumerable <FailureCode>());
        }
Beispiel #7
0
        //- To get ServiceOrderLinesBySerialNumber in  Work Order Controller

        public List <ServiceOrderLine> GetServiceOrderLinesDetailsBySerialNumber(string serialNumber, string itemNumber, string userName)
        {
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
            List <ServiceOrderLine> serviceOrderList = new List <ServiceOrderLine>();

            try
            {
                DataTable resultTable = axHelper.GetServiceOrderLinesDetailsBySerialNumber(serialNumber, itemNumber, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    ServiceOrderLine serviceObject = new ServiceOrderLine();
                    serviceObject.SerialNumber = row["SerialNumber"].ToString();
                    serviceObject.PartNumber   = row["PartNumber"].ToString();
                    serviceObject.PartType     = row["PartType"].ToString();
                    serviceObject.Quantity     = row["Quantity"].ToString();
                    serviceObject.Warranty     = row["Warranty"].ToString();
                    serviceObject.RepairType   = row["RepairType"].ToString();
                    serviceObject.LineProperty = row["LineProperty"].ToString();
                    serviceOrderList.Add(serviceObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(serviceOrderList);
        }
        public IEnumerable <PartDetails> GetItemNumbers(string userName)
        {
            IAXHelper          axHelper       = ObjectFactory.GetInstance <IAXHelper>();
            List <PartDetails> itemnumberList = new List <PartDetails>();

            try
            {
                DataTable resultTable = axHelper.GetItemNumbersList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    PartDetails partObject = new PartDetails();
                    partObject.ItemNumber     = row["ItemNumber"].ToString();
                    partObject.ProductName    = row["ProductName"].ToString();
                    partObject.ProductSubType = row["ProductSubType"].ToString();
                    itemnumberList.Add(partObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(itemnumberList.AsEnumerable <PartDetails>());
        }
        public IEnumerable <SpecialtyCode> GetSpecialCodes(string userName, string TransactionId)
        {
            IAXHelper            axHelper          = ObjectFactory.GetInstance <IAXHelper>();
            List <SpecialtyCode> SpecialtyCodeList = new List <SpecialtyCode>();

            try
            {
                DataTable resultTable = axHelper.GetSpecialityCodeList(userName, TransactionId.ToString());


                foreach (DataRow row in resultTable.Rows)
                {
                    SpecialtyCode SpecialtyCodeObject = new SpecialtyCode();
                    SpecialtyCodeObject.SpecialityCodeNo      = row["SpecialityCode"].ToString();
                    SpecialtyCodeObject.SpecialityDescription = row["SpecialityDescription"].ToString();

                    SpecialtyCodeList.Add(SpecialtyCodeObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(SpecialtyCodeList.AsEnumerable <SpecialtyCode>());
        }
Beispiel #10
0
        //- To get the GetSites  for sites

        public IEnumerable <Site> GetSitesListByUsername(string userName)
        {
            List <Site> siteList = new List <Site> {
            };
            IAXHelper axHelper   = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                DataTable resultTable = axHelper.GetDefaultSitesByUsername(userName);

                foreach (DataRow row in resultTable.Rows)
                {
                    Site currentSite = new Site();
                    currentSite.Username  = row["User"].ToString();
                    currentSite.SiteID    = row["Sites"].ToString();
                    currentSite.SiteName  = row["SitesName"].ToString();
                    currentSite.IsDefault = row["Default"].ToString();
                    siteList.Add(currentSite);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(siteList.AsEnumerable <Site>());
        }
Beispiel #11
0
        //- To get the GetSites for Service Order Process Page
        public List <Site> GetSites(string userName)
        {
            List <Site> siteList = new List <Site> {
            };
            IAXHelper axHelper   = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                DataTable resultTable = axHelper.GetSitesList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    Site siteObject = new Site();
                    siteObject.SiteID   = row["SiteID"].ToString();
                    siteObject.SiteName = row["SiteName"].ToString();
                    siteList.Add(siteObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(siteList);
        }
        //- To get the GetSalesDetails for Sales History

        public List <SalesHistory> GetSalesDetails(string serialNumber, string userName)
        {
            IAXHelper           axHelper  = ObjectFactory.GetInstance <IAXHelper>();
            List <SalesHistory> salesList = new List <SalesHistory>();

            try
            {
                DataTable resultTable = axHelper.GetSalesInformation(serialNumber, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    SalesHistory salesObject = new SalesHistory();
                    salesObject.SalesOrderNumber  = row["SalesNumber"].ToString();
                    salesObject.InvoiceNumber     = row["InvoiceNumber"].ToString();
                    salesObject.InvoiceDate       = row["InvoiceDate"].ToString();
                    salesObject.CustomerName      = row["Name"].ToString();
                    salesObject.ItemNumber        = row["ItemNumber"].ToString();
                    salesObject.SalesSerialNumber = serialNumber;


                    salesList.Add(salesObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(salesList);
        }
        //  - To get the GetServiceDetails for Sales History, Check In Page and Service Order with History Page

        public List <SalesHistory> GetServiceDetails(string serialNumber, string userName)
        {
            IAXHelper           axHelper  = ObjectFactory.GetInstance <IAXHelper>();
            List <SalesHistory> salesList = new List <SalesHistory>();
            string salesprice;

            try
            {
                DataTable resultTable = axHelper.GetSalesHistory(serialNumber, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    SalesHistory salesObject = new SalesHistory();
                    salesObject.SalesServiceOrder = row["ServiceOrderId"].ToString();
                    salesprice             = row["SalesPrice"].ToString();
                    salesprice             = salesprice + ".00";
                    salesObject.SalesPrice = string.Format("{0:c}", salesprice);

                    salesObject.DateExecution = row["DateExecution"].ToString();
                    salesObject.Description   = row["Description"].ToString();
                    salesObject.CustomerName  = row["CustomerName"].ToString();


                    salesList.Add(salesObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(salesList);
        }
Beispiel #14
0
        //- To get the GetWOClassification for Check In Page

        public IEnumerable <WOClassification> GetWOClassification(string userName)
        {
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
            List <WOClassification> woClassificationList = new List <WOClassification>();

            try
            {
                DataTable resultTable = axHelper.GetWOClassificationList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    WOClassification woObject = new WOClassification();
                    woObject.WOClassificationCode = row["WOCode"].ToString();
                    woObject.WOClassificationName = row["WOCode"].ToString() + " - " + row["WODescription"].ToString();

                    woClassificationList.Add(woObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }

            return(woClassificationList.AsEnumerable <WOClassification>());
        }
        public IEnumerable <LineProperty> GetLineProperty(string userName)
        {
            IAXHelper           axHelper         = ObjectFactory.GetInstance <IAXHelper>();
            List <LineProperty> LinePropertyList = new List <LineProperty>();

            try
            {
                DataTable resultTable = axHelper.GetLinePropertyList(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    LineProperty LinePropertyObject = new LineProperty();
                    LinePropertyObject.LinePropertyCode        = row["LinePropertyCode"].ToString();
                    LinePropertyObject.LinePropertyDescription = row["LinePropertyName"].ToString();

                    LinePropertyList.Add(LinePropertyObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(LinePropertyList.AsEnumerable <LineProperty>());
        }
Beispiel #16
0
        //- To get the GetCustomers for Check In Page

        public IEnumerable <Customer> GetCustomers(string userName)
        {
            IAXHelper       axHelper     = ObjectFactory.GetInstance <IAXHelper>();
            List <Customer> customerList = new List <Customer>();

            try
            {
                DataTable resultTable = axHelper.GetCustomers(userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    Customer customerObject = new Customer();
                    customerObject.CustomerAccount = row["CustomerAccount"].ToString();
                    customerObject.CustomerName    = row["CustomerAccount"].ToString() + " - " + row["CustomerName"].ToString();

                    customerList.Add(customerObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(customerList.AsEnumerable <Customer>());
        }
        public bool UpdateRepairLineItems(string uniqueId, string serviceOrderNo, string serviceOrderRelation, string conditionId, string symptomAreaId, string symptomCodeId, string diagonsisAreaId, string diagonsisCodeId, string resolutionId, string repairStageId, string technicianNo, string description, string serviceComments, string userName)
        {
            bool isSuccess = false;

            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                isSuccess = axHelper.UpdateRepairLines(uniqueId, serviceOrderNo, serviceOrderRelation, conditionId, symptomAreaId, symptomCodeId, diagonsisAreaId, diagonsisCodeId, resolutionId, repairStageId, technicianNo, description, serviceComments, userName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(isSuccess);
        }
Beispiel #18
0
        public bool DeleteServiceOrderPartItemLines(string uniqueId, string userName)
        {
            bool isSuccess = false;

            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                isSuccess = axHelper.DeleteServiceOrderPartLines(uniqueId, userName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(isSuccess);
        }
Beispiel #19
0
        public bool UpdateServiceOrderPartLines(string uniqueId, string serviceOrderNo, string transactionType, string serviceTechnicianCode, string quantity, string specialityCode, string failureCode, string serviceType, string serviceOrderRelation, string description, string serviceComments, string itemNumber, string site, string wareHouse, string transSerialCodeNo, string colorId, string sizeId, string configId, string locationId, string userName)
        {
            bool isSuccess = false;

            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                isSuccess = axHelper.UpdateServiceOrderPartLines(uniqueId, serviceOrderNo, transactionType, serviceTechnicianCode, quantity, specialityCode, failureCode, serviceType, serviceOrderRelation, description, serviceComments, itemNumber, site, wareHouse, transSerialCodeNo, colorId, sizeId, configId, locationId, userName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(isSuccess);
        }
Beispiel #20
0
        //- To get Service orders  in Service Order with History

        public List <ServiceOrder> GetServiceOrders(string inventId, string progressId, string serviceorderId, string userName)
        {
            IAXHelper           axHelper         = ObjectFactory.GetInstance <IAXHelper>();
            List <ServiceOrder> serviceOrderList = new List <ServiceOrder>();

            try
            {
                DataTable resultTable = axHelper.GetServiceOrders(inventId, progressId, serviceorderId, userName);

                string status = "";
                foreach (DataRow row in resultTable.Rows)
                {
                    ServiceOrder serviceObject = new ServiceOrder();
                    serviceObject.ServiceOrderId = row["ServiceorderId"].ToString();
                    serviceObject.Customer       = new Models.Customer(row["CustAccount"].ToString(), row["CustomerName"].ToString());
                    serviceObject.CustomerPO     = row["CustomerPO"].ToString();
                    serviceObject.Description    = row["Description"].ToString();
                    status = row["Status"].ToString();
                    serviceObject.WOClassification   = new Models.WOClassification("", row["WOClassification"].ToString());
                    serviceObject.ServiceTechnician  = new Models.ServiceTechnician(row["ServiceTechnician"].ToString(), row["ServiceTechnicianNo"].ToString());
                    serviceObject.ServiceResponsible = new Models.ServiceTechnician(row["ServiceResponsible"].ToString(), "");
                    serviceObject.ServiceOrderDate   = Convert.ToDateTime(row["EntryDate"].ToString());
                    serviceObject.WOBillingAddress   = new Models.Address(row["BillingAddress"].ToString());
                    serviceObject.WOShippingAddress  = new Models.Address(row["ShippingAddress"].ToString());

                    if (status == "0")
                    {
                        serviceObject.Status = "In Process";
                    }
                    else if (status == "1")
                    {
                        serviceObject.Status = "Posted";
                    }
                    else if (status == "2")
                    {
                        serviceObject.Status = "Canceled";
                    }
                    serviceOrderList.Add(serviceObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(serviceOrderList);
        }
Beispiel #21
0
        public bool CreateServiceOrder(string sitesId, string customerAccount, string addressId, string customerPo, string technicinanNo, string responsibleNo, string woClassification, string customerComments, out string newSerivceOrder, string userName)
        {
            bool      isSuccess = false;
            object    newSerivceOrderobject;
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                newSerivceOrderobject = axHelper.CreateServiceOrder(sitesId, customerAccount, addressId, customerPo, technicinanNo, responsibleNo, woClassification, customerComments, userName);
                newSerivceOrder       = (string)newSerivceOrderobject;
                isSuccess             = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(isSuccess);
        }
        public List <RepairType> GetRepairLineDetails(string serviceorderId, string userName)
        {
            IAXHelper         axHelper   = ObjectFactory.GetInstance <IAXHelper>();
            List <RepairType> repairList = new List <RepairType>();

            try
            {
                DataTable resultTable = axHelper.GetRepairLines(serviceorderId, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    RepairType repairObject = new RepairType();
                    repairObject.RepServiceOrder       = row["RepServiceOrder"].ToString();
                    repairObject.UniqueId              = row["UniqueId"].ToString();
                    repairObject.ServiceObjectRelation = row["SORelationID"].ToString();
                    repairObject.Description           = row["Description"].ToString();
                    repairObject.ConditionId           = row["ConditionId"].ToString();
                    repairObject.SymptomAreaId         = row["SymptomAreaId"].ToString();
                    repairObject.SymptomCodeId         = row["SymptomCodeId"].ToString();
                    repairObject.DiagonsisAreaId       = row["DiagnosisAreaId"].ToString();
                    repairObject.DiagonsisCodeId       = row["DiagnosisCodeId"].ToString();
                    repairObject.ResolutionId          = row["ResolutionId"].ToString();
                    repairObject.RepairStageId         = row["RepairStageId"].ToString();
                    repairObject.ServiceTechnicianNo   = row["TechnicianNo"].ToString();
                    repairObject.ServiceTechnicianName = row["TechnicianName"].ToString();
                    //repairObject.Technician = new Models.ServiceTechnician(row["TechnicianName"].ToString(), row["TechnicianNo"].ToString());
                    repairObject.Comments = row["ServiceComments"].ToString();


                    repairList.Add(repairObject);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(repairList);
        }
Beispiel #23
0
        public List <SerivceOrderPartLine> GetTransactionSerialNumbers(string itemNumber, string site, string wareHouse, string locationId, string userName)
        {
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
            List <SerivceOrderPartLine> serialNumberList = new List <SerivceOrderPartLine>();

            try
            {
                DataTable resultTable = axHelper.GetTransactionSerialNumberList(itemNumber, site, wareHouse, locationId, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    SerivceOrderPartLine serviceObject = new SerivceOrderPartLine();
                    serviceObject.TransactionSerialNumber = row["SerialNumber"].ToString();
                    serialNumberList.Add(serviceObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(serialNumberList);
        }
Beispiel #24
0
        public List <Location> GetLocations(string itemNumber, string site, string warehouse, string userName)
        {
            IAXHelper       axHelper     = ObjectFactory.GetInstance <IAXHelper>();
            List <Location> locationList = new List <Location>();

            try
            {
                DataTable resultTable = axHelper.GetLocations(itemNumber, site, warehouse, userName);

                foreach (DataRow row in resultTable.Rows)
                {
                    Location locationObject = new Location();
                    locationObject.LocationId     = row["LocationID"].ToString();
                    locationObject.LocationQty    = row["PhysicalQty"].ToString();
                    locationObject.LocationandQty = locationObject.LocationId + " [Qty - " + locationObject.LocationQty + " ]";
                    locationList.Add(locationObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(locationList);
        }
Beispiel #25
0
        public IEnumerable <SerivceOrderPartLine> GetSerialNumberByServiceOrder(string serviceOrderID, string userName)
        {
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
            List <SerivceOrderPartLine> soRelationList = new List <SerivceOrderPartLine>();

            try
            {
                DataTable resultTable = axHelper.GetSerialNumberByServiceOrder(serviceOrderID, userName);


                foreach (DataRow row in resultTable.Rows)
                {
                    SerivceOrderPartLine serviceOrderPartObject = new SerivceOrderPartLine();
                    serviceOrderPartObject.ServiceObjectRelation = row["SORID"].ToString();
                    serviceOrderPartObject.SerialNumber          = row["SerialNumber"].ToString();
                    soRelationList.Add(serviceOrderPartObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(soRelationList.AsEnumerable <SerivceOrderPartLine>());
        }
Beispiel #26
0
        //- 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);
        }
Beispiel #27
0
        public bool CreateServiceOrderLinesItem(string newSerivceOrder, List <ServiceOrderLine> serviceOrderLinesList, string userName)
        {
            bool   isSuccess = false;
            string serialNumber;
            string partNumber;
            string partType;
            string quantity;
            string repairType;
            string warranty;
            string comments;
            //object newSerivceOrderobject;
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();

            try
            {
                foreach (ServiceOrderLine serviceorderlineItem in serviceOrderLinesList)
                {
                    serialNumber = serviceorderlineItem.SerialNumber;
                    partNumber   = serviceorderlineItem.PartNumber;
                    partType     = serviceorderlineItem.PartType;
                    quantity     = serviceorderlineItem.Quantity;
                    repairType   = serviceorderlineItem.RepairType;
                    warranty     = serviceorderlineItem.Warranty;
                    comments     = serviceorderlineItem.Comments;
                    isSuccess    = axHelper.CreateServiceOrderLinesList(newSerivceOrder, serialNumber, partNumber, partType, quantity, repairType, warranty, comments, userName);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }



            return(isSuccess);
        }
Beispiel #28
0
        public List <SerivceOrderPartLine> GetServiceOrderPartLineByServiceOrder(string serviceorderId, string userName)
        {
            IAXHelper axHelper = ObjectFactory.GetInstance <IAXHelper>();
            List <SerivceOrderPartLine> serviceOrderList = new List <SerivceOrderPartLine>();

            try
            {
                DataTable resultTable = axHelper.GetServiceOrderPartLineByServiceOrder(serviceorderId, userName);

                List <SerivceOrderPartLine> serviceOrder = new List <SerivceOrderPartLine>();

                string status      = "";
                string transaction = "";
                foreach (DataRow row in resultTable.Rows)
                {
                    SerivceOrderPartLine serviceObject = new SerivceOrderPartLine();
                    serviceObject.SerialNumber          = row["SerialNumber"].ToString();
                    serviceObject.ServiceObjectRelation = row["SORelationID"].ToString();
                    transaction = row["TransactionType"].ToString();

                    if (transaction == "3")
                    {
                        serviceObject.TransactionType = TransactionType.Item;
                    }
                    else if (transaction == "1")
                    {
                        serviceObject.TransactionType = TransactionType.Hour;
                    }
                    else if (transaction == "2")
                    {
                        serviceObject.TransactionType = TransactionType.Expense;
                    }
                    else if (transaction == "4")
                    {
                        serviceObject.TransactionType = TransactionType.Fee;
                    }
                    serviceObject.Description = row["Description"].ToString();

                    serviceObject.SpecialtyCode     = new Models.SpecialtyCode(row["SpecialityCode"].ToString(), "");
                    serviceObject.FailureCode       = new Models.FailureCode(row["FailureCode"].ToString(), "");
                    serviceObject.LineProperty      = new Models.LineProperty(row["LineProperty"].ToString(), "");
                    serviceObject.Quantity          = row["Qty"].ToString();
                    serviceObject.SalesPrice        = row["SalesPrice"].ToString();
                    serviceObject.ServiceTechnician = new Models.ServiceTechnician(row["Technician"].ToString(), row["TechnicianNo"].ToString());

                    serviceObject.ServiceComments         = row["ServiceComments"].ToString();
                    serviceObject.UniqueId                = row["UniqueId"].ToString();
                    serviceObject.PartDetails             = new Models.PartDetails(row["ItemNumber"].ToString(), "", "");
                    serviceObject.Site                    = new Models.Site("", row["Site"].ToString(), "", "");
                    serviceObject.WareHouse               = new Models.WareHouse(row["WareHouse"].ToString(), "", "", "");
                    serviceObject.SizeType                = row["Size"].ToString();
                    serviceObject.ColorType               = row["Color"].ToString();
                    serviceObject.ConfigType              = row["Config"].ToString();
                    serviceObject.Location                = new Models.Location(row["LocationId"].ToString(), "", "", "");
                    serviceObject.TransactionSerialNumber = row["TransSerialNumber"].ToString();
                    if (status == "0")
                    {
                        serviceObject.Status = "In Process";
                    }
                    else if (status == "1")
                    {
                        serviceObject.Status = "Posted";
                    }
                    serviceObject.ServiceOrder = serviceorderId;


                    serviceOrderList.Add(serviceObject);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(serviceOrderList);
        }