public DataTable GetProdBasedOnRestaurantGetProData()
{
try
{
SqlCommand cmd = new SqlCommand();
return(_objdal.fngetdata("[spGetRestCode]", null));
}
catch (Exception ex)
{
throw ex;
}
}
//public DataTable getdata()
//{
// SqlCommand cmd = new SqlCommand();
// return _objdal.fngetdata("Categorytype", null);
//}
public DataTable GetLogin(LoginProperties lp)
{
DataTable dt = new DataTable();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Password", lp.Password));
return(_objdal.fngetdata("spValidateEmpDetails", param.ToArray()));
}
public DataTable chkorderid(string orderid)
{
try
{
SqlCommand cmd = new SqlCommand();
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@orderid", orderid));
return(_objdal.fngetdata("checkorderid", param.ToArray()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetEmpData()
{
try
{
SqlCommand cmd = new SqlCommand();
return(_objdal.fngetdata("spGetTotEmpdtls", null));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable getdata()
{
SqlCommand cmd = new SqlCommand();
return(_objdal.fngetdata("Categorytype", null));
}
