예제 #1
0
        public CustomerVehicleGetResponse CustomerVehicleGet(CustomerVehicleGetRequest request)
        {
            CustomerVehicleGetResponse response = new CustomerVehicleGetResponse();

            if (WA.Standard.IF.Logger.Log.Log.RunningMode.Equals(WA.Standard.IF.Data.v2.Common.Common.RunningMode.Mapper))
            {
                #region For Mapper Process
                WA.Standard.IF.Proxy.v2.Common.CustomerVehicle_Proxy proxy = new Proxy.v2.Common.CustomerVehicle_Proxy();
                response = proxy.CustomerVehicleGet(request);
                #endregion
            }
            else if (WA.Standard.IF.Logger.Log.Log.RunningMode.Equals(WA.Standard.IF.Data.v2.Common.Common.RunningMode.XMLDMS))
            {
                response.TransactionHeader = request.TransactionHeader;

                #region For XML Process
                List<CustomerVehicle> CustomerVehicles = Util.DataHelper.GetListByElementName<CustomerVehicle>(System.Web.HttpContext.Current.Server.MapPath("/v2/Repository/CustomerVehicles.xml"), "CustomerVehicle");

                if (CustomerVehicles != null && CustomerVehicles.Count > 0)
                {
                    List<CustomerVehicle> resultlist = CustomerVehicles
                        .Where(item =>
                            (request.CustomerVehicleGet.Customer == null
                                || (request.CustomerVehicleGet.Customer != null
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Customer.CardNo) || request.CustomerVehicleGet.Customer.CardNo == item.Customer.CardNo)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Customer.DMSCustomerNo) || request.CustomerVehicleGet.Customer.DMSCustomerNo == item.Customer.DMSCustomerNo)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Customer.Email) || request.CustomerVehicleGet.Customer.Email == item.Customer.Email)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Customer.LastName) || request.CustomerVehicleGet.Customer.LastName == item.Customer.LastName)
                                //Need to add condition, Contacts
                                )
                            ) &&
                            (request.CustomerVehicleGet.Vehicle == null
                                || (request.CustomerVehicleGet.Vehicle != null
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Vehicle.DMSVehicleNo) || request.CustomerVehicleGet.Vehicle.DMSVehicleNo == item.Vehicle.DMSVehicleNo)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Vehicle.LastSixVIN) || request.CustomerVehicleGet.Vehicle.LastSixVIN == item.Vehicle.LastSixVIN)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Vehicle.LicensePlateNo) || request.CustomerVehicleGet.Vehicle.LicensePlateNo == item.Vehicle.LicensePlateNo)
                                    && (string.IsNullOrEmpty(request.CustomerVehicleGet.Vehicle.VIN) || request.CustomerVehicleGet.Vehicle.VIN == item.Vehicle.VIN)
                                )
                            )).ToList<CustomerVehicle>();

                    response.CustomerVehicles = resultlist;

                    if (resultlist.Count > 0)
                        response.ResultMessage = GetResultMessageData(ResponseCode.Success, ResponseMessage.Success);
                    else
                        response.ResultMessage = GetResultMessageData(ResponseCode.NoResult, ResponseMessage.NoResult);
                }
                else
                {
                    response.ResultMessage = GetResultMessageData(ResponseCode.NoResult, ResponseMessage.NoResult);
                }
                #endregion
            }
            else if (WA.Standard.IF.Logger.Log.Log.RunningMode.Equals(WA.Standard.IF.Data.v2.Common.Common.RunningMode.DBDMS))
            {
                #region For DB Process

                /*
                DataSet resultDS = new DataSet();
                using (CustomerVehicle_Dac dac = new CustomerVehicle_Dac())
                {
                    if (request.CustomerVehicleGet.Customer != null && request.CustomerVehicleGet.Customer.Contacts != null)
                    {
                        foreach (WA.Standard.IF.Data.v2.Common.CustomerVehicle.Contact contact in request.CustomerVehicleGet.Customer.Contacts)
                        {
                            DataSet ds = dac.SelectCustomerVehicle(request.TransactionHeader.CountryID
                                                                , request.TransactionHeader.DistributorID
                                                                , request.TransactionHeader.GroupID
                                                                , request.TransactionHeader.DealerID
                                                                , request.TransactionHeader.Language // Need to check
                                                                , contact.ContactType
                                                                , contact.ContactValue
                                                                , request.CustomerVehicleGet
                                                                );
                            //Merging all data. Because same appointment could be return from sql server.
                            resultDS.Merge(ds);
                        }
                        //Remove duplicate rows by key field
                        if (resultDS.Tables != null)
                        {
                            for (int i = 0; i < resultDS.Tables.Count; i++)
                            {
                                if (i == 0)
                                    Util.DataHelper.RemoveDuplicateRows(resultDS.Tables[i], "DMSCustomerNo");
                                else if (i == 1)
                                    Util.DataHelper.RemoveDuplicateRows(resultDS.Tables[i], "DMSAddressNo");
                                else if (i == 2)
                                    Util.DataHelper.RemoveDuplicateRows(resultDS.Tables[i], "DMSContactNo");
                                else if (i == 3)
                                    Util.DataHelper.RemoveDuplicateRows(resultDS.Tables[i], "DMSCorporateInfoNo");
                                else if (i == 4)
                                    Util.DataHelper.RemoveDuplicateRows(resultDS.Tables[i], "DMSCampaignNo");
                            }
                        }
                    }
                    else
                    {
                        resultDS = dac.SelectCustomerVehicle(request.TransactionHeader.CountryID
                                                                , request.TransactionHeader.DistributorID
                                                                , request.TransactionHeader.GroupID
                                                                , request.TransactionHeader.DealerID
                                                                , request.TransactionHeader.Language //language
                                                                , null //contact.ContactType
                                                                , null //contact.ContactValue
                                                                , request.CustomerVehicleGet
                                                                );
                    }
                }

                //0. Customer
                //1. Address
                //2. Contact
                //3. CorporateInfo
                //4. Customer
                //5. Vehicle
                //6. Campaigns

                if (resultDS.Tables != null && resultDS.Tables.Count > 0)
                {
                    List<CustomerVehicle> CustomerVehicles = null;

                    if (resultDS.Tables[0].Rows.Count > 0)
                    {
                        #region CustomerVehicles
                        CustomerVehicles = resultDS.Tables[0].AsEnumerable()
                            .Select(row =>
                        new CustomerVehicle
                        {
                            Customer = new Data.v2.Common.Customer.Customer()
                            {
                                CardNo = Util.DataHelper.ConvertObjectToString(row["CardNo"]),
                                CustomerInfoType = Util.DataHelper.ConvertObjectToString(row["CustomerInfoType"]),
                                DMSCustomerNo = Util.DataHelper.ConvertObjectToString(row["DMSCustomerNo"]),
                                Email = Util.DataHelper.ConvertObjectToString(row["Email"]),
                                FirstName = Util.DataHelper.ConvertObjectToString(row["FirstName"]),
                                FullName = Util.DataHelper.ConvertObjectToString(row["FullName"]),
                                Gender = Util.DataHelper.ConvertObjectToString(row["Gender"]),
                                LastName = Util.DataHelper.ConvertObjectToString(row["LastName"]),
                                MiddleName = Util.DataHelper.ConvertObjectToString(row["MiddleName"]),
                                Salutation = Util.DataHelper.ConvertObjectToString(row["Salutation"]),
                                SpecialMessage = new SpecialMessage() { Message = Util.DataHelper.ConvertObjectToString(row["SpecialMessage"], null) },
                                Addresses = new List<Address>(),
                                Contacts = new List<Data.v2.Common.Customer.Contact>(),
                                CorporateInfos = new List<CorporateInfo>(),
                            },
                            Vehicle = new Data.v2.Common.Vehicle.Vehicle()
                            {
                                Color = Util.DataHelper.ConvertObjectToString(row["Color"]),
                                Cylinders = Util.DataHelper.ConvertObjectToString(row["Cylinders"]),
                                DateDelivered = Util.DataHelper.ConvertObjectToDateTime(row["DateDelivered"]),
                                DateInService = Util.DataHelper.ConvertObjectToDateTime(row["DateInService"]),
                                DeclinedJob = Util.DataHelper.ConvertObjectToString(row["DeclinedJob"]),
                                DisplayDescription = Util.DataHelper.ConvertObjectToString(row["DisplayDescription"]),
                                DMSCustomerNo = Util.DataHelper.ConvertObjectToString(row["DMSCustomerNo"]),
                                DMSVehicleNo = Util.DataHelper.ConvertObjectToString(row["DMSVehicleNo"]),
                                EngineType = Util.DataHelper.ConvertObjectToString(row["EngineType"]),
                                ExtendedWarranty = Util.DataHelper.ConvertObjectToDateTime(row["ExtendedWarranty"]),
                                FuelType = Util.DataHelper.ConvertObjectToString(row["FuelType"]),
                                FullModelName = Util.DataHelper.ConvertObjectToString(row["FullModelName"]),
                                InsuranceDate = Util.DataHelper.ConvertObjectToDateTime(row["InsuranceDate"]),
                                LastMileage = Util.DataHelper.ConvertObjectToString(row["LastMileage"]),
                                LastServiceDate = Util.DataHelper.ConvertObjectToDateTime(row["LastServiceDate"]),
                                LastSixVIN = Util.DataHelper.ConvertObjectToString(row["LastSixVIN"]),
                                LicenseNumber = Util.DataHelper.ConvertObjectToString(row["LicenseNumber"]),
                                LicensePlateNo = Util.DataHelper.ConvertObjectToString(row["LicensePlateNo"]),
                                Make = Util.DataHelper.ConvertObjectToString(row["Make"]),
                                ModelCode = Util.DataHelper.ConvertObjectToString(row["ModelCode"]),
                                ModelName = Util.DataHelper.ConvertObjectToString(row["ModelName"]),
                                ModelYear = Util.DataHelper.ConvertObjectToString(row["ModelYear"]),
                                PendingJob = Util.DataHelper.ConvertObjectToString(row["PendingJob"]),
                                StockNumber = Util.DataHelper.ConvertObjectToString(row["StockNumber"]),
                                Trim = Util.DataHelper.ConvertObjectToString(row["Trim"]),
                                VehicleType = Util.DataHelper.ConvertObjectToString(row["VehicleType"]),
                                VIN = Util.DataHelper.ConvertObjectToString(row["VIN"]),
                                WarrantyMiles = Util.DataHelper.ConvertObjectToString(row["WarrantyMiles"]),
                                WarrantyMonths = Util.DataHelper.ConvertObjectToString(row["WarrantyMonths"]),
                                WarrantyStartDate = Util.DataHelper.ConvertObjectToDateTime(row["WarrantyStartDate"]),
                                Campaigns = new List<Campaign>(),
                            }
                        }).ToList();
                        #endregion

                        if (CustomerVehicles != null && CustomerVehicles.Count > 0)
                        {
                            foreach (CustomerVehicle customervehicle in CustomerVehicles)
                            {
                                if (resultDS.Tables.Count > 1 && resultDS.Tables[1].Rows.Count > 0)
                                {
                                    #region Addresses
                                    List<Address> Addresses = null;
                                    Addresses = resultDS.Tables[1].AsEnumerable()
                                        .Where(row => Util.DataHelper.ConvertObjectToString(row["DMSCustomerNo"], null) == customervehicle.Customer.DMSCustomerNo)
                                        .Select(row =>
                                    new Address
                                    {
                                        Address1 = Util.DataHelper.ConvertObjectToString(row["Address1"]),
                                        Address2 = Util.DataHelper.ConvertObjectToString(row["Address2"]),
                                        AddressType = Util.DataHelper.ConvertObjectToString(row["AddressType"]),
                                        City = Util.DataHelper.ConvertObjectToString(row["City"]),
                                        Country = Util.DataHelper.ConvertObjectToString(row["Country"]),
                                        State = Util.DataHelper.ConvertObjectToString(row["State"]),
                                        ZipCode = Util.DataHelper.ConvertObjectToString(row["ZipCode"]),
                                    }).ToList();
                                    if (Addresses != null && Addresses.Count > 0)
                                        customervehicle.Customer.Addresses = Addresses;
                                    #endregion
                                }

                                if (resultDS.Tables.Count > 2 && resultDS.Tables[2].Rows.Count > 0)
                                {
                                    #region Contacts
                                    List<WA.Standard.IF.Data.v2.Common.Customer.Contact> Contacts = null;
                                    Contacts = resultDS.Tables[2].AsEnumerable()
                                        .Where(row => Util.DataHelper.ConvertObjectToString(row["DMSCustomerNo"], null) == customervehicle.Customer.DMSCustomerNo)
                                        .Select(row =>
                                    new WA.Standard.IF.Data.v2.Common.Customer.Contact
                                    {
                                        ContactMethodYN = Util.DataHelper.ConvertObjectToString(row["ContactMethodYN"]),
                                        ContactType = Util.DataHelper.ConvertObjectToString(row["ContactType"]),
                                        ContactValue = Util.DataHelper.ConvertObjectToString(row["ContactValue"]),
                                    }).ToList();
                                    if (Contacts != null && Contacts.Count > 0)
                                        customervehicle.Customer.Contacts = Contacts;
                                    #endregion
                                }

                                if (resultDS.Tables.Count > 3 && resultDS.Tables[3].Rows.Count > 0)
                                {
                                    #region CorporateInfos
                                    List<WA.Standard.IF.Data.v2.Common.Customer.CorporateInfo> CorporateInfos = null;
                                    CorporateInfos = resultDS.Tables[3].AsEnumerable()
                                        .Where(row => Util.DataHelper.ConvertObjectToString(row["DMSCustomerNo"], null) == customervehicle.Customer.DMSCustomerNo)
                                        .Select(row =>
                                    new WA.Standard.IF.Data.v2.Common.Customer.CorporateInfo
                                    {
                                        Name = Util.DataHelper.ConvertObjectToString(row["Name"]),
                                        Value = Util.DataHelper.ConvertObjectToString(row["Value"]),
                                    }).ToList();
                                    if (CorporateInfos != null && CorporateInfos.Count > 0)
                                        customervehicle.Customer.CorporateInfos = CorporateInfos;
                                    #endregion
                                }

                                if (resultDS.Tables.Count > 4 && resultDS.Tables[4].Rows.Count > 0)
                                {
                                    #region Campaigns
                                    List<WA.Standard.IF.Data.v2.Common.Vehicle.Campaign> Campaigns = null;
                                    Campaigns = resultDS.Tables[4].AsEnumerable()
                                        .Where(row => Util.DataHelper.ConvertObjectToString(row["VIN"], null) == customervehicle.Vehicle.VIN)
                                        .Select(row =>
                                    new WA.Standard.IF.Data.v2.Common.Vehicle.Campaign
                                    {
                                        CampaignDescription = Util.DataHelper.ConvertObjectToString(row["CampaignDescription"]),
                                        CampaignID = Util.DataHelper.ConvertObjectToString(row["CampaignID"]),
                                        CampaignPerformed = Util.DataHelper.ConvertObjectToString(row["CampaignPerformed"]),
                                    }).ToList();
                                    if (Campaigns != null && Campaigns.Count > 0)
                                        customervehicle.Vehicle.Campaigns = Campaigns;
                                    #endregion
                                }
                            }
                            response.CustomerVehicles = CustomerVehicles;
                            response.ResultMessage = GetResultMessageData(PredefinedCode._SuccessDone, PredefinedMessage._SuccessDone);
                        }
                    }
                    else
                    {
                        response.ResultMessage = GetResultMessageData(PredefinedCode._SuccessNoResult, PredefinedMessage._SuccessNoResult);
                    }
                }
                else
                {
                    response.ResultMessage = GetResultMessageData(PredefinedCode._SuccessNoResult, PredefinedMessage._SuccessNoResult);
                }
                 */
                #endregion
            }

            return response;
        }