public DataTable getUserRoleList()
{
DataTable dt = new DataTable();
try
{
string querry = "SELECT * FROM tbl_userrole;";
dt = CONN.getDataTable(querry);
}
catch (Exception ex)
{
dt = null;
throw ex;
}
return(dt);
}
public DataTable getCurrentDayStockDetails()
{
DataTable dt = new DataTable();
string curr_date = DateTime.Today.ToString("yyyy/MM/dd");
try
{
string querry = @"SELECT *
FROM vw_stockentry
WHERE createDate = '" + curr_date + "' ORDER BY stockEntryId DESC;";
dt = CONN.getDataTable(querry);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}