public bool Test() { SqlParameter[] param = new SqlParameter[1]; DBHelper helper = new DBHelper(); param[0] = new SqlParameter(CONSTANT.CAT_ID, "ZCVV"); bool ds = helper.InsertQuery(PROCEDURES.CAT_INSERT, param); return ds; }
public int deleteProduct(string product_id) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter(CONSTANT.PRODUCT_ID, product_id); int res = helper.InsertQuery(PROCEDURES.DELETE_PRODUCT, param); return res; }
public int deleteSubCategory(int id) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, id); int res = helper.InsertQuery(PROCEDURES.DELETE_SUB_CATEGORY, param); return res; }
public int createNewUser(User_Details _user, string type) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter(CONSTANT.UID, _user.User_ID); param[1] = new SqlParameter(CONSTANT.USER_NAME, _user.User_Name); param[2] = new SqlParameter(CONSTANT.PASSWORD, _user.User_Password); param[3] = new SqlParameter(CONSTANT.DESIGNATION, _user.User_Designation); param[4] = new SqlParameter(CONSTANT.USER_EMAIL, _user.User_Email); param[5] = new SqlParameter(CONSTANT.TYPE, type); int res = helper.InsertQuery(PROCEDURES.ADD_NEW_USER, param); return res; }
public int updateProduct(ProductDetails product) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[11]; param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, product.SubCategory); param[1] = new SqlParameter(CONSTANT.BRAND_ID, product.Brand_Name); param[2] = new SqlParameter(CONSTANT.PRODUCT_ID, product.Prod_Id); param[3] = new SqlParameter(CONSTANT.PRODUCT_NAME, product.Prod_Name); param[4] = new SqlParameter(CONSTANT.PRODUCT_IMAGE, product.Prod_Img); param[5] = new SqlParameter(CONSTANT.PRICE, product.Price); param[6] = new SqlParameter(CONSTANT.OFFER_PRICE, product.Offer_Price); param[7] = new SqlParameter(CONSTANT.PURCHASE_PRICE, product.Purchase_Price); param[8] = new SqlParameter(CONSTANT.PACKING_QUANITY, product.Prod_Quantity); param[9] = new SqlParameter(CONSTANT.TotalQuantity, product.Total_Quantity); param[10] = new SqlParameter(CONSTANT.SUB_CLASSFICATION_NAME, product.SubClassification); int res = helper.InsertQuery(PROCEDURES.UPDATE_PRODUCTS, param); return res; }
public int DeleteCategory(int cat_id) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter(CONSTANT.CAT_ID, cat_id); int res = helper.InsertQuery(PROCEDURES.DELETE_CATEGORY, param); return res; }
public int InsertSubClassification(string sub_class,string Sub_Cat_Id) { int res = 0; DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, Sub_Cat_Id); param[1] = new SqlParameter(CONSTANT.SUB_CLASSFICATION_NAME, sub_class); res = helper.InsertQuery(PROCEDURES.INSERT_SUB_CLASSIFICATION, param); return res; }
public int UpdateCategory(Category cat) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter(CONSTANT.CAT_ID, cat.Cat_Id); param[1] = new SqlParameter(CONSTANT.CATEGORY_NAME, cat.Cat_Name); int res = helper.InsertQuery(PROCEDURES.UPDATE_CATEGORY, param); return res; }
public int InsertCategory(string categoryName) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter(CONSTANT.CATEGORY_NAME, categoryName); int res = helper.InsertQuery(PROCEDURES.INSERT_CATEGORY, param); return res; }
public int EnterSubCat(int catID, string subCategoryName) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter(CONSTANT.CAT_ID , catID ); param[1] = new SqlParameter(CONSTANT.SUB_CAT_NAME, subCategoryName); int res = helper.InsertQuery(PROCEDURES.INSERT_SUB_CATEGORY, param); return res; }
public int DeleteBrand(int Brand_Id) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter(CONSTANT.BRAND_ID, Brand_Id); int res = helper.InsertQuery(PROCEDURES.DELETE_BRAND, param); return res; }
public int InsertBrand(Brand brand) { DBHelper helper = new DBHelper(); SqlParameter []parm=new SqlParameter[1]; parm[0]=new SqlParameter(CONSTANT.BRAND_NAME,brand.Brand_Name); int res = helper.InsertQuery(PROCEDURES.INSERT_BRAND, parm); return res; }