public List <CompanyMaster> ListCompanyData() { List <CompanyMaster> lResult = new List <CompanyMaster>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from r in entity.CompanyMasters select r) .Where(t => t.IsActive == true).ToList(); foreach (var item in listData) { lResult.Add(item); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public bool UpdateAppraisalDocHeader(AppraisalDocHeader updData) { bool updRet = false; try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from t in entity.AppraisalDocHeaders where t.RowID == updData.RowID select t).FirstOrDefault(); getData.AppraisalDocNo = updData.AppraisalDocNo; entity.SaveChanges(); updRet = true; } } catch (Exception ex) { updRet = false; logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(updRet); }
public List <EmployeeMaster> ListEmployeeData() { List <EmployeeMaster> lResult = new List <EmployeeMaster>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from r in entity.EmployeeMasters select r).ToList(); foreach (var item in listData) { lResult.Add(item); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public bool DeleteFileAttachment(string EmployeeID, string FileName) { bool ret = false; try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var lRetAttach = entity.Attachments.Where(c => c.EmployeeID == EmployeeID && c.FileName == FileName).ToList(); if (lRetAttach.Count() > 0) { foreach (var iAttach in lRetAttach) { entity.Attachments.Remove(iAttach); entity.SaveChanges(); } } } ret = true; } catch (Exception ex) { ret = false; logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(ret); }
public List <ActionHistory> ListActionHistory(string EmployeeID, int AppraisalYear) { List <ActionHistory> lResult = new List <ActionHistory>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from r in entity.ActionHistories select r) .Where(c => c.EmployeeID == EmployeeID && c.AppraisalYear == AppraisalYear).ToList(); foreach (var item in listData) { lResult.Add(item); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public bool UpdateRejectAppraisalDocHeader(AppraisalDocHeader updData) { bool updRet = false; try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from t in entity.AppraisalDocHeaders where t.AppraisalDocNo == updData.AppraisalDocNo select t).FirstOrDefault(); getData.AppraisalDate = updData.AppraisalDate; getData.AppraisalPeriodFrom = updData.AppraisalPeriodFrom; getData.AppraisalPeriodTo = updData.AppraisalPeriodTo; getData.AppraisalStatus = updData.AppraisalStatus; getData.AppraisalTotalScore = updData.AppraisalTotalScore; getData.AppraisalGrade = updData.AppraisalGrade; entity.SaveChanges(); updRet = true; } } catch (Exception ex) { updRet = false; logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(updRet); }
public List <Inf_TaskListData> ListCompleteEmployeeData() { List <Inf_TaskListData> lResult = new List <Inf_TaskListData>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from e in entity.EmployeeMasters join h in entity.AppraisalDocHeaders on e.EmployeeID equals h.EmployeeID where h.AppraisalStatus == "Completed" && h.AppraisalYear == DateTime.Now.Year select new { EmployeeID = e.EmployeeID, EmployeeName = e.EmployeeName, DepartmentName = e.DepartmentName, CompanyID = e.CompanyID, Position = e.Position, FirstManager = e.FirstManager, SecondManager = e.SecondManager, HRStaff = e.HRStaff, CreatedBy = e.CreatedBy, CreatedDate = e.CreatedDate, AppraisalDocNo = h.AppraisalDocNo, TaskOfUser = h.CreatedBy, AppraisalYear = h.AppraisalYear, AppraisalStatus = h.AppraisalStatus }).ToList(); foreach (var item in listData) { Inf_TaskListData data = new Inf_TaskListData(); data.AppraisalDocNo = item.AppraisalDocNo; data.AppraisalYear = item.AppraisalYear; data.CompanyID = item.CompanyID; data.CreatedBy = item.CreatedBy; data.CreatedDate = item.CreatedDate; data.DepartmentName = item.DepartmentName; data.EmployeeID = item.EmployeeID; data.EmployeeName = item.EmployeeName; data.FirstManager = item.FirstManager; data.HRStaff = item.HRStaff; data.Position = item.Position; data.SecondManager = item.SecondManager; data.TaskOfUser = item.TaskOfUser; data.AppraisalStatus = item.AppraisalStatus; lResult.Add(data); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public List <Attachment> listAttachfile(string EmployeeID) { List <Attachment> lRet = new List <Attachment>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { lRet = (from r in entity.Attachments select r).Where(t => t.EmployeeID == EmployeeID).ToList(); } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
public string GetActionHistoryStatus(string DocNo, string Responsibility) { string sStatus = string.Empty; try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { sStatus = entity.ActionHistories.Where(t => t.AppraisalDocNo == DocNo && t.Responsibility == Responsibility).Select(c => c.Status).FirstOrDefault(); } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(sStatus); }
public ActionHistory GetActionHistoryData(string EmployeeID) { ActionHistory retDet = new ActionHistory(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.ActionHistories select r).Where(t => t.EmployeeID == EmployeeID).FirstOrDefault(); retDet = getData; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retDet); }
public bool UpdateEmployeeData(EmployeeMaster EmpData) { bool insRet = false; using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { using (var dbTrans = entity.Database.BeginTransaction()) { try { var getData = (from t in entity.EmployeeMasters where t.EmployeeID == EmpData.EmployeeID select t).FirstOrDefault(); getData.FirstManager = EmpData.FirstManager; getData.FirstManagerMail = EmpData.FirstManagerMail; getData.SecondManager = EmpData.SecondManager; getData.SecondManagerMail = EmpData.SecondManagerMail; getData.CreatedBy = EmpData.CreatedBy; getData.CreatedDate = EmpData.CreatedDate; entity.SaveChanges(); dbTrans.Commit(); insRet = true; } catch (Exception ex) { insRet = false; dbTrans.Rollback(); logger.Error(ex.Message); logger.Error(ex.StackTrace); } } } return(insRet); }
public bool InsertData(List <AppraisalDocLine> lData) { bool ret = false; try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { using (var dbTrans = entity.Database.BeginTransaction()) { try { foreach (var item in lData) { entity.AppraisalDocLines.Add(item); 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 DepartmentMaster GetDepartmentData(string DepartmentName) { DepartmentMaster retDet = new DepartmentMaster(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.DepartmentMasters select r). Where(t => t.DepartmentName == DepartmentName).FirstOrDefault(); retDet = getData; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retDet); }
public AppraisalDocHeader GetData(string EmployeeID, int Year) { AppraisalDocHeader retDet = new AppraisalDocHeader(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.AppraisalDocHeaders select r) .Where(t => t.EmployeeID.Equals(EmployeeID.Trim()) && t.AppraisalYear == Year).FirstOrDefault(); retDet = getData; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retDet); }
public List <AppraisalDocHeader> ListDocHeaderByID(string EmployeeID) { List <AppraisalDocHeader> lRet = new List <AppraisalDocHeader>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.AppraisalDocHeaders select r) .Where(t => t.EmployeeID.Equals(EmployeeID.Trim()) && t.AppraisalStatus == "Completed").ToList(); lRet = getData; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
public CompanyMaster GetCompanyData(string Company) { CompanyMaster retDet = new CompanyMaster(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.CompanyMasters select r). Where(t => t.CompanyAD == Company && t.IsActive == true).FirstOrDefault(); retDet = getData; } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retDet); }
public HREmployee GetHREmployeeData(string EmployeeID) { HREmployee retDet = new HREmployee(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var getData = (from r in entity.HREmployees select r).Where(t => t.EmployeeID == EmployeeID).FirstOrDefault(); retDet = getData; } } catch (Exception ex) { retDet = null; logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(retDet); }
public List <EmployeeMaster> ListEmployeeByName(string _EmployeeName) { List <EmployeeMaster> lRet = new List <EmployeeMaster>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { lRet = (from r in entity.EmployeeMasters select r).Where(t => t.EmployeeName.Contains(_EmployeeName) && t.AppraisalYear != DateTime.Now.Year.ToString() && t.HRStaff == null).ToList(); } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lRet); }
public List <AppraisalTemplate> ListData() { List <AppraisalTemplate> lResult = new List <AppraisalTemplate>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from c in entity.AppraisalTemplates select c).ToList(); foreach (var item in listData) { lResult.Add(item); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public List <AppraisalDocLine> ListAppraisalDocLine(string AppraisalDocNo) { List <AppraisalDocLine> lResult = new List <AppraisalDocLine>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from r in entity.AppraisalDocLines select r).Where(c => c.AppraisalDocNo == AppraisalDocNo).ToList(); foreach (var item in listData) { lResult.Add(item); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
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 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); }
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 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 UpdateEmployeeMaster(List <EmployeeMaster> lUpdData) { bool insRet = false; using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { using (var dbTrans = entity.Database.BeginTransaction()) { try { foreach (var item in lUpdData) { var getData = (from t in entity.EmployeeMasters where t.EmployeeID == item.EmployeeID select t).FirstOrDefault(); getData.HRStaff = item.HRStaff; getData.CreatedBy = item.CreatedBy; getData.CreatedDate = item.CreatedDate; getData.AppraisalYear = item.AppraisalYear; entity.SaveChanges(); if (!string.IsNullOrEmpty(item.HRStaff)) { ActionHistory data = new ActionHistory(); data.EmployeeID = item.EmployeeID; data.Status = "New Document"; data.Action = "Create"; data.AppraisalYear = item.CreatedDate.Value.Year; data.CreatedBy = item.HRStaff; data.CreatedDate = item.CreatedDate; data.Responsibility = "Creator"; entity.ActionHistories.Add(data); entity.SaveChanges(); } if (!string.IsNullOrEmpty(item.FirstManager)) { ActionHistory data = new ActionHistory(); data.EmployeeID = item.EmployeeID; data.Action = "Approve"; data.AppraisalYear = item.CreatedDate.Value.Year; data.CreatedBy = item.FirstManager; data.CreatedDate = item.CreatedDate; data.Responsibility = "FirstManager"; entity.ActionHistories.Add(data); entity.SaveChanges(); } } dbTrans.Commit(); insRet = true; } catch (Exception ex) { insRet = false; dbTrans.Rollback(); logger.Error(ex.Message); logger.Error(ex.StackTrace); } } } return(insRet); }
public List <Inf_TaskListData> ListTaskEmployeeData(string UserName) { List <Inf_TaskListData> lResult = new List <Inf_TaskListData>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { var listData = (from e in entity.EmployeeMasters join a in entity.ActionHistories on e.EmployeeID equals a.EmployeeID join h in entity.AppraisalDocHeaders on e.EmployeeID equals h.EmployeeID into gj from h in gj.Where(f => f.AppraisalYear == DateTime.Now.Year).DefaultIfEmpty() where a.CreatedBy == UserName && a.Status == null && a.AppraisalYear == DateTime.Now.Year select new { EmployeeID = e.EmployeeID, EmployeeName = e.EmployeeName, DepartmentName = e.DepartmentName, CompanyID = e.CompanyID, Position = e.Position, FirstManager = e.FirstManager, SecondManager = e.SecondManager, HRStaff = e.HRStaff, CreatedBy = e.CreatedBy, CreatedDate = e.CreatedDate, Status = a.Status, AppraisalDocNo = a.AppraisalDocNo, TaskOfUser = a.CreatedBy, AppraisalYear = a.AppraisalYear, Responsibility = a.Responsibility, AppraisalStatus = h.AppraisalStatus }).ToList(); foreach (var item in listData) { Inf_TaskListData data = new Inf_TaskListData(); data.AppraisalDocNo = item.AppraisalDocNo; data.AppraisalYear = item.AppraisalYear; data.CompanyID = item.CompanyID; data.CreatedBy = item.CreatedBy; data.CreatedDate = item.CreatedDate; data.DepartmentName = item.DepartmentName; data.EmployeeID = item.EmployeeID; data.EmployeeName = item.EmployeeName; data.FirstManager = item.FirstManager; data.HRStaff = item.HRStaff; data.Position = item.Position; data.SecondManager = item.SecondManager; data.Status = item.Status; data.TaskOfUser = item.TaskOfUser; data.Responsibility = item.Responsibility; data.AppraisalStatus = item.AppraisalStatus; lResult.Add(data); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }
public List <Inf_TaskListData> ListAppraisalHistory(string DomainName) { List <Inf_TaskListData> lResult = new List <Inf_TaskListData>(); try { using (PerformanceAppraisalEntities entity = new PerformanceAppraisalEntities()) { SqlParameter paraComcode = new SqlParameter("@DomainName", DomainName); var result = entity.Database.SqlQuery <Inf_TaskListData>("exec spListAppraisalCompleteTask @DomainName", paraComcode).ToList(); lResult = result; #region #### Old Code #### // var listData = (from e in entity.EmployeeMasters // join h in entity.AppraisalDocHeaders on e.EmployeeID equals h.EmployeeID // where h.AppraisalYear == DateTime.Now.Year // select new // { // EmployeeID = e.EmployeeID, // EmployeeName = e.EmployeeName, // DepartmentName = e.DepartmentName, // CompanyID = e.CompanyID, // Position = e.Position, // FirstManager = e.FirstManager, // SecondManager = e.SecondManager, // HRStaff = e.HRStaff, // CreatedBy = e.CreatedBy, // CreatedDate = e.CreatedDate, // AppraisalDocNo = h.AppraisalDocNo, // TaskOfUser = h.CreatedBy, // AppraisalYear = h.AppraisalYear, // AppraisalStatus = h.AppraisalStatus // }).ToList(); // foreach (var item in listData) // { // Inf_TaskListData data = new Inf_TaskListData(); // data.AppraisalDocNo = item.AppraisalDocNo; // data.AppraisalYear = item.AppraisalYear; // data.CompanyID = item.CompanyID; // data.CreatedBy = item.CreatedBy; // data.CreatedDate = item.CreatedDate; // data.DepartmentName = item.DepartmentName; // data.EmployeeID = item.EmployeeID; // data.EmployeeName = item.EmployeeName; // data.FirstManager = item.FirstManager; // data.HRStaff = item.HRStaff; // data.Position = item.Position; // data.SecondManager = item.SecondManager; // data.TaskOfUser = item.TaskOfUser; // data.AppraisalStatus = item.AppraisalStatus; // lResult.Add(data); // } #endregion } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } return(lResult); }