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; }