public bool InsertEmployeeOfficial(EmployeeOfficialModel _EmployeeOfficialModel)
{
bool result = false;
if (_EmployeeOfficialModel != null)
{
result = EmployeeProfileDAL.InsertEmployeeOfficial(_EmployeeOfficialModel);
}
return(result);
}
public ActionResult EmployeeOfficialView(int id)
{
List <EmployeeOfficialModel> EmployeeOfficialModelList = new List <EmployeeOfficialModel>();
EmployeeOfficialModel _EmployeeOfficialModel = new EmployeeOfficialModel();
EmployeeBL _EmployeeBL = new EmployeeBL();
List <Department> departmentList = new List <Department>();
departmentList = _EmployeeBL.GetDepartment();
ViewBag.Department = departmentList;
List <EmployeeRole> EmployeeRoleList = new List <EmployeeRole>();
EmployeeRoleList = _EmployeeBL.GetEmployeeRole();
ViewBag.EmployeeRole = EmployeeRoleList;
List <EmployeeType> EmployeeTypeList = new List <EmployeeType>();
EmployeeTypeList = _EmployeeBL.GetEmployeeType();
ViewBag.EmployeeType = EmployeeTypeList;
List <OrganizationUnit> OrganizationUnitList = new List <OrganizationUnit>();
OrganizationUnitList = _EmployeeBL.GetOrganizationUnit();
ViewBag.OrganizationUnit = OrganizationUnitList;
List <PersonalProfileModel> managerList = new List <PersonalProfileModel>();
managerList = _EmployeeBL.GetManager();
ViewBag.managers = managerList;
List <PersonalProfileModel> hrmanagerList = new List <PersonalProfileModel>();
hrmanagerList = _EmployeeBL.GetHRManager();
ViewBag.hrmanagers = hrmanagerList;
List <PersonalProfileModel> hiringmanagerList = new List <PersonalProfileModel>();
hiringmanagerList = _EmployeeBL.GetHiringManager();
ViewBag.hiringManagers = hiringmanagerList;
List <PersonalProfileModel> supervisorList = new List <PersonalProfileModel>();
supervisorList = _EmployeeBL.GetSupervisor();
ViewBag.supervisors = supervisorList;
EmployeeOfficialModelList = _EmployeeBL.GetEmployeeOfficial(id);
if (EmployeeOfficialModelList != null)
{
_EmployeeOfficialModel = EmployeeOfficialModelList.FirstOrDefault();
}
return(View(_EmployeeOfficialModel));
}
public PartialViewResult NewEmployeeOfficial(int Employee_profile_id)
{
EmployeeOfficialModel _EmployeeOfficialModel = new EmployeeOfficialModel();
_EmployeeOfficialModel.Employee_proile_id = Employee_profile_id;
EmployeeBL _EmployeeBL = new EmployeeBL();
bool result = _EmployeeBL.InsertEmployeeOfficial(_EmployeeOfficialModel);
List <Department> departmentList = new List <Department>();
departmentList = _EmployeeBL.GetDepartment();
ViewBag.Department = departmentList;
List <EmployeeRole> EmployeeRoleList = new List <EmployeeRole>();
EmployeeRoleList = _EmployeeBL.GetEmployeeRole();
ViewBag.EmployeeRole = EmployeeRoleList;
List <EmployeeType> EmployeeTypeList = new List <EmployeeType>();
EmployeeTypeList = _EmployeeBL.GetEmployeeType();
ViewBag.EmployeeType = EmployeeTypeList;
List <OrganizationUnit> OrganizationUnitList = new List <OrganizationUnit>();
OrganizationUnitList = _EmployeeBL.GetOrganizationUnit();
ViewBag.OrganizationUnit = OrganizationUnitList;
List <PersonalProfileModel> managerList = new List <PersonalProfileModel>();
managerList = _EmployeeBL.GetManager();
ViewBag.managers = managerList;
List <PersonalProfileModel> hrmanagerList = new List <PersonalProfileModel>();
hrmanagerList = _EmployeeBL.GetHRManager();
ViewBag.hrmanagers = hrmanagerList;
List <PersonalProfileModel> hiringmanagerList = new List <PersonalProfileModel>();
hiringmanagerList = _EmployeeBL.GetHiringManager();
ViewBag.hiringManagers = hiringmanagerList;
List <PersonalProfileModel> supervisorList = new List <PersonalProfileModel>();
supervisorList = _EmployeeBL.GetSupervisor();
ViewBag.supervisors = supervisorList;
return(PartialView(_EmployeeOfficialModel));
}
public ActionResult EmployeeOfficialView(EmployeeOfficialModel _EmployeeOfficialModel)
{
EmployeeBL _EmployeeBL = new EmployeeBL();
bool result = _EmployeeBL.UpdateEmployeeOfficial(_EmployeeOfficialModel);
if (result == true)
{
return(RedirectToAction("EmployeeOfficialList"));
}
else
{
return(View(_EmployeeOfficialModel));
}
}
public static List <EmployeeOfficialModel> GetEmployeeOfficial(int id)
{
EmployeeOfficialModel _EmployeeOfficialProfile = null;
List <EmployeeOfficialModel> officialList = new List <EmployeeOfficialModel>();
Database db = DatabaseFactory.CreateDatabase("Helios_V2_DB");
DbCommand dbCommand = db.GetStoredProcCommand("sp_Employee_Official_Profile_get");
if (id > 0)
{
db.AddInParameter(dbCommand, "Employee_official_profile_id", DbType.Int32, id);
}
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader != null && dataReader.Read())
{
_EmployeeOfficialProfile = new EmployeeOfficialModel();
_EmployeeOfficialProfile.Employee_official_profile_id = DataParser.GetSafeInt(dataReader, "Employee_official_profile_id", 0);
_EmployeeOfficialProfile.Employee_id = DataParser.GetSafeString(dataReader, "Employee_id", String.Empty);
_EmployeeOfficialProfile.Employee_type_id = DataParser.GetSafeInt(dataReader, "Employee_type_id", 0);
_EmployeeOfficialProfile.Employee_Type_name = DataParser.GetSafeString(dataReader, "Employee_Type_name", String.Empty);
_EmployeeOfficialProfile.Employee_role_id = DataParser.GetSafeInt(dataReader, "Employee_role_id", 0);
_EmployeeOfficialProfile.Role_name = DataParser.GetSafeString(dataReader, "Role_name", String.Empty);
_EmployeeOfficialProfile.Department_Id = DataParser.GetSafeInt(dataReader, "Department_Id", 0);
_EmployeeOfficialProfile.Department_name = DataParser.GetSafeString(dataReader, "Department_name", String.Empty);
_EmployeeOfficialProfile.Organization_unit_id = DataParser.GetSafeInt(dataReader, "Organization_unit_id", 0);
_EmployeeOfficialProfile.Organization_unit_name = DataParser.GetSafeString(dataReader, "Organization_unit_name", String.Empty);
_EmployeeOfficialProfile.Job_code = DataParser.GetSafeString(dataReader, "Job_code", String.Empty);
_EmployeeOfficialProfile.Manager = DataParser.GetSafeInt(dataReader, "Manager", 0);
_EmployeeOfficialProfile.Manager_Name = DataParser.GetSafeString(dataReader, "Manager_Name", String.Empty);
_EmployeeOfficialProfile.Hiring_manager = DataParser.GetSafeInt(dataReader, "Hiring_manager", 0);
_EmployeeOfficialProfile.Hiring_Manager_Name = DataParser.GetSafeString(dataReader, "Hiring_Manager_Name", String.Empty);
_EmployeeOfficialProfile.Supervisor = DataParser.GetSafeInt(dataReader, "Supervisor", 0);
_EmployeeOfficialProfile.supervisor_Name = DataParser.GetSafeString(dataReader, "supervisor_Name", String.Empty);
_EmployeeOfficialProfile.Hr_manager = DataParser.GetSafeInt(dataReader, "Hr_manager", 0);
_EmployeeOfficialProfile.HR_Manager_Name = DataParser.GetSafeString(dataReader, "HR_Manager_Name", String.Empty);
_EmployeeOfficialProfile.Hiring_date = DataParser.GetSafeDateTime(dataReader, "Hiring_date", DateTime.Now);
_EmployeeOfficialProfile.Email_address = DataParser.GetSafeString(dataReader, "Email_address", String.Empty);
_EmployeeOfficialProfile.Employee_proile_id = DataParser.GetSafeInt(dataReader, "Employee_profile_id", 0);
_EmployeeOfficialProfile.Created_by = DataParser.GetSafeInt(dataReader, "Created_by", 0);
_EmployeeOfficialProfile.Created_Date = DataParser.GetSafeDateTime(dataReader, " Created_Date", DateTime.Now);
_EmployeeOfficialProfile.Last_updated_by = DataParser.GetSafeInt(dataReader, "Last_updated_by", 0);
_EmployeeOfficialProfile.Last_updated_date = DataParser.GetSafeDateTime(dataReader, "Last_updated_date", DateTime.Now);
officialList.Add(_EmployeeOfficialProfile);
}
}
return(officialList);
}
public static bool UpdateEmployeeOfficial(EmployeeOfficialModel _EmployeeOfficialModel)
{
bool result = true;
try
{
Database db = DatabaseFactory.CreateDatabase("Helios_V2_DB");
DbCommand dbCommand = db.GetStoredProcCommand("sp_Employee_Official_Profile_update");
db.AddInParameter(dbCommand, "@Employee_official_profile_id", DbType.Int32, _EmployeeOfficialModel.Employee_official_profile_id);
db.AddInParameter(dbCommand, "@Employee_id", DbType.String, _EmployeeOfficialModel.Employee_id);
db.AddInParameter(dbCommand, "@Employee_type_id", DbType.Int32, _EmployeeOfficialModel.Employee_type_id);
db.AddInParameter(dbCommand, "@Employee_role_id", DbType.Int32, _EmployeeOfficialModel.Employee_role_id);
db.AddInParameter(dbCommand, "@Department_Id", DbType.Int32, _EmployeeOfficialModel.Department_Id);
db.AddInParameter(dbCommand, "@Organization_unit_id", DbType.Int32, _EmployeeOfficialModel.Organization_unit_id);
db.AddInParameter(dbCommand, "@Job_code", DbType.String, _EmployeeOfficialModel.Job_code);
db.AddInParameter(dbCommand, "@Manager", DbType.Int32, _EmployeeOfficialModel.Manager);
db.AddInParameter(dbCommand, "@Hiring_manager", DbType.Int32, _EmployeeOfficialModel.Hiring_manager);
db.AddInParameter(dbCommand, "@Supervisor", DbType.Int32, _EmployeeOfficialModel.Supervisor);
db.AddInParameter(dbCommand, "@Hr_manager", DbType.Int32, _EmployeeOfficialModel.Hr_manager);
db.AddInParameter(dbCommand, "@Hiring_date", DbType.DateTime, _EmployeeOfficialModel.Hiring_date);
db.AddInParameter(dbCommand, "@Email_address", DbType.String, _EmployeeOfficialModel.Email_address);
db.AddInParameter(dbCommand, "@Employee_proile_id", DbType.Int32, _EmployeeOfficialModel.Employee_proile_id);
int ret = db.ExecuteNonQuery(dbCommand);
if (ret > 0)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
string var = ex.Message;
throw;
}
return(result);
}
public bool UpdateEmployeeOfficial(EmployeeOfficialModel _EmployeeOfficialModel)
{
bool result = EmployeeProfileDAL.UpdateEmployeeOfficial(_EmployeeOfficialModel);
return(result);
}
