public ActionResult UpdateEmployee(EmployeeModel EmployeeData, int IdEmployee)
{
try
{
CRUDEmployee = new EmployeeRepository();
CRUDEmployee.UpdateEmployee(EmployeeData);
return RedirectToAction("SearchEmployee", "Employee");
}
catch
{
return View();
}
}
public int UpdateEmployee(EmployeeModel EmployeeData)
{
int Result = -1;
using (ConnectionSQL = new SqlConnection(ConnectionDB))
{
using (CmdSQL = new SqlCommand("UpdateEmployee", ConnectionSQL))
{
CmdSQL.CommandType = CommandType.StoredProcedure;
CmdSQL.Parameters.Add("@IdEmployee", SqlDbType.Int).Value = EmployeeData.IdEmployee;
CmdSQL.Parameters.Add("@Username", SqlDbType.NVarChar, 20).Value = EmployeeData.Username;
CmdSQL.Parameters.Add("@UserPassword", SqlDbType.NVarChar, 20).Value = EmployeeData.UserPassword;
CmdSQL.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 100).Value = EmployeeData.EmailAddress;
CmdSQL.Connection.Open();
Result = CmdSQL.ExecuteNonQuery();
}
}
return Result;
}
public ActionResult RegisterEmployee(EmployeeModel EmployeeData)
{
try
{
if (ModelState.IsValid)
{
CRUDEmployee = new EmployeeRepository();
if(CRUDEmployee.RegisterEmployee(EmployeeData) >= 1)
{
ViewBag.Message = "Empleado registrado";
ModelState.Clear();
}
}
return View();
}
catch
{
return View();
}
}
public List<EmployeeModel> SearchEmployee()
{
List<EmployeeModel> Employees = new List<EmployeeModel>();
using (ConnectionSQL = new SqlConnection(ConnectionDB))
{
using (CmdSQL = new SqlCommand("SearchEmployee", ConnectionSQL))
{
CmdSQL.CommandType = CommandType.StoredProcedure;
CmdSQL.Connection.Open();
AdapterSQL = new SqlDataAdapter(CmdSQL);
TablesSQL = new DataTable();
AdapterSQL.Fill(TablesSQL);
ReaderSQL = CmdSQL.ExecuteReader();
while (ReaderSQL.Read())
{
EmployeeModel EmployeeData = new EmployeeModel
{
IdEmployee = (int)ReaderSQL["Id Employee"],
Username = ReaderSQL["Username"].ToString(),
UserPassword = ReaderSQL["User Password"].ToString(),
EmployeeName = ReaderSQL["Employee Name"].ToString(),
EmployeeFamilyName = ReaderSQL["Employee Family Name"].ToString(),
DateOfBirth = (DateTime)ReaderSQL["Date Of Birth"],
Age = (int)ReaderSQL["Age"],
EmailAddress = ReaderSQL["Email Address"].ToString()
};
Employees.Add(EmployeeData);
}
}
}
return Employees;
}
