private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
if (empData != null)
{
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
hdfFirstManagerMail.Value = empData.FirstManagerMail;
hdfFirstManager.Value = empData.FirstManager;
hdfSecondManager.Value = empData.SecondManager;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
}
else
{
btnSubmit.Visible = false;
btnReject.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
}
private void BindingGrid()
{
try
{
string sName = string.Empty;
string sEmpID = string.Empty;
string sCompany = string.Empty;
string sDepartment = string.Empty;
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
sName = txtEmpName.Text.Trim();
}
if (!string.IsNullOrEmpty(txtEmpID.Text.Trim()))
{
sEmpID = txtEmpID.Text.Trim();
}
if (ddlCompany.SelectedIndex > 0)
{
sCompany = ddlCompany.SelectedValue.Trim();
}
if (ddlDepartment.SelectedIndex > 0)
{
sDepartment = ddlDepartment.SelectedItem.ToString().Trim();
}
EmployeeMaster_Manage manager = new EmployeeMaster_Manage();
List <Inf_TaskListData> lEmployee = new List <Inf_TaskListData>();
lEmployee = manager.ListCompleteEmployeeData();
if (!string.IsNullOrEmpty(sName))
{
lEmployee = lEmployee.Where(c => c.EmployeeName.Contains(sName)).ToList();
}
if (!string.IsNullOrEmpty(sEmpID))
{
lEmployee = lEmployee.Where(c => c.EmployeeID.Contains(sEmpID)).ToList();
}
if (!string.IsNullOrEmpty(sCompany))
{
lEmployee = lEmployee.Where(c => c.CompanyID.Contains(sCompany)).ToList();
}
if (!string.IsNullOrEmpty(sDepartment))
{
lEmployee = lEmployee.Where(c => c.DepartmentName.Contains(sDepartment)).ToList();
}
gvEmployee.DataSource = lEmployee;
gvEmployee.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractStart != null)
{
lblContractStart.Text = empData.ContractStart.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractEnd != null)
{
lblContractEnd.Text = empData.ContractEnd.Value.ToString(@"dd\/MM\/yyyy");
}
//hdfCompanyID.Value = empData.CompanyID;
txt2ndMgtName.Text = empData.SecondManager;
txt2ndMgtEmail.Text = empData.SecondManagerMail;
txt1stMgtName.Text = empData.FirstManager;
txt1stMgtEmail.Text = empData.FirstManagerMail;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
List <EmployeeMaster> lData = new List <EmployeeMaster>();
EmployeeMaster data = new EmployeeMaster();
data.EmployeeID = hdfEmployeeID.Value;
data.FirstManager = hdfFirstManager.Value.Trim();
data.HRStaff = hdfUserLogin.Value;
data.CreatedBy = hdfUserLogin.Value;
data.CreatedDate = DateTime.Now;
data.AppraisalYear = DateTime.Now.Year.ToString();
lData.Add(data);
if (lData != null && lData.Count > 0)
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
bool ret = manage.UpdateEmployeeMaster(lData);
if (ret)
{
lblMsgResult.Text = "บันทึกข้อมูลเรียบร้อย";
lbtnPopup_ModalPopupExtender.Show();
string sSubjectMail = ConfigurationManager.GetConfiguration().SubjectMailApprove;
string sEmailFrom = ConfigurationManager.GetConfiguration().EmailFrom;
string reqDate = data.CreatedDate.Value.ToString(@"dd\/MM\/yyyy");
string Email1stManager = hdfFirstManagerMail.Value.Trim();
string emaiBody = GenEmailBody(data.EmployeeID, data.FirstManager, data.HRStaff, reqDate);
SendMail(sSubjectMail, emaiBody, Email1stManager, sEmailFrom);
}
else
{
lblMsgResult.Text = "ไม่สามารถบันทึกข้อมูลได้";
lbtnPopup_ModalPopupExtender.Show();
}
}
else
{
lblMsgResult.Text = "กรุณาเลือกพนักงานที่ต้องการประเมิน";
btnOK.Visible = false;
btnCancel.Visible = true;
lbtnPopup_ModalPopupExtender.Show();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialGVAttachFile()
{
try
{
string _EmployeeID = hdfEmployeeID.Value.Trim();
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
List <Attachment> lAttachment = new List <Attachment>();
lAttachment = manage.listAttachfile(_EmployeeID);
DataTable dtAttachment = (DataTable)Session["tbAttachFile"];
if (lAttachment != null && lAttachment.Count > 0)
{
dtAttachment = new DataTable();
DataRow dr;
dtAttachment.Clear();
dtAttachment.Columns.Add("FileName", typeof(string));
dtAttachment.Columns.Add("Description", typeof(string));
dtAttachment.Columns.Add("AttachFilePath", typeof(string));
dtAttachment.Columns.Add("EmployeeID", typeof(string));
foreach (var item in lAttachment)
{
dr = dtAttachment.NewRow();
dr["FileName"] = item.FileName;
dr["Description"] = string.Empty;
dr["AttachFilePath"] = item.Attachment1;
dr["EmployeeID"] = item.EmployeeID;
dtAttachment.Rows.Add(dr);
}
}
Session["tbAttachFile"] = dtAttachment;
gvAttachFile.DataSource = dtAttachment;
gvAttachFile.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void BindGridViewUser()
{
try
{
/********* Find User from TB EmployeeMaster *************/
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
List <EmployeeMaster> lUser = new List <EmployeeMaster>();
lUser = manage.ListEmployeeByName(txtSearch.Text.Trim());
gvSearchUser.DataSource = lUser;
gvSearchUser.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialGridAttachfile()
{
try
{
string _EmployeeID = hdfEmployeeID.Value.Trim();
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
List <Attachment> lAttachment = new List <Attachment>();
lAttachment = manage.listAttachfile(_EmployeeID);
gvAttachFile.DataSource = lAttachment;
gvAttachFile.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
if (empData != null)
{
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.AppraisalDate != null)
{
lblAppraisalDate.Text = empData.AppraisalDate.Value.ToString(@"dd\/MM\/yyyy");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
bool ret = false;
try
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster updData = new EmployeeMaster();
updData.EmployeeID = hdfEmployeeID.Value.Trim();
updData.FirstManager = txt1stMgtName.Text.Trim();
updData.FirstManagerMail = txt1stMgtEmail.Text.Trim();
updData.SecondManager = txt2ndMgtName.Text.Trim();
updData.SecondManagerMail = txt2ndMgtEmail.Text.Trim();
updData.CreatedBy = hdfUserLogin.Value.Trim();
updData.CreatedDate = DateTime.Now;
ret = manage.UpdateEmployeeData(updData);
if (ret)
{
lblResult.Text = "Update employee data completed.";
}
else
{
lblResult.Text = "Can not update employee data.";
}
lbtnPopupApp_ModalPopupExtender.Show();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
if (empData != null)
{
hdfEmployeeType.Value = empData.EmployeeType;
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
lbl1StManagerName.Text = empData.FirstManager;
lbl2StManagerName.Text = empData.SecondManager;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.AppraisalDate != null)
{
lblAppraisalDate.Text = empData.AppraisalDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractStart != null)
{
lblContractStart.Text = empData.ContractStart.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractEnd != null)
{
lblContractEnd.Text = empData.ContractEnd.Value.ToString(@"dd\/MM\/yyyy");
}
}
}
private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
if (empData != null)
{
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractStart != null)
{
lblContractStart.Text = empData.ContractStart.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractEnd != null)
{
lblContractEnd.Text = empData.ContractEnd.Value.ToString(@"dd\/MM\/yyyy");
}
lblFirstManager.Text = string.IsNullOrWhiteSpace(empData.FirstManager) ?
" (First Manager)" : empData.FirstManager.Trim() + " (First Manager)";
lblSecondManager.Text = string.IsNullOrWhiteSpace(empData.SecondManager) ?
" (Second Manager)" : empData.SecondManager.Trim() + " (Second Manager)";
hdfFirstManager.Value = empData.FirstManager;
hdfSecondManager.Value = empData.SecondManager;
hdfFirstManagerMail.Value = empData.FirstManagerMail;
}
}
private void BindingGrid()
{
try
{
string sName = string.Empty;
string sEmpID = string.Empty;
string sCompany = string.Empty;
string sDepartment = string.Empty;
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
sName = txtEmpName.Text.Trim();
}
if (!string.IsNullOrEmpty(txtEmpID.Text.Trim()))
{
sEmpID = txtEmpID.Text.Trim();
}
if (ddlCompany.SelectedIndex > 0)
{
sCompany = ddlCompany.SelectedValue.Trim();
}
if (ddlDepartment.SelectedIndex > 0)
{
sDepartment = ddlDepartment.SelectedItem.ToString().Trim();
}
EmployeeMaster_Manage manager = new EmployeeMaster_Manage();
List <Inf_TaskListData> lEmployee = new List <Inf_TaskListData>();
string _DomainName = hdfUserLogin.Value.Trim();
HREmployee_Manage manage = new HREmployee_Manage();
HREmployee hrData = new HREmployee();
string _EmployeeID = hdfUserLoginID.Value.Trim();
hrData = manage.GetHREmployeeData(_EmployeeID);
if (hrData != null && !string.IsNullOrEmpty(hrData.EmployeeID))
{
//For search all data
_DomainName = string.Empty;
}
lEmployee = manager.ListAppraisalHistory(_DomainName);
if (!string.IsNullOrEmpty(sName))
{
lEmployee = lEmployee.Where(c => c.EmployeeName.Contains(sName)).ToList();
}
if (!string.IsNullOrEmpty(sEmpID))
{
lEmployee = lEmployee.Where(c => c.EmployeeID.Contains(sEmpID)).ToList();
}
if (!string.IsNullOrEmpty(sCompany))
{
lEmployee = lEmployee.Where(c => c.CompanyID.Contains(sCompany)).ToList();
}
if (!string.IsNullOrEmpty(sDepartment))
{
lEmployee = lEmployee.Where(c => c.DepartmentName.Contains(sDepartment)).ToList();
}
gvEmployee.DataSource = lEmployee;
gvEmployee.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void InitialEmpDetail()
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
EmployeeMaster empData = new EmployeeMaster();
empData = manage.GetData(hdfEmployeeID.Value.Trim());
if (empData != null)
{
//============ For Check Employee Group for Contract =====//
hdfEmployeeType.Value = empData.EmployeeType;
//========================================================//
lblEmployeeName.Text = empData.EmployeeName;
lblDepartment.Text = empData.DepartmentName;
lblPosition.Text = empData.Position;
hdfCompanyID.Value = empData.CompanyID;
hdfSecondManager.Value = empData.SecondManager;
hdfFirstManager.Value = empData.FirstManager;
hdfFirstManagerMail.Value = empData.FirstManagerMail;
hdfSecondManagerMail.Value = empData.SecondManagerMail;
if (empData.StartDate != null)
{
lblJoinDate.Text = empData.StartDate.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractStart != null)
{
lblContractStart.Text = empData.ContractStart.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractEnd != null)
{
lblContractEnd.Text = empData.ContractEnd.Value.ToString(@"dd\/MM\/yyyy");
}
if (!string.IsNullOrEmpty(empData.AppraisalYear))
{
if (empData.EmployeeType.Trim().Equals("1"))
{
lblDateFrom.Text = "01/01/" + empData.AppraisalYear;
lblDateTo.Text = "31/12/" + empData.AppraisalYear;
}
else
{
if (empData.ContractStart != null)
{
lblDateFrom.Text = empData.ContractStart.Value.ToString(@"dd\/MM\/yyyy");
}
if (empData.ContractEnd != null)
{
lblDateTo.Text = empData.ContractEnd.Value.ToString(@"dd\/MM\/yyyy");
}
}
//**** Check for link appraisal no data (old llink)*******//
string _year = DateTime.Now.Year.ToString();
if (empData.AppraisalYear.Trim() != _year)
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
//********************************************************//
}
else
{
//**** Check for link appraisal no data (old llink)*******//
if (string.IsNullOrEmpty(empData.AppraisalYear) || string.IsNullOrEmpty(empData.HRStaff))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
//********************************************************//
}
}
else
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
List <EmployeeMaster> lData = new List <EmployeeMaster>();
foreach (GridViewRow row in gvEmployee.Rows)
{
CheckBox chkSelect = row.FindControl("chkSelect") as CheckBox;
if (chkSelect.Checked)
{
EmployeeMaster data = new EmployeeMaster();
HiddenField hdfFirstManager = row.FindControl("hdfFirstManager") as HiddenField;
HiddenField hdfSecondManager = row.FindControl("hdfSecondManager") as HiddenField;
HiddenField hdfEmployeeID = row.FindControl("hdfEmployeeID") as HiddenField;
HiddenField hdfFirstManagerMail = row.FindControl("hdfFirstManagerMail") as HiddenField;
HiddenField hdfSecondManagerMail = row.FindControl("hdfSecondManagerMail") as HiddenField;
HiddenField hdfEmployeeName = row.FindControl("hdfEmployeeName") as HiddenField;
HiddenField hdfPosition = row.FindControl("hdfPosition") as HiddenField;
data.EmployeeID = hdfEmployeeID.Value;
data.FirstManager = hdfFirstManager.Value;
data.SecondManager = hdfSecondManager.Value;
data.HRStaff = hdfUserLogin.Value;
data.CreatedBy = hdfUserLogin.Value;
data.CreatedDate = DateTime.Now;
data.FirstManagerMail = hdfFirstManagerMail.Value.Trim();
data.SecondManagerMail = hdfSecondManagerMail.Value.Trim();
data.EmployeeName = hdfEmployeeName.Value;
data.AppraisalYear = DateTime.Now.Year.ToString();
data.Position = hdfPosition.Value;
lData.Add(data);
}
}
if (lData != null && lData.Count > 0)
{
EmployeeMaster_Manage manage = new EmployeeMaster_Manage();
bool ret = manage.UpdateEmployeeMaster(lData);
if (ret)
{
lblMsgResult.Text = "บันทึกข้อมูลเรียบร้อย";
lbtnPopup_ModalPopupExtender.Show();
SendEamilTo1stManager(lData);
}
else
{
lblMsgResult.Text = "ไม่สามารถบันทึกข้อมูลได้";
btnOK.Visible = false;
btnCancel.Visible = true;
lbtnPopup_ModalPopupExtender.Show();
}
}
else
{
lblMsgResult.Text = "กรุณาเลือกพนักงานที่ต้องการประเมิน";
btnOK.Visible = false;
btnCancel.Visible = true;
lbtnPopup_ModalPopupExtender.Show();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void BindingGrid()
{
try
{
string sName = string.Empty;
string sEmpID = string.Empty;
string sCompany = string.Empty;
string sDepartment = string.Empty;
if (!string.IsNullOrEmpty(txtEmpName.Text.Trim()))
{
sName = txtEmpName.Text.Trim();
}
if (!string.IsNullOrEmpty(txtEmpID.Text.Trim()))
{
sEmpID = txtEmpID.Text.Trim();
}
if (ddlCompany.SelectedIndex > 0)
{
sCompany = ddlCompany.SelectedValue.Trim();
}
if (ddlDepartment.SelectedIndex > 0)
{
sDepartment = ddlDepartment.SelectedItem.ToString().Trim();
}
List <Inf_TaskListData> lEmployee = new List <Inf_TaskListData>();
EmployeeMaster_Manage manager = new EmployeeMaster_Manage();
lEmployee = manager.ListTaskEmployeeData(hdfUserLogin.Value.Trim());
if (!string.IsNullOrEmpty(sName))
{
lEmployee = lEmployee.Where(c => c.EmployeeName.Contains(sName)).ToList();
}
if (!string.IsNullOrEmpty(sEmpID))
{
lEmployee = lEmployee.Where(c => c.EmployeeID.Contains(sEmpID)).ToList();
}
if (!string.IsNullOrEmpty(sCompany))
{
lEmployee = lEmployee.Where(c => c.CompanyID.Contains(sCompany)).ToList();
}
if (!string.IsNullOrEmpty(sDepartment))
{
lEmployee = lEmployee.Where(c => c.DepartmentName.Contains(sDepartment)).ToList();
}
foreach (var item in lEmployee)
{
if (string.IsNullOrEmpty(item.AppraisalStatus))
{
item.AppraisalStatus = "Waiting 1st Manager Approve";
}
}
gvEmployee.DataSource = lEmployee;
gvEmployee.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
