public static bool UpdateRequestCustomerAccount(RequestVM request) { var row = new CustomerRequestAccountDataAccess().GetRequestCustomerAccount((int)request.CustomerRequestID.GetValueOrDefault()); if (row != null) { row.AccountNo = request.AccountNo; row.Address = request.MainAddress; row.LandlineNo = request.LandlineNo; row.PhoneOffice = request.PhoneOff; row.MainAddress = request.MainAddress; //row.MainLandline = request.MainLandline; row.MainMobile = request.MainMobile; return(new CustomerRequestAccountDataAccess().UpdateCustomerRequestAccount(row)); } return(false); }
//public static string GetLinkedAccounts() //{ //} public static bool AddRequestCustomerAccount(RequestVM request, string AddressValue, string MobileValue, string LandlineValue, string OfficePhoneValue) { try { //Check if Request Cust Account already exists tbl_Request_Customer_Accounts row1 = new CustomerRequestAccountDataAccess().GetRequestCustomerAccountByRequestId(int.Parse(request.ID.ToString())); request.MainAddress = !string.IsNullOrEmpty(request.MainAddress) ? request.MainAddress.Replace("\n", " ") : string.Empty; request.MainLandline = !string.IsNullOrEmpty(request.MainLandline) ? request.MainLandline.Replace("\n", " ") : string.Empty; request.MainMobile = !string.IsNullOrEmpty(request.MainMobile) ? request.MainMobile.Replace("\n", " ") : string.Empty; //string AddressValue = ""; string MobileValue = ""; //string LandlineValue= ""; string OfficePhoneValue = ""; var row = new tbl_Request_Customer_Accounts() { AccountNo = request.AccountNo, CardNo = request.CardNo, AccountTypeID = request.AccountTypeId, AccountTitle = request.AccountTitle, Address = request.AccountAddress, Address3 = request.CustomerAddress, AddressType = request.AddressType, LandlineNo = request.LandlineNo, MainAddress = request.MainAddress, CNIC = request.CNIC, //DateofBirth = !string.IsNullOrEmpty(request.DateofBirth) ? Convert.ToDateTime(request.DateofBirth) : (DateTime?)null, Email = request.Email, MainMobile = request.MainMobile, Mobile = request.MobileNo, // Nationality = "PAKISTANI", PassportNo = request.PassportNo, MotherMaidenName = request.MotherName, Salutation = request.Salutation, PhoneOffice = request.PhoneOff, WaiveCharges = request.Waive, CIF = request.CIFNo, Identification = request.Identification, RequestID = request.ID //saving main values required for audit trail report Jul-19 , Address2 = AddressValue , Mobile2 = MobileValue , MainLandline = LandlineValue , Company = OfficePhoneValue }; if (row.Identification == "PoR") { row.Nationality = "AF"; } else { row.Nationality = "PK"; } if (row1 != null) { return(new CustomerRequestAccountDataAccess().UpdateCustomerRequestAccount(row)); } else { return(new CustomerRequestAccountDataAccess().AddRequestCustomerAccountData(row)); } } catch (Exception ex) { throw ex; } }