/*================================================= 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 string taskloginstring(string strEmail, string strPassword) { CmdCAP = new SqlCommand(); AddParameter("@Email", SqlDbType.VarChar, 100, string.IsNullOrEmpty(strEmail)? SqlString.Null : strEmail); AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(strPassword)? SqlString.Null : strPassword); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "spCheckUserLoginDetails", CmdCAP); return(ErrorMessage); }
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 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 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 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); }
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 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 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 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 vendoritemadding(int vid, string items) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 0, vid)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.VarChar, 1000, string.IsNullOrEmpty(items) ? SqlString.Null : items)); using (ConCAP = new SqlConnection()) { try { ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "sp_vendoritems", CmdCAP); } catch (SqlException ex) { ErrorMessage = ex.Message; } } //DataTable dt = new DataTable(); //dt.Columns.Add(new DataColumn("vid", typeof(Int32))); //dt.Columns.Add(new DataColumn("prod_subcat_id", typeof(Int32))); //foreach (product model in list) //{ // dt.Rows.Add(model.vid,model.prod_subcat_id); //} //using (SqlConnection con = new SqlConnection(str)) //{ // SqlCommand sqlcom = new SqlCommand("sp_vendoritemlist", con); // sqlcom.CommandType = CommandType.StoredProcedure; // sqlcom.Parameters.AddWithValue("@List", dt); // // sqlcom.Parameters.Add(prmReturn); // con.Open(); // sqlcom.ExecuteNonQuery(); //} return(ErrorMessage); }
public string AddingAddressDetails(AddressModel model) { CmdCAP = new SqlCommand(); //CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@AID", SqlDbType.Int, 100, string.IsNullOrEmpty(model.AID.ToString()) ? SqlInt32.Null : Convert.ToInt32(model.AID))); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, string.IsNullOrEmpty(model.UID.ToString()) ? SqlInt32.Null : Convert.ToInt32(model.UID))); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Address", SqlDbType.VarChar, 100, string.IsNullOrEmpty(model.Address) ? SqlString.Null : model.Address)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Town", SqlDbType.VarChar, 100, string.IsNullOrEmpty(model.Town) ? SqlString.Null : model.Town)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@City", SqlDbType.VarChar, 100, string.IsNullOrEmpty(model.City) ? SqlString.Null : model.City)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Pincode", SqlDbType.Int, 100, string.IsNullOrEmpty(model.Pincode.ToString()) ? SqlInt32.Null : Convert.ToInt32(model.Pincode))); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@State", SqlDbType.VarChar, 100, string.IsNullOrEmpty(model.State) ? SqlString.Null : model.State)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Type", SqlDbType.VarChar, 50, string.IsNullOrEmpty(model.Type) ? SqlString.Null : model.Type)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@avaldays", SqlDbType.VarChar, 100, string.IsNullOrEmpty(model.avaldays) ? SqlString.Null : model.avaldays)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Time", SqlDbType.VarChar, 50, model.Time)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "Addaddress", CmdCAP); return(ErrorMessage); }
public string delvitem(int vpid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Clear(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Vpid", SqlDbType.Int, 0, vpid)); using (ConCAP = new SqlConnection()) { try { ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "sp_vitemdel", CmdCAP); } catch (SqlException ex) { ErrorMessage = ex.Message; } } return(ErrorMessage); }
//public int Register(User user) // { // SqlCommand sqlcommand = new SqlCommand(); // SqlParameter[] param = new SqlParameter[10]; // param[0] = new SqlParameter("@Firstname", user.FirstName); // param[1] = new SqlParameter("@LastName", user.LastName); // param[2] = new SqlParameter("@Email", user.Email); // param[3] = new SqlParameter("@PhoneNo", user.PhoneNo); // param[4] = new SqlParameter("@Gender", user.Gender); // param[5] = new SqlParameter("@Address", user.Address); // param[6] = new SqlParameter("@Password", user.Password); // param[7] = new SqlParameter("@OTP", user.OTP); // param[8] = new SqlParameter("@Image", user.Image); // param[9] = new SqlParameter("@RoleID", user.RoleID); // sqlcommand = new SqlCommand("spRegistration", OpenConnection()) // { // CommandType = CommandType.StoredProcedure // }; // sqlcommand.Parameters.AddRange(param); // try // { // int irowsAffected = sqlcommand.ExecuteNonQuery(); // return irowsAffected; // } // catch (SqlException ex) // { // //handel sql excepetions // Console.WriteLine(ex.Message + " in UserDb StoreUser()"); // return 0; // } // catch (Exception ex) // { // //handel exceptions // Console.WriteLine(ex.Message + " in UserDb StoreUser()"); // return 0; // } // finally // { // CloseConnection(); // } // } public string Register(User user) { 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("@Gender", SqlDbType.VarChar, 10, string.IsNullOrEmpty(user.Gender) ? SqlString.Null : user.Gender)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Password) ? SqlString.Null : user.Password)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@OTP", SqlDbType.Int, 0, string.IsNullOrEmpty(user.OTP.ToString()) ? SqlInt32.Null : Convert.ToInt32(user.OTP))); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Image", SqlDbType.VarChar, 100, user.Image)); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@RoleID", SqlDbType.Int, 0, user.RoleID)); ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "spRegistration", CmdCAP); return(ErrorMessage); }
public string inspname(string pname) { CmdCAP = new SqlCommand(); //CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Imode", SqlDbType.VarChar, 50, "Insproud")); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pname", SqlDbType.VarChar, 50, string.IsNullOrEmpty(pname) ? SqlString.Null : pname)); CmdCAP.CommandText = "Sp_vendor"; CmdCAP.CommandType = CommandType.StoredProcedure; using (ConCAP = new SqlConnection()) { try { ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "Sp_vendor", CmdCAP); } catch (SqlException ex) { ErrorMessage = ex.Message; } } return(ErrorMessage); }