public DataSet Get_Dealer_Accepted_product(int dealerID, string status, int?stateid = 0, int?districtId = 0, int?blockID = 0, int?category = 0, int?subcategory = 0, int?techid = 0, int?companyid = 0, int?brandid = 0) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.ACCEPTED_PRODUCTLIST_Master; SqlParameter[] parameters = new SqlParameter[10]; if (dealerID > 0) { parameters[0] = new SqlParameter("@DealerId", dealerID); } parameters[1] = new SqlParameter("@status", status); parameters[2] = new SqlParameter("@StateID", stateid); parameters[3] = new SqlParameter("@DistrictID", districtId); parameters[4] = new SqlParameter("@BlockID", blockID); parameters[5] = new SqlParameter("@CategoryID", category); parameters[6] = new SqlParameter("@SubCategoryID", subcategory); parameters[7] = new SqlParameter("@TechnicalNameID", techid); parameters[8] = new SqlParameter("@CompanyID", companyid); parameters[9] = new SqlParameter("@BrandID", brandid); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet Get_Product_Detail_Dealer(int productId) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.Get_Product_Detail_temp; SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@productid", productId); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet Get_Role(int userid) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.SPGetRole; SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@UserID", userid); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet Get_Product_Package(int productId, int Ismaster = 0) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.Get_ProductId_Package; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@ProductId", productId); parameters[1] = new SqlParameter("@IsMaster", Ismaster); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet Get_ProductList_useFor(string mode, string CategoryId) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.Prod_UseForList; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@mode", mode); parameters[1] = new SqlParameter("@CategoryID", CategoryId); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet Get_Nutrient_Unit(string mode = "") { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.Get_Nutrient_Unit; SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@MODE", mode); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }
public DataSet GetUserid_for_Product(int productid, bool Ismaster = false) { string sql = ""; DataSet ds = new DataSet(); try { sql = StoredProcedure.GetUserid_for_Product; SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@ProductId", productid); parameters[1] = new SqlParameter("@mastertable", Ismaster); ds = BaseDal.ExecuteAdapter(sql, parameters); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); } return(ds); }