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); }