//sudha created on 19/12 public DataSet GetAllUsers() { CmdCAP = new SqlCommand(); DsCAP = CommonDbFunctions.FillDataSet("spGetAllUsersList", CmdCAP); return(DsCAP); }
/*public DataSet Login(User user) * { * SqlDataAdapter da; * DataSet ds = new DataSet(); * * SqlCommand sqlcommand = new SqlCommand(); * * SqlParameter[] param = new SqlParameter[2]; * param[0] = new SqlParameter("@Email", user.Email); * param[1] = new SqlParameter("@Password", user.Password); * * sqlcommand = new SqlCommand("spCheckUserLoginDetails", OpenConnection()) * { * CommandType = CommandType.StoredProcedure * }; * sqlcommand.Parameters.AddRange(param); * * try * { * da = new SqlDataAdapter(sqlcommand); * da.Fill(ds); * * } * catch (SqlException ex) * { * //handel sql excepetions * Console.WriteLine(ex.Message + " in UserDb StoreUser()"); * } * catch (Exception ex) * { * //handel exceptions * Console.WriteLine(ex.Message + " in UserDb StoreUser()"); * } * finally * { * CloseConnection(); * } * return ds; * }*/ public DataSet Login(User user) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Email) ? SqlString.Null : user.Email)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Password) ? SqlString.Null : user.Password)); DsCAP = CommonDbFunctions.FillDataSet("spCheckUserLoginDetails", CmdCAP); return(DsCAP); }
public DataSet GeyAllProducts_Category_SubcategoryList() { CmdCAP = new SqlCommand(); DsCAP = CommonDbFunctions.FillDataSet("spGeyAllProducts_Category_SubcategoryList", CmdCAP); return(DsCAP); }
public DataSet GetListItems(int id) { CmdCAP = new SqlCommand(); //@prod_subcat_id CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("GetKurtasData", CmdCAP); return(DsCAP); }
public DataSet GetItemsBySearchnames(string searchname) { CmdCAP = new SqlCommand(); //@prod_subcat_id CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@name", SqlDbType.VarChar, 100, searchname)); DsCAP = CommonDbFunctions.FillDataSet("GetItemsBasedsearch", CmdCAP); return(DsCAP); }
public DataSet GeyAllOrdersDetails() { CmdCAP = new SqlCommand(); DsCAP = CommonDbFunctions.FillDataSet("spGeyAllOrderDetails", CmdCAP); return(DsCAP); }
public List <User> getvendoritemdetials(int vid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid)); DsCAP = CommonDbFunctions.FillDataSet("sp_vendoritemdetials", CmdCAP); return(CommonDbFunctions.ConvertDStolist(DsCAP)); }
public DataSet GetItemDetails(int id) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@itm_id", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("GetItemDetails", CmdCAP); return(DsCAP); }
public List <Vitem> getvendorwiseitems(int vid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid)); DsCAP = CommonDbFunctions.FillDataSet("sp_vendortotitems", CmdCAP); return(CommonDbFunctions.convertitemstolist(DsCAP)); }
/*------------------------------------whish list------------------------------------------------------*/ public DataSet GetDataFromWhishList(int uid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, uid)); DsCAP = CommonDbFunctions.FillDataSet("GetWhishListData", CmdCAP); return(DsCAP); }
/*------------------------------------bag------------------------------------------------------*/ public DataSet GetUserBagDetailsById(int id) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("GetUserBagDetials", CmdCAP); return(DsCAP); }
//sudha created on 02/01 public DataSet GetAllVendorsByActiveStatus(int IsActive) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Int, 0, IsActive)); DsCAP = CommonDbFunctions.FillDataSet("spGetAllVendorsByActiveStatus", CmdCAP); return(DsCAP); }
public List <AddressModel> GetUserAddressDataById(int id) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("GetAddressDetails", CmdCAP); return(CommonDbFunctions.ConvertAddressDStoBO(DsCAP)); }
public User GetUserDataById(int id) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("spGetAllUserDetailsByID", CmdCAP); return(CommonDbFunctions.ConvertDStoBO(DsCAP)); }
public DataSet GetAllProdcutswithCatg() { // string itm_ids = ""; CmdCAP = new SqlCommand(); DsCAP = CommonDbFunctions.FillDataSet("GetAllProductsDataWithCategory", CmdCAP); return(DsCAP); }
public DataSet GetAllBrandsData() { // string itm_ids = ""; CmdCAP = new SqlCommand(); DsCAP = CommonDbFunctions.FillDataSet("GetAllBrandsData", CmdCAP); return(DsCAP); }
/*===============================================================products===================================================================================*/ public DataSet GetAllProdcutswithsubCatg(int id) { // string itm_ids = ""; CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pid", SqlDbType.Int, 100, id)); DsCAP = CommonDbFunctions.FillDataSet("GetAllSubCatgProductDetails", CmdCAP); return(DsCAP); }
public DataSet GetBrandsDataById(string name) { // string itm_ids = ""; CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Bname", SqlDbType.VarChar, 150, name)); DsCAP = CommonDbFunctions.FillDataSet("GetProductsDataByBrands", CmdCAP); return(DsCAP); }
/*==================================================Filters=================================================================*/ public DataSet GetItemsByFilters(FiltersModel item) { // string itm_ids = ""; CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Bname", SqlDbType.VarChar, 150, item.bname)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@minprice", SqlDbType.Int, 150, item.minprice)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@maxprice", SqlDbType.Int, 150, item.maxprice)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@type", SqlDbType.Int, 150, item.type)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 150, item.prod_subcat_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@name", SqlDbType.VarChar, 150, item.name)); DsCAP = CommonDbFunctions.FillDataSet("FilterItems", CmdCAP); return(DsCAP); }
public string DeleteProductByAdmin(int PID) { try { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PID", SqlDbType.Int, 0, PID)); DsCAP = CommonDbFunctions.FillDataSet("spDeleteProductByAdmin", CmdCAP); ErrorMessage = ""; } catch (Exception ex) { ErrorMessage = ex.Message; Console.WriteLine(ex.Message); } return(ErrorMessage); }
public string DeleteSubCategoryByAdmin(int prod_subcat_id) { try { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 0, prod_subcat_id)); DsCAP = CommonDbFunctions.FillDataSet("spDeleteSubCategoryByAdmin", CmdCAP); ErrorMessage = ""; } catch (Exception ex) { ErrorMessage = ex.Message; Console.WriteLine(ex.Message); } return(ErrorMessage); }
public string ChangeProductStatusByAdmin(string strPIDS) { try { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PID", SqlDbType.VarChar, 100, string.IsNullOrEmpty(strPIDS) ? SqlString.Null : strPIDS)); DsCAP = CommonDbFunctions.FillDataSet("spChangeProductStatusByAdmin", CmdCAP); ErrorMessage = ""; } catch (Exception ex) { ErrorMessage = ex.Message; Console.WriteLine(ex.Message); } return(ErrorMessage); }
//sudha created on 28/12 public bool CheckEmail(string strEmail) { Boolean res = false; try { CmdCAP = new SqlCommand(); AddParameter("@Email", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strEmail) ? SqlString.Null : strEmail); DsCAP = CommonDbFunctions.FillDataSet("spCheckEmail", CmdCAP); if (DsCAP.Tables[0].Rows.Count > 0) { res = true; } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(res); }
public int CheckMailForExistVendor(string strEmail) { int vid = 0; try { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strEmail) ? SqlString.Null : strEmail)); DsCAP = CommonDbFunctions.FillDataSet("spCheckEmail", CmdCAP); if (DsCAP.Tables[0].Rows.Count >= 0) { vid = Convert.ToInt32(DsCAP.Tables[0].Rows[0][0].ToString()); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(vid); }
public int CheckProductNameIsExist(string strPName) { int pid = 0; try { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PName", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strPName) ? SqlString.Null : strPName)); DsCAP = CommonDbFunctions.FillDataSet("spCheckPName", CmdCAP); if (DsCAP.Tables[0].Rows.Count >= 0) { pid = Convert.ToInt32(DsCAP.Tables[0].Rows[0][0].ToString()); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(pid); }
public DataSet GetOrdersData(int uid) { // string itm_ids = ""; CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, uid)); DsCAP = CommonDbFunctions.FillDataSet("GetOrdersdatabyuid", CmdCAP); //if(DsCAP.Tables[0].Rows.Count>0) //{ // foreach(DataRow row in DsCAP.Tables[0].Rows) // { // itm_ids = row["itm_id"].ToString(); // aid =Convert.ToInt32(row["Address"].ToString()); // } //} return(DsCAP); }
public DataSet GetListItemsDataByPassing_Ids(List <int> list) { CmdCAP = new SqlCommand(); string str = db.Sconnection(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("n", typeof(Int32))); foreach (int num in list) { dt.Rows.Add(num); } //using (SqlConnection con = new SqlConnection(str)) //{ // SqlCommand sqlcom = new SqlCommand("GetItemsByPassing_IDS", con); // sqlcom.CommandType = CommandType.StoredProcedure; // sqlcom.Parameters.AddWithValue("@@proids", dt); // con.Open(); // DsCAP = CommonDbFunctions.FillDataSet("GetItemsByPassing_IDS", CmdCAP); // return DsCAP; //} CmdCAP.Parameters.AddWithValue("@proids", dt); DsCAP = CommonDbFunctions.FillDataSet("GetItemsByPassing_IDS", CmdCAP); return(DsCAP); }