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