/// <summary>
/// Gets the management users.
/// </summary>
/// <returns></returns>
public List <EmployeePositionData> GetManagementUsers(int clientId, int facility)
{
List <EmployeePositionData> lstEmployees = new List <EmployeePositionData>();
EmployeePositionData oEmployee = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@fa_key", facility));
param.Add(new SqlParameter("@userID", clientId));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetEmployeesToMigrate", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oEmployee = new EmployeePositionData();
oEmployee.EmployeeID = Convert.ToInt32(oReader["USER_ID"]);
oEmployee.Employee = Convert.ToString(oReader["UserName"]);
lstEmployees.Add(oEmployee);
}
oReader.Close();
oReader = null;
}
return(lstEmployees);
}
/// <summary>
/// Saves the EmployeePosition and its Access Rights.
/// </summary>
/// <returns></returns>
private int SaveEmployeePosition()
{
int result = 0;
wsEmployeePosition = new WsEmployeePosition();
EmployeePositionData oEmployeePositionData = ReadEmployeePositionData();
if (!string.IsNullOrEmpty(oEmployeePositionData.Position))
{
result = wsEmployeePosition.SaveEmployeePostion(oEmployeePositionData, Convert.ToInt32(hdnUserID.Value));
}
switch (result)
{
case -1:
lblMessage.Text = Messages.DisplayMessage(MSG03, true);
break;
case 0:
lblMessage.Text = Messages.DisplayMessage(MSG02, true);
break;
default:
lblMessage.Text = Messages.DisplayMessage(MSG01, false);
break;
}
wsEmployeePosition = null;
return(result);
}
/// <summary>
/// Get Position By Curriculum
/// </summary>
/// <returns></returns>
public List <EmployeePositionData> GetPositionByCurriculum(Int32 CurriculumId)
{
List <EmployeePositionData> lstEmployeePositionData = new List <EmployeePositionData>();
EmployeePositionData oEmployeePosition = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@CurriculumId", CurriculumId));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetPositionByCurriculum", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oEmployeePosition = new EmployeePositionData();
oEmployeePosition.PositionID = Convert.ToInt32(oReader["PositionID"]);
lstEmployeePositionData.Add(oEmployeePosition);
}
oReader.Close();
oReader = null;
}
return(lstEmployeePositionData);
}
/// <summary>
/// Gets the facility master user.
/// </summary>
/// <param name="clientId">The client identifier.</param>
/// <param name="facility">The facility.</param>
/// <returns></returns>
public List <EmployeePositionData> GetFacilityMasterUser(int clientId, int facility)
{
List <EmployeePositionData> lstEmployees = new List <EmployeePositionData>();
EmployeePositionData oEmployee = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@fa_key", facility));
param.Add(new SqlParameter("@userID", clientId));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetFacilityMasterUser", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oEmployee = new EmployeePositionData();
oEmployee.EmployeeID = Convert.ToInt32(oReader["em_key"]);
oEmployee.Employee = Convert.ToString(oReader["Employee"]);
oEmployee.Facility = Convert.ToInt32(oReader["fa_key"]);
oEmployee.EmployeeEmailId = Convert.ToString(oReader["cu_email"]);
lstEmployees.Add(oEmployee);
}
oReader.Close();
oReader = null;
}
return(lstEmployees);
}
/// <summary>
/// Gets the positions based on access.
/// </summary>
/// <param name="accessType">Type of the access.</param>
/// <returns></returns>
public List <EmployeePositionData> GetPositionsBasedOnAccess(int accessType)
{
List <EmployeePositionData> lstPositions = new List <EmployeePositionData>();
EmployeePositionData oPosition = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@accessType", accessType));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetPositionsBasedOnAccess", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oPosition = new EmployeePositionData();
oPosition.PositionID = Convert.ToInt32(oReader["PositionID"]);
oPosition.Position = Convert.ToString(oReader["Position"]);
lstPositions.Add(oPosition);
}
oReader.Close();
oReader = null;
}
return(lstPositions);
}
/// <summary>
/// Gets all supervisors.
/// </summary>
/// <param name="clientId">The client identifier.</param>
/// <param name="facility">The facility.</param>
/// <param name="employee">The employee.</param>
/// <returns></returns>
public List <EmployeePositionData> GetAllSupervisors(int clientId, int facility, int employee)
{
WsFacility wsfacility = new WsFacility();
string connectionstringweb = wsfacility.GetConnectionString(clientId);
List <EmployeePositionData> lstEmployees = new List <EmployeePositionData>();
EmployeePositionData oSupervisors = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@fa_key", facility));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionstringweb, CommandType.StoredProcedure, "GetSupervisors", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oSupervisors = new EmployeePositionData();
oSupervisors.EmployeeID = Convert.ToInt32(oReader["em_key"]);
oSupervisors.Employee = Convert.ToString(oReader["Supervisor"]);
oSupervisors.IsActive = Convert.ToBoolean(oReader["em_active"]);
lstEmployees.Add(oSupervisors);
}
oReader.Close();
oReader = null;
}
return(lstEmployees);
}
/// <summary>
/// Gets the positions to publish.
/// </summary>
/// <returns></returns>
public List <EmployeePositionData> GetPositionsToPublish()
{
List <EmployeePositionData> lstPositions = new List <EmployeePositionData>();
EmployeePositionData oEmployeePosition = null;
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetPropagatePosition");
if (oReader != null)
{
while (oReader.Read())
{
oEmployeePosition = new EmployeePositionData();
oEmployeePosition.PositionID = Convert.ToInt32(oReader["PositionID"]);
oEmployeePosition.Position = Convert.ToString(oReader["Position"]);
oEmployeePosition.ServiceID = Convert.ToInt32(oReader["ServiceID"]);
oEmployeePosition.ClassificationID = Convert.ToInt32(oReader["ClassificationID"]);
oEmployeePosition.IsDistributed = Convert.ToBoolean(oReader["IsDistribute"]);
oEmployeePosition.Service = GetService(oEmployeePosition.ServiceID);
oEmployeePosition.Classification = GetClassification(oEmployeePosition.ClassificationID);
lstPositions.Add(oEmployeePosition);
}
oReader.Close();
oReader = null;
}
return(lstPositions);
}
/// <summary>
/// Gets the employee positions.
/// </summary>
/// <returns></returns>
public List <EmployeePositionData> GetEmployeePositions()
{
List <EmployeePositionData> lstEmployeePositionData = new List <EmployeePositionData>();
EmployeePositionData oEmployeePosition = null;
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetPositions");
if (oReader != null)
{
while (oReader.Read())
{
oEmployeePosition = new EmployeePositionData();
oEmployeePosition.PositionID = Convert.ToInt32(oReader["PositionID"]);
oEmployeePosition.Position = Convert.ToString(oReader["Position"]);
oEmployeePosition.Description = Convert.ToString(oReader["Description"]);
oEmployeePosition.HouseKeeper = Convert.ToString(oReader["HouseKeeper"]);
oEmployeePosition.IsDistributed = Convert.ToBoolean(oReader["IsDistributed"]);
oEmployeePosition.ServiceID = Convert.ToInt32(oReader["Service"]);
oEmployeePosition.ClassificationID = Convert.ToInt32(oReader["Classification"]);
oEmployeePosition.Service = GetService(oEmployeePosition.ServiceID);
oEmployeePosition.Classification = GetClassification(oEmployeePosition.ClassificationID);
oEmployeePosition.ManagementTraining = Convert.ToBoolean(oReader["ManagementTraining"]);
oEmployeePosition.IsAnnualCertification = Convert.ToBoolean(oReader["IsAnnualCertification"]);
oEmployeePosition.IsAssociatedToUser = Convert.ToString(oReader["IsAssignedToUser"]);
lstEmployeePositionData.Add(oEmployeePosition);
}
oReader.Close();
oReader = null;
}
return(lstEmployeePositionData);
}
/// <summary>
/// Saves the employee position.
/// </summary>
/// <param name="employeePostionData">The employee postion data.</param>
/// <param name="userID">The user identifier.</param>
/// <returns></returns>
public int SaveEmployeePosition(EmployeePositionData employeePostionData, int userID)
{
int result = 0;
object oResult = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@ep_key", employeePostionData.PositionID));
param.Add(new SqlParameter("@ep_name", employeePostionData.Position));
param.Add(new SqlParameter("@ep_description", employeePostionData.Description));
param.Add(new SqlParameter("@ep_hk_key", employeePostionData.HouseKeepingID));
param.Add(new SqlParameter("@ep_service", employeePostionData.ServiceID));
param.Add(new SqlParameter("@ep_classification", employeePostionData.ClassificationID));
param.Add(new SqlParameter("@ep_mgt_training", employeePostionData.ManagementTraining));
param.Add(new SqlParameter("@ep_is_annual_cert", employeePostionData.IsAnnualCertification));
param.Add(new SqlParameter("@LastUserID", userID));
oResult = DBOPS.SqlHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, "SaveEmployeePosition", param.ToArray());
if (oResult != null && Convert.ToString(oResult) != string.Empty)
{
result = Convert.ToInt32(oResult);
}
return(result);
}
/// <summary>
/// Gets the employee position.
/// </summary>
/// <param name="positionID">The position identifier.</param>
/// <returns></returns>
public EmployeePositionData GetEmployeePosition(int positionID)
{
EmployeePositionData oEmployeePositionData = null;
param = new List <SqlParameter>();
param.Add(new SqlParameter("@PositionID", positionID));
SqlDataReader oReader = DBOPS.SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "GetEmployeePostionByID", param.ToArray());
if (oReader != null)
{
while (oReader.Read())
{
oEmployeePositionData = new EmployeePositionData();
oEmployeePositionData.PositionID = Convert.ToInt32(oReader["PositionID"]);
oEmployeePositionData.Position = Convert.ToString(oReader["Position"]);
oEmployeePositionData.Description = Convert.ToString(oReader["Description"]);
oEmployeePositionData.HouseKeepingID = Convert.ToInt32(oReader["HouseKeeperID"]);
oEmployeePositionData.HouseKeeper = Convert.ToString(oReader["HouseKeeper"]);
oEmployeePositionData.IsDistributed = Convert.ToBoolean(oReader["IsDistributed"]);
oEmployeePositionData.ServiceID = Convert.ToInt32(oReader["Service"]);
oEmployeePositionData.ClassificationID = Convert.ToInt32(oReader["Classification"]);
oEmployeePositionData.ManagementTraining = Convert.ToBoolean(oReader["ManagementTraining"]);
oEmployeePositionData.IsAnnualCertification = Convert.ToBoolean(oReader["IsAnnualCertification"]);
}
oReader.Close();
oReader = null;
}
return(oEmployeePositionData);
}
/// <summary>
/// Reads the page data and return the EmployeePosition Data object.
/// </summary>
/// <returns></returns>
private EmployeePositionData ReadEmployeePositionData()
{
EmployeePositionData oEmployeePositionData = new EmployeePositionData();
oEmployeePositionData.PositionID = Convert.ToInt32(hdnEmpPositionID.Value);
oEmployeePositionData.Position = txtPosition.Text.Trim();
oEmployeePositionData.Description = txtDescription.Text.Trim();
oEmployeePositionData.HouseKeepingID = Convert.ToInt32(ddlHouseKeeping.SelectedValue);
oEmployeePositionData.ServiceID = Convert.ToInt32(ddlService.SelectedValue);
oEmployeePositionData.ClassificationID = Convert.ToInt32(ddlClassification.SelectedValue);
oEmployeePositionData.ManagementTraining = chkMgtTraining.Checked;
oEmployeePositionData.IsAnnualCertification = chkAnnualCertification.Checked;
return(oEmployeePositionData);
}
/// <summary>
/// Loads the Employee Position and grid with records.
/// </summary>
private void LoadEmployeePosition()
{
wsEmployeePosition = new WsEmployeePosition();
EmployeePositionData oEmployeePositionData = wsEmployeePosition.GetEmployeePosition(Convert.ToInt32(hdnEmpPositionID.Value));
if (oEmployeePositionData != null)
{
hdnLastEmpPositionID.Value = hdnEmpPositionID.Value;
txtPosition.Text = oEmployeePositionData.Position;
txtDescription.Text = oEmployeePositionData.Description;
ddlHouseKeeping.SelectedValue = Convert.ToString(oEmployeePositionData.HouseKeepingID);
ddlService.SelectedValue = Convert.ToString(oEmployeePositionData.ServiceID);
ddlClassification.SelectedValue = Convert.ToString(oEmployeePositionData.ClassificationID);
chkMgtTraining.Checked = Convert.ToBoolean(oEmployeePositionData.ManagementTraining);
chkAnnualCertification.Checked = Convert.ToBoolean(oEmployeePositionData.IsAnnualCertification);
txtPosition.Enabled = oEmployeePositionData.IsDistributed ? false : true;
hdnIsPublished.Value = Convert.ToString(oEmployeePositionData.IsDistributed);
}
wsEmployeePosition = null;
}
public int SaveEmployeePostion(EmployeePositionData oEmpPosition, int userID)
{
return(oEmployeePosition.SaveEmployeePosition(oEmpPosition, userID));
}
