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); }