stored procedure with c#
public IEnumerable<usp_PumoriGetInformationByMainCode_Result> GetClientInformationByAccountNumber(string accountNumber)
{
IEnumerable<usp_PumoriGetInformationByMainCode_Result> result = _context.usp_PumoriGetInformationByMainCode(accountNumber).AsEnumerable();
return result;
}
--------- --------------- ------------------- ---------------------------- ------------
usp_PumoriGetInformationByMainCode_Result
public partial class usp_PumoriGetInformationByMainCode_Result
{
public string ClientCode { get; set; }
public string Name { get; set; }
public string FirstName { get; set; }
public string MiddleName { get; set; }
public string LastName { get; set; }
public string Address1 { get; set; }
public string Address2 { get; set; }
public string Address3 { get; set; }
public string City { get; set; }
public string MobileNo { get; set; }
public string Phone { get; set; }
public string Gender { get; set; }
public Nullable<System.DateTime> DateOfBirth { get; set; }
public string Beneficiary { get; set; }
public string ContactAdd1 { get; set; }
public string ContactAdd2 { get; set; }
public string ContactAdd3 { get; set; }
public string CompanyName { get; set; }
public string MaritalStatus { get; set; }
public string Salutation { get; set; }
public string ClientCategory { get; set; }
public string eMail { get; set; }
public string IdType { get; set; }
public string CitizenshipNo { get; set; }
public string PassportNo { get; set; }
public string DLicenceIdNo { get; set; }
public string VoterId { get; set; }
public string OtherIdNo { get; set; }
public string BranchCode { get; set; }
public string CurrencyCode { get; set; }
public string MainCode { get; set; }
public string AcType { get; set; }
public string MasterName { get; set; }
public Nullable<decimal> Balance { get; set; }
public Nullable<decimal> MinBalnReqd { get; set; }
public Nullable<decimal> GoodBaln { get; set; }
public Nullable<decimal> HeldAmt { get; set; }
public Nullable<decimal> AvailableBalance { get; set; }
}
Comments
Post a Comment