public List<Employee> GetEmployeeList()
{
sqlDataAccess da = new sqlDataAccess();
SqlCommand command = da.BuildCommand("SELECT * FROM Employee");
return GetData(command);
}
public List<Employee> GetEmployeeByName(string name)
{
sqlDataAccess da = new sqlDataAccess();
SqlCommand command = da.BuildCommand("SELECT * FROM Employee where EmployeeName like '%" + name + "%'");
//SqlParameter p1 = new SqlParameter("@Name", System.Data.SqlDbType.VarChar, 50);
//p1.Value = name;
//command.Parameters.Add(p1);
return GetData(command);
}
public bool insert(Employee obj)
{
sqlDataAccess da = new sqlDataAccess();
SqlCommand cmd = da.GetCommand("INSERT INTO [dbo].[Employee] ([ID],[EmployeeID],[EmployeeName],[Gender],[Email],[PhoneNumber],[Age],[Address],[JoinDate],[Status],[LeaveDate],[Salary]) " +
"VALUES (@ID , @EmployeeID, @EmployeeName,@Gender, @Email, @PhoneNumber,@Age,@address,@JoinDate,@Status,@leaveDate,@Salary)");
SqlParameter p = new SqlParameter("@ID", System.Data.SqlDbType.Int);
p.Value = obj.ID;
SqlParameter p1 = new SqlParameter("@EmployeeID", System.Data.SqlDbType.Int);
p1.Value = obj.EmployeeID;
SqlParameter p2 = new SqlParameter("@EmployeeName", System.Data.SqlDbType.VarChar, 50);
p2.Value = obj.EmployeeName;
SqlParameter p3 = new SqlParameter("@Gender", System.Data.SqlDbType.VarChar, 50);
p3.Value = obj.Gender;
SqlParameter p4 = new SqlParameter("@Email", System.Data.SqlDbType.VarChar, 50);
p4.Value = obj.Email;
SqlParameter p5 = new SqlParameter("@PhoneNumber", System.Data.SqlDbType.Int);
p5.Value = obj.PhoneNumber;
SqlParameter p6 = new SqlParameter("@Age", System.Data.SqlDbType.Int);
p6.Value = obj.Age;
SqlParameter p7 = new SqlParameter("@Address", System.Data.SqlDbType.VarChar, 50);
p7.Value = obj.Address;
SqlParameter p8 = new SqlParameter("@JoinDate", System.Data.SqlDbType.DateTime);
p8.Value = obj.JoinDate;
SqlParameter p9 = new SqlParameter("@Status", System.Data.SqlDbType.VarChar, 50);
p9.Value = obj.Status;
SqlParameter p10 = new SqlParameter("@LeaveDate", System.Data.SqlDbType.DateTime);
if (!obj.LeaveDate.HasValue)
p10.Value = obj.LeaveDate;
else
p10.Value = DBNull.Value;
SqlParameter p11 = new SqlParameter("@Salary", System.Data.SqlDbType.Int);
p11.Value = obj.Salary;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool update(Employee obj)
{
sqlDataAccess da = new sqlDataAccess();
SqlCommand cmd = da.GetCommand("UPDATE [Employee] SET [EmployeeID]=@EmployeeID,[EmployeeName]=@EmployeeName,[Gender]=@Gender,[Email]=@Email,[PhoneNumber]=@PhoneNumber,[Age]=@Age,[Address]=@Address,[JoinDate]=@JoinDate,[Status]=@Status,[LeaveDate]=@LeaveDate,[Salary]=@Salary" +
" WHERE ID = @ID");
SqlParameter p = new SqlParameter("@ID", System.Data.SqlDbType.Int);
p.Value = obj.ID;
SqlParameter p1 = new SqlParameter("@EmployeeID", System.Data.SqlDbType.Int);
p1.Value = obj.EmployeeID;
SqlParameter p2 = new SqlParameter("@EmployeeName", System.Data.SqlDbType.VarChar, 50);
p2.Value = obj.EmployeeName;
SqlParameter p3 = new SqlParameter("@Gender", System.Data.SqlDbType.VarChar, 50);
p3.Value = obj.Gender;
SqlParameter p4 = new SqlParameter("@Email", System.Data.SqlDbType.VarChar, 50);
p4.Value = obj.Email;
SqlParameter p5 = new SqlParameter("@PhoneNumber", System.Data.SqlDbType.Int);
p5.Value = obj.PhoneNumber;
SqlParameter p6 = new SqlParameter("@Age", System.Data.SqlDbType.Int);
p6.Value = obj.Age;
SqlParameter p7 = new SqlParameter("@Address", System.Data.SqlDbType.VarChar, 50);
p7.Value = obj.Address;
SqlParameter p8 = new SqlParameter("@JoinDate", System.Data.SqlDbType.DateTime);
p8.Value = obj.JoinDate;
SqlParameter p9 = new SqlParameter("@Status", System.Data.SqlDbType.VarChar, 50);
p9.Value = obj.Status;
SqlParameter p10 = new SqlParameter("@LeaveDate", System.Data.SqlDbType.DateTime2);
p10.Value = obj.LeaveDate;
SqlParameter p11 = new SqlParameter("@Salary", System.Data.SqlDbType.Int);
p11.Value = obj.Salary;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}