private void CheckStateActionHistory()
{
try
{
if (string.IsNullOrEmpty(hdfAppraisalStatus.Value.Trim()) ||
!hdfAppraisalStatus.Value.Trim().Equals("Rejected"))
{
ActionHistory_Manage hisManage = new ActionHistory_Manage();
List <ActionHistory> lResult = new List <ActionHistory>();
lResult = hisManage.ListActionHistory(hdfEmployeeID.Value.Trim(), DateTime.Now.Year);
if (lResult != null && lResult.Count > 0)
{
string FirstManager = (string.IsNullOrEmpty(hdfFirstManager.Value.Trim()) ? "" : hdfFirstManager.Value.Trim());
string SecondManager = (string.IsNullOrEmpty(hdfSecondManager.Value.Trim()) ? "" : hdfSecondManager.Value.Trim());
foreach (var item in lResult)
{
string _status = string.IsNullOrWhiteSpace(item.Status) ? "" : item.Status.Trim();
/* Check status of First Manager */
if (item.Responsibility.Trim().Equals("FirstManager") && (_status == ""))
{
lblFirstManager.ForeColor = System.Drawing.Color.Green;
}
/* Check status of Seccound Manager */
if (item.Responsibility.Trim().Equals("SecondManager") && (_status == ""))
{
lblSecondManager.ForeColor = System.Drawing.Color.Green;
}
}
}
}
else
{
if (hdfAppraisalStatus.Value.Trim().Equals("Rejected"))
{
lblFirstManager.ForeColor = System.Drawing.Color.Green;
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void DisableButton()
{
ActionHistory_Manage manage = new ActionHistory_Manage();
List <ActionHistory> lData = new List <ActionHistory>();
lData = manage.ListActionHistory(hdfEmployeeID.Value.Trim(), DateTime.Now.Year);
if (lData != null && lData.Count > 0)
{
ActionHistory data = lData.Where(c => c.Responsibility == "Creator").FirstOrDefault();
lblCreator.Text = string.IsNullOrEmpty(data.CreatedBy) ? "(Creator)" : data.CreatedBy + " (Creator)";
btnSubmit.Visible = false;
}
else
{
lblCreator.Text = "(Creator)";
btnSubmit.Visible = true;
}
}
protected void gvAttachFile_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Delete"))
{
if (e.CommandName.Equals("Delete"))
{
string filePath = string.Empty;
string fileName = string.Empty;
string empID = string.Empty;
string[] arg = new string[2];
arg = e.CommandArgument.ToString().Split(';');
filePath = arg[0];
empID = arg[1];
fileName = Path.GetFileName(filePath);
if (!string.IsNullOrWhiteSpace(filePath))
{
if (System.IO.File.Exists(Server.MapPath(filePath)))
{
System.IO.File.Delete(Server.MapPath(filePath));
}
}
if (!string.IsNullOrEmpty(fileName))
{
ActionHistory_Manage manage = new ActionHistory_Manage();
bool result = manage.DeleteFileAttachment(empID, fileName);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetAppraisalHeader()
{
AppraisalDocHeader_Manage manage = new AppraisalDocHeader_Manage();
AppraisalDocHeader docHead = new AppraisalDocHeader();
docHead = manage.GetData(hdfEmployeeID.Value.Trim(), DateTime.Now.Year);
if (docHead != null)
{
//**** For Check Duplicate Job ****//
if (docHead.AppraisalStatus.Trim().ToLower().Equals("completed"))
{
btnSubmit.Visible = false;
btnReject.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
if (docHead.AppraisalStatus.Trim().Equals("Rejected"))
{
ActionHistory_Manage hm = new ActionHistory_Manage();
string _staus = hm.GetActionHistoryStatus(hdfAppraisalDocNo.Value.Trim(), "SecondManager");
if (string.IsNullOrEmpty(_staus))
{
btnSubmit.Visible = false;
btnReject.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
btnSubmit.Visible = true;
btnReject.Visible = true;
}
}
else
{
btnSubmit.Visible = true;
btnReject.Visible = true;
}
}
//*******************************//
lblAppraisalDocNo.Text = docHead.AppraisalDocNo;
hdfAppraisalDocNo.Value = docHead.AppraisalDocNo;
txtEmpStrength.Text = docHead.EmployeeStrength.Trim();
txtEmpImpovement.Text = docHead.EmployeeImprovement.Trim();
if (docHead.AppraisalPeriodFrom != null)
{
lblDateFrom.Text = docHead.AppraisalPeriodFrom.Value.ToString(@"dd\/MM\/yyyy");
}
if (docHead.AppraisalPeriodTo != null)
{
lblDateTo.Text = docHead.AppraisalPeriodTo.Value.ToString(@"dd\/MM\/yyyy");
}
lblResultScore.Text = string.IsNullOrEmpty(docHead.AppraisalGrade) ? "" : "Band " + docHead.AppraisalGrade.Trim();
}
else
{
lblAppraisalDocNo.Text = "(Creator)";
//********** Check case click link from old email ***//
btnSubmit.Visible = false;
btnReject.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
//***************************************************//
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
/*********************************************************/
/************* Creaete Object Appraisal Doc Line *********/
/*********************************************************/
List <AppraisalDocLine> lDoclineData = new List <AppraisalDocLine>();
/****************** Gridview Part 1 **********************/
int iAppraisalDocLineNo = 1;
foreach (GridViewRow row in gvAppraisalPart1.Rows)
{
Label lblPart1Score = row.FindControl("lblPart1Score") as Label;
string sScore = lblPart1Score.Text.Trim();
DropDownList ddlPart1Result = row.FindControl("ddlPart1Result") as DropDownList;
string sAgreeReqult = ddlPart1Result.SelectedValue;
TextBox txtPart1Comment = row.FindControl("txtPart1Comment") as TextBox;
string sComment = txtPart1Comment.Text;
HiddenField hdfPart1QuestionDesc = row.FindControl("hdfPart1QuestionDesc") as HiddenField;
HiddenField hdfPart1QuestionLineNo = row.FindControl("hdfPart1QuestionLineNo") as HiddenField;
HiddenField hdfPart1QuestionType = row.FindControl("hdfPart1QuestionType") as HiddenField;
HiddenField hdfPart1QuestionWeight = row.FindControl("hdfPart1QuestionWeight") as HiddenField;
AppraisalDocLine itemPart1 = new AppraisalDocLine();
itemPart1.AppraisalDocNo = hdfAppraisalDocNo.Value.Trim();
itemPart1.AppraisalDocLineNo = iAppraisalDocLineNo;
itemPart1.Score = string.IsNullOrEmpty(sAgreeReqult) ? 0 : Convert.ToInt16(sAgreeReqult);
itemPart1.QuestionLineNo = Convert.ToInt16(hdfPart1QuestionLineNo.Value);
itemPart1.QuestionDesc = hdfPart1QuestionDesc.Value;
itemPart1.QuestionType = Convert.ToInt16(hdfPart1QuestionType.Value);
itemPart1.CalculatedScore = string.IsNullOrEmpty(sScore) ? 0 : Convert.ToDecimal(sScore);
itemPart1.QuestionWeight = string.IsNullOrEmpty(hdfPart1QuestionWeight.Value) ? 0 : Convert.ToDecimal(hdfPart1QuestionWeight.Value);
itemPart1.Remark = sComment;
lDoclineData.Add(itemPart1);
iAppraisalDocLineNo += 1;
}
/*********************************************************/
/***************** Gridview Part 2 ***********************/
foreach (GridViewRow row in gvAppraisalPart2.Rows)
{
Label lblPart1Score = row.FindControl("lblPart2Score") as Label;
string sScore = lblPart1Score.Text.Trim();
DropDownList ddlPart2Result = row.FindControl("ddlPart2Result") as DropDownList;
string sAgreeReqult = ddlPart2Result.SelectedValue;
TextBox txtPart1Comment = row.FindControl("txtPart2Comment") as TextBox;
string sComment = txtPart1Comment.Text;
HiddenField hdfPart2QuestionDesc = row.FindControl("hdfPart2QuestionDesc") as HiddenField;
HiddenField hdfPart2QuestionLineNo = row.FindControl("hdfPart2QuestionLineNo") as HiddenField;
HiddenField hdfPart2QuestionType = row.FindControl("hdfPart2QuestionType") as HiddenField;
HiddenField hdfPart2QuestionWeight = row.FindControl("hdfPart2QuestionWeight") as HiddenField;
AppraisalDocLine itemPart2 = new AppraisalDocLine();
itemPart2.AppraisalDocNo = hdfAppraisalDocNo.Value.Trim();
itemPart2.AppraisalDocLineNo = iAppraisalDocLineNo;
itemPart2.Score = string.IsNullOrEmpty(sAgreeReqult) ? 0 : Convert.ToInt16(sAgreeReqult);
itemPart2.QuestionLineNo = Convert.ToInt16(hdfPart2QuestionLineNo.Value);
itemPart2.QuestionDesc = hdfPart2QuestionDesc.Value;
itemPart2.QuestionType = Convert.ToInt16(hdfPart2QuestionType.Value);
itemPart2.CalculatedScore = string.IsNullOrEmpty(sScore) ? 0 : Convert.ToDecimal(sScore);
itemPart2.QuestionWeight = string.IsNullOrEmpty(hdfPart2QuestionWeight.Value) ? 0 : Convert.ToDecimal(hdfPart2QuestionWeight.Value);
itemPart2.Remark = sComment;
lDoclineData.Add(itemPart2);
iAppraisalDocLineNo += 1;
}
/***************** Set Grade & Score ********************/
int TotalScore = 0;
string gradeResult = "";
gradeResult = CalculateGrade(lDoclineData, ref TotalScore);
AppraisalDocHeader docHeaderData = new AppraisalDocHeader();
docHeaderData.AppraisalDate = DateTime.Now;
if (!string.IsNullOrEmpty(lblDateFrom.Text.Trim()))
{
docHeaderData.AppraisalPeriodFrom = DateTime.ParseExact(lblDateFrom.Text.Trim(), "dd/MM/yyyy", null);
}
if (!string.IsNullOrEmpty(lblDateTo.Text.Trim()))
{
docHeaderData.AppraisalPeriodTo = DateTime.ParseExact(lblDateTo.Text.Trim(), "dd/MM/yyyy", null);
}
docHeaderData.AppraisalStatus = "Waiting 2nd Manager Approve";
docHeaderData.AppraisalDocNo = hdfAppraisalDocNo.Value.Trim();
docHeaderData.AppraisalTotalScore = TotalScore;
docHeaderData.AppraisalGrade = gradeResult;
docHeaderData.EmployeeStrength = txtEmpStrength.Text;
docHeaderData.EmployeeImprovement = txtEmpImpovement.Text;
ActionHistory updActHisData = new ActionHistory();
updActHisData.EmployeeID = hdfEmployeeID.Value.Trim();
updActHisData.CreatedBy = hdfUserLogin.Value.Trim();
updActHisData.AppraisalDocNo = hdfAppraisalDocNo.Value.Trim();
updActHisData.Status = "Approved";
updActHisData.Comments = txtRemark.Text;
updActHisData.AppraisalYear = DateTime.Now.Year;
ApprovalHistory insAppHis = new ApprovalHistory();
insAppHis.Action = "Approve";
insAppHis.AppraisalDocNo = hdfAppraisalDocNo.Value.Trim();
insAppHis.Comment = txtRemark.Text;
insAppHis.TransactionDate = DateTime.Now;
insAppHis.UserID = hdfUserLogin.Value.Trim();
//***************** List Attach File for insert to Database *********
List <Attachment> lAttachFile = new List <Attachment>();
DataTable dtUpload = (DataTable)Session["tbAttachFile"];
if (dtUpload != null && dtUpload.Rows.Count > 0)
{
for (int i = 0; i < dtUpload.Rows.Count; i++)
{
Attachment attachData = new Attachment();
attachData.FileName = dtUpload.Rows[i]["FileName"].ToString();
attachData.EmployeeID = dtUpload.Rows[i]["EmployeeID"].ToString();
attachData.FileDescription = dtUpload.Rows[i]["Description"].ToString();
attachData.Attachment1 = dtUpload.Rows[i]["AttachFilePath"].ToString();
attachData.CreatedDate = DateTime.Now;
attachData.CreatedBy = hdfUserLogin.Value.Trim();
lAttachFile.Add(attachData);
}
}
//**********************************************************************
/*** Insert History and Generate Next For Approve **/
ActionHistory_Manage updHistoryManage = new ActionHistory_Manage();
bool updActionHis = updHistoryManage.InsertAndUpdHistoryReject(docHeaderData, updActHisData,
insAppHis, lDoclineData, lAttachFile);
if (updActionHis)
{
lblMsgResult.Text = "บันทึกข้อมูลเรียบร้อย";
lbtnPopup_ModalPopupExtender.Show();
string sSubjectMail = ConfigurationManager.GetConfiguration().SubjectMailApprove;
string sEmailFrom = ConfigurationManager.GetConfiguration().EmailFrom;
string reqDate = DateTime.Now.ToString(@"dd\/MM\/yyyy");
string Email2ndManager = hdfSecondManagerMail.Value.Trim();
if (!string.IsNullOrEmpty(Email2ndManager))
{
string _employeeName = lblEmployeeName.Text;
string emaiBody = GenEmailBody(hdfEmployeeID.Value.Trim(), hdfSecondManager.Value.Trim(),
hdfUserLogin.Value.Trim(), reqDate, _employeeName,
lblPosition.Text.Trim(), "Waiting 2nd Manager Approve", hdfFirstManagerName.Value.Trim());
SendMail2ndManager(sSubjectMail, emaiBody, Email2ndManager, sEmailFrom);
}
}
else
{
lblMsgResult.Text = "ไม่สามารถบันทึกข้อมูลได้";
btnOK.Visible = false;
btnCancel.Visible = true;
lbtnPopup_ModalPopupExtender.Show();
}
/****************************************************/
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
//*** Show Popup When Error (Exception) *****
lblMsgResult.Text = "ไม่สามารถบันทึกข้อมูลได้ กรุณาติดต่อผู้ดูแลระบบ";
btnOK.Visible = false;
btnCancel.Visible = true;
lbtnPopup_ModalPopupExtender.Show();
//*********************************
}
}
private void GetAppraisalHeader()
{
try
{
AppraisalDocHeader_Manage manage = new AppraisalDocHeader_Manage();
AppraisalDocHeader docHead = new AppraisalDocHeader();
docHead = manage.GetData(hdfEmployeeID.Value.Trim(), DateTime.Now.Year);
if (docHead != null)
{
hdfAppraisalDocNo.Value = string.IsNullOrEmpty(docHead.AppraisalDocNo) ? "" : docHead.AppraisalDocNo.Trim();
hdfStatus.Value = string.IsNullOrEmpty(docHead.AppraisalStatus) ? "" : docHead.AppraisalStatus.Trim();
lblAppraisalDocNo.Text = hdfAppraisalDocNo.Value.Trim();
string _EmployeeType = hdfEmployeeType.Value.Trim();
//**********************************************************
if (docHead.AppraisalPeriodFrom != null)
{
lblDateFrom.Text = docHead.AppraisalPeriodFrom.Value.ToString(@"dd\/MM\/yyyy");
}
else
{
if (_EmployeeType.Equals("1"))
{
lblDateFrom.Text = "01/01/" + DateTime.Now.Year.ToString();
}
else
{
lblDateFrom.Text = lblContractStart.Text.Trim();
}
}
if (docHead.AppraisalPeriodTo != null)
{
lblDateTo.Text = docHead.AppraisalPeriodTo.Value.ToString(@"dd\/MM\/yyyy");
}
else
{
if (_EmployeeType.Equals("1"))
{
lblDateTo.Text = "31/12/" + DateTime.Now.Year.ToString();
}
else
{
lblDateTo.Text = lblContractEnd.Text.Trim();
}
}
//********************************************************
txtEmpStrength.Text = docHead.EmployeeStrength;
txtEmpImpovement.Text = docHead.EmployeeImprovement;
lblResultScore.Text = string.IsNullOrEmpty(docHead.AppraisalGrade) ? "" : "Band " + docHead.AppraisalGrade;
if (docHead.AppraisalStatus.Trim().ToLower().Equals("completed"))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
if (docHead.AppraisalStatus.Trim().Equals("Waiting 2nd Manager Approve"))
{
ActionHistory_Manage hm = new ActionHistory_Manage();
string _staus = hm.GetActionHistoryStatus(hdfAppraisalDocNo.Value.Trim(), "FirstManager");
if (!string.IsNullOrEmpty(_staus) && _staus.Trim().Equals("Approved"))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
btnSubmit.Visible = true;
}
}
}
}
else
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetAppraisalHeader()
{
try
{
AppraisalDocHeader_Manage manage = new AppraisalDocHeader_Manage();
AppraisalDocHeader docHead = new AppraisalDocHeader();
docHead = manage.GetData(hdfEmployeeID.Value.Trim(), DateTime.Now.Year);
if (docHead != null)
{
string _DocNo = string.IsNullOrEmpty(docHead.AppraisalDocNo) ? "" : docHead.AppraisalDocNo.Trim();
hdfAppraisalDocNo.Value = _DocNo;
//**** For Check Duplicate Job ****//
if (!string.IsNullOrEmpty(_DocNo))
{
if (docHead.AppraisalStatus.ToLower().Trim().Equals("completed"))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
if (docHead.AppraisalStatus.Trim().Equals("Waiting 2nd Manager Approve"))
{
ActionHistory_Manage hm = new ActionHistory_Manage();
string _staus = hm.GetActionHistoryStatus(hdfAppraisalDocNo.Value.Trim(), "FirstManager");
if (!string.IsNullOrEmpty(_staus) && _staus.Trim().Equals("Approved"))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
btnSubmit.Visible = true;
}
}
else if (docHead.AppraisalStatus.Trim().Equals("Rejected"))
{
ActionHistory_Manage hm = new ActionHistory_Manage();
string _staus = hm.GetActionHistoryStatus(hdfAppraisalDocNo.Value.Trim(), "SecondManager");
if (string.IsNullOrEmpty(_staus))
{
btnSubmit.Visible = false;
lbtnPopupErr_ModalPopupExtender.Show();
}
else
{
btnSubmit.Visible = true;
}
}
else
{
btnSubmit.Visible = true;
}
}
}
//*******************************//
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
