public DataTable LoadEOD()
{
DataTable dt_Eod = null;
try
{
string s = "SELECT * FROM TBL_EOD";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
dt_Eod = objDB.LoadDataSet().Tables[0];
}
catch (Exception ex)
{
}
return(dt_Eod);
}
public DataTable GetSalesCategory()
{
DataTable dtSalesCategory = null;
try
{
string _read = "SELECT * FROM TBL_SALESCATEGORY WHERE CONREAD='FALSE'";
CeDataCon.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
CeDataCon.CmdType = CommandType.Text;
CeDataCon.CmdString = _read;
dtSalesCategory = CeDataCon.LoadDataSet().Tables[0];
}
catch (Exception ex)
{
}
return(dtSalesCategory);
}
public DataTable LoadInvoices()
{
DataTable dt_invc = null;
try
{
string s = "SELECT * FROM TBL_SALES";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
dt_invc = objDB.LoadDataSet().Tables[0];
}
catch (Exception ex)
{
}
return(dt_invc);
}