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); }