Int64 IHREmployeeDataAccess.Delete(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Delete(hREmployeeEntity, filterExpression, option);
break;
}
case TransactionRequired.Yes:
{
retValues = DeleteTran(hREmployeeEntity, filterExpression, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
Int64 IHREmployeeDataAccess.Add(HREmployeeEntity hREmployeeEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(hREmployeeEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(hREmployeeEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void GetEmployeeNameAndCode()
{
HREmployeeEntity entity = FCCHREmployee.GetFacadeCreate().GetByID(_CurrentEmployeeEvaluatedID);
HRMemberEntity ent = FCCHRMember.GetFacadeCreate().GetByID(entity.MemberID);
txtEmployeeCode.Text = entity.EmployeeCode;
txtEmployeeName.Text = ent.FirstName + " " + ent.MiddleName + " " + ent.LastName;
}
private void CalculateLeave()
{
if (chbxFilter.Checked)
{
HREmployeeEntity hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(Int64.Parse(ddlEmployeeID.SelectedValue));
ACFiscalYearEntity aCFiscalYearEntity = FCCACFiscalYear.GetFacadeCreate().GetByID(Int64.Parse(ddlFiscalYearID.SelectedValue));
MDLeaveCategoryEntity mDLeaveCategoryEntity = FCCMDLeaveCategory.GetFacadeCreate().GetByID(Int64.Parse(ddlLeaveCategoryID.SelectedValue));
IList <MDLeavePolicyEntity> mDLeavePolicyList = FCCMDLeavePolicy.GetFacadeCreate().GetIL(1000, 1, String.Empty, String.Empty, DatabaseOperationType.Load);
Decimal leaveInDays = 0;
if (mDLeavePolicyList.Count > 0 && mDLeavePolicyList != null)
{
mDLeavePolicyList[0] = mDLeavePolicyList.Single(x => (x.LeaveCategoryID == mDLeaveCategoryEntity.LeaveCategoryID && x.FiscalYearID == aCFiscalYearEntity.FiscalYearID && x.EmployeeJobTypeID == hREmployeeEntity.EmployeeJobTypeID));
if (mDLeavePolicyList[0].LeaveCategoryID == mDLeaveCategoryEntity.LeaveCategoryID && mDLeavePolicyList[0].FiscalYearID == aCFiscalYearEntity.FiscalYearID)
{
leaveInDays = mDLeavePolicyList[0].LeaveInDays;
}
if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && hREmployeeEntity.ConfirmDate <= aCFiscalYearEntity.BeginDate)
{
txtEarnedDays.Text = leaveInDays.ToString().Trim();;
}
else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.PARTTIMENOTLESS75PERCENT)
{
txtEarnedDays.Text = leaveInDays.ToString().Trim();
}
else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && hREmployeeEntity.ConfirmDate == null)
{
txtEarnedDays.Text = "0.0";
}
else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.PARTTIMENOTLESS50PERCENT)
{
txtEarnedDays.Text = leaveInDays.ToString().Trim();
}
else if (hREmployeeEntity.EmployeeJobTypeID == MasterDataConstants.MDEmployeeJobType.FULLTIME && (hREmployeeEntity.ConfirmDate <= aCFiscalYearEntity.BeginDate && hREmployeeEntity.ConfirmDate >= aCFiscalYearEntity.EndDate))
{
DateTime s = aCFiscalYearEntity.EndDate;
DateTime e = (DateTime)hREmployeeEntity.ConfirmDate;
Decimal Month = s.Subtract(e).Days / (365 / 12);
Month = (leaveInDays / 12) * Month;
txtEarnedDays.Text = Month.ToString().Trim();;
}
else
{
txtEarnedDays.Text = "0";
}
}
else
{
MiscUtil.ShowMessage(lblMessage, "There is no policy in this fiscal year and may be not active please insert data in Leave Policy.", false);
}
}
else
{
txtEarnedDays.Text = String.Empty;
}
}
private Int64 Update(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployee_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeEntity.EmployeeID);
Database.AddInParameter(cmd, "@MemberID", DbType.Int64, hREmployeeEntity.MemberID);
Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, hREmployeeEntity.ProjectID);
Database.AddInParameter(cmd, "@DepartmentID", DbType.Int64, hREmployeeEntity.DepartmentID);
Database.AddInParameter(cmd, "@DesignationID", DbType.Int64, hREmployeeEntity.DesignationID);
Database.AddInParameter(cmd, "@EmployeeCode", DbType.String, hREmployeeEntity.EmployeeCode);
Database.AddInParameter(cmd, "@EmployeeJobTypeID", DbType.Int64, hREmployeeEntity.EmployeeJobTypeID);
Database.AddInParameter(cmd, "@ConfirmDate", DbType.DateTime, hREmployeeEntity.ConfirmDate);
Database.AddInParameter(cmd, "@JoinDate", DbType.DateTime, hREmployeeEntity.JoinDate);
Database.AddInParameter(cmd, "@DOB", DbType.DateTime, hREmployeeEntity.DOB);
Database.AddInParameter(cmd, "@SalaryLevel", DbType.Int32, hREmployeeEntity.SalaryLevel);
Database.AddInParameter(cmd, "@BloodGroupID", DbType.Int64, hREmployeeEntity.BloodGroupID);
Database.AddInParameter(cmd, "@PrimaryEmail", DbType.String, hREmployeeEntity.PrimaryEmail);
Database.AddInParameter(cmd, "@SecondaryEmail", DbType.String, hREmployeeEntity.SecondaryEmail);
Database.AddInParameter(cmd, "@Initials", DbType.String, hREmployeeEntity.Initials);
Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, hREmployeeEntity.IsRemoved);
Database.AddInParameter(cmd, "@EmploymentStatusID", DbType.Int64, hREmployeeEntity.EmploymentStatusID);
Database.AddInParameter(cmd, "@DiscontinuedDate", DbType.DateTime, hREmployeeEntity.DiscontinuedDate);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HREmployeeEntity already exists. Please specify another HREmployeeEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeEntity already exists. Please specify another HREmployeeEntity.");
}
}
}
}
return(returnCode);
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_MemberID = 0;
_HRMemberEntity = new HRMemberEntity();
_EmployeeID = 0;
_HREmployeeEntity = new HREmployeeEntity();
PrepareInitialView();
}
private Int64 DeleteTran(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployee_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode >= 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
private void SendMail(HREmployeeLeaveApplicationEntity hREmployeeLeaveApplicationEntity)
{
HREmployeeLeaveApplicationEntity entity = hREmployeeLeaveApplicationEntity;
String fe = "EmployeeID = " + entity.BackupEmployeeID + "";
IList <HREmployee_DetailedEntity> listEmployee = FCCHREmployee_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
String EmployeeName = listEmployee[0].EmployeeFullName;
String EmployeeCode = listEmployee[0].EmployeeCode;
Int64 BackupEmployeeID = (Int64)entity.BackupEmployeeID;
#region Notice Mail
String MailBody = String.Empty;
String Subject = String.Empty;
//int count = 0;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("Employee Name: " + EmployeeName + " Code :" + EmployeeCode + " is going to take " + entity.TotalLeaveDays + " days leave. And you are the back employee or assigned to his/her work. .");
sb.Append("<br/>");
sb.Append("Please contact with him/her if you have any problem.");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Leave";
String[] sendToMail = new String[1];
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(BackupEmployeeID);
if (_hREmployeeEntity != null)
{
sendToMail[0] = _hREmployeeEntity.PrimaryEmail;
}
MiscUtil.SendMail(sendToMail, Subject, MailBody);
#endregion
}
public static HREmployeeEntity GetStoreInCharge(Int64 storeID)
{
HREmployeeEntity ent = new HREmployeeEntity();
try
{
INVStoreEntity store = FCCINVStore.GetFacadeCreate().GetByID(storeID);
ent = FCCHREmployee.GetFacadeCreate().GetByID(store.StoreInChargeEmployeeID);
}
catch (Exception ex)
{
}
return(ent);
}
private void SendMail(HREmployeeNoticeEntity noticeEntity)
{
HREmployeeNoticeEntity entity = noticeEntity;
#region Notice Mail
String MailBody = String.Empty;
String Subject = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("A " + entity.Memo + " Have Been send By HR. Please go to your profile and Check " + entity.Memo + ".");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Notice Reply";
String[] sendToMail = new String[1];
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(entity.SendToEmployeeID);
if (_hREmployeeEntity != null)
{
sendToMail[0] = _hREmployeeEntity.PrimaryEmail;
}
MiscUtil.SendMail(sendToMail, Subject, MailBody);
#endregion
}
private void PrepareEditView()
{
HREmployeeEntity hREmployeeEntity = CurrentHREmployeeEntity;
HRMemberEntity hRMemberEntity = CurrentHRMemberEntity;
if (!hRMemberEntity.IsNew)
{
txtFirstName.Text = hRMemberEntity.FirstName.ToString();
txtMiddleName.Text = hRMemberEntity.MiddleName.ToString();
txtLastName.Text = hRMemberEntity.LastName.ToString();
}
if (!hREmployeeEntity.IsNew)
{
txtEmployeeCode.Text = hREmployeeEntity.EmployeeCode.ToString();
if (ddlEmployeeJobTypeID.Items.Count > 0 && hREmployeeEntity.EmployeeJobTypeID != null)
{
ddlEmployeeJobTypeID.SelectedValue = hREmployeeEntity.EmployeeJobTypeID.ToString();
}
txtConfirmDate.Text = hREmployeeEntity.ConfirmDate.ToStringDefault();
txtJoinDate.Text = hREmployeeEntity.JoinDate.ToStringDefault();
txtDOB.Text = hREmployeeEntity.DOB.ToStringDefault();
if (ddlBloodGroupID.Items.Count > 0 && hREmployeeEntity.BloodGroupID != null)
{
ddlBloodGroupID.SelectedValue = hREmployeeEntity.BloodGroupID.ToString();
}
txtPrimaryEmail.Text = hREmployeeEntity.PrimaryEmail.ToString();
txtSecondaryEmail.Text = hREmployeeEntity.SecondaryEmail.ToString();
txtInitials.Text = hREmployeeEntity.Initials.ToString();
//btnSubmit.Enabled = true;
btnSubmit.Text = "Update";
}
}
private Int64 Delete(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployee_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HREmployeeEntity already exists. Please specify another HREmployeeEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeEntity already exists. Please specify another HREmployeeEntity.");
}
}
}
}
return(returnCode);
}
private void SaveHREmployeeEntity()
{
if (IsValid)
{
try
{
#region Member
HRMemberEntity hRMemberEntity = BuildHRMemberEntity();
Int64 result = -1;
if (hRMemberEntity.IsNew)
{
result = FCCHRMember.GetFacadeCreate().Add(hRMemberEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HRMemberEntity.FLD_NAME_MemberID, hRMemberEntity.MemberID.ToString(), SQLMatchType.Equal);
result = FCCHRMember.GetFacadeCreate().Update(hRMemberEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
#endregion
if (result > 0)
{
_MemberID = 0;
_HRMemberEntity = new HRMemberEntity();
}
if (result > 0)
{
HREmployeeEntity hREmployeeEntity = BuildHREmployeeEntity();
Int64 resultC = -1;
if (hREmployeeEntity.IsNew)
{
hREmployeeEntity.MemberID = result;
resultC = FCCHREmployee.GetFacadeCreate().Add(hREmployeeEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_EmployeeID, hREmployeeEntity.EmployeeID.ToString(), SQLMatchType.Equal);
resultC = FCCHREmployee.GetFacadeCreate().Update(hREmployeeEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (resultC > 0)
{
_EmployeeID = 0;
_HREmployeeEntity = new HREmployeeEntity();
PrepareEditView();
if (hREmployeeEntity.IsNew)
{
ResourceEntity resourceEntity = new ResourceEntity();
resourceEntity.ReferenceID = resultC; // means new contractor id
resourceEntity.ResourceCategoryID = MasterDataConstants.ResourceCategory.EMPLOYEE;
FCCResource.GetFacadeCreate().Add(resourceEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
if (hREmployeeEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Employee Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Employee Information has been updated successfully.", false);
}
}
else
{
if (hREmployeeEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Information.", false);
}
}
}
else
{
if (hRMemberEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Member Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Member Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void btnForward_Click(object sender, EventArgs e)
{
if (chbxAutoForwardTo.Checked)
{
APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.BILL, CMBillID);
IList <APMemberFeedbackEntity> feedbackList = APRobot.GetAllMemberFeedbacks(aPApprovalProcessEntity.APApprovalProcessID);
IList <APMemberFeedbackEntity> ordered_list = feedbackList.OrderBy(x => x.SequenceNo).ToList();
APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(Int64.Parse(ddlForwardTo.SelectedValue));
var existsInfo = (from s in ordered_list
where s.EmployeeID.ToString() == aPPanelForwardMemberEntity.EmployeeID.ToString()
select s);
if (existsInfo != null && existsInfo.Count() > 0)
{
MiscUtil.ShowMessage(lblMessage, "Member Already Exists in the Approval Panel", true);
return;
}
APMemberFeedbackEntity currentEmployeeInfo = (from r in ordered_list
where r.EmployeeID.ToString() == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString()
select r).FirstOrDefault();
if (currentEmployeeInfo != null)
{
ordered_list = (from m in ordered_list
where m.SequenceNo > currentEmployeeInfo.SequenceNo
select m).ToList();
APMemberFeedbackEntity aPMemberFeedbackEntity = new APMemberFeedbackEntity();
aPMemberFeedbackEntity.APApprovalProcessID = aPApprovalProcessEntity.APApprovalProcessID;
aPMemberFeedbackEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID;
aPMemberFeedbackEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID;
aPMemberFeedbackEntity.SequenceNo = currentEmployeeInfo.SequenceNo + 1;
aPMemberFeedbackEntity.APFeedbackID = MasterDataConstants.APFeedback.NOT_YET_REQUESTED;
aPMemberFeedbackEntity.FeedbackRequestDate = DateTime.Now;
aPMemberFeedbackEntity.FeedbackLastResponseDate = null;
aPMemberFeedbackEntity.FeedbackSubmitDate = null;
aPMemberFeedbackEntity.IsProxyEmployeeEnabled = false;
aPMemberFeedbackEntity.ProxyEmployeeID = null;
Int64 aPMemberFeedbackID = FCCAPMemberFeedback.GetFacadeCreate().Add(aPMemberFeedbackEntity, DatabaseOperationType.Add, TransactionRequired.No);
foreach (APMemberFeedbackEntity ent in ordered_list)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), SQLMatchType.Equal);
ent.SequenceNo += 1;
FCCAPMemberFeedback.GetFacadeCreate().Update(ent, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
APRobot.UpdateApprovalProcessFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.APPROVED, MasterDataConstants.APType.BILL, CMBillID);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Approved";
}
remarks = AddProxyMemberInfo(remarks);
APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
EnableDisableApprovalButtons();
MiscUtil.ShowMessage(lblMessage, "You have Approved Successfully", UIConstants.MessageType.GREEN);
PrepareInitialView();
BindList();
RedirectPageToPendingList();
}
}
//Previous Code
else
{
if (ddlRejectTo.Items.Count > 0)
{
APRobot.UpdateMemberFeedbackFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.FORWARDED);
APRobot.UpdateMemberFeedbackLastResponseDate(APMemberFeedbackID, DateTime.Now);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Forwarded";
}
remarks = AddProxyMemberInfo(remarks);
Int64 aPMemberFeedbackRemarksID = APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
Int64 aPPanelForwardMemberID = Int64.Parse(ddlForwardTo.SelectedValue);
APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(aPPanelForwardMemberID);
APForwardInfoEntity aPForwardInfoEntity = new APForwardInfoEntity();
aPForwardInfoEntity.APMemberFeedbackID = APMemberFeedbackID;
aPForwardInfoEntity.APApprovalProcessID = APApprovalProcessID;
aPForwardInfoEntity.APMemberFeedbackRemarksID = aPMemberFeedbackRemarksID;
aPForwardInfoEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID;
aPForwardInfoEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID;
aPForwardInfoEntity.CommentRequestDate = DateTime.Now;
aPForwardInfoEntity.CommentSubmitDate = null;
aPForwardInfoEntity.APMemberComment = txtForwardRemarks.Text.Trim();
aPForwardInfoEntity.APForwardMemberComment = String.Empty;
FCCAPForwardInfo.GetFacadeCreate().Add(aPForwardInfoEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "You have forwarded the thread successfully", UIConstants.MessageType.GREEN);
PrepareInitialView();
BindList();
#region Forwarded Mail
String MailBody = String.Empty;
String Subject = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("A Bill Request is Forwarded Request is waiting for your approval");
sb.Append("<br/>");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Bill, Forwarded";
MailBody = @"Please note that a Bill is Forwarded.-Thanks ERP System";
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(aPForwardInfoEntity.EmployeeID);
if (_hREmployeeEntity != null)
{
String[] sendToMail = new String[] { _hREmployeeEntity.PrimaryEmail };
MiscUtil.SendMail(sendToMail, Subject, MailBody);
}
#endregion
//RedirectPageToForwardList();
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to forward", UIConstants.MessageType.RED);
}
}
}
private HREmployeeSupervisorMapEntity BuildHREmployeeSupervisorMapEntity()
{
HREmployeeSupervisorMapEntity hREmployeeSupervisorMapEntity = CurrentHREmployeeSupervisorMapEntity;
if (ddlSessionCategoryID.Items.Count > 0)
{
if (ddlSessionCategoryID.SelectedValue == "0")
{
}
else
{
hREmployeeSupervisorMapEntity.SessionCategoryID = Int64.Parse(ddlSessionCategoryID.SelectedValue);
}
}
if (ddlEmployeeID.Items.Count > 0)
{
if (ddlEmployeeID.SelectedValue == "0")
{
}
else
{
hREmployeeSupervisorMapEntity.EmployeeID = Int64.Parse(ddlEmployeeID.SelectedValue);
HREmployeeEntity hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(hREmployeeSupervisorMapEntity.EmployeeID);
if (hREmployeeEntity != null && hREmployeeEntity.EmployeeID > 0)
{
hREmployeeSupervisorMapEntity.EmployeeCode = hREmployeeEntity.EmployeeCode;
}
}
}
if (ddlSupervisorTypeID.Items.Count > 0)
{
if (ddlSupervisorTypeID.SelectedValue == "0")
{
}
else
{
hREmployeeSupervisorMapEntity.SupervisorTypeID = Int64.Parse(ddlSupervisorTypeID.SelectedValue);
}
}
if (ddlSupervisorEmployeeID.Items.Count > 0)
{
if (ddlSupervisorEmployeeID.SelectedValue == "0")
{
}
else
{
hREmployeeSupervisorMapEntity.SupervisorEmployeeID = Int64.Parse(ddlSupervisorEmployeeID.SelectedValue);
HREmployeeEntity hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(hREmployeeSupervisorMapEntity.SupervisorEmployeeID);
if (hREmployeeEntity != null && hREmployeeEntity.EmployeeID > 0)
{
hREmployeeSupervisorMapEntity.SupervisorEmployeeCode = hREmployeeEntity.EmployeeCode;
}
}
}
hREmployeeSupervisorMapEntity.Remarks = txtRemarks.Text.Trim();
hREmployeeSupervisorMapEntity.CreateDate = System.DateTime.Now;
return(hREmployeeSupervisorMapEntity);
}
private void PrepareEditView()
{
HREmployeeEntity hREmployeeEntity = CurrentHREmployeeEntity;
HRMemberEntity hRMemberEntity = CurrentHRMemberEntity;
if (!hRMemberEntity.IsNew)
{
txtFirstName.Text = hRMemberEntity.FirstName.ToString();
txtMiddleName.Text = hRMemberEntity.MiddleName.ToString();
txtLastName.Text = hRMemberEntity.LastName.ToString();
}
if (!hREmployeeEntity.IsNew)
{
txtEmployeeCode.Text = hREmployeeEntity.EmployeeCode.ToString();
if (ddlEmployeeJobTypeID.Items.Count > 0 && hREmployeeEntity.EmployeeJobTypeID != null)
{
ddlEmployeeJobTypeID.SelectedValue = hREmployeeEntity.EmployeeJobTypeID.ToString();
}
if (ddlDesignationID.Items.Count > 0 && hREmployeeEntity.DesignationID != null)
{
ddlDesignationID.SelectedValue = hREmployeeEntity.DesignationID.ToString();
}
if (hREmployeeEntity.ConfirmDate != null)
{
DateTime datetime = (DateTime)hREmployeeEntity.ConfirmDate;
txtConfirmDate.Text = datetime.ToValidDateString();
}
else
{
txtConfirmDate.Text = hREmployeeEntity.ConfirmDate.ToStringDefault();
}
txtJoinDate.Text = hREmployeeEntity.JoinDate.ToStringDefault();
txtDOB.Text = hREmployeeEntity.DOB.ToStringDefault();
txtSalaryLevel.Text = hREmployeeEntity.SalaryLevel.ToString();
if (ddlBloodGroupID.Items.Count > 0 && hREmployeeEntity.BloodGroupID != null)
{
ddlBloodGroupID.SelectedValue = hREmployeeEntity.BloodGroupID.ToString();
}
txtPrimaryEmail.Text = hREmployeeEntity.PrimaryEmail.ToString();
txtSecondaryEmail.Text = hREmployeeEntity.SecondaryEmail.ToString();
txtInitials.Text = hREmployeeEntity.Initials.ToString();
if (ddlEmploymentStatusID.Items.Count > 0 && hREmployeeEntity.EmploymentStatusID != null)
{
ddlEmploymentStatusID.SelectedValue = hREmployeeEntity.EmploymentStatusID.ToString();
}
if (ddlEmploymentStatusID.Items.Count > 0 && hREmployeeEntity.EmploymentStatusID != null && hREmployeeEntity.EmploymentStatusID == MasterDataConstants.MDEmploymentStatus.DISCONTINUED)
{
pnlDiscontinuedDate.Visible = true;
}
else
{
pnlDiscontinuedDate.Visible = false;
}
txtDiscontinuedDate.Text = hREmployeeEntity.DiscontinuedDate.ToStringDefault();
if (ddlDepartmentID.Items.Count > 0 && hREmployeeEntity.DepartmentID != null)
{
ddlDepartmentID.SelectedValue = hREmployeeEntity.DepartmentID.ToString();
}
if (ddlProjectID.Items.Count > 0 && hREmployeeEntity.ProjectID != null)
{
ddlProjectID.SelectedValue = hREmployeeEntity.ProjectID.ToString();
}
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
private void SaveHREmployeeEntity()
{
if (IsValid)
{
try
{
#region Member
HRMemberEntity hRMemberEntity = BuildHRMemberEntity();
Int64 result = -1;
if (hRMemberEntity.IsNew)
{
result = FCCHRMember.GetFacadeCreate().Add(hRMemberEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HRMemberEntity.FLD_NAME_MemberID, hRMemberEntity.MemberID.ToString(), SQLMatchType.Equal);
result = FCCHRMember.GetFacadeCreate().Update(hRMemberEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
#endregion
if (result > 0)
{
_MemberID = 0;
_HRMemberEntity = new HRMemberEntity();
}
if (result > 0)
{
HREmployeeEntity hREmployeeEntity = BuildHREmployeeEntity();
Int64 resultC = -1;
if (hREmployeeEntity.IsNew)
{
hREmployeeEntity.MemberID = result;
resultC = FCCHREmployee.GetFacadeCreate().Add(hREmployeeEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_EmployeeID, hREmployeeEntity.EmployeeID.ToString(), SQLMatchType.Equal);
resultC = FCCHREmployee.GetFacadeCreate().Update(hREmployeeEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
#region Create Six Task For HR
try
{
StringBuilder xmlStr = new StringBuilder();
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
Int64 referenceID = 49;
DateTime joinDate = (DateTime)hREmployeeEntity.JoinDate;
String fe = "DepartmentID = " + MasterDataConstants.MDDepartment.HR_DEPARTMENTID + "";
IList <HREmployeeEntity> lst = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
#region Delete Old Task
String filter = "IssueIdentityCategoryID = " + MasterDataConstants.MDIssueIdentityCategory.HRMETTINGWITHEMPLOYEE + " and SupervisorEmployeeID = " + hREmployeeEntity.EmployeeID + "";
IList <OTIssueEntity> issueList = FCCOTIssue.GetFacadeCreate().GetIL(null, null, String.Empty, filter, DatabaseOperationType.LoadWithFilterExpression);
if (issueList != null && issueList.Count > 0)
{
OTIssueEntity oTIssueEntity = new OTIssueEntity();
FCCOTIssue.GetFacadeCreate().Delete(oTIssueEntity, filter, DatabaseOperationType.Delete, TransactionRequired.No);
}
#endregion
String title = "Employee Name: " + hRMemberEntity.FirstName + " " + hRMemberEntity.MiddleName + " " + hRMemberEntity.LastName + ", Code: " + hREmployeeEntity.EmployeeCode + " join Date: " + hREmployeeEntity.JoinDate + " has metting with you";
xmlStr.Append("<m>");
if (lst != null && lst.Count > 0)
{
foreach (HREmployeeEntity e in lst)
{
for (int i = 1; i <= 6; i++)
{
String subXmlStr = null;
subXmlStr = subXmlStr + "<i><a>" + title + "</a><b>" + hREmployeeEntity.EmployeeID + "</b><c>" + e.EmployeeID + "</c><d>" + CurrentMember.MemberID + "</d><e>" + referenceID + "</e><f>" + joinDate.AddDays(i * 30) + "</f><g>" + joinDate.AddDays((i * 30) + 1) + "</g></i>";
xmlStr.Append(subXmlStr.ToString());
}
}
}
xmlStr.Append("</m>");
FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.CreateSixTaskForHR);
MiscUtil.ShowMessage(lblMessage, "Six Task has created for HR Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
#endregion
if (resultC > 0)
{
_EmployeeID = 0;
_HREmployeeEntity = new HREmployeeEntity();
PrepareInitialView();
BindHREmployeeList();
if (hREmployeeEntity.IsNew)
{
ResourceEntity resourceEntity = new ResourceEntity();
resourceEntity.ReferenceID = resultC; // means new employee id
resourceEntity.ResourceCategoryID = MasterDataConstants.ResourceCategory.EMPLOYEE;
FCCResource.GetFacadeCreate().Add(resourceEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
if (hREmployeeEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Employee Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Employee Information has been updated successfully.", false);
}
}
else
{
if (hREmployeeEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Information.", false);
}
}
}
else
{
if (hRMemberEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Member Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Member Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private Int64 UpdateTran(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployee_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
db.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeEntity.EmployeeID);
db.AddInParameter(cmd, "@MemberID", DbType.Int64, hREmployeeEntity.MemberID);
db.AddInParameter(cmd, "@ProjectID", DbType.Int64, hREmployeeEntity.ProjectID);
db.AddInParameter(cmd, "@DepartmentID", DbType.Int64, hREmployeeEntity.DepartmentID);
db.AddInParameter(cmd, "@DesignationID", DbType.Int64, hREmployeeEntity.DesignationID);
db.AddInParameter(cmd, "@EmployeeCode", DbType.String, hREmployeeEntity.EmployeeCode);
db.AddInParameter(cmd, "@EmployeeJobTypeID", DbType.Int64, hREmployeeEntity.EmployeeJobTypeID);
db.AddInParameter(cmd, "@ConfirmDate", DbType.DateTime, hREmployeeEntity.ConfirmDate);
db.AddInParameter(cmd, "@JoinDate", DbType.DateTime, hREmployeeEntity.JoinDate);
db.AddInParameter(cmd, "@DOB", DbType.DateTime, hREmployeeEntity.DOB);
db.AddInParameter(cmd, "@SalaryLevel", DbType.Int32, hREmployeeEntity.SalaryLevel);
db.AddInParameter(cmd, "@BloodGroupID", DbType.Int64, hREmployeeEntity.BloodGroupID);
db.AddInParameter(cmd, "@PrimaryEmail", DbType.String, hREmployeeEntity.PrimaryEmail);
db.AddInParameter(cmd, "@SecondaryEmail", DbType.String, hREmployeeEntity.SecondaryEmail);
db.AddInParameter(cmd, "@Initials", DbType.String, hREmployeeEntity.Initials);
db.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, hREmployeeEntity.IsRemoved);
db.AddInParameter(cmd, "@EmploymentStatusID", DbType.Int64, hREmployeeEntity.EmploymentStatusID);
db.AddInParameter(cmd, "@DiscontinuedDate", DbType.DateTime, hREmployeeEntity.DiscontinuedDate);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
protected void lvHREmployee_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 EmployeeID;
Int64.TryParse(e.CommandArgument.ToString(), out EmployeeID);
if (EmployeeID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_EmployeeID = EmployeeID;
_MemberID = CurrentHREmployeeEntity.MemberID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
HREmployeeEntity tempEmployee = FCCHREmployee.GetFacadeCreate().GetByID(EmployeeID);
#region Resource Delete
Int64 resultOne = -1;
String fe1_re = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, EmployeeID.ToString(), SQLMatchType.Equal);
String fe2_re = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.EMPLOYEE.ToString(), SQLMatchType.Equal);
String fe_re = SqlExpressionBuilder.PrepareFilterExpression(fe1_re, SQLJoinType.AND, fe2_re);
IList <ResourceEntity> resourceList = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_re, DatabaseOperationType.LoadWithFilterExpression);
foreach (ResourceEntity ent in resourceList)
{
String fe_re_delete = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceID, ent.ResourceID.ToString(), SQLMatchType.Equal);
resultOne = FCCResource.GetFacadeCreate().Delete(ent, fe_re_delete, DatabaseOperationType.Delete, TransactionRequired.No);
}
#endregion
#region Employee Delete
Int64 resultTwo = -1;
if (resultOne == 0)
{
String fe_con_delete = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_EmployeeID, EmployeeID.ToString(), SQLMatchType.Equal);
HREmployeeEntity hREmployeeEntity = new HREmployeeEntity();
resultTwo = FCCHREmployee.GetFacadeCreate().Delete(hREmployeeEntity, fe_con_delete, DatabaseOperationType.Delete, TransactionRequired.No);
}
#endregion
#region Member Delete
Int64 resultThree = -1;
if (resultTwo == 0)
{
String fe_mem_delete = SqlExpressionBuilder.PrepareFilterExpression(HRMemberEntity.FLD_NAME_MemberID, tempEmployee.MemberID.ToString(), SQLMatchType.Equal);
HRMemberEntity hRMemberEntity = new HRMemberEntity();
resultThree = FCCHRMember.GetFacadeCreate().Delete(hRMemberEntity, fe_mem_delete, DatabaseOperationType.Delete, TransactionRequired.No);
}
#endregion
if (resultOne == 0 && resultTwo == 0 && resultThree == 0)
{
_EmployeeID = 0;
_HREmployeeEntity = new HREmployeeEntity();
_MemberID = 0;
_HRMemberEntity = new HRMemberEntity();
PrepareInitialView();
BindHREmployeeList();
MiscUtil.ShowMessage(lblMessage, "Employee has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
Int64 IHREmployeeFacade.Delete(HREmployeeEntity hREmployeeEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeDataAccess().Delete(hREmployeeEntity, filterExpression, option, reqTran));
}
Int64 IHREmployeeFacade.Add(HREmployeeEntity hREmployeeEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeDataAccess().Add(hREmployeeEntity, option, reqTran));
}
private void GetSalaryLevel()
{
HREmployeeEntity entity = FCCHREmployee.GetFacadeCreate().GetByID(Int64.Parse(ddlSendToEmployeeID.SelectedValue));
txtMemo.Text = entity.SalaryLevel.ToString().Trim();
}
private void SaveOTIssueEntity()
{
if (IsValid)
{
try
{
OTIssueEntity oTIssueEntity = BuildOTIssueEntity();
Int64 result = -1;
if (oTIssueEntity.IsNew)
{
result = FCCOTIssue.GetFacadeCreate().Add(oTIssueEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(OTIssueEntity.FLD_NAME_IssueID, oTIssueEntity.IssueID.ToString(), SQLMatchType.Equal);
result = FCCOTIssue.GetFacadeCreate().Update(oTIssueEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
if (oTIssueEntity.IsNew)
{
#region Send Notification
String mailSubject = String.Empty;
String mailBody = String.Empty;
String[] mailTo = new String[1];
String fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueID, result.ToString(), SQLMatchType.Equal);
IList <OTIssue_DetailedEntity> lstOTIssueEntity = FCCOTIssue_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe);
if (lstOTIssueEntity != null && lstOTIssueEntity.Count > 0)
{
mailSubject = lstOTIssueEntity[0].Title.ToString() + "-" + lstOTIssueEntity[0].SupervisorFullName;
mailBody = lstOTIssueEntity[0].Description.ToString();
mailBody += "<br/>";
mailBody += "<br/>";
mailBody += "Expected Start Date: " + lstOTIssueEntity[0].ExpectedStartDate.ToString(UIConstants.SHORT_DATE_FORMAT);
mailBody += "<br/>";
mailBody += "Expected End Date: " + lstOTIssueEntity[0].ExpectedEndDate.ToString(UIConstants.SHORT_DATE_FORMAT);
HREmployeeEntity hREmployeeEntitiy = FCCHREmployee.GetFacadeCreate().GetByID(lstOTIssueEntity[0].AssignedToEmployeeID);
if (hREmployeeEntitiy != null && hREmployeeEntitiy.EmployeeID > 0)
{
mailTo[0] = hREmployeeEntitiy.PrimaryEmail;
MiscUtil.SendMail(mailTo, mailSubject, mailBody);
}
}
#endregion
_IssueID = 0;
_OTIssueEntity = new OTIssueEntity();
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been added successfully.", false);
String NavigationUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueAssignedResource.aspx", string.Empty, UrlConstants.OVERVIEW_ISSUE_ID, result.ToString()).ToString();
Response.Redirect(NavigationUrl);
}
else
{
PrepareInitialView();
PrepareEditView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been updated successfully.", false);
}
}
else
{
if (oTIssueEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Issue Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Issue Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
btnApprove.Enabled = false;
APRobot.UpdateApprovalProcessFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.APPROVED, MasterDataConstants.APType.AGREEMENT, OverviewAgreementID);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Approved";
}
remarks = AddProxyMemberInfo(remarks);
APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
EnableDisableApprovalButtons();
MiscUtil.ShowMessage(lblMessage, "You Have Approved Successfully", UIConstants.MessageType.GREEN);
String fe = SqlExpressionBuilder.PrepareFilterExpression(APForwardInfoEntity.FLD_NAME_APMemberFeedbackID, APMemberFeedbackID.ToString(), SQLMatchType.Equal);
IList <APForwardInfoEntity> lstForwardedInfo = FCCAPForwardInfo.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lstForwardedInfo != null && lstForwardedInfo.Count > 0)
{
#region Forwarded Reply Mail
String MailBody = String.Empty;
String Subject = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("A Forwarded Requisition is Processed By Senior");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Requsition, Forwarded Reply";
String[] sendToMail = new String[lstForwardedInfo.Count];
Int64 count = 0;
foreach (APForwardInfoEntity aPForwardInfoEntity in lstForwardedInfo)
{
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(aPForwardInfoEntity.EmployeeID);
if (_hREmployeeEntity != null)
{
sendToMail[count] = _hREmployeeEntity.PrimaryEmail;
count++;
}
}
MiscUtil.SendMail(sendToMail, Subject, MailBody);
#endregion
}
PrepareInitialView();
BindList();
RedirectPageToPendingList();
}
private HREmployeeEntity BuildHREmployeeEntity()
{
HREmployeeEntity hREmployeeEntity = CurrentHREmployeeEntity;
hREmployeeEntity.EmployeeCode = txtEmployeeCode.Text.Trim();
if (ddlDesignationID.Items.Count > 0)
{
if (ddlDesignationID.SelectedValue == "0")
{
hREmployeeEntity.DesignationID = null;
}
else
{
hREmployeeEntity.DesignationID = Int64.Parse(ddlDesignationID.SelectedValue);
}
}
hREmployeeEntity.EmployeeCode = txtEmployeeCode.Text.Trim();
if (ddlEmployeeJobTypeID.Items.Count > 0)
{
if (ddlEmployeeJobTypeID.SelectedValue == "0")
{
}
else
{
hREmployeeEntity.EmployeeJobTypeID = Int64.Parse(ddlEmployeeJobTypeID.SelectedValue);
}
}
if (txtConfirmDate.Text.Trim().IsNotNullOrEmpty())
{
hREmployeeEntity.ConfirmDate = MiscUtil.ParseToDateTime(txtConfirmDate.Text);
}
else
{
hREmployeeEntity.ConfirmDate = null;
}
if (txtJoinDate.Text.Trim().IsNotNullOrEmpty())
{
hREmployeeEntity.JoinDate = MiscUtil.ParseToDateTime(txtJoinDate.Text);
}
else
{
hREmployeeEntity.JoinDate = null;
}
if (txtDOB.Text.Trim().IsNotNullOrEmpty())
{
hREmployeeEntity.DOB = MiscUtil.ParseToDateTime(txtDOB.Text);
}
else
{
hREmployeeEntity.DOB = null;
}
if (ddlBloodGroupID.Items.Count > 0)
{
if (ddlBloodGroupID.SelectedValue == "0")
{
hREmployeeEntity.BloodGroupID = null;
}
else
{
hREmployeeEntity.BloodGroupID = Int64.Parse(ddlBloodGroupID.SelectedValue);
}
}
hREmployeeEntity.PrimaryEmail = txtPrimaryEmail.Text.Trim();
hREmployeeEntity.SecondaryEmail = txtSecondaryEmail.Text.Trim();
hREmployeeEntity.Initials = txtInitials.Text.Trim();
hREmployeeEntity.IsRemoved = false;
return(hREmployeeEntity);
}
protected void btnForward_Click(object sender, EventArgs e)
{
btnForward.Enabled = false;
if (ddlRejectTo.Items.Count > 0)
{
APRobot.UpdateMemberFeedbackFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.FORWARDED);
APRobot.UpdateMemberFeedbackLastResponseDate(APMemberFeedbackID, DateTime.Now);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Forwarded";
}
remarks = AddProxyMemberInfo(remarks);
Int64 aPMemberFeedbackRemarksID = APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
Int64 aPPanelForwardMemberID = Int64.Parse(ddlForwardTo.SelectedValue);
APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(aPPanelForwardMemberID);
APForwardInfoEntity aPForwardInfoEntity = new APForwardInfoEntity();
aPForwardInfoEntity.APMemberFeedbackID = APMemberFeedbackID;
aPForwardInfoEntity.APApprovalProcessID = APApprovalProcessID;
aPForwardInfoEntity.APMemberFeedbackRemarksID = aPMemberFeedbackRemarksID;
aPForwardInfoEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID;
aPForwardInfoEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID;
aPForwardInfoEntity.CommentRequestDate = DateTime.Now;
aPForwardInfoEntity.CommentSubmitDate = null;
aPForwardInfoEntity.APMemberComment = txtForwardRemarks.Text.Trim();
aPForwardInfoEntity.APForwardMemberComment = String.Empty;
FCCAPForwardInfo.GetFacadeCreate().Add(aPForwardInfoEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "You have forwarded the thread successfully", UIConstants.MessageType.GREEN);
PrepareInitialView();
BindList();
#region Forwarded Mail
String MailBody = String.Empty;
String Subject = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("A Requisition Forwarded Request is waiting for your approval");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Requsition, Forwarded";
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(aPForwardInfoEntity.EmployeeID);
if (_hREmployeeEntity != null)
{
String[] sendToMail = new String[] { _hREmployeeEntity.PrimaryEmail };
MiscUtil.SendMail(sendToMail, Subject, MailBody);
}
#endregion
RedirectPageToForwardList();
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to forward", UIConstants.MessageType.RED);
}
}
protected void lvHREmployeeEvaluation_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
HREmployeeEvaluationIndividual_CustomEntity ent = (HREmployeeEvaluationIndividual_CustomEntity)dataItem.DataItem;
HyperLink hypBtnDoEvaluation = (HyperLink)e.Item.FindControl("hypBtnDoEvaluation");
HyperLink hypReport = (HyperLink)e.Item.FindControl("hypReport");
Label lblRequestInfo = (Label)e.Item.FindControl("lblRequestInfo");
Label lblEmployeeSubmitInfo = (Label)e.Item.FindControl("lblEmployeeSubmitInfo");
Label lblSupervisorSubmitInfo = (Label)e.Item.FindControl("lblSupervisorSubmitInfo");
HyperLink hypBtnDoHREvaluation = (HyperLink)e.Item.FindControl("hypBtnDoHREvaluation");
HyperLink hypHRReport = (HyperLink)e.Item.FindControl("hypHRReport");
String sname = "Employee";
if (ent.SupervisorEmployeeID == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember))
{
sname = "Supervisor";
}
if (!ent.EmployeeSubmitDate.HasValue && !ent.SupervisorSubmitDate.HasValue)
{
lblRequestInfo.Text = "Requested Only";
}
#region SupervisorSubmited or not
if (!ent.SupervisorSubmitDate.HasValue && ent.SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR)
{
lblRequestInfo.Text = "Supervisor Please Submit your marks";
}
#endregion
if (ent.EmployeeSubmitDate.HasValue)
{
lblEmployeeSubmitInfo.Text = "<br/>Employee Submitted";
}
if (ent.SupervisorSubmitDate.HasValue)
{
lblSupervisorSubmitInfo.Text = "<br/>Supervisor Submitted";
}
if (PageAPType == MasterDataConstants.MDEvaluationSessionCategory.HEALTH_CHECKUP)
{
hypBtnDoEvaluation.Text = "Give Answer";
}
//hypBtnDoHREvaluation.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeEvaluationReport.aspx", string.Empty, "do", sname, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
//hypHRReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATIONREPORT_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATION_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
lblEmployeeSubmitInfo.Visible = false;
hypBtnDoHREvaluation.Visible = false;
hypHRReport.Visible = false;
#region IsSupervisor
Int64 supervisorID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
HREmployeeEntity currentHREmployee = FCCHREmployee.GetFacadeCreate().GetByID(supervisorID);
if (ent.SupervisorEmployeeID == supervisorID && ent.SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR || CurrentMember.MemberID == 25 || CurrentMember.MemberID == 182 || CurrentMember.MemberID == 317 || CurrentMember.MemberID == 20520 || CurrentMember.MemberID == 27 || CurrentMember.MemberID == 181)
{
//hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATION_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
hypBtnDoEvaluation.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeEvaluationMigration.aspx", string.Empty, "do", sname, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString(), UrlConstants.OVERVIEW_SUEPRVISOR_EMPLOYEE_ID, ent.SupervisorEmployeeID.ToString()).ToString();
}
else if (ent.SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR)
{
//hypReport.Enabled = false;
hypBtnDoEvaluation.Enabled = false;
chbxShowAll.Visible = false;
}
else
{
//hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATION_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
hypBtnDoEvaluation.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeEvaluationMigration.aspx", string.Empty, "do", sname, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString(), UrlConstants.OVERVIEW_SUEPRVISOR_EMPLOYEE_ID, ent.SupervisorEmployeeID.ToString()).ToString();
}
if (CurrentMember.MemberID == 182 || CurrentMember.MemberID == 25 || CurrentMember.MemberID == 317 || CurrentMember.MemberID == 20520 || CurrentMember.MemberID == 27 || CurrentMember.MemberID == 181)
{
chbxShowAll.Visible = true;
}
if ((CurrentMember.MemberID == 182 || CurrentMember.MemberID == 25 || CurrentMember.MemberID == 317 || CurrentMember.MemberID == 20520 || CurrentMember.MemberID == 27 || CurrentMember.MemberID == 181) && ent.SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR)
{
hypBtnDoHREvaluation.Visible = true;
hypHRReport.Visible = true;
hypBtnDoHREvaluation.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeEvaluationReport.aspx", string.Empty, "do", sname, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
hypHRReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATIONREPORT_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, ent.EmployeeID.ToString()).ToString();
}
else
{
hypBtnDoHREvaluation.Enabled = false;
hypHRReport.Enabled = false;
}
hypReport.Target = "_blank";
hypBtnDoEvaluation.Target = "_blank";
hypBtnDoHREvaluation.Target = "_blank";
hypHRReport.Target = "_blank";
#endregion IsSuperviosr
}
}
