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