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