public static ReqBrsPaymentList GetBrsPayment(ReqGetBrsPayment reqGetBrsPayment, string spName)
{
ReqBrsPaymentList _reqBrsPaymentList = new ReqBrsPaymentList();
List <ReqBrsPayment> reqBrsPaymentList = new List <ReqBrsPayment>();
DataTable dt = new DataTable();
try
{
using (SqlConnection con = new SqlConnection(StaticConst.connectionString))
{
using (SqlCommand cmd = new SqlCommand(spName, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.Parameters.Add(new SqlParameter("@Id", reqGetBrsPayment.Id));
cmd.Parameters.Add(new SqlParameter("@Type", reqGetBrsPayment.Type));
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ReqBrsPayment resqBrsPayment = new ReqBrsPayment();
resqBrsPayment.Amount = Convert.ToString(dt.Rows[i]["Amount"]);
resqBrsPayment.Id = Convert.ToInt16(dt.Rows[i]["Id"]);
resqBrsPayment.Memo = Convert.ToString(dt.Rows[i]["Memo"]);
resqBrsPayment.ModeNo = Convert.ToString(dt.Rows[i]["ModeNo"]);
resqBrsPayment.PaidDate = Convert.ToString(dt.Rows[i]["PaidDate"]);
resqBrsPayment.PaymentMode = Convert.ToString(dt.Rows[i]["PaymentMode"]);
resqBrsPayment.RealizationDate = Convert.ToString(dt.Rows[i]["RealizationDate"]);
reqBrsPaymentList.Add(resqBrsPayment);
}
_reqBrsPaymentList.reqBrsPaymentList = reqBrsPaymentList;
_reqBrsPaymentList.ResponseCode = 0;
_reqBrsPaymentList.ResponseMessage = "Fetched Detail Successfully";
}
else
{
_reqBrsPaymentList.ResponseCode = 0;
_reqBrsPaymentList.ResponseMessage = "No Records found";
}
}
}
}
}
catch (Exception ex)
{
}
return(_reqBrsPaymentList);
}
public ReqBrsPaymentList GetBrsPayment(ReqGetBrsPayment reqGetBrsPayment)
{
return(BrsCall.GetBrsPayment(reqGetBrsPayment, StaticConst.SPGETBRSPAYMENT));
}
