public SystemMessage SaveEmployee(int roleId, int idTable, ApprovalHistory obj)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@IDofTable", obj.IDofTable);
param.Add("@TableName", obj.TableName.ToUpper());
param.Add("@Status", obj.Status);
param.Add("@SubmittedBy", obj.SubmittedBy);
param.Add("@SubmittedDate", obj.SubmittedDate);
param.Add("@Note", obj.Note);
param.Add("@AutoID", obj.AutoID, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("ApprovalHistory_Save", param);
systemMessage.IsSuccess = true;
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
public List <ApprovalHistory> GetApprovalHistory(Guid DocumentID, string DocumentTypeCode)
{
List <ApprovalHistory> approvalHistoryList = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetDocumentApprovalHistory]";
cmd.Parameters.Add("@DocumentID", SqlDbType.UniqueIdentifier).Value = DocumentID;
cmd.Parameters.Add("@DocumentTypeCode", SqlDbType.NVarChar, 5).Value = DocumentTypeCode;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
approvalHistoryList = new List <ApprovalHistory>();
while (sdr.Read())
{
ApprovalHistory approvalHistory = new ApprovalHistory();
{
approvalHistory.ApproverID = (sdr["ApproverID"].ToString() != "" ? Guid.Parse(sdr["ApproverID"].ToString()) : approvalHistory.ApproverID);
approvalHistory.ApprovalDate = (sdr["ApprovalDate"].ToString() != "" ? DateTime.Parse(sdr["ApprovalDate"].ToString()).ToString(settings.DateFormat) : approvalHistory.ApprovalDate);
approvalHistory.ApproverLevel = (sdr["ApproverLevel"].ToString() != "" ? sdr["ApproverLevel"].ToString() : approvalHistory.ApproverLevel);
approvalHistory.ApproverName = (sdr["ApproverName"].ToString() != "" ? sdr["ApproverName"].ToString() : approvalHistory.ApproverName);
approvalHistory.Remarks = (sdr["Remarks"].ToString() != "" ? sdr["Remarks"].ToString() : approvalHistory.Remarks);
approvalHistory.ApprovalStatus = (sdr["ApprovalStatus"].ToString() != "" ? sdr["ApprovalStatus"].ToString() : approvalHistory.ApprovalStatus);
}
approvalHistoryList.Add(approvalHistory);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(approvalHistoryList);
}
public Result AddApprovalHistory(ApprovalHistory objApprovalHistory, string siteUrl)
{
Result res = new Result();
try
{
res = CRUDOperations.AddListItem <ApprovalHistory>(Lists.Lists.ApprovalHistory, objApprovalHistory);
res.StatusCode = StatusCode.Success;
res.Message = Messages.MsgSuccessAdd;
return(res);
}
catch (Exception ex)
{
string guid = RestAPI.WriteException(ex, MethodBase.GetCurrentMethod().Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
res.Message = Messages.MsgSomethingWentWrong;
res.StatusCode = StatusCode.Error;
return(res);
}
}
public ApprovalHistory GetApprovalHistoryData(string AppraisalDocNo)
{
ApprovalHistory retDet = new ApprovalHistory();
try
{
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
var getData = (from r in entity.ApprovalHistories select r).Where(t => t.AppraisalDocNo == AppraisalDocNo).FirstOrDefault();
retDet = getData;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(retDet);
}
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
if (e.Item.Text == @"Accept" && !string.IsNullOrEmpty(hfId.Value))
{
if (IsValid)
{
var type = Convert.ToInt32(hfType.Value);
var id = Convert.ToInt32(hfId.Value);
var cApprovalHistory = new CApprovalHistory();
var approvalHistory = new ApprovalHistory()
{
CreatedId = CurrentUserId,
CreatedDate = DateTime.Now,
ApprovalDate = DateTime.Now,
ApprovalMemo = tbRemark.Text,
ApproveType = type,
MenuSeqId = id,
ApprovalUser = CurrentUserId,
IsApprovalRequest = true,
ApprovalStep = (int)CConstValue.ApprovalStatus.InProgress
};
if (type == (int)CConstValue.Approval.CorporateCreditCard)
{
try
{
var cCorporateCreditCard = new CCorporateCreditCard();
var corporateCreditCard = cCorporateCreditCard.Get(id);
corporateCreditCard.ApprovalDate = approvalHistory.ApprovalDate;
corporateCreditCard.ApprovalId = approvalHistory.ApprovalUser;
corporateCreditCard.ApprovalMemo = approvalHistory.ApprovalMemo;
corporateCreditCard.ApprovalStatus = approvalHistory.ApprovalStep;
cCorporateCreditCard.Update(corporateCreditCard);
RunClientScript("Close();");
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
// BusinessTrip
if (type == (int)CConstValue.Approval.BusinessTrip)
{
try
{
var cBusinessTrip = new CBusinessTrip();
var businessTrip = cBusinessTrip.Get(id);
businessTrip.ApprovalDate = approvalHistory.ApprovalDate;
businessTrip.ApprovalId = approvalHistory.ApprovalUser;
businessTrip.ApprovalMemo = approvalHistory.ApprovalMemo;
businessTrip.ApprovalStatus = approvalHistory.ApprovalStep;
cBusinessTrip.Update(businessTrip);
RunClientScript("Close();");
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
// Expense Program
else if (type == (int)CConstValue.Approval.Expense)
{
try
{
var cExpense = new CExpense();
var expense = cExpense.Get(id);
expense.ApprovalDate = approvalHistory.ApprovalDate;
expense.ApprovalId = approvalHistory.ApprovalUser;
expense.ApprovalMemo = approvalHistory.ApprovalMemo;
expense.ApprovalStatus = approvalHistory.ApprovalStep;
cExpense.Update(expense);
RunClientScript("Close();");
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
// Purchase Order
else if (type == (int)CConstValue.Approval.PurchaseOrder)
{
try
{
// approved
approvalHistory.ApprovalStep = (int)CConstValue.ApprovalStatus.Approved;
var cPurchaseOrder = new CPurchaseOrder();
var purchaseOrder = cPurchaseOrder.Get(id);
purchaseOrder.ApprovalDate = approvalHistory.ApprovalDate;
purchaseOrder.ApprovalId = approvalHistory.ApprovalUser;
purchaseOrder.ApprovalMemo = approvalHistory.ApprovalMemo;
purchaseOrder.ApprovalStatus = approvalHistory.ApprovalStep;
cPurchaseOrder.Update(purchaseOrder);
RunClientScript("Close();");
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
// update approvalHistory
cApprovalHistory.Add(approvalHistory);
new CMail().SendMail((CConstValue.Approval)type, CConstValue.MailStatus.ToRequestUser, id, string.Empty, CurrentUserId);
}
}
}
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();
//*********************************
}
}
/// <summary>
/// 修改审批历史
/// </summary>
/// <param name="approvalHistory"></param>
/// <returns></returns>
public int UpdateApprovalHistory(ApprovalHistory approvalHistory)
{
throw new NotImplementedException();
}
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
if (e.Item.Text == "Cancel" && !string.IsNullOrEmpty(hfId.Value))
{
if (IsValid)
{
try
{
var type = Convert.ToInt32(hfType.Value);
var id = Convert.ToInt32(hfId.Value);
var cApprovalHistory = new CApprovalHistory();
var approvalHistory = cApprovalHistory.Get(type, id, CurrentUserId);
bool isExists = true;
if (approvalHistory == null)
{
approvalHistory = new ApprovalHistory();
approvalHistory.ApprovalUser = CurrentUserId;
isExists = false;
}
approvalHistory.ApprovalDate = DateTime.Now;
approvalHistory.ApprovalMemo = tbRemark.Text;
approvalHistory.ApprovalStep = (int)CConstValue.ApprovalStatus.Canceled;
// update approvalHistory
if (isExists)
{
cApprovalHistory.Update(approvalHistory);
}
if (type == (int)CConstValue.Approval.Refund)
{
var cRefund = new CRefund();
var refund = cRefund.Get(id);
refund.ApprovalDate = approvalHistory.ApprovalDate;
refund.ApprovalId = approvalHistory.ApprovalUser;
refund.ApprovalMemo = approvalHistory.ApprovalMemo;
refund.ApprovalStatus = approvalHistory.ApprovalStep;
if (cRefund.Update(refund))
{
var cInvoiceInfo = new CInvoice();
var invoiceInfo = cInvoiceInfo.Get(refund.InvoiceId);
var cOriginalInvoiceInfo = new CInvoice();
var originalInvoiceInfo = cOriginalInvoiceInfo.Get(Convert.ToInt32(invoiceInfo.OriginalInvoiceId));
invoiceInfo.Status = (int)CConstValue.InvoiceStatus.Cancelled_RF; // Canceled_R
invoiceInfo.UpdatedId = CurrentUserId;
originalInvoiceInfo.Status = (int)CConstValue.InvoiceStatus.Invoiced; // Invoiced
originalInvoiceInfo.UpdatedId = CurrentUserId;
cInvoiceInfo.Update(invoiceInfo);
cOriginalInvoiceInfo.Update(originalInvoiceInfo);
}
}
else if (type == (int)CConstValue.Approval.Agency)
{
var cAgency = new CAgency();
var agency = cAgency.Get(id);
agency.ApprovalDate = approvalHistory.ApprovalDate;
agency.ApprovalId = approvalHistory.ApprovalUser;
agency.ApprovalMemo = approvalHistory.ApprovalMemo;
agency.ApprovalStatus = approvalHistory.ApprovalStep;
cAgency.Update(agency);
}
else if (type == (int)CConstValue.Approval.CreditMemoPayout)
{
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(id);
creditMemoPayout.ApprovalDate = approvalHistory.ApprovalDate;
creditMemoPayout.ApprovalId = approvalHistory.ApprovalUser;
creditMemoPayout.ApprovalMemo = approvalHistory.ApprovalMemo;
creditMemoPayout.ApprovalStatus = approvalHistory.ApprovalStep;
cCreditMemoPayout.Update(creditMemoPayout);
}
else if (type == (int)CConstValue.Approval.Package)
{
var cPackageProgram = new CPackageProgram();
var packageProgram = cPackageProgram.GetPackageProgram(id);
packageProgram.ApprovalDate = approvalHistory.ApprovalDate;
packageProgram.ApprovalId = approvalHistory.ApprovalUser;
packageProgram.ApprovalMemo = approvalHistory.ApprovalMemo;
packageProgram.ApprovalStatus = approvalHistory.ApprovalStep;
cPackageProgram.Update(packageProgram);
}
else if (type == (int)CConstValue.Approval.Promotion)
{
var cPromotion = new CPromotion();
var promotion = cPromotion.Get(id);
promotion.ApprovalDate = approvalHistory.ApprovalDate;
promotion.ApprovalId = approvalHistory.ApprovalUser;
promotion.ApprovalMemo = approvalHistory.ApprovalMemo;
promotion.ApprovalStatus = approvalHistory.ApprovalStep;
cPromotion.Update(promotion);
}
else if (type == (int)CConstValue.Approval.Scholarship)
{
var cScholarship = new CScholarship();
var scholarship = cScholarship.Get(id);
scholarship.ApprovalDate = approvalHistory.ApprovalDate;
scholarship.ApprovalId = approvalHistory.ApprovalUser;
scholarship.ApprovalMemo = approvalHistory.ApprovalMemo;
scholarship.ApprovalStatus = approvalHistory.ApprovalStep;
cScholarship.Update(scholarship);
}
else if (type == (int)CConstValue.Approval.CorporateCreditCard)
{
var cCorporateCreditCard = new CCorporateCreditCard();
var corporateCreditCard = cCorporateCreditCard.Get(id);
corporateCreditCard.ApprovalDate = approvalHistory.ApprovalDate;
corporateCreditCard.ApprovalId = approvalHistory.ApprovalUser;
corporateCreditCard.ApprovalMemo = approvalHistory.ApprovalMemo;
corporateCreditCard.ApprovalStatus = approvalHistory.ApprovalStep;
cCorporateCreditCard.Update(corporateCreditCard);
}
// BusinessTrip
else if (type == (int)CConstValue.Approval.BusinessTrip)
{
var cBusinessTrip = new CBusinessTrip();
var businessTrip = cBusinessTrip.Get(id);
businessTrip.ApprovalDate = approvalHistory.ApprovalDate;
businessTrip.ApprovalId = approvalHistory.ApprovalUser;
businessTrip.ApprovalMemo = approvalHistory.ApprovalMemo;
businessTrip.ApprovalStatus = approvalHistory.ApprovalStep;
cBusinessTrip.Update(businessTrip);
}
// Purchase Order
else if (type == (int)CConstValue.Approval.PurchaseOrder)
{
var cPurchaseOrder = new CPurchaseOrder();
var purchaseOrder = cPurchaseOrder.Get(id);
purchaseOrder.ApprovalDate = approvalHistory.ApprovalDate;
purchaseOrder.ApprovalId = approvalHistory.ApprovalUser;
purchaseOrder.ApprovalMemo = approvalHistory.ApprovalMemo;
purchaseOrder.ApprovalStatus = approvalHistory.ApprovalStep;
cPurchaseOrder.Update(purchaseOrder);
}
// Expense
else if (type == (int)CConstValue.Approval.Expense)
{
var cExpense = new CExpense();
var expense = cExpense.Get(id);
expense.ApprovalDate = approvalHistory.ApprovalDate;
expense.ApprovalId = approvalHistory.ApprovalUser;
expense.ApprovalMemo = approvalHistory.ApprovalMemo;
expense.ApprovalStatus = approvalHistory.ApprovalStep;
cExpense.Update(expense);
}
// Hire
else if (type == (int)CConstValue.Approval.Hire)
{
var cHire = new CHire();
var hire = cHire.Get(id);
hire.ApprovalDate = approvalHistory.ApprovalDate;
hire.ApprovalId = approvalHistory.ApprovalUser;
hire.ApprovalMemo = approvalHistory.ApprovalMemo;
hire.ApprovalStatus = approvalHistory.ApprovalStep;
cHire.Update(hire);
}
// Vacation
else if (type == (int)CConstValue.Approval.Vacation)
{
var cVacation = new CVacation();
var vacation = cVacation.Get(id);
vacation.ApprovalDate = approvalHistory.ApprovalDate;
vacation.ApprovalId = approvalHistory.ApprovalUser;
vacation.ApprovalMemo = approvalHistory.ApprovalMemo;
vacation.ApprovalStatus = approvalHistory.ApprovalStep;
cVacation.Update(vacation);
}
RunClientScript("Close();");
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
}
}
public bool UpdateAppraisalData(AppraisalDocHeader data, List <AppraisalDocLine> lData)
{
bool ret = false;
try
{
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
using (var dbTrans = entity.Database.BeginTransaction())
{
try
{
/**** Insert AppraisalDocHeader ******/
entity.AppraisalDocHeaders.Add(data);
entity.SaveChanges();
/*************************************/
/**** Insert AppraisalDocLine ******/
foreach (var item in lData)
{
entity.AppraisalDocLines.Add(item);
entity.SaveChanges();
}
/*************************************/
/***** Update table Action History *****/
var getData = (from t in entity.ActionHistories
where t.EmployeeID == data.EmployeeID && t.CreatedBy == data.CreatedBy && t.Status != "New Document"
select t).FirstOrDefault();
getData.Status = "Approved";
getData.AppraisalDocNo = data.AppraisalDocNo;
getData.Comments = "";
entity.SaveChanges();
/*****************************************/
/******* Insert ApprovalHistory *********/
ApprovalHistory dataAppHis = new ApprovalHistory();
dataAppHis.Action = "Approve";
dataAppHis.TransactionDate = data.CreatedDate;
dataAppHis.UserID = data.CreatedBy;
dataAppHis.Comment = "";
dataAppHis.AppraisalDocNo = data.AppraisalDocNo;
entity.ApprovalHistories.Add(dataAppHis);
entity.SaveChanges();
/****************************************/
dbTrans.Commit();
ret = true;
}
catch (Exception ex)
{
ret = false;
dbTrans.Rollback();
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(ret);
}
public bool Upd2ndManagerReject(AppraisalDocHeader data, string Remark, List <Attachment> lAttachFile)
{
bool ret = false;
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
using (var dbTrans = entity.Database.BeginTransaction())
{
try
{
/**** Update Approve AppraisalDocHeader ******/
var getData = (from t in entity.AppraisalDocHeaders
where t.AppraisalDocNo == data.AppraisalDocNo
select t).FirstOrDefault();
getData.AppraisalStatus = data.AppraisalStatus;
getData.CreatedDate = data.CreatedDate;
getData.CreatedBy = data.CreatedBy;
entity.SaveChanges();
/*****************************************/
/******* Update ActionHistory First Manager ******/
var getAct1stData = (from t in entity.ActionHistories
where t.EmployeeID == data.EmployeeID &&
t.Responsibility == "FirstManager" &&
t.AppraisalYear == DateTime.Now.Year &&
t.AppraisalDocNo == data.AppraisalDocNo
select t).FirstOrDefault();
//getAct1stData.AppraisalDocNo = data.AppraisalDocNo;
//getAct1stData.CreatedDate = data.CreatedDate;
//getAct1stData.CreatedBy = data.CreatedBy;
//getAct1stData.Comments = Remark;
getAct1stData.Status = null;
entity.SaveChanges();
/****************************************/
/******* Update ActionHistory Seccound Manager ******/
var getAct1ndData = (from t in entity.ActionHistories
where t.EmployeeID == data.EmployeeID &&
(t.Status == null || t.Status.Trim().Equals("Rejected")) &&
t.AppraisalYear == DateTime.Now.Year &&
t.Responsibility == "SecondManager" &&
t.AppraisalDocNo == data.AppraisalDocNo
select t).FirstOrDefault();
//getActionData.AppraisalDocNo = data.AppraisalDocNo;
//getActionData.CreatedDate = data.CreatedDate;
//getActionData.CreatedBy = data.CreatedBy;
getAct1ndData.Comments = Remark;
getAct1ndData.Status = "Rejected";
entity.SaveChanges();
/****************************************/
/******* Insert ApprovalHistory *********/
ApprovalHistory dataAppHis = new ApprovalHistory();
dataAppHis.Action = "Reject";
dataAppHis.TransactionDate = data.CreatedDate;
dataAppHis.UserID = data.CreatedBy;
dataAppHis.Comment = Remark;
dataAppHis.AppraisalDocNo = data.AppraisalDocNo;
entity.ApprovalHistories.Add(dataAppHis);
entity.SaveChanges();
/****************************************/
//**** Delete rows before insert******************//
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
var lRetAttach = entity.Attachments.Where(c => c.EmployeeID == item.EmployeeID &&
c.FileName == item.FileName).ToList();
if (lRetAttach.Count() > 0)
{
foreach (var iAttach in lRetAttach)
{
entity.Attachments.Remove(iAttach);
entity.SaveChanges();
}
}
}
}
//************************************************//
//***** Insert table Attachments ****************/
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
Attachment insAttachment = new Attachment();
insAttachment.FileName = item.FileName;
insAttachment.EmployeeID = item.EmployeeID;
insAttachment.FileDescription = item.FileDescription;
insAttachment.Attachment1 = item.Attachment1;
insAttachment.CreatedBy = item.CreatedBy;
insAttachment.CreatedDate = item.CreatedDate;
insAttachment.UpdatedBy = item.UpdatedBy;
insAttachment.UpdatedDate = item.UpdatedDate;
entity.Attachments.Add(insAttachment);
entity.SaveChanges();
}
}
//*****************************************/
dbTrans.Commit();
ret = true;
}
catch (Exception ex)
{
ret = false;
dbTrans.Rollback();
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
}
return(ret);
}
public bool InsertDocHeaderData(AppraisalDocHeader AppraisalData, List <Attachment> lAttachFile,
List <AppraisalDocLine> lAppraisalDocLine, ActionHistory updActHisData, ApprovalHistory insApprovalHis, ActionHistory ins2NdActHisData)
{
bool result = false;
Int64 retPK = 0;
try
{
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
using (var dbTrans = entity.Database.BeginTransaction())
{
try
{
//** Insert table AppraisalDocHeaders ****/
entity.AppraisalDocHeaders.Add(AppraisalData);
entity.SaveChanges();
retPK = AppraisalData.RowID;
//***************************************/
//**** Delete rows before insert******************//
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
var lRetAttach = entity.Attachments.Where(c => c.EmployeeID == AppraisalData.EmployeeID &&
c.FileName == item.FileName).ToList();
if (lRetAttach.Count() > 0)
{
foreach (var iAttach in lRetAttach)
{
entity.Attachments.Remove(iAttach);
entity.SaveChanges();
}
}
}
}
//************************************************//
//***** Insert table Attachments ****************/
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
Attachment insAttachment = new Attachment();
insAttachment.FileName = item.FileName;
insAttachment.EmployeeID = item.EmployeeID;
insAttachment.FileDescription = item.FileDescription;
insAttachment.Attachment1 = item.Attachment1;
insAttachment.CreatedBy = item.CreatedBy;
insAttachment.CreatedDate = item.CreatedDate;
insAttachment.UpdatedBy = item.UpdatedBy;
insAttachment.UpdatedDate = item.UpdatedDate;
entity.Attachments.Add(insAttachment);
entity.SaveChanges();
}
}
//*****************************************/
//************* Step 2 ********************//
if (retPK > 0)
{
string AppraisalDocNo = string.Empty;
AppraisalDocNo = GenerateDocNo(retPK.ToString());
if (!string.IsNullOrEmpty(AppraisalDocNo))
{
//---------- Update "DocNo" to AppraisalDocHeader -------//
var getData = (from t in entity.AppraisalDocHeaders
where t.RowID == retPK
select t).FirstOrDefault();
getData.AppraisalDocNo = AppraisalDocNo;
entity.SaveChanges();
//-------------------------------------------------------//
//-------------------- Insert AppraisalDocLine ----------//
foreach (var itemIns in lAppraisalDocLine)
{
itemIns.AppraisalDocNo = AppraisalDocNo;
entity.AppraisalDocLines.Add(itemIns);
entity.SaveChanges();
}
//-------------------------------------------------------//
//---------------- Insert & Update History -------------//
/***** Update table Action History *****/
var getActHistory = (from t in entity.ActionHistories
where t.EmployeeID == updActHisData.EmployeeID &&
t.CreatedBy == updActHisData.CreatedBy &&
t.Status != "New Document" &&
t.AppraisalYear == updActHisData.AppraisalYear
select t).FirstOrDefault();
getActHistory.Status = updActHisData.Status;
getActHistory.AppraisalDocNo = AppraisalDocNo;
getActHistory.Comments = updActHisData.Comments;
entity.SaveChanges();
/*****************************************/
/******* Insert Approval History *********/
insApprovalHis.AppraisalDocNo = AppraisalDocNo;
entity.ApprovalHistories.Add(insApprovalHis);
entity.SaveChanges();
/*****************************************/
/* Insert table Action History For Seccound Manager */
if (!string.IsNullOrEmpty(ins2NdActHisData.EmployeeID))
{
ins2NdActHisData.AppraisalDocNo = AppraisalDocNo;
entity.ActionHistories.Add(ins2NdActHisData);
entity.SaveChanges();
}
/*****************************************/
/***** Update table Employee Master *****/
var getEmpMasData = (from t in entity.EmployeeMasters
where t.EmployeeID == updActHisData.EmployeeID
select t).FirstOrDefault();
getEmpMasData.AppraisalDate = insApprovalHis.TransactionDate;
entity.SaveChanges();
/*****************************************/
}
}
dbTrans.Commit();
result = true;
}
catch (Exception ex)
{
result = false;
dbTrans.Rollback();
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
result = false;
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(result);
}
public bool InsertAndUpdHistory(ActionHistory updActionHis, ApprovalHistory insApprovalHis, ActionHistory insActionHis)
{
bool ret = false;
try
{
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
using (var dbTrans = entity.Database.BeginTransaction())
{
try
{
/***** Update table Action History *****/
var getData = (from t in entity.ActionHistories
where t.EmployeeID == updActionHis.EmployeeID &&
t.CreatedBy == updActionHis.CreatedBy &&
t.Status != "New Document" &&
t.AppraisalYear == updActionHis.AppraisalYear
select t).FirstOrDefault();
getData.Status = updActionHis.Status;
getData.AppraisalDocNo = updActionHis.AppraisalDocNo;
getData.Comments = updActionHis.Comments;
entity.SaveChanges();
/*****************************************/
/******* Insert Approval History *********/
entity.ApprovalHistories.Add(insApprovalHis);
entity.SaveChanges();
/*****************************************/
/* Insert table Action History For Seccound Manager */
if (!string.IsNullOrEmpty(insActionHis.EmployeeID))
{
entity.ActionHistories.Add(insActionHis);
entity.SaveChanges();
}
/*****************************************/
/***** Update table Employee Master *****/
var getEmpMasData = (from t in entity.EmployeeMasters
where t.EmployeeID == updActionHis.EmployeeID
select t).FirstOrDefault();
getEmpMasData.AppraisalDate = insApprovalHis.TransactionDate;
entity.SaveChanges();
/*****************************************/
dbTrans.Commit();
ret = true;
}
catch (Exception ex)
{
ret = false;
dbTrans.Rollback();
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(ret);
}
public bool InsertAndUpdHistoryReject(AppraisalDocHeader headerData, ActionHistory updActionHis,
ApprovalHistory insApprovalHis, List <AppraisalDocLine> lDoclineData,
List <Attachment> lAttachFile)
{
bool ret = false;
try
{
using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities())
{
using (var dbTrans = entity.Database.BeginTransaction())
{
try
{
/***** Update table AppraisalDocHeader *****/
var getHeaderData = (from t in entity.AppraisalDocHeaders
where t.AppraisalDocNo == headerData.AppraisalDocNo
select t).FirstOrDefault();
getHeaderData.AppraisalDate = headerData.AppraisalDate;
getHeaderData.AppraisalPeriodFrom = headerData.AppraisalPeriodFrom;
getHeaderData.AppraisalPeriodTo = headerData.AppraisalPeriodTo;
getHeaderData.AppraisalStatus = headerData.AppraisalStatus;
getHeaderData.AppraisalTotalScore = headerData.AppraisalTotalScore;
getHeaderData.AppraisalGrade = headerData.AppraisalGrade;
getHeaderData.EmployeeStrength = headerData.EmployeeStrength;
getHeaderData.EmployeeImprovement = headerData.EmployeeImprovement;
entity.SaveChanges();
/***********************************************/
/***** Update table ActionHistory 1st Manager Status *****/
var getActHis1stData = (from t in entity.ActionHistories
where t.EmployeeID == updActionHis.EmployeeID &&
t.Responsibility == "FirstManager" &&
t.AppraisalYear == updActionHis.AppraisalYear &&
t.AppraisalDocNo == updActionHis.AppraisalDocNo
select t).FirstOrDefault();
getActHis1stData.Status = updActionHis.Status;
getActHis1stData.Comments = updActionHis.Comments;
entity.SaveChanges();
/*****************************************/
/***** Update table ActionHistory 2nd Manager Status *****/
var getActHis2ndData = (from t in entity.ActionHistories
where t.EmployeeID == updActionHis.EmployeeID &&
t.Responsibility == "SecondManager" &&
t.AppraisalYear == updActionHis.AppraisalYear &&
t.AppraisalDocNo == updActionHis.AppraisalDocNo
select t).FirstOrDefault();
getActHis2ndData.Status = null;
getActHis2ndData.Comments = null;
entity.SaveChanges();
/*****************************************/
/******* Insert Approval History *********/
entity.ApprovalHistories.Add(insApprovalHis);
entity.SaveChanges();
/*****************************************/
/***** Update table Employee Master *****/
var getEmpMasData = (from t in entity.EmployeeMasters
where t.EmployeeID == updActionHis.EmployeeID
select t).FirstOrDefault();
getEmpMasData.AppraisalDate = insApprovalHis.TransactionDate;
entity.SaveChanges();
/*****************************************/
/**** Delete AppraisalDocLine Where "AppraisalDocNo" bofore Insert *******/
entity.AppraisalDocLines.RemoveRange(entity.AppraisalDocLines.Where(c => c.AppraisalDocNo == headerData.AppraisalDocNo));
entity.SaveChanges();
/***********************************************************/
/**** Insert AppraisalDocLine *******/
foreach (var item in lDoclineData)
{
entity.AppraisalDocLines.Add(item);
entity.SaveChanges();
}
/*************************************/
//**** Delete rows before insert******************//
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
var lRetAttach = entity.Attachments.Where(c => c.EmployeeID == item.EmployeeID &&
c.FileName == item.FileName).ToList();
if (lRetAttach.Count() > 0)
{
foreach (var iAttach in lRetAttach)
{
entity.Attachments.Remove(iAttach);
entity.SaveChanges();
}
}
}
}
//************************************************//
//***** Insert table Attachments ****************/
if (lAttachFile != null && lAttachFile.Count > 0)
{
foreach (var item in lAttachFile)
{
Attachment insAttachment = new Attachment();
insAttachment.FileName = item.FileName;
insAttachment.EmployeeID = item.EmployeeID;
insAttachment.FileDescription = item.FileDescription;
insAttachment.Attachment1 = item.Attachment1;
insAttachment.CreatedBy = item.CreatedBy;
insAttachment.CreatedDate = item.CreatedDate;
insAttachment.UpdatedBy = item.UpdatedBy;
insAttachment.UpdatedDate = item.UpdatedDate;
entity.Attachments.Add(insAttachment);
entity.SaveChanges();
}
}
//*****************************************/
dbTrans.Commit();
ret = true;
}
catch (Exception ex)
{
ret = false;
dbTrans.Rollback();
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(ret);
}
