public string[] UpdateCustomer(CustomerClass fred, CreditCardClass cc, object[] stupid) { DBConnect DB = new DBConnect(); SqlCommand command = new SqlCommand(); string[] meh = new string[3]; ErrorCodes ec = new ErrorCodes(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "CustomerUpdate"; command.Parameters.AddWithValue("@FirstName", fred.Firstname); command.Parameters.AddWithValue("@Address", fred.Address); command.Parameters.AddWithValue("@City", fred.City); command.Parameters.AddWithValue("@State", fred.State); command.Parameters.AddWithValue("@ZipCode", fred.ZipCode); command.Parameters.AddWithValue("@AccountBalance", cc.AccountBalance); meh[0] = (DB.DoUpdateUsingCmdObj(command) > 0) ? "true" : "false"; SqlCommand sandy = new SqlCommand(); sandy.CommandType = CommandType.StoredProcedure; sandy.CommandText = "VerifyInfo"; sandy.Parameters.AddWithValue("@CreditCardNum", cc.CardNumber); sandy.Parameters.AddWithValue("@CVV", cc.CVV); sandy.Parameters.AddWithValue("@TransAmnt", float.Parse(stupid[2].ToString())); sandy.Parameters.AddWithValue("@FirstName", fred.Firstname); SqlParameter returnParam = new SqlParameter("@RVAL", DbType.Int32); returnParam.Direction = ParameterDirection.ReturnValue; sandy.Parameters.Add(returnParam); // DataSet ds = DB.GetDataSetUsingCmdObj(sandy); DB.GetDataSetUsingCmdObj(sandy); meh[1] = sandy.Parameters["@RVAL"].Value.ToString(); meh[2] = ec.GetErrorCodeMessage(int.Parse(meh[1])); return meh; }
protected void btnSaveChanges_Click(object sender, EventArgs e) { string email = txtCurrentEmail.Text; string newPhone = txtPhonenumber.Text; SqlCommand phoneCmd = new SqlCommand(); DBConnect objDB = new DBConnect(); phoneCmd.CommandType = CommandType.StoredProcedure; phoneCmd.CommandText = "dbo.TP_ResetPhonenumber"; SqlParameter inputEmail = new SqlParameter("@email", email); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; phoneCmd.Parameters.Add(inputEmail); SqlParameter inputPhone = new SqlParameter("@newPhone", newPhone); inputPhone.Direction = ParameterDirection.Input; inputPhone.SqlDbType = SqlDbType.NVarChar; inputPhone.Size = 50; phoneCmd.Parameters.Add(inputPhone); phoneCmd.Parameters.Add("@results", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(phoneCmd); int result = Convert.ToInt32(phoneCmd.Parameters["@results"].Value); if (result == 1) lblMsg.Text = "Your phone number was changed succesfully!"; else if (result == 0) lblMsg.Text = "Your phone number was not changed!Please try again"; }
protected void btnSaveChanges_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtCurrentEmail.Text) || String.IsNullOrEmpty(txtCurrentPassword.Text) || String.IsNullOrEmpty(txtNewPassword.Text)) Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "<script> alert('All fields are required.Thank you!'); </script>"); SqlCommand pass = new SqlCommand(); DBConnect objDB = new DBConnect(); //string currentPassword = (string)pass.ExecuteScalar(); //if (currentPassword == txtCurrentPassword.Text) // { } //else // lblMsg.Text = "Please enter your current password again!"; Salt salt = new Salt(); string currentEmail = txtCurrentEmail.Text; string currentPassword = txtCurrentPassword.Text; string newPassword1 = txtNewPassword.Text; customer customerObj=new customer(); int result = customerObj.ResetPassword(currentEmail, currentPassword, newPassword1, salt.ToString(),role); if (result == 0) lblMsg.Text = "The password you entered is incorrect!"; else if (result == 1) lblMsg.Text = "The password was changed successfully."; // Response.Redirect("LoginPage.aspx"); }
public Boolean AssessmentsUpdate(String fiscalYear) { SqlCommand objcomm = new SqlCommand(); objcomm.CommandType = CommandType.StoredProcedure; objcomm.CommandText = "UpdateAssessments"; objcomm.Parameters.Add("@fiscalYear", fiscalYear); SqlParameter outputParameter = new SqlParameter("@result", DbType.Int32); outputParameter.Direction = ParameterDirection.ReturnValue; objcomm.Parameters.Add(outputParameter); DBConnect objDB = new DBConnect(); objDB.DoUpdateUsingCmdObj(objcomm); int result = int.Parse(objcomm.Parameters["@result"].Value.ToString()); if (result == 1) { return true; } else { return false; } }
protected void btnSaveChanges_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtPhonenumber.Text) || String.IsNullOrEmpty(txtCurrentEmail.Text)) Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "<script> alert('All fields are required.Thank you!'); </script>"); string email = txtCurrentEmail.Text; string newPhone = txtPhonenumber.Text; SqlCommand phoneCmd = new SqlCommand(); DBConnect objDB = new DBConnect(); phoneCmd.CommandType = CommandType.StoredProcedure; phoneCmd.CommandText = "dbo.TP_ResetPhonenumber"; SqlParameter inputEmail = new SqlParameter("@email", email); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; phoneCmd.Parameters.Add(inputEmail); SqlParameter inputPhone = new SqlParameter("@newPhone", newPhone); inputPhone.Direction = ParameterDirection.Input; inputPhone.SqlDbType = SqlDbType.NVarChar; inputPhone.Size = 50; phoneCmd.Parameters.Add(inputPhone); phoneCmd.Parameters.Add("@results", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(phoneCmd); int result = Convert.ToInt32(phoneCmd.Parameters["@results"].Value); if (result == 1) lblMsg.Text = "Your phone number was changed succesfully!"; else if (result == 0) lblMsg.Text = "Your phone number was not changed!Please try again"; }
protected void btnConfirm_Click(object sender, EventArgs e) { string oldpass = txtOldPass.Text; string newpass1 = txtNewPass1.Text; string newpass2 = txtNewPass2.Text; if (newpass1 == newpass2) { DBConnect db = new DBConnect(); string email = Session["emailSession"].ToString(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "UpdateMerch"; command.Parameters.AddWithValue("@email", email); command.Parameters.AddWithValue("@oldPass", oldpass); command.Parameters.AddWithValue("@newPass1", newpass1); command.Parameters.AddWithValue("@newPass2", newpass2); db.DoUpdateUsingCmdObj(command); } else { Label lblerror = new Label(); lblerror.Text = "New Passwords do not match please try again"; } }
protected void btnSaveChanges_Click(object sender, EventArgs e) { string email = txtCurrentEmail.Text; string newName = txtNewName.Text; SqlCommand name = new SqlCommand(); DBConnect objDB = new DBConnect(); name.CommandType = CommandType.StoredProcedure; name.CommandText = "dbo.TP_ResetName"; SqlParameter inputEmail = new SqlParameter("@email", email); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; name.Parameters.Add(inputEmail); SqlParameter inputName = new SqlParameter("@newName", newName); inputName.Direction = ParameterDirection.Input; inputName.SqlDbType = SqlDbType.NVarChar; inputName.Size = 50; name.Parameters.Add(inputName); name.Parameters.Add("@result", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(name); int result = Convert.ToInt32(name.Parameters["@result"].Value); if (result == 1) lblMsg.Text = "Your name was changed succesfully!"; else if (result==0) lblMsg.Text = "Your name was not changed!"; }
public bool ValidMerchantLogin(string email, string password) { DataSet myDS = new DataSet(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_ValidMerchantLogin"; objCommand.Parameters.AddWithValue("@email", email); objCommand.Parameters.AddWithValue("@password", password); DBConnect objDB = new DBConnect(); myDS = objDB.GetDataSetUsingCmdObj(objCommand); bool returnvalue = true; //if the values are found in the DB return true if ((myDS.Tables[0].Rows.Count <= 1) && (myDS.Tables[0].Rows[0]["password"].ToString() == password)) { returnvalue = true; } //the user does not exist in the DB else { returnvalue = false; } return returnvalue; }
public bool AddNewCustomer(Customer newCustomer) { DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "AddTPCustomer"; objCommand.Parameters.AddWithValue("@Name", newCustomer.name); objCommand.Parameters.AddWithValue("@Email", newCustomer.email ); objCommand.Parameters.AddWithValue("@password", newCustomer.password); objCommand.Parameters.AddWithValue("@address", newCustomer.shippingAddress); objCommand.Parameters.AddWithValue("@city", newCustomer.shippingAddress); objCommand.Parameters.AddWithValue("@state", newCustomer.shippingState); objCommand.Parameters.AddWithValue("@zipcode", newCustomer.shippingZipcode); //integer to determine if value was added into DB or not int result= objDB.DoUpdateUsingCmdObj(objCommand); if (!(result <= 0)) //if a new row was successsfully added { return false; } else //else the row was not added successfully { return true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string query = "SELECT * FROM Student"; DBConnect db = new DBConnect(); ddStudentSelect.DataSource = db.GetDataSet(query); ddStudentSelect.DataValueField = "StudentID"; ddStudentSelect.DataTextField = "Name"; ddStudentSelect.DataBind(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetAllCourses"; gvCourses.DataSource = db.GetDataSetUsingCmdObj(command); gvCourses.DataBind(); for(int r = 0; r<gvCourses.Rows.Count; r++) { CheckBox cb; cb = (CheckBox)gvCourses.Rows[r].FindControl("cbSelectCourse"); if (int.Parse(gvCourses.Rows[r].Cells[10].Text) == 0) { cb.Enabled = false; } } } }
public Boolean cartExists(int loginID) { Boolean cartExists = false; DataSet cart = new DataSet(); DBConnect objDB = new DBConnect(); SqlCommand logID = new SqlCommand(); logID.CommandType = CommandType.StoredProcedure; logID.CommandText = ("TP_findCartByLogin"); SqlParameter theID = new SqlParameter("@loginID", loginID); theID.Direction = ParameterDirection.Input; theID.SqlDbType = SqlDbType.Int; theID.Size = 4; logID.Parameters.Add(theID); cart = objDB.GetDataSetUsingCmdObj(logID); int size = Convert.ToInt32(cart.Tables[0].Rows[0][0].ToString()); if (size > 0) { cartExists = true; return cartExists; } else { return cartExists; } }
public Boolean AssestmentsUpdate(String fiscalYear,double financialAidRateGrad,double plandFundFeeGradRate,double financialAidRateUndergrad,double plandFundFeeRateUndergrad ) { SqlCommand objcomm = new SqlCommand(); objcomm.CommandType = CommandType.StoredProcedure; objcomm.CommandText = "AssesmentsUpdate"; objcomm.Parameters.Add("@fiscalYearId", fiscalYear); objcomm.Parameters.Add("@financialAidRateGrad", financialAidRateGrad); objcomm.Parameters.Add("@plandFundFeeGradRate", plandFundFeeGradRate); objcomm.Parameters.Add("@financialAidRateUndergrad", financialAidRateUndergrad); objcomm.Parameters.Add("@plandFundFeeRateUndergrad", plandFundFeeRateUndergrad); SqlParameter outputParameter = new SqlParameter("@result", DbType.Int32); outputParameter.Direction = ParameterDirection.ReturnValue; objcomm.Parameters.Add(outputParameter); DBConnect objDB = new DBConnect(); objDB.GetDataSetUsingCmdObj(objcomm); int result = int.Parse(objcomm.Parameters["@result"].Value.ToString()); if (result == 1) { return true; } else { return false; } }
protected void btnPlaceOrder_Click(object sender, EventArgs e) { List<cartItem> cartItems = new List<cartItem>(); cartItems = (List<cartItem>)Session["cart"]; DBConnect objDB = new DBConnect(); SqlCommand addPurchase = new SqlCommand(); addPurchase.CommandType = CommandType.StoredProcedure; addPurchase.CommandText = "TP_CustomerTransactions"; SqlCommand updateProdQuan = new SqlCommand(); updateProdQuan.CommandType = CommandType.StoredProcedure; updateProdQuan.CommandText = "TP_subtractProducts"; foreach(cartItem obj in cartItems) { SqlParameter prodID = new SqlParameter("@prodNum", obj.ProdNum); prodID.Direction = ParameterDirection.Input; prodID.SqlDbType = SqlDbType.Int; prodID.Size = 4; addPurchase.Parameters.Add(prodID); SqlParameter quantity = new SqlParameter("@quantity", obj.ProdQuantity); quantity.Direction = ParameterDirection.Input; prodID.SqlDbType = SqlDbType.Int; prodID.Size = 4; addPurchase.Parameters.Add(quantity); SqlParameter loginiD = new SqlParameter("@loginID", Convert.ToInt32(Session["loginId"])); loginiD.Direction = ParameterDirection.Input; loginiD.SqlDbType = SqlDbType.Int; loginiD.Size = 4; addPurchase.Parameters.Add(loginiD); SqlParameter quan = new SqlParameter("@prodNum", obj.ProdNum); quan.Direction = ParameterDirection.Input; quan.SqlDbType = SqlDbType.Int; quan.Size = 4; updateProdQuan.Parameters.Add(quan); objDB.DoUpdateUsingCmdObj(updateProdQuan); } //SqlCommand removeCart = new SqlCommand(); //updateProdQuan.CommandType = CommandType.StoredProcedure; //updateProdQuan.CommandText = "TP_removeCart"; //SqlParameter id = new SqlParameter("@custID", Convert.ToInt32(Session["loginId"])); //id.Direction = ParameterDirection.Input; //id.SqlDbType = SqlDbType.Int; //id.Size = 4; //objDB.DoUpdateUsingCmdObj(removeCart); //List<cartItem> emptyCart = new List<cartItem>(); //Session["cart"] = emptyCart; }
public void rebind() { DBConnect db = new DBConnect(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetAllCourses"; gvCourses.DataSource = db.GetDataSetUsingCmdObj(command); gvCourses.DataBind(); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtCurrentEmail.Text) || String.IsNullOrEmpty(txtPassword.Text) || String.IsNullOrEmpty(txtNewEmail2.Text)) Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", "<script> alert('All fields are required.Thank you!'); </script>"); { string currentEmail = txtCurrentEmail.Text; string passord = txtPassword.Text; string newEmail2 = txtNewEmail2.Text; SqlCommand emailCmd = new SqlCommand(); DBConnect objDB = new DBConnect(); emailCmd.CommandType = CommandType.StoredProcedure; emailCmd.CommandText = "dbo.TP_ResetEmail"; SqlParameter inputEmail = new SqlParameter("@currentEmail", currentEmail); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; emailCmd.Parameters.Add(inputEmail); SqlParameter inputPassword = new SqlParameter("@password", passord); inputPassword.Direction = ParameterDirection.Input; inputPassword.SqlDbType = SqlDbType.NVarChar; inputPassword.Size = 50; emailCmd.Parameters.Add(inputPassword); SqlParameter inputEmail2 = new SqlParameter("@newEmail", newEmail2); inputEmail2.Direction = ParameterDirection.Input; inputEmail2.SqlDbType = SqlDbType.NVarChar; inputEmail2.Size = 50; emailCmd.Parameters.Add(inputEmail2); emailCmd.Parameters.Add("@result", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(emailCmd); int result = Convert.ToInt32(emailCmd.Parameters["@result"].Value); if (result == -1) lblMsg.Text = "The password you entered is incorrect!"; else if (result == 0) { lblMsg.Text = "The new email you entered already exists."; } else { lblMsg.Text = "The email was changed succesfully."; } } }
public void CreateFiscalYear(String fiscalYear) { SqlCommand objcomm = new SqlCommand(); objcomm.CommandType = CommandType.StoredProcedure; objcomm.CommandText = "sp_CreateFiscalYear"; objcomm.Parameters.Add("@fiscalYear", fiscalYear); DBConnect objDB = new DBConnect(); objDB.DoUpdateUsingCmdObj(objcomm); }
protected void ddlDepartments_SelectedIndexChanged(object sender, EventArgs e) { DataSet products = new DataSet(); DBConnect objDB = new DBConnect(); string depNum = ddlDepartments.SelectedValue; //string depNum = "SELECT departmentNum FROM TP_DEPARTMENT WHERE departmentName = "+depName+""; products = pxy.GetProductCatalog(depNum); gvProducts.DataSource = products; gvProducts.DataBind(); }
public void saveStudent() { SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "NewStudent"; command.Parameters.AddWithValue("@ID", id); command.Parameters.AddWithValue("@Name", name); command.Parameters.AddWithValue("@Tuition", tuition); DBConnect DB = new DBConnect(); DB.DoUpdateUsingCmdObj(command); }
protected void Page_Load(object sender, EventArgs e) { DBConnect db = new DBConnect(); string merchEmail = Session["emailSession"].ToString(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetMerchAccount"; command.Parameters.AddWithValue("@email", merchEmail); DataSet ds = db.GetDataSetUsingCmdObj(command); gvMerchAccount.DataSource = ds; gvMerchAccount.DataBind(); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { SqlCommand pass = new SqlCommand(); DBConnect objDB = new DBConnect(); pass.CommandType = CommandType.StoredProcedure; pass.CommandText = "dbo.TP_ResetPassword"; //string currentPassword = (string)pass.ExecuteScalar(); //if (currentPassword == txtCurrentPassword.Text) // { } //else // lblMsg.Text = "Please enter your current password again!"; string currentEmail = txtCurrentEmail.Text; string currentPassword = txtCurrentPassword.Text; string newPassword1 = txtNewPassword.Text; SqlParameter inputEmail = new SqlParameter("@email", currentEmail); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; pass.Parameters.Add(inputEmail); SqlParameter inputPassword = new SqlParameter("@currentPass", currentPassword); inputPassword.Direction = ParameterDirection.Input; inputPassword.SqlDbType = SqlDbType.NVarChar; inputPassword.Size = 50; pass.Parameters.Add(inputPassword); SqlParameter inputPassword1 = new SqlParameter("@newPass", newPassword1); inputPassword1.Direction = ParameterDirection.Input; inputPassword1.SqlDbType = SqlDbType.NVarChar; inputPassword1.Size = 50; pass.Parameters.Add(inputPassword1); pass.Parameters.Add("@returnId", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(pass); int result = Convert.ToInt32(pass.Parameters["@returnId"].Value); if (result == 1) lblMsg.Text = "The password you entered is incorrect!"; else if (result == 0) lblMsg.Text = "The password was not changed."; // Response.Redirect("LoginPage.aspx"); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { { string currentEmail = txtCurrentEmail.Text; string passord = txtPassword.Text; string newEmail2 = txtNewEmail2.Text; SqlCommand emailCmd = new SqlCommand(); DBConnect objDB = new DBConnect(); emailCmd.CommandType = CommandType.StoredProcedure; emailCmd.CommandText = "dbo.TP_ResetEmail"; SqlParameter inputEmail = new SqlParameter("@currentEmail", currentEmail); inputEmail.Direction = ParameterDirection.Input; inputEmail.SqlDbType = SqlDbType.NVarChar; inputEmail.Size = 50; emailCmd.Parameters.Add(inputEmail); SqlParameter inputPassword = new SqlParameter("@password", passord); inputPassword.Direction = ParameterDirection.Input; inputPassword.SqlDbType = SqlDbType.NVarChar; inputPassword.Size = 50; emailCmd.Parameters.Add(inputPassword); SqlParameter inputEmail2 = new SqlParameter("@newEmail", newEmail2); inputEmail2.Direction = ParameterDirection.Input; inputEmail2.SqlDbType = SqlDbType.NVarChar; inputEmail2.Size = 50; emailCmd.Parameters.Add(inputEmail2); emailCmd.Parameters.Add("@result", SqlDbType.Int).Direction = ParameterDirection.Output; objDB.DoUpdateUsingCmdObj(emailCmd); int result = Convert.ToInt32(emailCmd.Parameters["@result"].Value); if (result == -1) lblMsg.Text = "The password you entered is incorrect!"; else if (result == 0) { lblMsg.Text = "The new email you entered already exists."; } else { lblMsg.Text = "The email was changed succesfully."; } } }
protected void btnAPI_Click(object sender, EventArgs e) { Label lblAPI = new Label(); DBConnect db = new DBConnect(); string merchEmail = Session["emailSession"].ToString(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetAPI"; command.Parameters.AddWithValue("@email", merchEmail); DataSet ds = db.GetDataSetUsingCmdObj(command); string api = ds.Tables[0].Rows[0]["APIKey"].ToString(); lblAPI.Text = api; }
public DataSet GetDepartments() { SqlCommand dep = new SqlCommand(); DBConnect objDB = new DBConnect(); DataSet department = new DataSet(); dep.CommandType = CommandType.StoredProcedure; dep.CommandText = "dbo.TP_getDepartments"; department = objDB.GetDataSetUsingCmdObj(dep); return department; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string query = "SELECT * FROM Student"; DBConnect db = new DBConnect(); ddStudentSelect.DataSource = db.GetDataSet(query); ddStudentSelect.DataValueField = "StudentID"; ddStudentSelect.DataTextField = "Name"; ddStudentSelect.DataBind(); } }
public void loadProducts() { //display data from each item in Product DB into correct template feilds //display product name into label //display product url image into image DBConnect dbobj = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "GetAllProducts"; DataSet ds = dbobj.GetDataSetUsingCmdObj(objCommand); rptProducts.DataSource = ds; rptProducts.DataBind(); }
public void insertIntoPurchase(string email, string CardNum, string ProductID) { //Email, CardNum, SaleTotal, Products DBConnect objdb = new DBConnect(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = "TP_InsertIntoPurchase"; sqlCommand.Parameters.AddWithValue("@email", email); sqlCommand.Parameters.AddWithValue("@CardNum", CardNum); //sqlCommand.Parameters.AddWithValue("@SaleTotal", SaleTotal); sqlCommand.Parameters.AddWithValue("@products", ProductID); objdb.DoUpdateUsingCmdObj(sqlCommand); // }
//Register Merchant Button protected void btnContinue_Click(object sender, EventArgs e) { DBConnect DB = new DBConnect(); Register register = new Register(); Merchant newMerchant = new Merchant(); newMerchant.groupName = txtName.Text; newMerchant.email = txtEmail.Text; newMerchant.address = txtAddress.Text; newMerchant.url = txtURL.Text; SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "RegisterMerchant"; command.Parameters.AddWithValue("@GroupName", newMerchant.groupName); command.Parameters.AddWithValue("@Email", newMerchant.email); command.Parameters.AddWithValue("@Address", newMerchant.address); command.Parameters.AddWithValue("@URL", newMerchant.url); DB.DoUpdateUsingCmdObj(command); DB = new DBConnect(); SqlCommand key = new SqlCommand(); key.CommandType = CommandType.StoredProcedure; key.CommandText = "InsertKey"; key.Parameters.AddWithValue("@GroupName", newMerchant.groupName); DataSet ds = DB.GetDataSetUsingCmdObj(key); string apikey = ds.Tables[0].Rows[0]["APIKey"].ToString(); lblGeneralError.Text = "Your APIKey is " + apikey; //Stored procedure to insert new merchant into a merchant table //if "Remember Me" is checked, store userName in cookie //if (chkbxRemeberMe.Checked) //{ // HttpCookie emailCookie = new HttpCookie("Login_Cookie");//cookie's name // emailCookie.Values["email"] = txtEmail.Text; //set cookies value // emailCookie.Values["LastVisited"] = DateTime.Now.ToString(); // emailCookie.Expires = DateTime.Now.AddYears(1); // Response.Cookies.Add(emailCookie); //} //else //{ // //remove user's email from username textbox // Response.Cookies.Remove("mycookie"); //} //Response.Redirect("Login.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DBConnect DB = new DBConnect(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetDep"; DataSet ds = DB.GetDataSetUsingCmdObj(command); ddDepartment.DataSource = ds; ddDepartment.DataTextField = "DepartmentName"; ddDepartment.DataValueField = "DepartmentID"; ddDepartment.DataBind(); } }
public void AddAdmin(AdminObject admin) { DBConnect objDB = new DBConnect(); SqlCommand objcomm = new SqlCommand(); objcomm.CommandType = CommandType.StoredProcedure; objcomm.CommandText = "sp_addadmin"; objcomm.Parameters.Add("@tuid", admin.tuid); objcomm.Parameters.Add("@firstName", admin.firstName); objcomm.Parameters.Add("@lastName", admin.lastName); objcomm.Parameters.Add("@department", admin.department); objcomm.Parameters.Add("@accessLevel", admin.accessLevel); objDB.DoUpdateUsingCmdObj(objcomm); }
public bool HelloWorld(CreditCardClass cc, CustomerClass arthur) { DBConnect DB = new DBConnect(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "AddCard"; command.Parameters.AddWithValue("@CreditCardNumber", cc.CardNumber); command.Parameters.AddWithValue("@CVV", cc.CVV); command.Parameters.AddWithValue("@AccountNumber", cc.AccountNumber); command.Parameters.AddWithValue("@CreditLimit", cc.CreditLimit); command.Parameters.AddWithValue("@AccountBalance", cc.AccountBalance); command.Parameters.AddWithValue("@FirstName", arthur.Firstname); command.Parameters.AddWithValue("@LastName", arthur.LastName); return (DB.DoUpdateUsingCmdObj(command) > 0) ? true : false; }
public List <ProfileFeedClass> RetrieveProfileFeed(String RequestingUser, String RequestedUserEmail, String privacySetting) { List <ProfileFeedClass> EmptyArray = new List <ProfileFeedClass>(); Profile ProfileObject = new Profile(); Boolean checkifFriends = ProfileObject.CheckIf2UsersAreFriends(RequestingUser, RequestedUserEmail); if (checkifFriends == true) { List <ProfileFeedClass> feedArray = new List <ProfileFeedClass>(); DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_LoadProfileFeed"; objCommand.Parameters.AddWithValue("@Email", RequestedUserEmail); DataSet FeedDS = objDB.GetDataSetUsingCmdObj(objCommand); if (FeedDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < FeedDS.Tables[0].Rows.Count; i++) { ProfileFeedClass postObject = new ProfileFeedClass(); postObject.postID = int.Parse(FeedDS.Tables[0].Rows[i][0].ToString()); postObject.userEmail = FeedDS.Tables[0].Rows[i][1].ToString(); postObject.postBody = FeedDS.Tables[0].Rows[i][2].ToString(); postObject.datePosted = FeedDS.Tables[0].Rows[i][4].ToString(); postObject.imageURL = FeedDS.Tables[0].Rows[i][3].ToString(); postObject.postType = FeedDS.Tables[0].Rows[i][6].ToString(); postObject.postingToUser = FeedDS.Tables[0].Rows[i][7].ToString(); feedArray.Add(postObject); } return(feedArray); } else { return(EmptyArray); } } if (privacySetting == "Public") { List <ProfileFeedClass> feedArray = new List <ProfileFeedClass>(); DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_LoadProfileFeed"; objCommand.Parameters.AddWithValue("@Email", RequestedUserEmail); DataSet FeedDS = objDB.GetDataSetUsingCmdObj(objCommand); if (FeedDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < FeedDS.Tables[0].Rows.Count; i++) { ProfileFeedClass postObject = new ProfileFeedClass(); postObject.postID = int.Parse(FeedDS.Tables[0].Rows[i][0].ToString()); postObject.userEmail = FeedDS.Tables[0].Rows[i][1].ToString(); postObject.postBody = FeedDS.Tables[0].Rows[i][2].ToString(); postObject.datePosted = FeedDS.Tables[0].Rows[i][4].ToString(); postObject.imageURL = FeedDS.Tables[0].Rows[i][3].ToString(); postObject.postType = FeedDS.Tables[0].Rows[i][6].ToString(); postObject.postingToUser = FeedDS.Tables[0].Rows[i][7].ToString(); feedArray.Add(postObject); } return(feedArray); } else { return(EmptyArray); } } if (privacySetting == "Friends") { List <ProfileFeedClass> feedArray = new List <ProfileFeedClass>(); Boolean flag = ProfileObject.CheckIf2UsersAreFriends(RequestingUser, RequestedUserEmail); if (flag == true) { DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_LoadProfileFeed"; objCommand.Parameters.AddWithValue("@Email", RequestedUserEmail); DataSet FeedDS = objDB.GetDataSetUsingCmdObj(objCommand); if (FeedDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < FeedDS.Tables[0].Rows.Count; i++) { ProfileFeedClass postObject = new ProfileFeedClass(); postObject.postID = int.Parse(FeedDS.Tables[0].Rows[i][0].ToString()); postObject.userEmail = FeedDS.Tables[0].Rows[i][1].ToString(); postObject.postBody = FeedDS.Tables[0].Rows[i][2].ToString(); postObject.datePosted = FeedDS.Tables[0].Rows[i][4].ToString(); postObject.imageURL = FeedDS.Tables[0].Rows[i][3].ToString(); postObject.postType = FeedDS.Tables[0].Rows[i][6].ToString(); postObject.postingToUser = FeedDS.Tables[0].Rows[i][7].ToString(); feedArray.Add(postObject); } return(feedArray); } else { return(EmptyArray); } } } if (privacySetting == "FOF") { List <ProfileFeedClass> feedArray = new List <ProfileFeedClass>(); Boolean flag = ProfileObject.CheckIfFOF(RequestingUser, RequestedUserEmail); if (flag == true) { DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_LoadProfileFeed"; objCommand.Parameters.AddWithValue("@Email", RequestedUserEmail); DataSet FeedDS = objDB.GetDataSetUsingCmdObj(objCommand); if (FeedDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < FeedDS.Tables[0].Rows.Count; i++) { ProfileFeedClass postObject = new ProfileFeedClass(); postObject.postID = int.Parse(FeedDS.Tables[0].Rows[i][0].ToString()); postObject.userEmail = FeedDS.Tables[0].Rows[i][1].ToString(); postObject.postBody = FeedDS.Tables[0].Rows[i][2].ToString(); postObject.datePosted = FeedDS.Tables[0].Rows[i][4].ToString(); postObject.imageURL = FeedDS.Tables[0].Rows[i][3].ToString(); postObject.postType = FeedDS.Tables[0].Rows[i][6].ToString(); postObject.postingToUser = FeedDS.Tables[0].Rows[i][7].ToString(); feedArray.Add(postObject); } return(feedArray); } else { return(EmptyArray); } } else { return(EmptyArray); } } else { return(EmptyArray); } }
public StoredProcedure() { objDB = new DBConnect(); objCmd = new SqlCommand(); }