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 = "";
}
