/*public bool Update(EmployeeRep emp)
* {
* try
* {
* string query = "UPDATE Employees SET EmployeeName = '" + emp.EmployeeName + "', Salary = " + emp.Salary + ", Designation = '" + emp.Designation + "' WHERE EmployeeId= '" + emp.EmployeeId + "'";
* DatabaseConnectionClass dcc = new DatabaseConnectionClass();
* dcc.ConnectWithDB();
* int x = dcc.ExecuteSQL(query);
* dcc.CloseConnection();
* return true;
* }
* catch (Exception ex)
* {
* return false;
* }
* }
* public bool Delete(string employeeId)
* {
* try
* {
* string query = "DELETE from Employees WHERE EmployeeId = '" + employeeId + "'";
* DatabaseConnectionClass dcc = new DatabaseConnectionClass();
* dcc.ConnectWithDB();
* int x = dcc.ExecuteSQL(query);
* dcc.CloseConnection();
* return true;
* }
* catch (Exception ex)
* {
* return false;
* }
* }*/
/*public Employee GetEmployee(string employeeId)
* {
* string query = "SELECT * from Employees WHERE EmployeeId= '" + employeeId + "'";
* Employee emp = null;
* DatabaseConnectionClass dcc = new DatabaseConnectionClass();
* dcc.ConnectWithDB();
* SqlDataReader sdr = dcc.GetData(query);
* if (sdr.Read())
* {
* emp = new Employee();
* emp.EmployeeId = sdr["EmployeeId"].ToString();
* emp.Password = sdr["Password"].ToString();
* emp.EmployeeName = sdr["EmployeeName"].ToString();
* emp.Salary = Convert.ToDouble(sdr["Salary"]);
* emp.Designation = sdr["Designation"].ToString();
* }
* dcc.CloseConnection();
* return emp;
* }
*
* public List<Employee> GetAllEmployees()
* {
* string query = "SELECT * from Employees";
* List<Employee> empList = new List<Employee>();
* DatabaseConnectionClass dcc = new DatabaseConnectionClass();
* dcc.ConnectWithDB();
* SqlDataReader sdr = dcc.GetData(query);
* while (sdr.Read())
* {
* Employee emp = new Employee();
* emp.EmployeeId = sdr["EmployeeId"].ToString();
* emp.Password = sdr["Password"].ToString();
* emp.EmployeeName = sdr["EmployeeName"].ToString();
* emp.Salary = Convert.ToDouble(sdr["Salary"]);
* emp.Designation = sdr["Designation"].ToString();
* }
* dcc.CloseConnection();
* return empList;
* }*/
public bool UserLoginVerification(EmployeeRep emp)
{
string query = "SELECT * from Employee WHERE Id= '" + emp.Employeeid + "' AND Password= '******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
emp.Employeename = sdr["Name"].ToString();
emp.Gender = sdr["Gender"].ToString();
emp.Address = sdr["Address"].ToString();
emp.Email = sdr["Email"].ToString();
emp.Status = sdr["Status"].ToString();
emp.Contacts = sdr["Contact"].ToString();
dcc.CloseConnection();
return(true);
}
else
{
dcc.CloseConnection();
return(false);
}
}
public bool Insert(EmployeeRep emp)
{
try
{
string query = "INSERT into Employee VALUES ('" + emp.Employeeid + "', '" + emp.Employeename + "', '" + emp.Gender + "', '" + emp.Address + "', '" + emp.Email + "', '" + emp.Contacts + "', '" + emp.Status + "','" + emp.Password + "','" + emp.Salary + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}