public bool AddRequestCustomerAccountData(tbl_Request_Customer_Accounts row) { try { using (var db = new SoneriCISEntities()) { db.tbl_Request_Customer_Accounts.Add(row); db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public bool UpdateCustomerRequestAccount(tbl_Request_Customer_Accounts row) { try { using (var db = new SoneriCISEntities()) { tbl_Request_Customer_Accounts val = new DAL.tbl_Request_Customer_Accounts(); val = db.tbl_Request_Customer_Accounts.Where(a => a.ID == row.ID).FirstOrDefault(); val.ID = row.ID; val.AccountNo = row.AccountNo; val.CIF = row.CIF; val.CardNo = row.CardNo; val.AccountStatusActive = row.AccountStatusActive; val.Salutation = row.Salutation; val.AccountTitle = row.AccountTitle; val.Address = row.Address; val.Mobile = row.Mobile; val.DateofBirth = row.DateofBirth; val.MotherMaidenName = row.MotherMaidenName; val.Identification = row.Identification; val.CNIC = row.CNIC; val.AddressType = row.AddressType; val.AccountTypeID = row.AccountTypeID; val.WaiveCharges = row.WaiveCharges; val.PassportNo = row.PassportNo; val.LandlineNo = row.LandlineNo; val.Email = row.Email; val.Nationality = row.Nationality; val.AccountCategoryCode = row.AccountCategoryCode; val.PhoneOffice = row.PhoneOffice; val.Company = row.Company; val.IdentificationType = row.IdentificationType; val.Mobile2 = row.Mobile2; val.Address2 = row.Address2; val.Address3 = row.Address3; val.MainMobile = row.MainMobile; val.MainLandline = row.MainLandline; val.MainAddress = row.MainAddress; db.SaveChanges(); } return(true); } catch (Exception ex) { 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; } }