protected void btnCreate_Click(object sender, EventArgs e) { dataAccess database = new dataAccess(); Format format = new Format(); DataTable dt = database.getTable("SELECT Email from aspnet_Membership WHERE Email = '" + txtEmail.Text.ToLower() + "'"); if (dt.Rows.Count == 0) // Check for existing email in database. If not zero email exists. Display invalid email { bool flag = false; string fname = format.capitalizeStart(txtFName.Text.ToString()); string lname = format.capitalizeStart(txtLName.Text.ToString()); string contactNum = txtContactNum.Text.ToString(); string passportID = txtPassportID.Text.ToString(); string email = txtEmail.Text.ToString(); string address = txtPhysicalAddress.Text.ToString(); string password = txtPassword.Text.ToString(); string insertString = "INSERT INTO jobsdb_Administrator (FirstName, LastName, ContactNumber,Email, PhysicalAddress, PassportID, Active) VALUES ('" + fname + "','" + lname + "','" + contactNum + "','" + email + "','" + address + "','" + passportID + "','True')"; try { flag = database.insertData(insertString); if (flag) { //Creste user with Email and Password given Membership.CreateUser(email, password, email); //Assign user admin role Roles.AddUserToRole(email, ConfigurationSettings.AppSettings["AdminRoleName"]); } } catch (Exception) { } if (flag) { Response.Redirect("RegistrationSuccessful.aspx"); } else { Response.Redirect("RegistrationUnsuccessful.aspx"); } } else { lblMessage.Text = "Email already exists. Please use another"; lblMessage.ForeColor = System.Drawing.Color.Red; } }
protected void btnCategoryUpdate_Click(object sender, EventArgs e) { administrator admin = new administrator(); dataAccess database = new dataAccess(); Format format = new Format(); bool flag = false; bool exists = false; DataTable jobCatTbl = admin.GetJobCategoryTable(); for (int i = 0; i < jobCatTbl.Rows.Count; i++) { if (jobCatTbl.Rows[i]["Category"].ToString().ToLower() == txtNewCategory.Text.ToString().ToLower()) { exists = true; } } if (exists == false) { flag = database.insertData("INSERT INTO jobsdb_JobCategory (Category) VALUES ('" + format.capitalizeStart(txtNewCategory.Text.ToString()) + "')"); } if (flag) { lblCategoryMessage.Text = txtNewCategory.Text.ToString() + " successfully inserted"; lblCategoryMessage.ForeColor = System.Drawing.Color.Green; ddlCategory.DataBind(); } else { if (exists) { lblCategoryMessage.Text = txtNewCategory.Text + " already exists"; lblCategoryMessage.ForeColor = System.Drawing.Color.Red; } else { lblCategoryMessage.Text = "Unable to insert request"; lblCategoryMessage.ForeColor = System.Drawing.Color.Red; } } txtNewCategory.Text = ""; }