/// <summary>
///
/// </summary>
/// <param name="contractId"></param>
/// <param name="merchantId"></param>
/// <returns></returns>
public CorporateDocModel RetrieveCorpDetails(Int64 contractId, Int64 merchantId)
{
CorporateDocModel mDetail = new CorporateDocModel();
List<OwnerModel> OwnerList = new List<OwnerModel>();
DataSet dsData = new DataSet();
dsData = contractsRepository.RetrieveCorpDetails(contractId, merchantId);
if (dsData.Tables.Count > 0)
{
if (dsData.Tables[0].Rows.Count > 0)
{
mDetail.nameOfCompany = Convert.ToString(dsData.Tables[0].Rows[0]["nameOfCompany"]);
mDetail.addressDesc = Convert.ToString(dsData.Tables[0].Rows[0]["addressDesc"]);
mDetail.RNCNumber = Convert.ToString(dsData.Tables[0].Rows[0]["RNCNumber"]);
}
if (dsData.Tables[1].Rows.Count > 0)
{
//foreach (DataRow dRow in dsData.Tables[1].Rows)
//{
// OwnerModel mCorp = new OwnerModel();
// mCorp.ownerFirstName = Convert.ToString(dRow["OwnerName"]);
// mCorp.ownerLastName = Convert.ToString(dRow["OwnerLastName"]);
// mCorp.PassportNumber = Convert.ToString(dRow["PassportNbr"]);
// mCorp.phone1 = Convert.ToString(dRow["Telephone"]);
// mCorp.Authorized = Convert.ToBoolean(dRow["IsAuthorized"]);
// mCorp.ownerId = Convert.ToInt64(dRow["OwnerId"]);
// mCorp.contactId = Convert.ToInt64(dRow["ContactId"]);
// mCorp.addressId = Convert.ToInt64(dRow["AddressId"]);
// OwnerList.Add(mCorp);
// mCorp = null;
//}
// List<OwnerModel> ownermodellist = new List<OwnerModel>();
foreach (DataRow dRow in dsData.Tables[1].Rows)
{
OwnerModel ownermodel = new OwnerModel();
if (dRow["contactId"].ToString() != null && dRow["contactId"].ToString() != "")
ownermodel.contactId = Convert.ToInt64(dRow["contactId"]);
if (dRow["ownerId"].ToString() != null && dRow["ownerId"].ToString() != "")
ownermodel.ownerId = Convert.ToInt64(dRow["ownerId"]);
if (dRow["addressId"].ToString() != null && dRow["addressId"].ToString() != "")
ownermodel.addressId = Convert.ToInt64(dRow["addressId"]);
ownermodel.merchantId = merchantId;
ownermodel.ownerFirstName = Convert.ToString(dRow["ownerFirstName"]);
ownermodel.ownerLastName = Convert.ToString(dRow["ownerLastName"]);
if (dRow["ownerDOB"].ToString() != null && dRow["ownerDOB"].ToString() != "")
ownermodel.ownerDOB = Convert.ToDateTime(dRow["ownerDOB"]);
ownermodel.PassportNumber = Convert.ToString(dRow["passportnbr"]);
ownermodel.phone1 = Convert.ToString(dRow["phone1"]);
ownermodel.CellNumber = Convert.ToString(dRow["phone2"]);
ownermodel.ssn = Convert.ToString(dRow["ssn"]);
ownermodel.addressLine1 = Convert.ToString(dRow["addressLine1"]);
ownermodel.addressLine2 = Convert.ToString(dRow["addressLine2"]);
ownermodel.country = Convert.ToString(dRow["country"]);
ownermodel.city = Convert.ToString(dRow["city"]);
ownermodel.state = Convert.ToString(dRow["state"]);
ownermodel.stateId = Convert.ToString(dRow["stateId"]);
ownermodel.zip = Convert.ToString(dRow["zip"]);
ownermodel.email = Convert.ToString(dRow["email"]);
ownermodel.Authorized = Convert.ToBoolean(dRow["IsAuthorized"]);
OwnerList.Add(ownermodel);
}
}
mDetail.OwnerList = OwnerList;
OwnerList = null;
if (dsData.Tables[2].Rows.Count > 0)
{
mDetail.fileName = Convert.ToString(dsData.Tables[2].Rows[0]["fileName"]);
mDetail.fileDetails = Convert.ToString(dsData.Tables[2].Rows[0]["fileDetails"]);
}
}
return mDetail;
}
public MerchantsAdditionalInfo RetrieveMerchantDataEntry(Int64 merchantId)
{
MerchantsAdditionalInfo merchantsdemodel = null;
DataSet merchantsinfo = (new DataAccess.DataAccess()).ExecuteDataSet("avz_mrc_spretrieveMerchantDataEntry",
new
{
merchantId = merchantId
});
if (merchantsinfo.Tables[0].Rows.Count > 0)
{
merchantsdemodel = new MerchantsAdditionalInfo();
merchantsdemodel.merchantName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["merchantName"]);
merchantsdemodel.legalName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["legalName"]);
merchantsdemodel.businessName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["businessName"]);
merchantsdemodel.businessTypeId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["businessTypeId"]);
merchantsdemodel.businessWebSite = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["businessWebSite"]);
merchantsdemodel.rentAmount = Convert.ToDouble(merchantsinfo.Tables[0].Rows[0]["rentAmount"]);
merchantsdemodel.annualSales = string.IsNullOrEmpty(merchantsinfo.Tables[0].Rows[0]["annualSales"].ToString()) ? 0 : Convert.ToDouble(merchantsinfo.Tables[0].Rows[0]["annualSales"]);
merchantsdemodel.loanAmountRequired = string.IsNullOrEmpty(merchantsinfo.Tables[0].Rows[0]["loanAmountRequired"].ToString()) ? 0 : Convert.ToDouble(merchantsinfo.Tables[0].Rows[0]["loanAmountRequired"]);
merchantsdemodel.rnc = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["rnc"]);
merchantsdemodel.industryTypeId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["industryTypeId"]);
merchantsdemodel.assignedSales = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["assignedSales"]);
merchantsdemodel.salesRepId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["salesRepId"]);
merchantsdemodel.taskName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["taskName"]);
merchantsdemodel.workFlowName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["workFlowName"]);
if (merchantsinfo.Tables[0].Rows[0]["workflowId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["workflowId"].ToString() != "")
merchantsdemodel.workflowId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["workflowId"]);
merchantsdemodel.assigneduserId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["assigneduserId"]);
if (merchantsinfo.Tables[0].Rows[0]["assignedDate"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["assignedDate"].ToString() != "")
merchantsdemodel.assignedDate = Convert.ToDateTime(merchantsinfo.Tables[0].Rows[0]["assignedDate"]);
if (merchantsinfo.Tables[0].Rows[0]["businessStartDate"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["businessStartDate"].ToString() != "")
merchantsdemodel.businessStartDate = Convert.ToDateTime(merchantsinfo.Tables[0].Rows[0]["businessStartDate"]);
if (merchantsinfo.Tables[0].Rows[0]["merchantId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["merchantId"].ToString() != "")
merchantsdemodel.merchantId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["merchantId"]);
if (merchantsinfo.Tables[0].Rows[0]["bankId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["bankId"].ToString() != "")
merchantsdemodel.BankID = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["bankId"]);
merchantsdemodel.propertyType = string.IsNullOrEmpty(merchantsinfo.Tables[0].Rows[0]["propertyType"].ToString()) ? 0 : Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["propertyType"]);
merchantsdemodel.accountNumber = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["accountNumber"]);
merchantsdemodel.accountName = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["accountName"]);
merchantsdemodel.BankCode = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["bankcode"]);
merchantsdemodel.AnnualSalesCalcFile = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["AnnualSalesCalcFile"]);
merchantsdemodel.contractId = Convert.ToInt64(string.IsNullOrEmpty(merchantsinfo.Tables[0].Rows[0]["contractId"].ToString()) == false ? merchantsinfo.Tables[0].Rows[0]["contractId"].ToString() : "0");
if (merchantsinfo.Tables[0].Rows[0]["primarySalesRepId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["primarySalesRepId"].ToString() != "")
merchantsdemodel.PsalesRepId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["primarySalesRepId"]);
if (merchantsinfo.Tables[0].Rows[0]["secondarySalesRepId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["secondarySalesRepId"].ToString() != "")
merchantsdemodel.SecsalesRepId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["secondarySalesRepId"]);
if (merchantsinfo.Tables[0].Rows[0]["typeofadvances"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["typeofadvances"].ToString() != "")
merchantsdemodel.TypeOfAdvanceId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["typeofadvances"]);
Address merchantsaddress = new Address();
merchantsaddress.phone1 = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["phone1"]);
merchantsaddress.phone2 = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["phone2"]);
merchantsaddress.addressLine1 = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["addressLine1"]);
merchantsaddress.addressLine2 = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["addressLine2"]);
merchantsaddress.country = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["country"]);
merchantsaddress.city = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["city"]);
merchantsaddress.state = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["state"]);
merchantsaddress.stateId = string.IsNullOrEmpty(merchantsinfo.Tables[0].Rows[0]["stateId"].ToString()) ? 0 : Convert.ToInt64(merchantsinfo.Tables[0].Rows[0]["stateId"]);
merchantsaddress.email = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["email"]);
merchantsaddress.zipId = Convert.ToString(merchantsinfo.Tables[0].Rows[0]["zipId"]);
if (merchantsinfo.Tables[0].Rows[0]["addressId"].ToString() != null && merchantsinfo.Tables[0].Rows[0]["addressId"].ToString() != "")
merchantsaddress.addressId = Convert.ToInt32(merchantsinfo.Tables[0].Rows[0]["addressId"]);
merchantsdemodel.address = merchantsaddress;
// Owner's Information
if (merchantsinfo.Tables[1].Rows.Count > 0)
{
List<OwnerModel> ownermodellist = new List<OwnerModel>();
for (int i = 0; i < merchantsinfo.Tables[1].Rows.Count; i++)
{
OwnerModel ownermodel = new OwnerModel();
if (merchantsinfo.Tables[1].Rows[i]["contactId"].ToString() != null && merchantsinfo.Tables[1].Rows[i]["contactId"].ToString() != "")
ownermodel.contactId = Convert.ToInt64(merchantsinfo.Tables[1].Rows[i]["contactId"]);
if (merchantsinfo.Tables[1].Rows[i]["ownerId"].ToString() != null && merchantsinfo.Tables[1].Rows[i]["ownerId"].ToString() != "")
ownermodel.ownerId = Convert.ToInt64(merchantsinfo.Tables[1].Rows[i]["ownerId"]);
if (merchantsinfo.Tables[1].Rows[i]["addressId"].ToString() != null && merchantsinfo.Tables[1].Rows[i]["addressId"].ToString() != "")
ownermodel.addressId = Convert.ToInt64(merchantsinfo.Tables[1].Rows[i]["addressId"]);
ownermodel.merchantId = merchantId;
ownermodel.ownerFirstName = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["ownerFirstName"]);
ownermodel.ownerLastName = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["ownerLastName"]);
if (merchantsinfo.Tables[1].Rows[i]["ownerDOB"].ToString() != null && merchantsinfo.Tables[1].Rows[i]["ownerDOB"].ToString() != "")
ownermodel.ownerDOB = Convert.ToDateTime(merchantsinfo.Tables[1].Rows[i]["ownerDOB"]);
ownermodel.PassportNumber = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["passportnbr"]);
ownermodel.phone1 = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["phone1"]);
ownermodel.CellNumber = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["phone2"]);
ownermodel.ssn = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["ssn"]);
ownermodel.addressLine1 = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["addressLine1"]);
ownermodel.addressLine2 = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["addressLine2"]);
ownermodel.country = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["country"]);
ownermodel.city = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["city"]);
ownermodel.state = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["state"]);
ownermodel.stateId = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["stateId"]);
ownermodel.zip = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["zip"]);
ownermodel.email = Convert.ToString(merchantsinfo.Tables[1].Rows[i]["email"]);
ownermodel.Authorized = Convert.ToBoolean(merchantsinfo.Tables[1].Rows[i]["IsAuthorized"]);
ownermodellist.Add(ownermodel);
}
merchantsdemodel.owners = ownermodellist;
}
//Processor Information
if (merchantsinfo.Tables[2].Rows.Count > 0)
{
List<MerchantProcessorModel> processors = new List<MerchantProcessorModel>();
for (int i = 0; i < merchantsinfo.Tables[2].Rows.Count; i++)
{
MerchantProcessorModel processormodel = new MerchantProcessorModel();
if (merchantsinfo.Tables[2].Rows[i]["processorId"].ToString() != null && merchantsinfo.Tables[2].Rows[i]["processorId"].ToString() != "")
processormodel.processorId = Convert.ToInt32(merchantsinfo.Tables[2].Rows[i]["processorId"]);
if (merchantsinfo.Tables[2].Rows[i]["processorTypeId"].ToString() != null && merchantsinfo.Tables[2].Rows[i]["processorTypeId"].ToString() != "")
processormodel.processorTypeId = Convert.ToInt32(merchantsinfo.Tables[2].Rows[i]["processorTypeId"]);
processormodel.processorName = Convert.ToString(merchantsinfo.Tables[2].Rows[i]["processorname"]);
if (merchantsinfo.Tables[2].Rows[i]["processorNumber"].ToString() != null && merchantsinfo.Tables[2].Rows[i]["processorNumber"].ToString() != "")
processormodel.processorNumber = Convert.ToString(merchantsinfo.Tables[2].Rows[i]["processorNumber"]);
if (merchantsinfo.Tables[2].Rows[i]["firstprocessedDate"].ToString() != null && merchantsinfo.Tables[2].Rows[i]["firstprocessedDate"].ToString() != "")
processormodel.firstprocessedDate = Convert.ToDateTime(merchantsinfo.Tables[2].Rows[i]["firstprocessedDate"]);
processors.Add(processormodel);
}
merchantsdemodel.processor = processors;
}
if (merchantsinfo.Tables[3].Rows.Count > 0)
{
List<MerchantBankStatement> statements = new List<MerchantBankStatement>();
for (int i = 0; i < merchantsinfo.Tables[3].Rows.Count; i++)
{
MerchantBankStatement statementmodel = new MerchantBankStatement();
if (merchantsinfo.Tables[3].Rows[i]["StatementId"].ToString() != null && merchantsinfo.Tables[3].Rows[i]["StatementId"].ToString() != "")
statementmodel.StatementId = Convert.ToInt32(merchantsinfo.Tables[3].Rows[i]["StatementId"]);
if (merchantsinfo.Tables[3].Rows[i]["StatementMonthId"].ToString() != null && merchantsinfo.Tables[3].Rows[i]["StatementMonthId"].ToString() != "")
statementmodel.StatementMonthId = Convert.ToInt32(merchantsinfo.Tables[3].Rows[i]["StatementMonthId"]);
statementmodel.StatementYear = Convert.ToString(merchantsinfo.Tables[3].Rows[i]["Statementyear"]);
if (merchantsinfo.Tables[3].Rows[i]["amount"].ToString() != null && merchantsinfo.Tables[3].Rows[i]["amount"].ToString() != "")
statementmodel.Amount = Convert.ToDouble(merchantsinfo.Tables[3].Rows[i]["amount"]);
statements.Add(statementmodel);
}
merchantsdemodel.BankStatements = statements;
}
if (merchantsinfo.Tables[4].Rows.Count > 0)
{
int i = 0;
MerchantLandLord LandlordInformationmodel = new MerchantLandLord();
if (merchantsinfo.Tables[4].Rows[i]["landlordcompany"].ToString() != null && merchantsinfo.Tables[4].Rows[i]["landlordcompany"].ToString() != "")
LandlordInformationmodel.CompanyName = Convert.ToString(merchantsinfo.Tables[4].Rows[i]["landlordcompany"]);
if (merchantsinfo.Tables[4].Rows[i]["landlordId"].ToString() != null && merchantsinfo.Tables[4].Rows[i]["landlordId"].ToString() != "")
LandlordInformationmodel.LandlordId = Convert.ToInt32(merchantsinfo.Tables[4].Rows[i]["landlordId"]);
LandlordInformationmodel.FirstName = Convert.ToString(merchantsinfo.Tables[4].Rows[i]["firstname"]);
LandlordInformationmodel.LastName = Convert.ToString(merchantsinfo.Tables[4].Rows[i]["lastname"]);
LandlordInformationmodel.PhoneNumber = Convert.ToString(merchantsinfo.Tables[4].Rows[i]["telephone"]);
merchantsdemodel.LandlordInformation = LandlordInformationmodel;
}
if (merchantsinfo.Tables[5].Rows.Count > 0)
{
List<MerchantTradeReference> traderefs = new List<MerchantTradeReference>();
for (int i = 0; i < merchantsinfo.Tables[5].Rows.Count; i++)
{
MerchantTradeReference traderef = new MerchantTradeReference();
if (merchantsinfo.Tables[5].Rows[i]["TradeRefId"].ToString() != null && merchantsinfo.Tables[5].Rows[i]["TradeRefId"].ToString() != "")
traderef.ReferenceId = Convert.ToInt32(merchantsinfo.Tables[5].Rows[i]["TradeRefId"]);
traderef.ReferenceName = Convert.ToString(merchantsinfo.Tables[5].Rows[i]["Name"]);
traderef.PhoneNumber = Convert.ToString(merchantsinfo.Tables[5].Rows[i]["PhoneNumber"]);
traderefs.Add(traderef);
}
merchantsdemodel.TradeReference = traderefs;
}
}
return merchantsdemodel;
}
