public static ResBrsList GetBrsList(ReqBrs reqBrs, string spName)
{
ResBrsList resBrsList = new ResBrsList();
List <ResBrs> _resBrsList = new List <ResBrs>();
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("@UserId", reqBrs.UserId));
cmd.Parameters.Add(new SqlParameter("@tableName", reqBrs.tableName));
cmd.Parameters.Add(new SqlParameter("@Month", reqBrs.Month));
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ResBrs resBrs = new ResBrs();
resBrs.PId = Convert.ToInt16(dt.Rows[i]["PId"]);
resBrs.TId = Convert.ToInt16(dt.Rows[i]["TId"]);
resBrs.VendorName = Convert.ToString(dt.Rows[i]["Name"]);
resBrs.Amount = Convert.ToString(dt.Rows[i]["Amount"]);
resBrs.Date = Convert.ToString(dt.Rows[i]["Date"]);
resBrs.Status = Convert.ToString(dt.Rows[i]["Status"]);
resBrs.PendingAmount = Convert.ToString(dt.Rows[i]["PendingAmount"]);
_resBrsList.Add(resBrs);
}
resBrsList.resBrsList = _resBrsList;
resBrsList.ResponseCode = 0;
resBrsList.ResponseMessage = "Detail fetched successfully";
}
else
{
resBrsList.ResponseCode = 0;
resBrsList.ResponseMessage = "No Records Found";
}
}
}
}
}
catch (Exception ex)
{
}
return(resBrsList);
}
public ResBrsList GetBrsList(ReqBrs reqBrs)
{
return(BrsCall.GetBrsList(reqBrs, StaticConst.SPGETBRSLIST));
}
