private void BillsList(M_Bills_RQ m_Bills_RQ)
{
dAL_Bills = new DAL_Bills();
var result = dAL_Bills.GetBillDetails(m_Bills_RQ);
dgvListOfBills.DataSource = result;
}
public List <M_Bills> GetBillDetails(M_Bills_RQ _RQ)
{
try
{
if (DB_Service._dbconnection.State == ConnectionState.Closed)
{
DB_Service._dbconnection.Open();
}
var result = DB_Service._dbconnection.Query <M_Bills>("splocal_getBillDetails", new { BillId = _RQ.BillID, BillNo = _RQ.BillNo, MobileNo = _RQ.MobileNo }, commandType: CommandType.StoredProcedure).ToList <M_Bills>();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public List <M_Bills_RS> BillSaveAs(M_Bills_RQ m_Bills_RQ)
{
try
{
if (DB_Service._dbconnection.State == ConnectionState.Closed)
{
DB_Service._dbconnection.Open();
}
var result = DB_Service._dbconnection.Query <M_Bills_RS>("splocal_BillSaveAs",
new
{
BillNo = m_Bills_RQ.BillNo
}, commandType: CommandType.StoredProcedure).ToList <M_Bills_RS>();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
