public MPMerchantLandlordModel()
{
Questions = new MPMerchantLandlordQuestionsModel();
LandlordAddress = new MPMerchantAddressInfoModel();
}
public MPMerchantLandlordQuestionsModel GetMerchantDetailsForVerification(Int64 merchantId)
{
MPMerchantLandlordQuestionsModel details = new MPMerchantLandlordQuestionsModel();
//List<UseOfAdvanceModel> AdvancesList = new List<UseOfAdvanceModel>();
DataSet dsData = new DataSet();
dsData = 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"]);
}
}
}
return details;
}
