public int Register(LeadEmp em)
{
dbc = new DataAccess();
string sql = "INSERT INTO Employees(emp_name,emp_gender,emp_dob,emp_number,emp_email,emp_address,emp_user_type,emp_photo) " +
"VALUES('" + em.emp_name + "','" + em.emp_gender + "','" + em.emp_dob + "','" + em.emp_number + "','" + em.emp_email + "','" + em.emp_address + "','" + em.emp_usertype + "','" + em.emp_photo + "')";
int result = dbc.ExecuteQuery(sql);
dbc.Dispose();
if (result > 0)
{
dbc = new DataAccess();
sql = "SELECT * FROM Employees where emp_id=(select max(emp_id) from Employees)";
SqlDataReader reader = dbc.GetData(sql);
dbc.Dispose();
reader.Read();
ut = (int)reader["emp_user_type"];
id = (int)reader["emp_id"];
if (ut < 2)
{
dbc = new DataAccess();
sql = "INSERT INTO Credentials(emp_username,emp_password,emp_usertype,emp_email,emp_id) VALUES('" + em.emp_username + "','" + em.emp_password + "'," + em.emp_usertype
+ ",'" + em.emp_email + "'," + id + ")";
result = dbc.ExecuteQuery(sql);
dbc.Dispose();
if (result > 0)
{
return(3);
}
else
{
return(2);
}
}
else
{
return(1);
}
}
else
{
return(0);
}
}
public LeadEmp Getdata(string email)
{
dbc = new DataAccess();
string sql = " select Employees.emp_name,Credentials.emp_username from Employees,credentials where Credentials.emp_email='" + email + "' and Employees.emp_id=Credentials.emp_id";
SqlDataReader reader = dbc.GetData(sql);
if (reader.Read())
{
LeadEmp le = new LeadEmp();
le.Emp_name = reader["emp_name"].ToString();
le.Emp_username = reader["emp_username"].ToString();
dbc.Dispose();
return(le);
}
else
{
return(null);
}
}
private void enter_email_btn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox2.Text) == true)
{
textBox2.Focus();
errorProvider3.SetError(this.textBox2, "Enter an email");
}
else if (Regex.IsMatch(textBox2.Text, patt) == false)
{
errorProvider3.SetError(this.textBox2, "Email is Not valid");
}
else
{
if (fs.Getusername(textBox2.Text) != null)
{
LeadEmp le = fs.Getusername(textBox2.Text);
email = textBox2.Text;
username = le.Emp_username;
MessageBox.Show(username);
textBox2.Text = string.Empty;
User_name_lbl.Text = le.Emp_name;
user_name_txb.Text = le.Emp_username;
user_name_txb.Text.Trim();
groupBox1.Visible = true;
}
else
{
MessageBox.Show("user not found");
}
}
}
public LeadEmp Getusername(string email)
{
LeadEmp le = fr.Getdata(email);
return(le);
}
