public ActionResult NewEmployee(string button, Models.DepartmentModels ReadDepartmentModel, string NewEmployeeName, string NewCompanyEmployeeCode)
{
Models.DepartmentModels DepartmentModel = new Models.DepartmentModels();
List <Models.M_Department> DepartmentList = new List <Models.M_Department>();
DepartmentModel.checkCodeflag = true;
DepartmentModel.checkInputflag = true;
if (button == "Register")
{
if (ReadDepartmentModel.SelectDepartmentId != 0 && NewEmployeeName != "" && NewCompanyEmployeeCode != "")
{
DepartmentModel.checkCodeflag = checkCompanyEmployeeCode(NewCompanyEmployeeCode);
if (DepartmentModel.checkCodeflag == true)
{
int RegisterId = GetRegisterNumber() + 1;
RegisterEmployee(RegisterId, ReadDepartmentModel.SelectDepartmentId, NewEmployeeName, NewCompanyEmployeeCode);
return(RedirectToAction("Index", "Department"));
}
}
else
{
DepartmentModel.checkInputflag = false;
}
}
DepartmentList = GetDepartmentList(DepartmentModel);
return(View(DepartmentModel));
}
// GET: Registros
public ActionResult addDepartment()
{
Muebleria18.Models.DepartmentModels pModel = new Models.DepartmentModels();
pModel.mensaje = "Bienvenido a mi ABM";
pModel.lstDepartmentModel = Dominio.Fachada.Department_SearchAll();
return(View(pModel));
}
// GET: Department
public ActionResult Index(string button, Models.DepartmentModels ReadDepartmentModel, string SearchEmployeeName)
{
Models.DepartmentModels DepartmentModel = new Models.DepartmentModels();
List <Models.M_Department> DepartmentList = new List <Models.M_Department>();
DepartmentList = GetDepartmentList(DepartmentModel);
if (button == "Search")
{
DepartmentModel.SearchResult = SearchResult(ReadDepartmentModel.SelectDepartmentId, SearchEmployeeName);
}
return(View(DepartmentModel));
}
public List <Models.M_Department> GetDepartmentList(Models.DepartmentModels DepartmentModel)
{
Modules.DBModules DB = new Modules.DBModules();
Models.M_Department Department = new Models.M_Department();
List <Models.M_Department> DepartmentList = new List <Models.M_Department>();
SqlDataReader sqlRdr = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM M_Department");
try
{
if (!DB.DB_Connect())
{
}
if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
{
}
while (sqlRdr.Read())
{
Department = new Models.M_Department();
Department.DepartmentId = int.Parse(sqlRdr["DepartmentId"].ToString());
Department.DepartmentName = sqlRdr["DepartmentName"].ToString();
DepartmentList.Add(Department);
}
DepartmentModel.DepartmentList = DepartmentList;
}
catch (Exception ex)
{
}
finally
{
if (sqlRdr != null)
{
if (!sqlRdr.IsClosed)
{
sqlRdr.Close();
}
}
DB.DB_Close();
}
return(DepartmentList);
}
