public bool IsUserAuthorized(string userID)
{
bool isAuthorized = false;
Employee obj = new EmployeeDao().GetById(userID);
if (obj != null)
{
JobTitleLevel objTitle = new JobTitleLevelDao().GetById(obj.TitleId);
if (objTitle != null)
{
if (objTitle.JobTitle.IsManager)
{
isAuthorized = true;
}
}
}
return isAuthorized;
}
/// <summary>
/// Write Update Log For Employee
/// </summary>
/// <param name="newInfo"></param>
/// <param name="logId"></param>
/// <returns></returns>
private bool WriteUpdateLogForEmployee(Employee newInfo, string logId)
{
bool isUpdated = false;
try
{
// Get old info
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.IDNumber != oldInfo.IDNumber)
{
commonDao.InsertLogDetail(logId, "IDNumber", "ID Number", oldInfo.IDNumber, newInfo.IDNumber);
isUpdated = true;
}
if (newInfo.LastName != oldInfo.LastName)
{
commonDao.InsertLogDetail(logId, "LastName", "Last Name", oldInfo.LastName, newInfo.LastName);
isUpdated = true;
}
if (newInfo.Major != oldInfo.Major)
{
commonDao.InsertLogDetail(logId, "LastName", "Last Name", oldInfo.Major, newInfo.Major);
isUpdated = true;
}
if (newInfo.MiddleName != oldInfo.MiddleName)
{
commonDao.InsertLogDetail(logId, "MiddleName", "Middle Name", oldInfo.MiddleName, newInfo.MiddleName);
isUpdated = true;
}
if (newInfo.OtherDegree != oldInfo.OtherDegree)
{
commonDao.InsertLogDetail(logId, "OtherDegree", "Other Degree", oldInfo.OtherDegree, newInfo.OtherDegree);
isUpdated = true;
}
if (newInfo.FirstName != oldInfo.FirstName)
{
commonDao.InsertLogDetail(logId, "FirstName", "First Name", oldInfo.FirstName, newInfo.FirstName);
isUpdated = true;
}
if (newInfo.VnFirstName != oldInfo.VnFirstName)
{
commonDao.InsertLogDetail(logId, "VnFirstName", "Vn First Name", oldInfo.VnFirstName, newInfo.VnFirstName);
isUpdated = true;
}
if (newInfo.VnMiddleName != oldInfo.VnMiddleName)
{
commonDao.InsertLogDetail(logId, "MiddleName", "Vn Middle Name", oldInfo.VnMiddleName, newInfo.VnMiddleName);
isUpdated = true;
}
if (newInfo.VnLastName != oldInfo.VnLastName)
{
commonDao.InsertLogDetail(logId, "VnLastName", "Vn Last Name", oldInfo.VnLastName, newInfo.VnLastName);
isUpdated = true;
}
if (newInfo.VnPOB != oldInfo.VnPOB)
{
commonDao.InsertLogDetail(logId, "VnPOB", "Vn Place Of Birth", oldInfo.VnPOB, newInfo.VnPOB);
isUpdated = true;
}
if (newInfo.VnPlaceOfOrigin != oldInfo.VnPlaceOfOrigin)
{
commonDao.InsertLogDetail(logId, "VnPlaceOfOrigin", "Vn Place Of Origin", oldInfo.VnPlaceOfOrigin, newInfo.VnPlaceOfOrigin);
isUpdated = true;
}
if (newInfo.Degree != oldInfo.Degree)
{
commonDao.InsertLogDetail(logId, "Degree", "Degree", oldInfo.Degree, newInfo.Degree);
isUpdated = true;
}
if (newInfo.Race != oldInfo.Race)
{
commonDao.InsertLogDetail(logId, "Race", "Race", oldInfo.Race, newInfo.Race);
isUpdated = true;
}
if (newInfo.IDIssueLocation != oldInfo.IDIssueLocation)
{
commonDao.InsertLogDetail(logId, "IDIssueLocation", "Issue Location", oldInfo.IDIssueLocation, newInfo.IDIssueLocation);
isUpdated = true;
}
if (newInfo.VnIDIssueLocation != oldInfo.VnIDIssueLocation)
{
commonDao.InsertLogDetail(logId, "VnIDIssueLocation", "Vn Issue Location", oldInfo.VnIDIssueLocation, newInfo.VnIDIssueLocation);
isUpdated = true;
}
if (newInfo.TaxID != oldInfo.TaxID)
{
commonDao.InsertLogDetail(logId, "TaxID", "TaxID", oldInfo.TaxID, newInfo.TaxID);
isUpdated = true;
}
if (newInfo.TaxIssueDate != oldInfo.TaxIssueDate)
{
commonDao.InsertLogDetail(logId, "TaxIssueDate", "Tax Issue Date", oldInfo.TaxIssueDate.HasValue ? oldInfo.TaxIssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW) : "", newInfo.TaxIssueDate.HasValue ? newInfo.TaxIssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW) : "");
isUpdated = true;
}
if (newInfo.SocialInsuranceNo != oldInfo.SocialInsuranceNo)
{
commonDao.InsertLogDetail(logId, "SocialInsuranceNo", "Social Insurance Book No", oldInfo.SocialInsuranceNo, newInfo.SocialInsuranceNo);
isUpdated = true;
}
if (newInfo.InsuranceHospitalID != oldInfo.InsuranceHospitalID)
{
commonDao.InsertLogDetail(logId, "InsuranceHospitalID", "Health Insurance Hospital", !string.IsNullOrEmpty(oldInfo.InsuranceHospitalID)?oldInfo.InsuranceHospital.Name:"",string.IsNullOrEmpty(newInfo.InsuranceHospitalID)?"":new InsuranceHospitalDao().GetById(newInfo.InsuranceHospitalID).Name);
isUpdated = true;
}
if (newInfo.VnPermanentAddress != oldInfo.VnPermanentAddress)
{
commonDao.InsertLogDetail(logId, "VnPermanentAddress", "Vn Permanent Address", oldInfo.VnPermanentAddress, newInfo.VnPermanentAddress);
isUpdated = true;
}
if (newInfo.VnPermanentArea != oldInfo.VnPermanentArea)
{
commonDao.InsertLogDetail(logId, "VnPermanentArea", "Vn Permanent Area", oldInfo.VnPermanentArea, newInfo.VnPermanentArea);
isUpdated = true;
}
if (newInfo.VnPermanentDistrict != oldInfo.VnPermanentDistrict)
{
commonDao.InsertLogDetail(logId, "VnPermanentDistrict", "Vn Permanent District", oldInfo.VnPermanentDistrict, newInfo.VnPermanentDistrict);
isUpdated = true;
}
if (newInfo.VnPermanentCityProvince != oldInfo.VnPermanentCityProvince)
{
commonDao.InsertLogDetail(logId, "VnPermanentCityProvince", "Vn Permanent City Province", oldInfo.VnPermanentCityProvince, newInfo.VnPermanentCityProvince);
isUpdated = true;
}
if (newInfo.VnPermanentCountry != oldInfo.VnPermanentCountry)
{
commonDao.InsertLogDetail(logId, "VnPermanentCountry", "Vn Permanent Country", oldInfo.VnPermanentCountry, newInfo.VnPermanentCountry);
isUpdated = true;
}
if (newInfo.VnTempAddress != oldInfo.VnTempAddress)
{
commonDao.InsertLogDetail(logId, "VnTempAddress", "Vn Temp Address", oldInfo.VnTempAddress, newInfo.VnTempAddress);
isUpdated = true;
}
if (newInfo.VnTempArea != oldInfo.VnTempArea)
{
commonDao.InsertLogDetail(logId, "VnTempArea", "Vn Temp Area", oldInfo.VnTempArea, newInfo.VnTempArea);
isUpdated = true;
}
if (newInfo.VnTempCityProvince != oldInfo.VnTempCityProvince)
{
commonDao.InsertLogDetail(logId, "VnTempCityProvince", "Vn Temp City Province", oldInfo.VnTempCityProvince, newInfo.VnTempCityProvince);
isUpdated = true;
}
if (newInfo.VnTempCountry != oldInfo.VnTempCountry)
{
commonDao.InsertLogDetail(logId, "VnTempCountry", "Vn Temp Country", oldInfo.VnTempCountry, newInfo.VnTempCountry);
isUpdated = true;
}
if (newInfo.Gender != oldInfo.Gender)
{
commonDao.InsertLogDetail(logId, "Gender", "Gender",oldInfo.Gender.HasValue?(oldInfo.Gender == Constants.MALE ? "Male" : "Famale"):"", newInfo.Gender.HasValue?(newInfo.Gender == Constants.MALE ? "Male" : "Famale"):"");
isUpdated = true;
}
if (newInfo.StartDate != oldInfo.StartDate)
{
commonDao.InsertLogDetail(logId, "StartDate", "Start Date", oldInfo.StartDate.ToString(Constants.DATETIME_FORMAT_VIEW), newInfo.StartDate.ToString(Constants.DATETIME_FORMAT_VIEW));
isUpdated = true;
}
if (newInfo.ContractedDate != oldInfo.ContractedDate)
{
commonDao.InsertLogDetail(logId, "ContractedDate", "Contracted Date",oldInfo.ContractedDate.HasValue?oldInfo.ContractedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.ContractedDate.HasValue?newInfo.ContractedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.Photograph != oldInfo.Photograph)
{
commonDao.InsertLogDetail(logId, "Photograph", "Photograph", oldInfo.Photograph, newInfo.Photograph);
isUpdated = true;
}
if (newInfo.JR != oldInfo.JR)
{
commonDao.InsertLogDetail(logId, "JobRequest", "Job Request", oldInfo.JR, newInfo.JR);
isUpdated = true;
}
if (newInfo.JRApproval != oldInfo.JRApproval)
{
commonDao.InsertLogDetail(logId, "JobRequestApproval", "Job Request Approval", oldInfo.JRApproval, newInfo.JRApproval);
isUpdated = true;
}
if (newInfo.TempAddress != oldInfo.TempAddress)
{
commonDao.InsertLogDetail(logId, "TempAddress", "Temp Address", oldInfo.TempAddress, newInfo.TempAddress);
isUpdated = true;
}
if (newInfo.TempArea != oldInfo.TempArea)
{
commonDao.InsertLogDetail(logId, "TempArea", "Temp Area", oldInfo.TempArea, newInfo.TempArea);
isUpdated = true;
}
if (newInfo.TempDistrict != oldInfo.TempDistrict)
{
commonDao.InsertLogDetail(logId, "TempDistrict", "Temp District", oldInfo.TempDistrict, newInfo.TempDistrict);
isUpdated = true;
}
if (newInfo.TempCityProvince != oldInfo.TempCityProvince)
{
commonDao.InsertLogDetail(logId, "TempCityProvince", "Temp City Province", oldInfo.TempCityProvince, newInfo.TempCityProvince);
isUpdated = true;
}
if (newInfo.TempCountry != oldInfo.TempCountry)
{
commonDao.InsertLogDetail(logId, "TempCountry", "Temp Country", oldInfo.TempCountry, newInfo.TempCountry);
isUpdated = true;
}
if (newInfo.PermanentAddress != oldInfo.PermanentAddress)
{
commonDao.InsertLogDetail(logId, "PermanentAddress", "Permanent Address", oldInfo.PermanentAddress, newInfo.PermanentAddress);
isUpdated = true;
}
if (newInfo.PermanentArea != oldInfo.PermanentArea)
{
commonDao.InsertLogDetail(logId, "PermanentArea", "Permanent Ward", oldInfo.PermanentArea, newInfo.PermanentArea);
isUpdated = true;
}
if (newInfo.PermanentDistrict != oldInfo.PermanentDistrict)
{
commonDao.InsertLogDetail(logId, "PermanentDistrict", "Permanent District", oldInfo.PermanentDistrict, newInfo.PermanentDistrict);
isUpdated = true;
}
if (newInfo.PermanentCityProvince != oldInfo.PermanentCityProvince)
{
commonDao.InsertLogDetail(logId, "PermanentCityProvince", "Permanent City Province", oldInfo.PermanentCityProvince, newInfo.PermanentCityProvince);
isUpdated = true;
}
if (newInfo.PermanentCountry != oldInfo.PermanentCountry)
{
commonDao.InsertLogDetail(logId, "PermanentCountry", "PermanentCountry ", oldInfo.PermanentCountry, newInfo.PermanentCountry);
isUpdated = true;
}
if (newInfo.HomePhone != oldInfo.HomePhone)
{
commonDao.InsertLogDetail(logId, "HomePhone", "Home Phone", oldInfo.HomePhone, newInfo.HomePhone);
isUpdated = true;
}
if ( newInfo.CellPhone != oldInfo.CellPhone)
{
commonDao.InsertLogDetail(logId, "CellPhone", "Cell Phone", oldInfo.CellPhone, newInfo.CellPhone);
isUpdated = true;
}
if (newInfo.PersonalEmail != oldInfo.PersonalEmail)
{
commonDao.InsertLogDetail(logId, "PersonalEmail", "Personal Email", oldInfo.PersonalEmail, newInfo.PersonalEmail);
isUpdated = true;
}
if (newInfo.OfficeEmail != oldInfo.OfficeEmail)
{
commonDao.InsertLogDetail(logId, "OfficeEmail", "Office Email", oldInfo.OfficeEmail, newInfo.OfficeEmail);
isUpdated = true;
}
if (newInfo.ExtensionNumber != oldInfo.ExtensionNumber)
{
commonDao.InsertLogDetail(logId, "ExtensionNumber", "Extension Number", oldInfo.ExtensionNumber, newInfo.ExtensionNumber);
isUpdated = true;
}
if (newInfo.DOB != oldInfo.DOB)
{
commonDao.InsertLogDetail(logId, "DOB", "Date Of Birth",oldInfo.DOB.HasValue?oldInfo.DOB.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.DOB.HasValue?newInfo.DOB.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.POB != oldInfo.POB)
{
commonDao.InsertLogDetail(logId, "POB", "Place Of Birth", oldInfo.POB, newInfo.POB);
isUpdated = true;
}
if (newInfo.Nationality != oldInfo.Nationality)
{
commonDao.InsertLogDetail(logId, "Nationality", "Nationality", oldInfo.Nationality, newInfo.Nationality);
isUpdated = true;
}
if (newInfo.PlaceOfOrigin != oldInfo.PlaceOfOrigin)
{
commonDao.InsertLogDetail(logId, "PlaceOfOrigin", "Place Of Origin", oldInfo.PlaceOfOrigin, newInfo.PlaceOfOrigin);
isUpdated = true;
}
if (newInfo.IssueDate != oldInfo.IssueDate)
{
commonDao.InsertLogDetail(logId, "IssueDate", "Issue Date",oldInfo.IssueDate.HasValue?oldInfo.IssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.IssueDate.HasValue? newInfo.IssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.BankAccount != oldInfo.BankAccount)
{
commonDao.InsertLogDetail(logId, "BankAccount", "Bank Account", oldInfo.BankAccount, newInfo.BankAccount);
isUpdated = true;
}
if (newInfo.BankName != oldInfo.BankName)
{
commonDao.InsertLogDetail(logId, "BankName", "Bank Name", oldInfo.BankName, newInfo.BankName);
isUpdated = true;
}
if (newInfo.ResignedDate != oldInfo.ResignedDate)
{
commonDao.InsertLogDetail(logId, "ResignedDate", "Resigned Date", oldInfo.ResignedDate.HasValue?oldInfo.ResignedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.ResignedDate.HasValue?newInfo.ResignedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.ResignedReason != oldInfo.ResignedReason)
{
commonDao.InsertLogDetail(logId, "ResignedReason", "Resigned Reason", oldInfo.ResignedReason, newInfo.ResignedReason);
isUpdated = true;
}
if (newInfo.ResignedAllowance != oldInfo.ResignedAllowance)
{
commonDao.InsertLogDetail(logId, "ResignedAllowance", "Resigned Allowance", oldInfo.ResignedAllowance.HasValue?oldInfo.ResignedAllowance.ToString():"", newInfo.ResignedAllowance.HasValue?newInfo.ResignedAllowance.ToString():"");
isUpdated = true;
}
if (newInfo.LaborUnion != oldInfo.LaborUnion)
{
commonDao.InsertLogDetail(logId, "LaborUnion", "Labor Union",oldInfo.LaborUnion.HasValue?(oldInfo.LaborUnion.Value == Constants.LABOR_UNION_FALSE ? "No" : "Yes"):"",newInfo.LaborUnion.HasValue?(newInfo.LaborUnion.Value == Constants.LABOR_UNION_FALSE ? "No" : "Yes"):"");
isUpdated = true;
}
if (newInfo.LaborUnionDate != oldInfo.LaborUnionDate)
{
commonDao.InsertLogDetail(logId, "LaborUnionDate", "Labor Union Date", oldInfo.LaborUnionDate.HasValue ? oldInfo.LaborUnionDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW) : "",newInfo.LaborUnionDate.HasValue?newInfo.LaborUnionDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.Remarks != oldInfo.Remarks)
{
commonDao.InsertLogDetail(logId, "Remarks", "Remarks", oldInfo.Remarks, newInfo.Remarks);
isUpdated = true;
}
if (newInfo.MarriedStatus != oldInfo.MarriedStatus)
{
commonDao.InsertLogDetail(logId, "Married Status", "Married Status",oldInfo.MarriedStatus.HasValue?(oldInfo.MarriedStatus == Constants.SINGLE ? "Single" : "Married"):"",newInfo.MarriedStatus.HasValue?(newInfo.MarriedStatus == Constants.SINGLE ? "Single" : "Married"):"");
isUpdated = true;
}
if (newInfo.Religion != oldInfo.Religion)
{
commonDao.InsertLogDetail(logId, "Religion", "Religion", oldInfo.Religion, newInfo.Religion);
isUpdated = true;
}
if (newInfo.EmergencyContactName != oldInfo.EmergencyContactName)
{
commonDao.InsertLogDetail(logId, "EmergencyContactName", "Emergency Contact Name", oldInfo.EmergencyContactName, newInfo.EmergencyContactName);
isUpdated = true;
}
if (newInfo.EmergencyContactPhone != oldInfo.EmergencyContactPhone)
{
commonDao.InsertLogDetail(logId, "EmergencyContactPhone", "Emergency Contact Phone", oldInfo.EmergencyContactPhone, newInfo.EmergencyContactPhone);
isUpdated = true;
}
if (newInfo.EmergencyContactRelationship != oldInfo.EmergencyContactRelationship)
{
commonDao.InsertLogDetail(logId, "EmergencyContactRelationship", "Emergency Contact Relationship", oldInfo.EmergencyContactRelationship, newInfo.EmergencyContactRelationship);
isUpdated = true;
}
if (newInfo.TitleId != oldInfo.TitleId)
{
JobTitleLevelDao titleDao = new JobTitleLevelDao();
JobTitleLevel objTitle = titleDao.GetById(newInfo.TitleId);
if (objTitle != null)
{
commonDao.InsertLogDetail(logId, "TitleId", "Job Title", oldInfo.JobTitleLevel.DisplayName, objTitle.DisplayName);
isUpdated = true;
}
}
if (newInfo.DepartmentId != oldInfo.DepartmentId)
{
DepartmentDao departDao = new DepartmentDao();
Department objDepart = departDao.GetById(newInfo.DepartmentId);
if (objDepart != null)
{
commonDao.InsertLogDetail(logId, "DepartmentId", "Sub Department", oldInfo.Department.DepartmentName, objDepart.DepartmentName);
commonDao.InsertLogDetail(logId, "Department", "Department", new DepartmentDao().GetDepartmentNameBySub(oldInfo.DepartmentId), new DepartmentDao().GetDepartmentNameBySub(newInfo.DepartmentId));
isUpdated = true;
}
}
if (newInfo.SkypeId != oldInfo.SkypeId)
{
commonDao.InsertLogDetail(logId, "SkypeId", "SkypeId", oldInfo.SkypeId, newInfo.SkypeId);
isUpdated = true;
}
if (newInfo.YahooId != oldInfo.YahooId)
{
commonDao.InsertLogDetail(logId, "YahooId", "YahooId", oldInfo.YahooId, newInfo.YahooId);
isUpdated = true;
}
if (newInfo.LocationCode != oldInfo.LocationCode)
{
commonDao.InsertLogDetail(logId, "LocationCode", "LocationCode", CommonFunc.GenerateStringOfLocation(oldInfo.LocationCode), CommonFunc.GenerateStringOfLocation(newInfo.LocationCode));
isUpdated = true;
}
if (newInfo.CVFile != oldInfo.CVFile)
{
commonDao.InsertLogDetail(logId, "CVFile", "CVFile", oldInfo.CVFile, newInfo.CVFile);
isUpdated = true;
}
if (newInfo.EmpStatusId != oldInfo.EmpStatusId)
{
commonDao.InsertLogDetail(logId, "EmpStatusId", "Employee Status",oldInfo.EmpStatusId.HasValue?oldInfo.EmployeeStatus.StatusName:"",newInfo.EmpStatusId.HasValue?new EmployeeStatusDao().GetById(newInfo.EmpStatusId.Value).StatusName:"");
isUpdated = true;
}
if (newInfo.Project != oldInfo.Project)
{
commonDao.InsertLogDetail(logId, "Project", "Project", oldInfo.Project, newInfo.Project);
isUpdated = true;
}
if (newInfo.ManagerId != oldInfo.ManagerId)
{
commonDao.InsertLogDetail(logId, "Manager", "Manager", oldInfo.ManagerId, newInfo.ManagerId);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
}
}
catch (Exception ex)
{
throw ex;
}
return isUpdated;
}
public void ProcessRequest(HttpContext context)
{
string name = context.Request.QueryString["q"];
string pageName = context.Request.QueryString["Page"];
#region pageName
switch (pageName)
{
case "JRAdmin":
//JRAdminDao jrDao = new JRAdminDao();
//List<sp_GetJRForAdminResult> listJRAdmin = jrDao.GetListByName(name, 0, 0);
//var finalListJRAdmin = listJRAdmin.Select(p => p.UserName).Distinct();
//foreach (string item in finalListJRAdmin)
//{
// context.Response.Write(item + Environment.NewLine);
//}
UserAdminDao userAdminDao = new UserAdminDao();
List<UserAdmin> listUserAdmin = userAdminDao.GetList().Where(p => p.UserName.ToLower().Contains(name)).ToList<UserAdmin>();
foreach (UserAdmin item in listUserAdmin)
{
Employee objEmployee = new EmployeeDao().GetByOfficeEmailInActiveList(item.UserName + Constants.PREFIX_EMAIL_LOGIGEAR);
string displayName = item.UserName;
if (objEmployee != null)
{
displayName += " - " + objEmployee.ID;
}
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "Group":
GroupDao groupDao = new GroupDao();
List<Group> listGroup = groupDao.GetListByName(name);
foreach (Group item in listGroup)
{
context.Response.Write(item.GroupName + Environment.NewLine);
}
break;
case "Employee":
EmployeeDao empDao = new EmployeeDao();
int isActive = int.Parse(context.Request.QueryString["IsActive"]);
List<sp_GetEmployeeResult> empList = new List<sp_GetEmployeeResult>();
if (isActive == Constants.EMPLOYEE_ACTIVE)
{
empList = empDao.GetListByName(name, isActive, Constants.RESIGNED);
}
else if (isActive == Constants.EMPLOYEE_NOT_ACTIVE)
{
empList = empDao.GetListByName(name, isActive, Constants.RESIGNED);
}
//var finalListEmployee = empList.Select(p => p.DisplayName).Distinct();
foreach (sp_GetEmployeeResult item in empList)
{
context.Response.Write(item.DisplayName + " - " + item.ID + Environment.NewLine);
}
break;
case "AssignEmployee":
ExamDao examDao = new ExamDao();
EmployeeDao employeeDao = new EmployeeDao();
int examID = int.Parse(context.Request.QueryString[CommonDataKey.EXAM_ID]);
List<sp_GetEmployeeResult> employeeList = new List<sp_GetEmployeeResult>();
employeeList = employeeDao.GetListByName(name, Constants.EMPLOYEE_ACTIVE, Constants.RESIGNED);
List<string> assignedEmployeeListID = examDao.AssignedEmployeeListID(examID);
employeeList = employeeList.Where(c => !assignedEmployeeListID.Contains(c.ID)).ToList<sp_GetEmployeeResult>();
var finalListEmp = employeeList.Select(p => p.DisplayName).Distinct();
foreach (string item in finalListEmp)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "UserAdmin":
//UserAdminDao userAdminDao = new UserAdminDao();
//List<UserAdmin> listUserAdmin = userAdminDao.GetList().Where(p => p.UserName.ToLower().Contains(name)).ToList<UserAdmin>();
//foreach (UserAdmin item in listUserAdmin)
//{
// context.Response.Write(item.UserName + Environment.NewLine);
//}
List<String> listUser = new List<string>();
System.DirectoryServices.SearchResultCollection entriesUser = CommonFunc.GetDomainUserList(name);
foreach (System.DirectoryServices.SearchResult searchResult in entriesUser)
{
System.DirectoryServices.DirectoryEntry entry = searchResult.GetDirectoryEntry();
if (entry.Properties["mail"] != null)
{
if (entry.Properties["mail"].Count > 0)
{
string displayName = entry.Properties[CommonFunc.GetDomainUserProperty(DomainUserProperty.LoginName)][0].ToString();
//string emailAddress = entry.Properties[CommonFunc.GetDomainUserProperty(DomainUserProperty.OutlookEmail)][0].ToString();
Employee objEmployee = new EmployeeDao().GetByOfficeEmailInActiveList(displayName + Constants.PREFIX_EMAIL_LOGIGEAR);
string item = displayName;
if (objEmployee != null)
{
item += " - " + objEmployee.ID;
}
// +" <" + emailAddress + ">";
context.Response.Write(item + Environment.NewLine);
}
}
}
break;
case "UserLogs":
//List<sp_LogMasterResult> logList = new LogDao().GetList("", "");
//var finalList = logList.Select(p => p.UserName).Distinct();
List<CRM.Models.Entities.MasterLogEntity> logList = new LogDao().GetQueryList("", "").ToList();
var finalList = logList.Select(p => p.UserName).Distinct();
foreach (string item in finalList)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "STT":
STTDao sttDao = new STTDao();
List<sp_GetSTTResult> listSTT = sttDao.GetListByName(name);
foreach (sp_GetSTTResult item in listSTT)
{
context.Response.Write(item.DisplayName + " - " + item.ID + Environment.NewLine);
}
break;
case "Candidate":
CandidateDao candidateDao = new CandidateDao();
List<sp_GetCandidateResult> result = candidateDao.GetList(name, 0, 0, 0, "", "", 0);
List<String> lstDisplayName = result.Select(p => p.DisplayName).ToList();
foreach (string item in lstDisplayName)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "AssignCandidate":
ExamDao exDao = new ExamDao();
CandidateDao canDao = new CandidateDao();
int exID = int.Parse(context.Request.QueryString[CommonDataKey.EXAM_ID]);
List<sp_GetCandidateResult> canList = canDao.GetList(name, 0, 0, 0, "", "", 0);
List<int> assignedCandidateListID = exDao.AssignedCandidateListID(exID);
canList = canList.Where(c => !assignedCandidateListID.Contains(c.ID)).ToList<sp_GetCandidateResult>();
List<String> canListDisplayName = canList.Select(p => p.DisplayName).ToList();
foreach (string item in canListDisplayName)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "JR":
string action = context.Request.QueryString["Action"];
if (string.IsNullOrEmpty(action) || action == "undefined")
{
List<sp_GetJobRequestCompleteResult> listJr = new List<sp_GetJobRequestCompleteResult>();
listJr = new JobRequestDao().GetJRListComplete(name, 0, 0, 0, null, 0);
foreach (sp_GetJobRequestCompleteResult item in listJr)
{
context.Response.Write(Constants.JOB_REQUEST_ITEM_PREFIX + item.ID + Environment.NewLine);
}
}
else
{
List<sp_GetJobRequestCompleteInterviewResult> listJr = new List<sp_GetJobRequestCompleteInterviewResult>();
name = name.Replace("j", "");
name = name.Replace("r", "");
name = name.Replace("-", "");
listJr = new JobRequestDao().GetJRListInterView(name, 0, 0, 0, 0);
foreach (sp_GetJobRequestCompleteInterviewResult item in listJr)
{
context.Response.Write(Constants.JOB_REQUEST_ITEM_PREFIX + item.ID + Environment.NewLine);
}
}
break;
case "JRIndex":
string containsJR = Constants.JOB_REQUEST_PREFIX;
JobRequestItemDao jrItemDao = new JobRequestItemDao ();
if (containsJR.ToLower().Contains(name.ToLower()) ||
Constants.JOB_REQUEST_ITEM_PREFIX.ToLower().Contains(name.ToLower()))
{
name = string.Empty;
}
string assignRole = context.Request.QueryString["Role"];
List<sp_GetJobRequestResult> listJrIndex =
new JobRequestDao().GetList(name, 0, 0, 0, 0, 0, assignRole, 0);
foreach (sp_GetJobRequestResult item in listJrIndex)
{
context.Response.Write(Constants.JOB_REQUEST_PREFIX + item.ID + Environment.NewLine);
List<JobRequestItem> jrItems = jrItemDao.GetListByJrId(item.ID);
foreach (JobRequestItem subItem in jrItems)
{
if (subItem.ID.ToString().ToLower().Contains(name.ToLower()))
{
context.Response.Write(Constants.JOB_REQUEST_ITEM_PREFIX + subItem.ID + Environment.NewLine);
}
}
}
break;
case "SendMail":
List<String> list = new List<string>();
System.DirectoryServices.SearchResultCollection entries = CommonFunc.GetDomainUserList(name);
foreach (System.DirectoryServices.SearchResult searchResult in entries)
{
System.DirectoryServices.DirectoryEntry entry = searchResult.GetDirectoryEntry();
if (entry.Properties["mail"] != null)
{
if (entry.Properties["mail"].Count > 0)
{
string displayName = entry.Properties[CommonFunc.GetDomainUserProperty(DomainUserProperty.LoginName)][0].ToString();
//string emailAddress = entry.Properties[CommonFunc.GetDomainUserProperty(DomainUserProperty.OutlookEmail)][0].ToString();
string item = displayName;// +" <" + emailAddress + ">";
context.Response.Write(item + Environment.NewLine);
}
}
}
break;
case "PRIndex":
string containsPR = Constants.PR_REQUEST_PREFIX;
if (containsPR.ToLower().Contains(name))
{
name = string.Empty;
}
string roles = context.Request.QueryString["Role"];
string isViewAll = context.Request.QueryString["IsViewAll"];
int requestorId = 0;
string loginName = context.Request.QueryString["loginName"];
if (isViewAll.Equals("False") && roles == Constants.PR_REQUESTOR_ID.ToString())
{
requestorId = int.Parse(context.Request.QueryString["UserLoginId"]);
}
//List<sp_GetPurchaseRequestResult> listPrIndex = new PurchaseRequestDao().GetList(name, 0, 0, requestorId, 0, 0, roles, requestorId, loginName);
//List<sp_GetPurchaseRequestResult> listPrIndex = new PurchaseRequestDao().GetList(name, 0, 0, 0, 0, null, requestorId, int.Parse(roles), 0, false);
//chau.ly update 14.02.2012
List<sp_GetPurchaseRequestResult> listPrIndex = new PurchaseRequestDao().GetList(name, 0, 0, 0, 0, null, null, requestorId, int.Parse(roles), 0, false);
foreach (sp_GetPurchaseRequestResult item in listPrIndex)
{
context.Response.Write(Constants.PR_REQUEST_PREFIX + item.ID + Environment.NewLine);
}
break;
case "Question":
QuestionDao qDao = new QuestionDao();
List<LOT_Question> listQuestion = qDao.GetListAutoComplete(name);
foreach (LOT_Question item in listQuestion)
{
context.Response.Write(CommonFunc.TruncateAroundSubText(item.QuestionContent, name) + Environment.NewLine);
}
break;
case "Manager":
List<sp_GetManagerResult> listManager = new EmployeeDao().GetManager(name, 0, 0);
foreach (sp_GetManagerResult item in listManager)
{
context.Response.Write(item.DisplayName + Environment.NewLine);
}
break;
case "University":
List<University> listUniversity = new CandidateDao().GetUniversityList("");
listUniversity = listUniversity.Where(p => p.Name.ToLower().Contains(name.ToLower())).ToList<University>();
foreach (University item in listUniversity)
{
context.Response.Write(item.Name + Environment.NewLine);
}
break;
case "PTOAdmin":
List<sp_GetEmployeeManagerResult> listEmployeeManagerForAdmin = new EmployeeDao().GetEmployeeManager(name);
foreach (sp_GetEmployeeManagerResult item in listEmployeeManagerForAdmin)
{
string displayName = item.OfficeEmail.Replace(Constants.PREFIX_EMAIL_LOGIGEAR, "") + " - " + item.ID;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "PTO_User":
var listEmployeeManager = new EmployeeDao().GetManager(name, 0, 0);
empDao = new EmployeeDao();
foreach (var item in listEmployeeManager)
{
context.Response.Write(empDao.FullName(item.ID, Constants.FullNameFormat.FirstMiddleLast) + " - " + item.ID + Environment.NewLine);
}
break;
case "PTOCC":
EmployeeDao emplDao = new EmployeeDao();
List<sp_GetEmployeeResult> listEmpl = emplDao.GetListByName(name, Constants.EMPLOYEE_ACTIVE,
Constants.RESIGNED);
string content = "";
foreach (sp_GetEmployeeResult item in listEmpl)
{
if (item.OfficeEmail != null)
{
string[] aTmp = item.OfficeEmail.Split('@');
content += aTmp[0] + Environment.NewLine;
}
}
context.Response.Write(content);
break;
case "EmployeeWithID":
var empListWithId = new EmployeeDao().GetListByOfficeEmail(name).
Select(p => new { p.ID, p.OfficeEmail });
foreach (var item in empListWithId)
{
string displayName = item.OfficeEmail.Remove(item.OfficeEmail.IndexOf("@")) + " - " + item.ID;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "ManagerWithID":
var mgrList = new EmployeeDao().GetEmployeeManager(name);
foreach (sp_GetEmployeeManagerResult item in mgrList)
{
string displayName = item.OfficeEmail.Remove(item.OfficeEmail.IndexOf("@")) + " - " + item.ID;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "JobTitleLevel":
var jobTitleLevelList = new JobTitleLevelDao().GetList().Where(c => c.DisplayName.ToLower().Contains(name.Trim().ToLower()));
foreach (JobTitleLevel item in jobTitleLevelList)
{
string displayName = item.DisplayName;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "EditPosition":
var mgrList_EP = new EmployeeDao().GetListManagerWithAllAttr(name);
empDao = new EmployeeDao();
foreach (Employee item in mgrList_EP)
{
string displayName = empDao.FullName(item.ID,
Constants.FullNameFormat.FirstMiddleLast) + " - " + item.ID;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "Position":
empDao = new EmployeeDao();
string deptId = context.Request.QueryString["deptId"];
string subDeptId = context.Request.QueryString["subDeptId"];
string titleId = context.Request.QueryString["titleId"];
string project = context.Request.QueryString["project"];
string locationCode = null;
var positionList = empDao.GetListEmployeeAndSTT(name, ConvertUtil.ConvertToInt(deptId), ConvertUtil.ConvertToInt(subDeptId),
ConvertUtil.ConvertToInt(titleId),project, locationCode);
/*foreach (Employee item in positionList)
{
string displayName = CommonFunc.GetEmployeeFullName(item,
Constants.FullNameFormat.FirstMiddleLast);
context.Response.Write(displayName + Environment.NewLine);
}*/
foreach (sp_GetPositionResult item in positionList)
{
string displayName = item.FullName;
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "ManagerListPR":
string sStatus = context.Request.QueryString["status"];
string sNeed = context.Request.QueryString["need"];
var userName = HttpContext.Current.User.Identity.Name;
empDao = new EmployeeDao();
var prlist_Manager = empDao.GetPRList(CommonFunc.GetEmployeeByUserName(userName).ID,
name, sStatus, sNeed.Equals(Constants.PER_REVIEW_NEED_PR_LIST));
foreach (sp_GetEmployeesForPRResult item in prlist_Manager)
{
string displayName = empDao.FullName(item.ID,
Constants.FullNameFormat.FirstMiddleLast);
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "HRPR":
string status = context.Request.QueryString["status"];
string need = context.Request.QueryString["need"];
if (string.IsNullOrEmpty(status))
status = "0";
PerformanceReviewDao perDao = new PerformanceReviewDao();
var prlist = perDao.GetList(name, int.Parse(status), need.Equals(Constants.PER_REVIEW_NEED_PR_LIST), Constants.PRW_ROLE_HR_ID.ToString());
foreach (sp_GetEmployeesPRForHRResult item in prlist)
{
context.Response.Write(item.EmployeeName + Environment.NewLine);
}
break;
case "PTOManager":
DateTime? from = null;
DateTime? to = null;
string month = context.Request.QueryString["month"];
string managerID = context.Request.QueryString["managerId"];
if (!string.IsNullOrEmpty(month))
{
try
{
// filter month is date end of month and this date dependent on configuration
// ex: month:Feb-2011 => from: 25-Feb-2011, to: 26-Feb-2011
to = DateTime.Parse(Constants.DATE_LOCK_PTO + month);
from = to.Value.AddMonths(-1).AddDays(1);
}
catch
{
// get mon by curent date
month = DateTime.Now.ToString(Constants.PTO_MANAGER_DATE_FORMAT);
to = DateTime.Parse(Constants.DATE_LOCK_PTO + month);
from = to.Value.AddMonths(-1).AddDays(1);
}
}
List<sp_GetPTOEmployeeListForManagerResult> listPTOUser = new PTODao().GetPTOEmpListForManager(name, 0, 0, 0, from, to, managerID,null);
List<string> finalListPTOUser = listPTOUser.Select(p => p.Submitter + " - " + p.EmployeeID).Distinct().ToList<string>();
foreach (string item in finalListPTOUser)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "WorkFlow":
int wfID = int.Parse(context.Request.QueryString["workflowID"]);
List<sp_GetJRForAdminResult> listUserAdminRole = new JRAdminDao().GetListByName(name, wfID, 0);
List<string> listStringName = listUserAdminRole.Select(q => q.UserName).Distinct().ToList();
foreach (string item in listStringName)
{
Employee objEmployee = new EmployeeDao().GetByOfficeEmailInActiveList(item + Constants.PREFIX_EMAIL_LOGIGEAR);
string displayName = item;
if (objEmployee != null)
{
displayName += " - " + objEmployee.ID;
}
context.Response.Write(displayName + Environment.NewLine);
}
break;
case "LocationEmployee":
EmployeeDao empDao1 = new EmployeeDao();
List<sp_GetListEmployeeSttNotSeatResult> empList1 = new List<sp_GetListEmployeeSttNotSeatResult>();
empList1 = empDao1.GetListEmployeeNotSeat(name);
foreach (sp_GetListEmployeeSttNotSeatResult item in empList1)
{
context.Response.Write(item.FullName + " - " + item.ID + Environment.NewLine);
}
break;
case "LocationChart":
EmployeeDao empDao2 = new EmployeeDao();
List<sp_GetEmployeeSTTListResult> empSttList = new List<sp_GetEmployeeSTTListResult>();
empSttList = empDao2.GetEmpSttList(name);
if (context.Request.QueryString.AllKeys.Contains("hasLocation"))
empSttList = empSttList.Where(p=>!string.IsNullOrEmpty(p.LocationCode)).ToList();
foreach (sp_GetEmployeeSTTListResult item in empSttList)
{
context.Response.Write(item.FullName + " - " + item.ID + Environment.NewLine);
}
break;
case "MoveLocation":
LocationDao locatinoDao = new LocationDao();
var listSeatCode = locatinoDao.GetListSeatCode(name, 0, 0, 0, false);
foreach (var item in listSeatCode)
{
context.Response.Write(item.SeatCodeName + " (" + item.FloorName + ") - "
+ item.SeatCodeID + Environment.NewLine);
}
break;
case "ServiceRequest":
var listServiceRequestIT = new UserAdminDao().GetListITHelpDesk((int)Modules.ServiceRequestAdmin, (int)Permissions.ItHelpDesk);
foreach (var item in listServiceRequestIT)
{
context.Response.Write(item.Name + " -" + item.ID+ Environment.NewLine);
}
break;
case "ServiceRequestSetting":
List<sp_GetSR_SettingResult> listSRSetting = new SRSettingDao().GetList(name,"",0,0);
List<string> listUserSetting = listSRSetting.Select(q => q.UserName).Distinct().ToList();
foreach (var item in listUserSetting)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "ClassPlaning":
int typeCourse = ConvertUtil.ConvertToInt(context.Request["TypeCourse"]);
int trainingStatus = ConvertUtil.ConvertToInt(context.Request["TrainingStatus"]);
List<sp_GetClassPlanningResult> listClassID = new TrainingCenterDao().GetList(name, 0, 0, trainingStatus, null, typeCourse);
List<string> listClassName = listClassID.Select(q => q.ClassID).Distinct().ToList();
foreach (var item in listClassName)
{
context.Response.Write(item + Environment.NewLine);
}
break;
case "AAsset":
//List<A_Asset> aAssetList = new AAssetDao().GetParentAsset();
//foreach (var item in aAssetList)
//{
// context.Response.Write(item.AssetId + Environment.NewLine);
//}
break;
}
#endregion
string funcName = context.Request.QueryString["func"];
#region funcName
switch (funcName)
{
case "Employee":
EmployeeDao empDao = new EmployeeDao();
//type = 1 -> user name, type = 2 -> full name (first middle last)
int type = ConvertUtil.ConvertToInt(context.Request.QueryString["type"]);
//hasSuffixId = true -> include the Employee ID in the display result
bool hasSuffixId = !string.IsNullOrEmpty(context.Request.QueryString["suffixId"]);
//idFirst = true -> display the id first then display name
bool idFirst = !string.IsNullOrEmpty(context.Request.QueryString["idFirst"]);
if (type == 1)
{
var empList = empDao.GetListByOfficeEmail(name).Where(p=>!p.DeleteFlag);
foreach (var item in empList)
{
string suffix = "";
string mainValue = "";
if (hasSuffixId && !idFirst)
{
suffix = " - " + item.ID;
mainValue = item.OfficeEmail.Remove(item.OfficeEmail.IndexOf("@"));
}
else if (hasSuffixId && idFirst)
{
suffix = " - " + item.OfficeEmail.Remove(item.OfficeEmail.IndexOf("@"));
mainValue = item.ID;
}
string displayName = mainValue + suffix;
context.Response.Write(displayName + Environment.NewLine);
}
}
else if (type == 2)
{
var empList = empDao.GetList(name, 0, 0, 0, 1, 0).Where(p=>p.EmpStatusId != Constants.RESIGNED);
foreach (var item in empList)
{
string suffix = "";
string mainValue = "";
if (hasSuffixId && !idFirst)
{
suffix = " - " + item.ID;
mainValue = empDao.FullName(item.ID, Constants.FullNameFormat.FirstMiddleLast);
}
else if (hasSuffixId && idFirst)
{
suffix = " - " + empDao.FullName(item.ID, Constants.FullNameFormat.FirstMiddleLast);
mainValue = item.ID;
}
string displayName = mainValue + suffix;
context.Response.Write(displayName + Environment.NewLine);
}
}
break;
}
#endregion
}
public Message Update(PerformanceReview pr, string eformMasterId)
{
Message msg = null;
EmployeeDao empDao = new EmployeeDao();
EformDao eformDao = new EformDao();
DbTransaction trans = null;
try
{
if (dbContext.Connection.State == System.Data.ConnectionState.Closed)
{
dbContext.Connection.Open();
}
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
EForm oldEform = null;
PerformanceReview prDB = GetById(pr.ID);
//Update eform
EForm eform = new EForm();
if (!pr.EForm.MasterID.Equals(eformMasterId))
{
//Delete old eform
oldEform = pr.EForm;
//Insert new eform
eform.MasterID = eformMasterId;
eform.PersonID = pr.EmployeeID;
eform.PersonType = (int)Constants.PersonType.Employee;
eform.FormIndex = 1;
eform.CreateDate = DateTime.Now;
eform.CreatedBy = pr.CreatedBy;
dbContext.EForms.InsertOnSubmit(eform);
dbContext.SubmitChanges();
pr.EForm = eform;
}
//Update performance Review
prDB.AssignID = pr.AssignID;
prDB.EForm = pr.EForm;
prDB.AssignRole = pr.AssignRole;
prDB.CCEmail = pr.CCEmail;
prDB.InvolveDate = pr.InvolveDate;
prDB.InvolveID = pr.InvolveID;
prDB.InvolveResolution = pr.InvolveResolution;
prDB.InvolveRole = pr.InvolveRole;
prDB.NextReviewDate = pr.NextReviewDate;
prDB.PRDate = pr.PRDate;
prDB.UpdateDate = DateTime.Now;
prDB.UpdatedBy = pr.UpdatedBy;
prDB.WFResolutionID = pr.WFResolutionID;
if(oldEform!=null)
dbContext.EForms.DeleteOnSubmit(oldEform);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info,
"Performance Review \"" + pr.ID + "\"", "updated");
trans.Commit();
}
catch
{
trans.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Insert performance review
/// </summary>
/// <param name="pr">PerformanceReview</param>
/// <param name="eformMasterId">string</param>
/// <returns>Message</returns>
public Message Insert(PerformanceReview pr, string eformMasterId)
{
Message msg = null;
EmployeeDao empDao = new EmployeeDao();
EformDao eformDao = new EformDao();
DbTransaction trans = null;
try
{
if (dbContext.Connection.State == System.Data.ConnectionState.Closed)
{
dbContext.Connection.Open();
}
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
EForm eform = new EForm();
eform.MasterID = eformMasterId;
eform.PersonID = pr.EmployeeID;
eform.PersonType = (int)Constants.PersonType.Employee;
eform.FormIndex = 1;
eform.CreateDate = DateTime.Now;
eform.CreatedBy = pr.CreatedBy;
dbContext.EForms.InsertOnSubmit(eform);
dbContext.SubmitChanges();
pr.ID = GetNewPrId(pr.EmployeeID);
pr.EFormID = eform.ID;
dbContext.PerformanceReviews.InsertOnSubmit(pr);
msg = new Message(MessageConstants.I0001, MessageType.Info, "PR", "setup");
dbContext.SubmitChanges();
trans.Commit();
}
catch
{
trans.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public void WriteLogForUpdatePersonal(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.VnIDIssueLocation != oldInfo.VnIDIssueLocation)
{
commonDao.InsertLogDetail(logId, "VnIDIssueLocation", "Vn Issue Location", oldInfo.VnIDIssueLocation, newInfo.VnIDIssueLocation);
isUpdated = true;
}
if (newInfo.Race != oldInfo.Race)
{
commonDao.InsertLogDetail(logId, "Race", "Race", oldInfo.Race, newInfo.Race);
isUpdated = true;
}
if (newInfo.Major != oldInfo.Major)
{
commonDao.InsertLogDetail(logId, "Major", "Major", oldInfo.Major, newInfo.Major);
isUpdated = true;
}
if (newInfo.IDIssueLocation != oldInfo.IDIssueLocation)
{
commonDao.InsertLogDetail(logId, "IDIssueLocation", "Issue Location", oldInfo.IDIssueLocation, newInfo.IDIssueLocation);
isUpdated = true;
}
if (newInfo.Degree != oldInfo.Degree)
{
commonDao.InsertLogDetail(logId, "Degree", "Degree", oldInfo.Degree, newInfo.Degree);
isUpdated = true;
}
if (newInfo.OtherDegree != oldInfo.OtherDegree)
{
commonDao.InsertLogDetail(logId, "OtherDegree", "Other Degree", oldInfo.OtherDegree, newInfo.OtherDegree);
isUpdated = true;
}
if (newInfo.VnPlaceOfOrigin != oldInfo.VnPlaceOfOrigin)
{
commonDao.InsertLogDetail(logId, "VnPlaceOfOrigin", "Vn Place Of Origin", oldInfo.VnPlaceOfOrigin, newInfo.VnPlaceOfOrigin);
isUpdated = true;
}
if (newInfo.VnPOB != oldInfo.VnPOB)
{
commonDao.InsertLogDetail(logId, "VnPOB", "Vn Place Of Birth", oldInfo.VnPOB, newInfo.VnPOB);
isUpdated = true;
}
if (newInfo.VnLastName != oldInfo.VnLastName)
{
commonDao.InsertLogDetail(logId, "VnLastName", "Vn Last Name", oldInfo.VnLastName, newInfo.VnLastName);
isUpdated = true;
}
if (newInfo.VnMiddleName != oldInfo.VnMiddleName)
{
commonDao.InsertLogDetail(logId, "VnMiddleName", "Vn Middle Name", oldInfo.VnMiddleName, newInfo.VnMiddleName);
isUpdated = true;
}
if (newInfo.VnFirstName != oldInfo.VnFirstName)
{
commonDao.InsertLogDetail(logId, "VnFirstName", "Vn First Name", oldInfo.VnFirstName, newInfo.VnFirstName);
isUpdated = true;
}
if (newInfo.LastName != oldInfo.LastName)
{
commonDao.InsertLogDetail(logId, "LastName", "Last Name", oldInfo.LastName, newInfo.LastName);
isUpdated = true;
}
if (newInfo.MiddleName != oldInfo.MiddleName)
{
commonDao.InsertLogDetail(logId, "MiddleName", "Middle Name", oldInfo.MiddleName, newInfo.MiddleName);
isUpdated = true;
}
if (newInfo.FirstName != oldInfo.FirstName)
{
commonDao.InsertLogDetail(logId, "FirstName", "First Name", oldInfo.FirstName, newInfo.FirstName);
isUpdated = true;
}
if (newInfo.Gender != oldInfo.Gender)
{
commonDao.InsertLogDetail(logId, "Gender", "Gender",oldInfo.Gender.HasValue?(oldInfo.Gender.Value == Constants.MALE ? "Male" : "Famale"):"", newInfo.Gender.HasValue?(newInfo.Gender.Value == Constants.MALE ? "Male" : "Famale"):"");
isUpdated = true;
}
if (newInfo.DOB != oldInfo.DOB)
{
commonDao.InsertLogDetail(logId, "DOB", "Date Of Birth",oldInfo.DOB.HasValue?oldInfo.DOB.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.DOB.HasValue?newInfo.DOB.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.POB != oldInfo.POB)
{
commonDao.InsertLogDetail(logId, "POB", "Place Of Birth", oldInfo.POB, newInfo.POB);
isUpdated = true;
}
if (newInfo.Nationality != oldInfo.Nationality)
{
commonDao.InsertLogDetail(logId, "Nationality", "Nationality", oldInfo.Nationality, newInfo.Nationality);
isUpdated = true;
}
if (newInfo.PlaceOfOrigin != oldInfo.PlaceOfOrigin)
{
commonDao.InsertLogDetail(logId, "PlaceOfOrigin", "Place Of Origin", oldInfo.PlaceOfOrigin, newInfo.PlaceOfOrigin);
isUpdated = true;
}
if (newInfo.IDNumber != oldInfo.IDNumber)
{
commonDao.InsertLogDetail(logId, "IDNumber", "ID Number", oldInfo.IDNumber, newInfo.IDNumber);
isUpdated = true;
}
if (newInfo.IssueDate != oldInfo.IssueDate)
{
commonDao.InsertLogDetail(logId, "IssueDate", "Issue Date",oldInfo.IssueDate.HasValue?oldInfo.IssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"", newInfo.IssueDate.HasValue?newInfo.IssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.MarriedStatus != oldInfo.MarriedStatus)
{
commonDao.InsertLogDetail(logId, "Married Status", "Married Status", oldInfo.MarriedStatus.HasValue?(oldInfo.MarriedStatus.Value == Constants.SINGLE ? "Single" : "Married"):"", newInfo.MarriedStatus.HasValue?(newInfo.MarriedStatus.Value == Constants.SINGLE ? "Single" : "Married"):"");
isUpdated = true;
}
if (newInfo.Religion != oldInfo.Religion)
{
commonDao.InsertLogDetail(logId, "Religion", "Religion", oldInfo.Religion, newInfo.Religion);
isUpdated = true;
}
if (newInfo.EmpStatusId != oldInfo.EmpStatusId)
{
commonDao.InsertLogDetail(logId, "EmpStatusId", "Employee Status", oldInfo.EmpStatusId.HasValue ? oldInfo.EmployeeStatus.StatusName : "", newInfo.EmpStatusId.HasValue ? new EmployeeStatusDao().GetById(newInfo.EmpStatusId.Value).StatusName : "");
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void WriteLogForUpdateRemarks(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.Remarks != oldInfo.Remarks)
{
commonDao.InsertLogDetail(logId, "Remarks", "Remarks", oldInfo.Remarks, newInfo.Remarks);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetAssignUserInSRSetting(string userName)
{
Employee objEmployee = new EmployeeDao().GetByOfficeEmailInActiveList(userName + Constants.PREFIX_EMAIL_LOGIGEAR);
if (objEmployee != null)
{
string project = null;
int officeID = 0;
if (!string.IsNullOrEmpty(objEmployee.Project))
{
project = objEmployee.Project.Trim();
}
if (!string.IsNullOrEmpty(objEmployee.LocationCode))
{
officeID = ConvertUtil.ConvertToInt(CommonFunc.GetLocation(objEmployee.LocationCode, LocationType.Office));
}
SR_Setting objSetting = new SRSettingDao().GetByProjectAndOffice(project, officeID);
if (objSetting == null)
{
//if project not been set routing then change to Office
objSetting = new SRSettingDao().GetByProjectAndOffice(null, officeID);
}
if (objSetting != null)
{
return objSetting.UserAdmin.UserName;
}
}
return string.Empty;
}
/// <summary>
/// Get Employee ID by User Name
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static Employee GetEmployeeByUserName(string userName)
{
string result = string.Empty;
string officeEmail = userName + Constants.PREFIX_EMAIL_LOGIGEAR;
Employee emp = new EmployeeDao().GetByOfficeEmailInActiveList(officeEmail);
return emp;
}
public static void SendEmailToEmployee(PTODao ptoDao, PTO pto, List<PTO_Detail> listPTO_Detail, bool? isManager, string ccMail="")
{
try
{
EmployeeDao empDao = new EmployeeDao();
string template="";
if (pto.DeleteFlag)
template = GetTemplateForDeletion;
else if(isManager.HasValue)
template = isManager.Value ? GetTemplateForManager : GetTemplateForEmployee;
string sTemplate = string.Empty;
string sFooter = GetEmailFooter();
sTemplate = template + sFooter;
//PTO pto = ptoDao.GetPTOById(id);
Employee emp = empDao.GetById(pto.Submitter);
Employee manager = empDao.GetById(pto.SubmitTo);
string actor = CommonFunc.GetEmployeeFullName(manager);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_REASON, HttpUtility.HtmlEncode(pto.Reason));
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_STATUS_NAME, pto.PTO_Status.Name);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_TYPE_NAME, pto.PTO_Type.Name);
string sPTO_ID = "";
string sAction = "";
string sEmailSubject = "";
string sEmpName = CommonFunc.GetEmployeeFullName(emp, Constants.FullNameFormat.FirstMiddleLast);
string toEmail = pto.Employee.OfficeEmail;
if (pto.DeleteFlag)
{
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_DELETE, pto.ID);
}
else if (pto.Status_ID == Constants.PTO_STATUS_NEW)
{
sPTO_ID = "Your PTO (" + pto.ID + ")";
sAction = "submitted to";
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_NEW, pto.ID);
}
else if (pto.Status_ID == Constants.PTO_STATUS_APPROVED)
{
sPTO_ID = "The " + pto.ID;
sAction = "approved by";
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_APPROVE_REJECT, pto.ID, "approved");
}
else if (pto.Status_ID == Constants.PTO_STATUS_REJECTED)
{
sPTO_ID = "The " + pto.ID;
sAction = "rejected by";
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_APPROVE_REJECT, pto.ID, "rejected");
}
else if (pto.Status_ID == Constants.PTO_STATUS_CONFIRM)
{
sPTO_ID = "The " + pto.ID;
sAction = "approved by";
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_APPROVE_REJECT, pto.ID, "approved");
}
else if (pto.Status_ID == Constants.PTO_STATUS_VERIFIED)
{
sPTO_ID = "The " + pto.ID;
sAction = "verified by";
actor = CommonFunc.GetEmployeeFullName(CommonFunc.GetEmployeeByUserName(HttpContext.Current.User.Identity.Name),
Constants.FullNameFormat.FirstMiddleLast);
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_VERIFIED, pto.ID);
}
if (!isManager.HasValue)
{
toEmail = HttpContext.Current.User.Identity.Name + Constants.LOGIGEAR_EMAIL_DOMAIN;
}
else if (isManager.Value)
{
if(!pto.DeleteFlag)
sEmailSubject = String.Format(Constants.PTO_EMAIL_SUBJECT_TO_MANAGER, sEmpName);
toEmail = pto.Employee1.OfficeEmail;
}
var empUser = CommonFunc.GetEmployeeByUserName(HttpContext.Current.User.Identity.Name);
string recipent = "";
if (!isManager.HasValue)
recipent = empDao.FullName(empUser.ID, Constants.FullNameFormat.FirstMiddleLast);
else if (isManager.Value)
recipent = empDao.FullName(manager.ID, Constants.FullNameFormat.FirstMiddleLast);
else
recipent = sEmpName;
string commentTemplate = "<br/><b>{0}</b>: <i>{1}</i>";
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_MANAGER_NAME, actor);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_EMPLOYEE_NAME, sEmpName);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_EMPLOYEE_SUBMIT_DATE, pto.CreateDate.ToString(Constants.DATETIME_FORMAT_VIEW));
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_ID, sPTO_ID);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_REAL_ID, pto.ID);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_ACTION, sAction);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_USER, empDao.FullName(empUser.ID, Constants.FullNameFormat.FirstMiddleLast));
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_PTO_ID, pto.ID);
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_RECIPENT, recipent);
sTemplate = sTemplate.Replace(Constants.PTO_PM_COMMENT_FIELD, string.IsNullOrEmpty(pto.ManagerComment) ? "" :
string.Format(commentTemplate, "Manager comment (" +
CommonFunc.GetEmployeeFullName(pto.Employee1, Constants.FullNameFormat.FirstMiddleLast) +
")", HttpUtility.HtmlEncode(pto.ManagerComment)));
sTemplate = sTemplate.Replace(Constants.PTO_HR_COMMENT_FIELD, string.IsNullOrEmpty(pto.HRComment) ? "" :
string.Format(commentTemplate, "HR comment", HttpUtility.HtmlEncode(pto.HRComment)));
string sDetail = "";
//List<PTO_Detail> listPTO_Detail = ptoDao.GetPTO_DetailByPTO_ID(pto.ID).OrderBy(p => p.DateOff).ToList();
foreach (PTO_Detail detail in listPTO_Detail)
{
if (pto.PTO_Type.IsHourType)
{
sDetail += detail.DateOff.Value.ToString(Constants.DATETIME_FORMAT_VIEW) +
": " + (detail.HourFrom < 10 ? "0" + detail.HourFrom : detail.HourFrom.ToString()) + ":00 » " +
(detail.HourTo < 10 ? "0" + detail.HourTo : detail.HourTo.ToString()) + ":00<br/>";
}
else
{
sDetail += "From " + detail.DateOffFrom.Value.ToString(Constants.DATETIME_FORMAT_VIEW);
sDetail += " to " + detail.DateOffTo.Value.ToString(Constants.DATETIME_FORMAT_VIEW);
sDetail += "<br/>";
}
}
sTemplate = sTemplate.Replace(Constants.PTO_EMAIL_FIELD_PTO_DETAIL, sDetail);
string host = ConfigurationManager.AppSettings["mailserver_host"];
string port = ConfigurationManager.AppSettings["mailserver_port"];
string from = Constants.CRM_MAIL_FROM_ADDRESS;
string fromName = Constants.PTO_SENDER_NAME;
WebUtils.SendMail(host, port, from, fromName, toEmail, ccMail, sEmailSubject, sTemplate);
}
catch
{
}
}
/// <summary>
/// Send SR_Request to only Requestor
/// </summary>
/// <param name="srId"></param>
/// <param name="type"></param>
public static void SendSRMailFromPortal(int srId, int type)
{
// Get body detail
SR_ServiceRequest obj = new ServiceRequestDao().GetById(srId);
//WFRole role = null;
if (obj == null)
{
return;
}
string from_email = ConfigurationManager.AppSettings["from_email"];
string host = ConfigurationManager.AppSettings["mailserver_host"];
string port = ConfigurationManager.AppSettings["mailserver_port"];
string poster = "Service Request";
string subject = string.Empty;
switch (type)
{
case Constants.SR_SEND_MAIL_COMMENT:
subject = "[CRM-SR] " + Constants.SR_SERVICE_REQUEST_PREFIX + obj.ID + " has been modified";
break;
default:
if (obj.StatusID == Constants.SR_STATUS_CLOSED)
{
subject = "[CRM-SR] " + Constants.SR_SERVICE_REQUEST_PREFIX + obj.ID + " has been closed";
}
else
{
subject = "[CRM-SR] " + Constants.SR_SERVICE_REQUEST_PREFIX + obj.ID + " has been forwarded to " + obj.AssignUser;
}
break;
}
string body = CreateBodyOfEmail(obj);
// string requestorBody = CreateRequestorBodyOfEmail(obj);
string to_email = string.Empty;
string cc_email = string.Empty;
string[] arrIds = new string[] { };
arrIds = obj.InvolveUser.Split(Constants.SEPARATE_INVOLVE_CHAR);
List<string> sendList = new List<string>();
List<string> duplicateEmail = new List<string>();
for (int i = 0; i < arrIds.Length - 1; i++)
{
//check duplicate person on user name
if (!sendList.Contains(arrIds[i]))
{
sendList.Add(arrIds[i]);
if (obj.StatusID == Constants.SR_STATUS_CLOSED) //If an email has "Close" status, just only send by "To" section, not cc
{
if (!duplicateEmail.Contains(arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";"))
{
// only send survey email to SubmitUser
if (i == 0)
{
string surveyBody = CreateSurveyBodyEmail(obj);
string survey_email = arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
WebUtils.SendMail(host, port, from_email, poster, survey_email, cc_email, subject, surveyBody);
}
else
to_email += arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
duplicateEmail.Add(arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
}
}
else
{
//Just send by "To" section only to person who has been assigned, the involved others are by "CC" section.
if (string.IsNullOrEmpty(to_email))
{
to_email = obj.AssignUser + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
cc_email = arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
duplicateEmail.Add(arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
duplicateEmail.Add(obj.AssignUser + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
cc_email = obj.RequestUser + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
duplicateEmail.Add(obj.RequestUser + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
}
else //make a cc list mail send.
{
if (!duplicateEmail.Contains(arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";"))
{
duplicateEmail.Add(arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
cc_email += arrIds[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
}
}
}
}
}
if (!string.IsNullOrEmpty(obj.CCList))
{
string[] array = obj.CCList.Split(';');
foreach (string item in array)
{
if (!string.IsNullOrEmpty(item))
{
string userAdminID = item;
if (!duplicateEmail.Contains(item + Constants.LOGIGEAR_EMAIL_DOMAIN + ";"))
{
duplicateEmail.Add(item + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
cc_email += item + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
}
}
}
}
#region Get default email from routing page
ServiceRequestDao srDao = new ServiceRequestDao();
EmployeeDao emplDao = new EmployeeDao();
SRSettingDao srSettingDao = new SRSettingDao();
SR_Setting srSetting = new SR_Setting();
string bcc_email = String.Empty;
string[] aTo = new string[] { };
string[] aCc = new string[] { };
string[] aBcc = new string[] { };
string locationCode = (emplDao.GetByOfficeEmail((obj.RequestUser + Constants.LOGIGEAR_EMAIL_DOMAIN).Trim()) as Employee).LocationCode;
if (!String.IsNullOrEmpty(locationCode))
{
int officeId = ConvertUtil.ConvertToInt(CommonFunc.GetLocation(locationCode, LocationType.Office));
string proName = (emplDao.GetByOfficeEmail(obj.RequestUser + Constants.LOGIGEAR_EMAIL_DOMAIN) as Employee).Project;
if (String.IsNullOrEmpty(proName))
{
srSetting = srSettingDao.GetByProjectAndOffice(String.Empty, officeId);
}
else
{
srSetting = srSettingDao.GetByProjectAndOffice(proName, officeId);
}
if (!string.IsNullOrEmpty(srSetting.EmailTo))
{
aTo = srSetting.EmailTo.Split(Constants.SEPARATE_CC_LIST);
for (int i = 0; i < aTo.Count(); i++)
{
if (!duplicateEmail.Contains(aTo[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";") && !String.IsNullOrEmpty(aTo[i]))
{
duplicateEmail.Add(aTo[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
to_email += aTo[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
}
}
}
if(!string.IsNullOrEmpty(srSetting.EmailCc))
{
aCc = srSetting.EmailCc.Split(Constants.SEPARATE_CC_LIST);
for (int i = 0; i < aCc.Count(); i++)
{
if (!duplicateEmail.Contains(aCc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";") && !String.IsNullOrEmpty(aCc[i]))
{
duplicateEmail.Add(aCc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
cc_email += aCc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
}
}
}
if(!string.IsNullOrEmpty(srSetting.EmailBcc))
{
aBcc = srSetting.EmailBcc.Split(Constants.SEPARATE_CC_LIST);
for (int i = 0; i < aBcc.Count(); i++)
{
if (!duplicateEmail.Contains(aBcc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";") && !String.IsNullOrEmpty(aBcc[i]))
{
duplicateEmail.Add(aBcc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";");
bcc_email += aBcc[i] + Constants.LOGIGEAR_EMAIL_DOMAIN + ";";
}
}
}
}
#endregion
if (!string.IsNullOrEmpty(to_email))
{
//WebUtils.SendMail(host, port, from_email, poster, to_email, cc_email, subject, body);
WebUtils.SendMail(host, port, from_email, poster, to_email, cc_email, bcc_email, subject, body);
}
}
public static string GetManagerIdByEmpID(string empID)
{
string mId = string.Empty;
Employee emp = new EmployeeDao().GetById(empID);
return mId = emp.ManagerId;
}
public static string GetManagerFullNameByEmpID(string empID)
{
string st = string.Empty;
Employee emp = new EmployeeDao().GetById(empID);
string mId = emp.ManagerId;
Employee manaId = new EmployeeDao().GetById(mId);
if (manaId != null)
{
if (string.IsNullOrEmpty(manaId.MiddleName))
{
st = HttpUtility.HtmlEncode(manaId.FirstName) + " " + HttpUtility.HtmlEncode(manaId.LastName);
}
else
{
st = HttpUtility.HtmlEncode(manaId.FirstName) + " " + HttpUtility.HtmlEncode(manaId.MiddleName) + " " + HttpUtility.HtmlEncode(manaId.LastName) + " - " + HttpUtility.HtmlEncode(manaId.ID);
}
}
return st;
}
public static string GetEmployeeFullNameByEmpID(string empID)
{
string st = string.Empty;
Employee emp = new EmployeeDao().GetById(empID);
if (emp != null)
{
if (string.IsNullOrEmpty(emp.MiddleName))
{
st = HttpUtility.HtmlEncode(emp.FirstName) + " " + HttpUtility.HtmlEncode(emp.LastName);
}
else
{
st = HttpUtility.HtmlEncode(emp.FirstName) + " " + HttpUtility.HtmlEncode(emp.MiddleName) + " " + HttpUtility.HtmlEncode(emp.LastName) + " - " + HttpUtility.HtmlEncode(emp.ID);
}
}
return st;
}
public void WriteLogForUpdateCompany(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.JR != oldInfo.JR)
{
commonDao.InsertLogDetail(logId, "JR", "Job Request", oldInfo.JR, newInfo.JR);
isUpdated = true;
}
if (newInfo.Project != oldInfo.Project)
{
commonDao.InsertLogDetail(logId, "Project", "JProject", oldInfo.Project, newInfo.Project);
isUpdated = true;
}
if (newInfo.ManagerId != oldInfo.ManagerId)
{
commonDao.InsertLogDetail(logId, "Manager", "Manager", oldInfo.ManagerId, newInfo.ManagerId);
isUpdated = true;
}
if (newInfo.JRApproval != oldInfo.JRApproval)
{
commonDao.InsertLogDetail(logId, "JRApproval", "Job Request Approval", oldInfo.JRApproval, newInfo.JRApproval);
isUpdated = true;
}
if (newInfo.StartDate != oldInfo.StartDate)
{
commonDao.InsertLogDetail(logId, "StartDate", "Start Date", oldInfo.StartDate.ToString(Constants.DATETIME_FORMAT_VIEW), newInfo.StartDate.ToString(Constants.DATETIME_FORMAT_VIEW));
isUpdated = true;
}
if (newInfo.ContractedDate != oldInfo.ContractedDate)
{
commonDao.InsertLogDetail(logId, "ContractedDate", "Contracted Date",oldInfo.ContractedDate.HasValue?oldInfo.ContractedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"", newInfo.ContractedDate.HasValue?newInfo.ContractedDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.DepartmentId != oldInfo.DepartmentId)
{
Department sub = new DepartmentDao().GetById(newInfo.DepartmentId);
commonDao.InsertLogDetail(logId, "DepartmentId", "Sub Department", oldInfo.Department.DepartmentName, sub.DepartmentName);
isUpdated = true;
}
if (newInfo.TitleId != oldInfo.TitleId)
{
JobTitleLevel title = new JobTitleLevelDao().GetById(newInfo.TitleId);
commonDao.InsertLogDetail(logId, "TitleId", "Job Title", oldInfo.JobTitleLevel.DisplayName, title.DisplayName);
isUpdated = true;
}
if (newInfo.LaborUnion != oldInfo.LaborUnion)
{
commonDao.InsertLogDetail(logId, "LaborUnion", "Labor Union",oldInfo.LaborUnion.HasValue?(oldInfo.LaborUnion == true?"Yes":"No"):"", newInfo.LaborUnion.HasValue?(newInfo.LaborUnion == true?"Yes":"No"):"");
isUpdated = true;
}
if (newInfo.LaborUnionDate != oldInfo.LaborUnionDate)
{
commonDao.InsertLogDetail(logId, "LaborUnionDate", "Labor Union date", oldInfo.LaborUnionDate.HasValue?oldInfo.LaborUnionDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.LaborUnionDate.HasValue?newInfo.LaborUnionDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.TaxID != oldInfo.TaxID)
{
commonDao.InsertLogDetail(logId, "TaxID", "TaxID", oldInfo.TaxID, newInfo.TaxID);
isUpdated = true;
}
if (newInfo.TaxIssueDate != oldInfo.TaxIssueDate)
{
commonDao.InsertLogDetail(logId, "TaxIssueDate", "Tax Issue Date", oldInfo.TaxIssueDate.HasValue?oldInfo.TaxIssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"",newInfo.TaxIssueDate.HasValue?newInfo.TaxIssueDate.Value.ToString(Constants.DATETIME_FORMAT_VIEW):"");
isUpdated = true;
}
if (newInfo.SocialInsuranceNo != oldInfo.SocialInsuranceNo)
{
commonDao.InsertLogDetail(logId, "SocialInsuranceNo", "Insurance Book No", oldInfo.SocialInsuranceNo, newInfo.SocialInsuranceNo);
isUpdated = true;
}
if (newInfo.InsuranceHospitalID != oldInfo.InsuranceHospitalID)
{
commonDao.InsertLogDetail(logId, "InsuranceHospitalID", "Insurance Hospital", oldInfo.InsuranceHospitalID, newInfo.InsuranceHospitalID);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetEmployeeIDByUserName(string userName)
{
string result = string.Empty;
string officeEmail = userName + Constants.PREFIX_EMAIL_LOGIGEAR;
Employee emp = new EmployeeDao().GetByOfficeEmailInActiveList(officeEmail);
if (emp != null)
{
result = emp.ID;
}
return result;
}
public void WriteLogForUpdateContact(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.HomePhone != oldInfo.HomePhone)
{
commonDao.InsertLogDetail(logId, "HomePhone", "Home Phone", oldInfo.HomePhone, newInfo.HomePhone);
isUpdated = true;
}
if (newInfo.CellPhone != oldInfo.CellPhone)
{
commonDao.InsertLogDetail(logId, "CellPhone", "Cell Phone", oldInfo.CellPhone, newInfo.CellPhone);
isUpdated = true;
}
if (newInfo.ExtensionNumber != oldInfo.ExtensionNumber)
{
commonDao.InsertLogDetail(logId, "ExtensionNumber", "Extension Number", oldInfo.ExtensionNumber, newInfo.ExtensionNumber);
isUpdated = true;
}
if (newInfo.LocationCode != oldInfo.LocationCode)
{
commonDao.InsertLogDetail(logId, "LocationCode", "LocationCode", CommonFunc.GenerateStringOfLocation(oldInfo.LocationCode), CommonFunc.GenerateStringOfLocation(newInfo.LocationCode));
isUpdated = true;
}
if (newInfo.SkypeId != oldInfo.SkypeId)
{
commonDao.InsertLogDetail(logId, "SkypeId", "SkypeId", oldInfo.SkypeId, newInfo.SkypeId);
isUpdated = true;
}
if (newInfo.YahooId != oldInfo.YahooId)
{
commonDao.InsertLogDetail(logId, "YahooId", "YahooId", oldInfo.YahooId, newInfo.YahooId);
isUpdated = true;
}
if (newInfo.PersonalEmail != oldInfo.PersonalEmail)
{
commonDao.InsertLogDetail(logId, "PersonalEmail", "Personal Email", oldInfo.PersonalEmail, newInfo.PersonalEmail);
isUpdated = true;
}
if (newInfo.OfficeEmail != oldInfo.OfficeEmail)
{
commonDao.InsertLogDetail(logId, "OfficeEmail", "Office Email", oldInfo.OfficeEmail, newInfo.OfficeEmail);
isUpdated = true;
}
if (newInfo.EmergencyContactName != oldInfo.EmergencyContactName)
{
commonDao.InsertLogDetail(logId, "EmergencyContactName", "Emergency Contact Name", oldInfo.EmergencyContactName, newInfo.EmergencyContactName);
isUpdated = true;
}
if (newInfo.EmergencyContactPhone != oldInfo.EmergencyContactPhone)
{
commonDao.InsertLogDetail(logId, "EmergencyContactPhone", "Emergency Contact Phone", oldInfo.EmergencyContactPhone, newInfo.EmergencyContactPhone);
isUpdated = true;
}
if (newInfo.EmergencyContactRelationship != oldInfo.EmergencyContactRelationship)
{
commonDao.InsertLogDetail(logId, "EmergencyContactRelationship", "Emergency Contact Relationship", oldInfo.EmergencyContactRelationship, newInfo.EmergencyContactRelationship);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetUserNameLoginByEmpID(string empID)
{
string result = string.Empty;
Employee emp = new EmployeeDao().GetById(empID);
if (emp != null && !string.IsNullOrEmpty(emp.OfficeEmail))
{
result = emp.OfficeEmail.Replace(Constants.PREFIX_EMAIL_LOGIGEAR, "");
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="newInfo"></param>
/// <param name="action"></param>
public void WriteLogForUpdatePosition(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.ManagerId != oldInfo.ManagerId)
{
commonDao.InsertLogDetail(logId, "Manager", "Manager", oldInfo.ManagerId, newInfo.ManagerId);
isUpdated = true;
}
if (newInfo.Project != oldInfo.Project)
{
commonDao.InsertLogDetail(logId, "Project", "Project", oldInfo.Project, newInfo.Project);
isUpdated = true;
}
if (newInfo.Floor != oldInfo.Floor)
{
commonDao.InsertLogDetail(logId, "Floor", "Floor", oldInfo.Floor, newInfo.Floor);
isUpdated = true;
}
if (newInfo.SeatCode != oldInfo.SeatCode)
{
commonDao.InsertLogDetail(logId, "SeatCode", "SeatCode", oldInfo.SeatCode, newInfo.SeatCode);
isUpdated = true;
}
if (newInfo.LocationCode != oldInfo.LocationCode)
{
commonDao.InsertLogDetail(logId, "LocationCode", "LocationCode", CommonFunc.GenerateStringOfLocation(oldInfo.LocationCode), CommonFunc.GenerateStringOfLocation(newInfo.LocationCode));
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Message UpdatePromote(string sttID,string newID, Employee obj)
{
Message msg = null;
try
{
#region Set Value for Employee
STT objSTT = new STTDao().GetById(sttID);
if (objSTT != null)
{
UpdateForPromoted(objSTT);
//Insert Employee
obj.OldEmployeeId = sttID;
obj.ID = newID;
obj.FirstName = objSTT.FirstName;
obj.MiddleName = objSTT.MiddleName;
obj.LastName = objSTT.LastName;
obj.DOB = objSTT.DOB;
obj.POB = objSTT.POB;
obj.PlaceOfOrigin = objSTT.PlaceOfOrigin;
obj.Nationality = objSTT.Nationality;
obj.IDNumber = objSTT.IDNumber;
obj.IssueDate = objSTT.IssueDate;
obj.Gender = objSTT.Gender;
obj.Religion = objSTT.Religion;
obj.MarriedStatus = objSTT.MarriedStatus;
obj.JR = objSTT.JR;
obj.JRApproval = objSTT.JRApproval;
obj.StartDate = objSTT.StartDate;
obj.DepartmentId = objSTT.DepartmentId;
obj.LaborUnion = objSTT.LaborUnion;
obj.LaborUnionDate = objSTT.LaborUnionDate;
obj.HomePhone = objSTT.HomePhone;
obj.CellPhone = objSTT.CellPhone;
obj.Floor = objSTT.Floor;
obj.ExtensionNumber = objSTT.ExtensionNumber;
obj.SeatCode = objSTT.SeatCode;
obj.SkypeId = objSTT.SkypeId;
obj.YahooId = objSTT.YahooId;
obj.PersonalEmail = objSTT.PersonalEmail;
obj.OfficeEmail = objSTT.OfficeEmail;
obj.EmergencyContactName = objSTT.EmergencyContactName;
obj.EmergencyContactPhone = objSTT.EmergencyContactPhone;
obj.EmergencyContactRelationship = objSTT.EmergencyContactRelationship;
obj.PermanentAddress = objSTT.PermanentAddress;
obj.PermanentArea = objSTT.PermanentArea;
obj.PermanentDistrict = objSTT.PermanentDistrict;
obj.PermanentCityProvince = objSTT.PermanentCityProvince;
obj.PermanentCountry = objSTT.PermanentCountry;
obj.TempAddress = objSTT.TempAddress;
obj.TempArea = objSTT.TempArea;
obj.TempDistrict = objSTT.TempDistrict;
obj.TempCityProvince = objSTT.TempCityProvince;
obj.TempCountry = objSTT.TempCountry;
obj.BankName = objSTT.BankName;
obj.BankAccount = objSTT.BankAccount;
obj.Remarks = objSTT.Remarks;
obj.UpdateDate = DateTime.Now;
obj.CreateDate = DateTime.Now;
obj.VnFirstName = objSTT.VnFirstName;
obj.VnMiddleName = objSTT.VnMiddleName;
obj.VnLastName = objSTT.VnLastName;
obj.VnPOB = objSTT.VnPOB;
obj.VnPlaceOfOrigin = objSTT.VnPlaceOfOrigin;
obj.Degree = objSTT.Degree;
obj.OtherDegree = objSTT.OtherDegree;
obj.Race = objSTT.Race;
obj.IDIssueLocation = objSTT.IDIssueLocation;
obj.VnIDIssueLocation = objSTT.VnIDIssueLocation;
obj.VnPermanentAddress = objSTT.VnPermanentAddress;
obj.VnPermanentArea = objSTT.VnPermanentArea;
obj.VnPermanentDistrict = objSTT.VnPermanentDistrict;
obj.VnPermanentCityProvince = objSTT.VnPermanentCityProvince;
obj.VnPermanentCountry = objSTT.VnPermanentCountry;
obj.VnTempAddress = objSTT.VnTempAddress;
obj.VnTempArea = objSTT.VnTempArea;
obj.VnTempDistrict = objSTT.VnTempDistrict;
obj.VnTempCityProvince = objSTT.VnTempCityProvince;
obj.VnTempCountry = objSTT.VnTempCountry;
msg = new EmployeeDao().Insert(obj);
if (msg.MsgType == MessageType.Info)
{
msg = new EmployeeDao().InsertTracking(obj);
}
}
#endregion
msg = new Message(MessageConstants.I0001, MessageType.Info, objSTT.ID + " " + objSTT.FirstName + " " + objSTT.MiddleName + " " + objSTT.LastName, "updated");
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public void WriteLogForUpdateAddress(Employee newInfo, ELogAction action)
{
try
{
bool isUpdated = false;
if (newInfo == null)
{
return;
}
MasterLog objMasterLog = new MasterLog();
string logId = commonDao.UniqueId;
commonDao.InsertMasterLog(logId, newInfo.UpdatedBy, ELogTable.Employee.ToString(), action.ToString());
Employee oldInfo = new EmployeeDao().GetById(newInfo.ID);
if ((oldInfo != null) && (newInfo != null) && (logId != null))
{
if (newInfo.PermanentAddress != oldInfo.PermanentAddress)
{
commonDao.InsertLogDetail(logId, "PermanentAddress", "Permanent Address", oldInfo.PermanentAddress, newInfo.PermanentAddress);
isUpdated = true;
}
if (newInfo.PermanentArea != oldInfo.PermanentArea)
{
commonDao.InsertLogDetail(logId, "PermanentArea", "Permanent Ward", oldInfo.PermanentArea, newInfo.PermanentArea);
isUpdated = true;
}
if (newInfo.PermanentDistrict != oldInfo.PermanentDistrict)
{
commonDao.InsertLogDetail(logId, "PermanentDistrict", "Permanent District", oldInfo.PermanentDistrict, newInfo.PermanentDistrict);
isUpdated = true;
}
if (newInfo.PermanentCityProvince != oldInfo.PermanentCityProvince)
{
commonDao.InsertLogDetail(logId, "PermanentCityProvince", "Permanent City Province", oldInfo.PermanentCityProvince, newInfo.PermanentCityProvince);
isUpdated = true;
}
if (newInfo.PermanentCountry != oldInfo.PermanentCountry)
{
commonDao.InsertLogDetail(logId, "PermanentCountry", "Permanent Country", oldInfo.PermanentCountry, newInfo.PermanentCountry);
isUpdated = true;
}
if (newInfo.TempAddress != oldInfo.TempAddress)
{
commonDao.InsertLogDetail(logId, "TempAddress", "Temp Address", oldInfo.TempAddress, newInfo.TempAddress);
isUpdated = true;
}
if (newInfo.TempArea != oldInfo.TempArea)
{
commonDao.InsertLogDetail(logId, "TempArea", "Temp Area", oldInfo.TempArea, newInfo.TempArea);
isUpdated = true;
}
if (newInfo.TempDistrict != oldInfo.TempDistrict)
{
commonDao.InsertLogDetail(logId, "TempDistrict", "Temp District", oldInfo.TempDistrict, newInfo.TempDistrict);
isUpdated = true;
}
if (newInfo.TempCityProvince != oldInfo.TempCityProvince)
{
commonDao.InsertLogDetail(logId, "TempCityProvince", "Temp City Province", oldInfo.TempCityProvince, newInfo.TempCityProvince);
isUpdated = true;
}
if (newInfo.TempCountry != oldInfo.TempCountry)
{
commonDao.InsertLogDetail(logId, "TempCountry", "Temp Country", oldInfo.TempCountry, newInfo.TempCountry);
isUpdated = true;
}
if (newInfo.VnPermanentAddress != oldInfo.VnPermanentAddress)
{
commonDao.InsertLogDetail(logId, "VnPermanentAddress", "Vn Permanent Address", oldInfo.VnPermanentAddress, newInfo.VnPermanentAddress);
isUpdated = true;
}
if (newInfo.VnPermanentArea != oldInfo.VnPermanentArea)
{
commonDao.InsertLogDetail(logId, "VnPermanentArea", "Vn Permanent Area", oldInfo.VnPermanentArea, newInfo.VnPermanentArea);
isUpdated = true;
}
if (newInfo.VnPermanentDistrict != oldInfo.VnPermanentDistrict)
{
commonDao.InsertLogDetail(logId, "VnPermanentDistrict", "Vn Permanent District", oldInfo.VnPermanentDistrict, newInfo.VnPermanentDistrict);
isUpdated = true;
}
if (newInfo.VnPermanentCityProvince != oldInfo.VnPermanentCityProvince)
{
commonDao.InsertLogDetail(logId, "VnPermanentCityProvince", "Vn Permanent City Province", oldInfo.VnPermanentCityProvince, newInfo.VnPermanentCityProvince);
isUpdated = true;
}
if (newInfo.VnPermanentCountry != oldInfo.VnPermanentCountry)
{
commonDao.InsertLogDetail(logId, "VnPermanentCountry", "Vn Permanent Country", oldInfo.VnPermanentCountry, newInfo.VnPermanentCountry);
isUpdated = true;
}
if (newInfo.VnTempAddress != oldInfo.VnTempAddress)
{
commonDao.InsertLogDetail(logId, "VnTempAddress", "Vn Temp Address", oldInfo.VnTempAddress, newInfo.VnTempAddress);
isUpdated = true;
}
if (newInfo.VnTempArea != oldInfo.VnTempArea)
{
commonDao.InsertLogDetail(logId, "VnTempArea", "Vn Temp Area", oldInfo.VnTempArea, newInfo.VnTempArea);
isUpdated = true;
}
if (newInfo.VnTempCityProvince != oldInfo.VnTempCityProvince)
{
commonDao.InsertLogDetail(logId, "VnTempCityProvince", "Vn Temp City Province", oldInfo.VnTempCityProvince, newInfo.VnTempCityProvince);
isUpdated = true;
}
if (newInfo.VnTempCountry != oldInfo.VnTempCountry)
{
commonDao.InsertLogDetail(logId, "VnTempCountry", "Vn Temp Country", oldInfo.VnTempCountry, newInfo.VnTempCountry);
isUpdated = true;
}
if (isUpdated)
{
// Insert Key Name
string key = oldInfo.ID + " [" + oldInfo.FirstName + " " + oldInfo.MiddleName + " " + oldInfo.LastName + "]";
commonDao.InsertLogDetail(logId, "ID", "Key for Update", key, null);
}
else
{
commonDao.DeleteMasterLog(logId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Message Swap(string id1, string id2)
{
Message msg = null;
STTDao sttDao = new STTDao ();
EmployeeDao empDao =new EmployeeDao ();
try
{
if (id1.IsSttId())
{
STT obj1 = sttDao.GetById(id1);
string tmp = obj1.LocationCode;
if (id2.IsSttId())
{
STT obj2 = sttDao.GetById(id2);
obj1.LocationCode = obj2.LocationCode;
obj2.LocationCode = tmp;
}
else
{
Employee obj2 = empDao.GetById(id2);
obj1.LocationCode = obj2.LocationCode;
obj2.LocationCode = tmp;
}
}
else
{
Employee obj1 = empDao.GetById(id1);
string tmp = obj1.LocationCode;
if (id2.IsSttId())
{
STT obj2 = sttDao.GetById(id2);
obj1.LocationCode = obj2.LocationCode;
obj2.LocationCode = tmp;
}
else
{
Employee obj2 = empDao.GetById(id2);
obj1.LocationCode = obj2.LocationCode;
obj2.LocationCode = tmp;
}
}
msg = new Message(MessageConstants.I0001, MessageType.Info, "Work Location", "swapped");
dbContext.SubmitChanges();
}
catch
{
msg = new Message(MessageConstants.E0033, MessageType.Error);
}
return msg;
}
