public DataTable GetAllCategories()
{
CmdCAP = new SqlCommand();
CmdCAP.CommandText = "spGetAllProducts_Category";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable getbrands()
{
CmdCAP = new SqlCommand();
CmdCAP.CommandText = "sp_getitembrand";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable getdescitems(int vid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid));
CmdCAP.CommandText = "sp_getvendoritemdesclist";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable getmaterialwork()
{
CmdCAP = new SqlCommand();
CmdCAP.CommandText = "sp_getitemworktype";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable bindvendors()
{
CmdCAP = new SqlCommand();
//CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Imode", SqlDbType.VarChar, 100, "select"));
CmdCAP.CommandText = "getvendors";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable bindpcategories(int pid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pid", SqlDbType.Int, 0, pid));
CmdCAP.CommandText = "sp_Products_Category";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable getitemname(int vid, int prodscatid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 100, prodscatid));
CmdCAP.CommandText = "sp_getitemnames";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
public DataTable bindsubcatbyvid(int prod_cat_id, int vid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_cat_id", SqlDbType.Int, 0, prod_cat_id));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 0, vid));
CmdCAP.CommandText = "Sp_Products_Subcategorybyvid";
CmdCAP.CommandType = CommandType.StoredProcedure;
dt = CommonDbFunctions.SetToDataTable(CmdCAP);
return(dt);
}
