public DataSet GetUserType()
{
try
{
SqlCommand cmd = new SqlCommand();
return(_objdal.fngetData("spGetUserType", null));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getorddata(string Ppr)
{
try
{
DataSet dt = new DataSet();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@restcode", Ppr));
return(_objdal.fngetData("getOrdersForTicket", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetProdData(string Ppr)
{
try
{
DataSet dt = new DataSet();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Table_Name", Ppr));
return(_objdal.fngetData("Dynamic_SP", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getOrders(string RestCode)
{
//string RestCode
try
{
SqlCommand cmd = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RestCode", RestCode));
return(_objdal.fngetData("spGET_ORDERS1", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getdailyreports(DateTime rpt)
{
try
{
DataSet dt = new DataSet();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@specify_date", rpt));
return(_objdal.fngetData("rptGetDailyReportDT", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}