public MerchantDetailQuestionModel GetMerchantDetailsForVerification(Int64 merchantId)
{
MerchantDetailQuestionModel details = new MerchantDetailQuestionModel();
//List<UseOfAdvanceModel> AdvancesList = new List<UseOfAdvanceModel>();
DataSet dsData = new DataSet();
dsData = contractsRepository.GetMerchantDetailsForQuestion(merchantId);
if (dsData.Tables.Count > 0)
{
if (dsData.Tables[0].Rows.Count > 0)
{
details.MerchantId = Convert.ToInt16(dsData.Tables[0].Rows[0]["MerchantId"]);
details.LegalName = Convert.ToString(dsData.Tables[0].Rows[0]["LegalName"]);
details.BusinessName = Convert.ToString(dsData.Tables[0].Rows[0]["BusinessName"]);
details.SalesRepName = Convert.ToString(dsData.Tables[0].Rows[0]["SalesRepName"]);
details.OwnerFirstName = Convert.ToString(dsData.Tables[0].Rows[0]["OwnerFirstName"]);
details.OwnerLastName = Convert.ToString(dsData.Tables[0].Rows[0]["OwnerLastName"]);
//details.OwnerName = Convert.ToString(dsData.Tables[0].Rows[0]["OwnerName"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["retention"].ToString()) == false)
details.RetensionPct = Convert.ToInt16(dsData.Tables[0].Rows[0]["retention"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["IsAuthorized"].ToString()) == false)
details.IsAuthorised = Convert.ToInt16(dsData.Tables[0].Rows[0]["IsAuthorized"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["LoanedAmount"].ToString()) == false)
details.LoanAmount = Convert.ToDouble(dsData.Tables[0].Rows[0]["LoanedAmount"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["ownedAmount"].ToString()) == false)
details.OwnedAmount = Convert.ToDouble(dsData.Tables[0].Rows[0]["ownedAmount"]);
details.OwnerPassport = Convert.ToString(dsData.Tables[0].Rows[0]["PassportNbr"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["GrossAnnualSales"].ToString()) == false)
details.GrossAnnualSales = Convert.ToDouble(dsData.Tables[0].Rows[0]["GrossAnnualSales"]);
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["AdminExp"].ToString()) == false)
details.AdminExp = Convert.ToDouble(dsData.Tables[0].Rows[0]["AdminExp"]);
if (dsData.Tables[0].Rows[0]["BusinessStartDate"] != null)
{
if (dsData.Tables[0].Rows[0]["BusinessStartDate"].ToString() != "")
details.BusinessStartDate = Convert.ToDateTime(dsData.Tables[0].Rows[0]["BusinessStartDate"]);
}
if (string.IsNullOrEmpty(dsData.Tables[0].Rows[0]["TypeOfAdvanceId"].ToString()) == false)
details.TypeOfAdvanceId = Convert.ToInt64(dsData.Tables[0].Rows[0]["TypeOfAdvanceId"]);
if (dsData.Tables[0].Rows[0]["RentFlag"] != null)
{
long v = 0;
long.TryParse(dsData.Tables[0].Rows[0]["RentFlag"].ToString(), out v);
details.RentFlag = v;
}
if (dsData.Tables[0].Rows[0]["ContractStartDate"] != null)
{
if (dsData.Tables[0].Rows[0]["ContractStartDate"].ToString() != "")
details.ContractStartDate = Convert.ToDateTime(dsData.Tables[0].Rows[0]["ContractStartDate"]);
}
if (dsData.Tables[0].Rows[0]["ContractExpireDate"] != null)
{
if (dsData.Tables[0].Rows[0]["ContractExpireDate"].ToString() != "")
// details.ContractExpireDate = (dsData.Tables[0].Rows[0]["ContractExpireDate"]).ToString();
details.ContractExpireDate = Convert.ToDateTime(dsData.Tables[0].Rows[0]["ContractExpireDate"]);
}
}
if (dsData.Tables[1].Rows.Count > 0)
{
foreach (DataRow dRow in dsData.Tables[1].Rows)
{
details.MerchantAddress = Convert.ToString(dRow["MerchantAddress"]);
details.LandlordAddress = Convert.ToString(dRow["LandlordAddress"]);
details.RentedAmount = dRow.Field<double?>("RentedAmount");
//details.LandlordName = Convert.ToString(dRow["LandlordName"]);
details.LLFirstName = Convert.ToString(dRow["LLFirstName"]);
details.LLLastName = Convert.ToString(dRow["LLLastName"]);
details.LLCompany = Convert.ToString(dRow["LLCompany"]);
}
}
//if (dsData.Tables[1].Rows.Count > 0)
//{
// foreach (DataRow dRow in dsData.Tables[1].Rows)
// {
// UseOfAdvanceModel eType = new UseOfAdvanceModel();
// eType.AdvanceId = Convert.ToInt64(dRow["TypeId"]);
// eType.Description = Convert.ToString(dRow["Description"]);
// AdvancesList.Add(eType);
// eType = null;
// }
//}
//details.advances = AdvancesList;
}
return details;
}
public VerificationModel RetrieveVerificationDetails(Int64 contractId, Int64 merchantId, string entity)
{
var t = new DataAccess.DataAccess().ExecuteReader<QuestionsModel, VerificationModel>("avz_cnt_RetriveVeriCall",
new
{
ContractId = contractId,
Entity = entity
});
var vc = t.Item2.Count > 0 ? t.Item2[0] : new VerificationModel();
vc.questions = t.Item1;
MerchantDetailQuestionModel mod = new MerchantDetailQuestionModel();
using (ContractTier dT = new ContractTier())
{
mod = dT.GetMerchantDetailsForVerification(merchantId);
}
vc.MerchantDetails = mod;
return vc;
}
