/*================================================= Orders ==========================================================================*/ public string AddOrders(orders item) { CmdCAP = new SqlCommand(); item.ord_date = DateTime.Now.ToString(); item.ord_status = "Ordered Taken"; item.expe_dvy_date = DateTime.Now.AddDays(7).ToString(); item.actl_dvy = DateTime.Now.AddDays(7).ToString(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, item.uid)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@itm_id", SqlDbType.VarChar, 150, item.itm_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@aid", SqlDbType.Int, 50, item.aid)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@phone", SqlDbType.VarChar, 100, item.phone)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@amount", SqlDbType.Int, 100, item.amount)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@shippingchrgs", SqlDbType.Int, 100, item.shipping_charges)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@totalamount", SqlDbType.Int, 50, item.Total_amount)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@paymentmode", SqlDbType.VarChar, 100, item.payment_mode)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@cardno", SqlDbType.VarChar, 100, item.cardno)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@cardname", SqlDbType.VarChar, 100, item.cardname)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@expmonth", SqlDbType.Int, 100, item.expmonth)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@expyear", SqlDbType.Int, 100, item.expyear)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@cvv", SqlDbType.Int, 50, item.cvv)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@ord_date", SqlDbType.VarChar, 100, item.ord_date)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@ord_status", SqlDbType.VarChar, 100, item.ord_status)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@expe_dvy_date", SqlDbType.VarChar, 100, item.expe_dvy_date)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@actl_dvy", SqlDbType.VarChar, 100, item.actl_dvy)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@bagstaus", SqlDbType.VarChar, 100, "ORD")); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "AddOrders", CmdCAP); return(ErrorMessage); }
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 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 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 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); }
/*------------------------------------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); }
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)); }
/*------------------------------------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); }
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)); }
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 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 string RemoveItemFromWhishList(Item item) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@wh_id", SqlDbType.Int, 100, item.bag_id)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "RemoveItemfromWhishList", CmdCAP); return(ErrorMessage); }
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); }
public string DleteAddressById(int uid, int aid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@AID", SqlDbType.Int, 100, string.IsNullOrEmpty(aid.ToString()) ? SqlInt32.Null : Convert.ToInt32(aid))); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, string.IsNullOrEmpty(uid.ToString()) ? SqlInt32.Null : Convert.ToInt32(uid))); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "DeleteAddress", CmdCAP); return(ErrorMessage); }
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 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); }
//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 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 string UpdatePassword(int id, string password) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(password) ? SqlString.Null : password)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "UpdatePassword", CmdCAP); return(ErrorMessage); }
/*===============================================================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); }
public string UpdateProfilePic(int id, string imagepath) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Image", SqlDbType.VarChar, 200, string.IsNullOrEmpty(imagepath) ? SqlString.Null : imagepath)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "updateprofilephoto", CmdCAP); return(ErrorMessage); }
public string CommonForMovetowhislist_RemovefromBag(Item item) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, item.uid)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@itm_id", SqlDbType.Int, 100, item.itm_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@type", SqlDbType.Int, 100, item.type)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@bag_id", SqlDbType.Int, 100, item.bag_id)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "MoveToWishLost_AND_RemovefromBag", CmdCAP); return(ErrorMessage); }
public string AddorEditProductByAdmin(Products_Types product) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PID", SqlDbType.Int, 0, product.PID)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pName", SqlDbType.VarChar, 100, string.IsNullOrEmpty(product.pName) ? SqlString.Null : product.pName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Bit, 0, product.IsActive)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "spAddorEditProductByAdmin", CmdCAP); return(ErrorMessage); }
public string AddorEditSubCategoryByAdmin(Products_SubCategory product_subcategory) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 0, product_subcategory.prod_subcat_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pscName", SqlDbType.VarChar, 100, string.IsNullOrEmpty(product_subcategory.pscName) ? SqlString.Null : product_subcategory.pscName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_cat_id", SqlDbType.Int, 0, product_subcategory.prod_cat_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Bit, 0, product_subcategory.IsActive)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "spAddorEditSubCategoryByAdmin", CmdCAP); return(ErrorMessage); }
public string UpdateBagDetails(Item item) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@bag_id", SqlDbType.Int, 100, item.bag_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@qunty", SqlDbType.Int, 100, item.qunty)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@size", SqlDbType.VarChar, 100, item.size)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@type", SqlDbType.Int, 100, item.type)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@price", SqlDbType.Int, 100, item.price)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "UpdateBagDetails", CmdCAP); return(ErrorMessage); }
public string AddItemsToBag(Item item) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, item.uid)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@itm_id", SqlDbType.Int, 100, item.itm_id)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@size", SqlDbType.VarChar, 50, string.IsNullOrEmpty(item.size) ? SqlString.Null : item.size)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@price", SqlDbType.Int, 100, item.price)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@qunty", SqlDbType.Int, 100, item.qunty)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@status", SqlDbType.VarChar, 100, "INB")); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "AdditemsToBag", CmdCAP); return(ErrorMessage); }
public string UpdateUserPersonalData(User user) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, user.UID)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Firstname", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.FirstName) ? SqlString.Null : user.FirstName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@LastName", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.LastName) ? SqlString.Null : user.LastName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Email) ? SqlString.Null : user.Email)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PhoneNo", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.PhoneNo) ? SqlString.Null : user.PhoneNo)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Gender", SqlDbType.VarChar, 10, string.IsNullOrEmpty(user.Gender) ? SqlString.Null : user.Gender)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "UpdateUserDataById", CmdCAP); return(ErrorMessage); }
public string AddorEditVenderByAdmin(User user) { string strConnstring = db.Sconnection(); CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Firstname", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.FirstName) ? SqlString.Null : user.FirstName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@LastName", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.LastName) ? SqlString.Null : user.LastName)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Email) ? SqlString.Null : user.Email)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PhoneNo", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.PhoneNo) ? SqlString.Null : user.PhoneNo)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Password) ? SqlString.Null : user.Password)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Gender", SqlDbType.VarChar, 10, string.IsNullOrEmpty(user.Gender) ? SqlString.Null : user.Gender)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 0, user.UID)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@RoleID", SqlDbType.Int, 0, user.RoleID)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Int, 0, user.IsActive)); CmdCAP.CommandText = "spAddorEditVenderByAdmin"; CmdCAP.CommandType = CommandType.StoredProcedure; using (ConCAP = new SqlConnection(strConnstring)) { try { ConCAP.Open(); tranCAP = ConCAP.BeginTransaction(); CmdCAP.Connection = ConCAP; CmdCAP.Transaction = tranCAP; CmdCAP.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output; int iENQResult = CmdCAP.ExecuteNonQuery(); tranCAP.Commit(); ErrorMessage = ""; } catch (Exception ex) { ErrorMessage = ex.Message; if (tranCAP != null) { tranCAP.Rollback(); } } } return(ErrorMessage); }
/*==================================================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); }