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