public void UpdateGM([FromBody] JObject Data)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
tblApprove Ap = header.GetAllApprove().Where(a => a.EvaID == Convert.ToInt32(Data["EvaID"].ToString())).OrderByDescending(a => a.ID).FirstOrDefault();
tblApproveStatus Aps = header.GetApproveStatus().Where(a => a.ApproveID == Ap.ID && a.FlowOrder == 3).FirstOrDefault();
tblEmployee emp = header.getEmployees().Where(a => a.EmployeeNo.Trim() == Data["EmployeeNo"].ToString().Trim()).FirstOrDefault();
header.UpdateGM(Aps.ID, emp.EmployeeNo.Trim(), emp.EmployeeFirstName + " " + emp.EmployeeLastName);
}
public List <JObject> getEvaDataByPeriod(string EvaluatorID, int periodID)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
List <SP_GetEvaListByEvaluatorID_Result> evalist = header.getEvaListByEvaluatorID(EvaluatorID).Where(a => a.PeriodID == periodID).OrderByDescending(a => a.Eva_ID).ToList();
List <JObject> Jeva = new List <JObject>();
List <tblEmployee> emp = header.getEmployees();
List <tblApprove> ap = header.GetAllApprove();
evalist.ForEach(a =>
{
JObject tmp = new JObject();
tblApprove t = ap.Where(x => x.EvaID == a.Eva_ID).FirstOrDefault();
tmp["ApproveStat"] = (t != null) ? t.ApproveState : 0;
if (a.ProjectCode != null)
{
tmp["CustomerCompanyAlias"] = (a.ProjectCode.Contains('-') ? a.ProjectCode.Trim().Split('-')[0] : "");
}
tmp["EmployeeFirstName"] = a.EmployeeFirstName;
tmp["EmployeeLastName"] = a.EmployeeLastName;
tmp["EvaluatorFirstName"] = a.EvaluatorFirstName;
tmp["EvaluatorLastName"] = a.EvaluatorLastName;
tmp["EvaStatus"] = a.EvaStatus;
tmp["EvaTerm"] = a.EvaTerm;
tmp["Eva_ID"] = a.Eva_ID;
tmp["Date"] = a.Date.ToString().Substring(0, 10) + " " + ((a.Date.ToString().ElementAt(11) == ':')?'0' + a.Date.ToString().Substring(10, 4): a.Date.ToString().Substring(10, 5));
a.StartDatePlan = a.StartDatePlan.Replace(" ", "/");
if (a.StartDatePlan.ElementAt(4) == '/')
{
a.StartDatePlan = a.StartDatePlan.Substring(0, 4) + "0" + a.StartDatePlan.Substring(5);
}
a.StartDatePlan = a.StartDatePlan.Substring(4, 2) + "/" + a.StartDatePlan.Substring(0, 3) + "/" + a.StartDatePlan.Substring(9, 2);
tmp["StartDatePlan"] = a.StartDatePlan;
a.FinishDatePlan = a.FinishDatePlan.Replace(" ", "/");
if (a.FinishDatePlan.ElementAt(4) == '/')
{
a.FinishDatePlan = a.FinishDatePlan.Substring(0, 4) + "0" + a.FinishDatePlan.Substring(5);
}
a.FinishDatePlan = a.FinishDatePlan.Substring(4, 2) + "/" + a.FinishDatePlan.Substring(0, 3) + "/" + a.FinishDatePlan.Substring(9, 2);
tmp["FinishDatePlan"] = a.FinishDatePlan;
tmp["FinishEvaDate"] = a.FinishEvaDate;
tmp["Function"] = a.Function;
tmp["GroupOfStaff"] = a.GroupOfStaff;
tmp["PeriodID"] = a.PeriodID;
tmp["ProjectCode"] = a.ProjectCode;
tmp["ProjectType"] = a.ProjectType;
tmp["StartEvaDate"] = a.StartEvaDate;
//tmp["employee_language"] =
// tblEmployee empTemp = emp.Where(b => b.EmployeeNo.Replace(" ","") == a.em).FirstOrDefault();
tmp["name_language"] = JsonConvert.DeserializeObject <JObject>("{\"EN\":\"" + a.EmployeeFirstName + " " + a.EmployeeLastName + "\",\"TH\":\"" + a.EmployeeFirstNameThai + " " + a.EmployeeLastNameThai + "\"}");
Jeva.Add(tmp);
});
return(Jeva);
}
public void UpdateApproveData(tblApprove ap)
{
PSESEntities db = new PSESEntities();
// tblApprove tmp = GetAllApprove().Where(a => a.ID == ap.ID).FirstOrDefault();
int number = (int)ap.ApproveState;
if (ap.GM + ap.HR + ap.PM + ap.ST == 4)
{
number = 2;
}
db.SP_UpdateApprove(number, ap.ID, ap.HR, ap.GM, ap.PM, ap.ST);
}
public List <JObject> ApproveHistory(string EmpID)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
// var header = ServiceContainer.GetService<PesWeb.Service.Modules.EvaManage>();
List <tblApprove> app = header.GetAllApprove();
List <tblApproveStatus> ApS = header.GetApproveStatus().Where(a => a.EmployeeNO == EmpID).OrderByDescending(a => a.ID).ToList();
List <tblApprove> Ap = new List <tblApprove>();
List <tblEvaluation> ListEva = header.GetAllEvaluation().ToList();
List <tblFlowMaster> ListFlow = header.getAllFlow();
foreach (tblApproveStatus o in ApS)
{
tblApprove Approve = app.Where(a => a.ID == o.ApproveID).FirstOrDefault();
if (Approve != null && ListEva.Where(a => a.Eva_ID == Approve.EvaID).ToList().Count == 1)
{
Ap.Add(Approve);
}
}
List <tblEmployee> emp = header.getEmployees();
List <JObject> ApObject = new List <JObject>();
Ap.ForEach(a =>
{
JObject tmp = new JObject();
tmp["ApproverID"] = a.ApproverID;
tmp["ApproveState"] = a.ApproveState;
tmp["EvaID"] = a.EvaID;
tmp["GM"] = a.GM;
tmp["HR"] = a.HR;
tmp["ID"] = a.ID;
tmp["Name"] = a.Name;
tmp["PM"] = a.PM;
tmp["Position"] = a.Position;
tmp["PositionID"] = a.PositionID;
tmp["ProjectCode"] = a.ProjectCode;
tmp["Role"] = a.Role;
tmp["ST"] = a.ST;
tblApproveStatus ApSt = ApS.Where(b => b.ApproveID == a.ID && b.Status != 0).OrderByDescending(b => b.ID).FirstOrDefault();
tblEvaluation eva = ListEva.Where(b => b.Eva_ID == a.EvaID).FirstOrDefault();
tmp["Date"] = (ApSt != null)? ApSt.ApproveDate.ToString().Substring(0, 9).Replace("-", "/") + " " + ((ApSt.ApproveDate.ToString().ElementAt(11) == ':') ? '0' + ApSt.ApproveDate.ToString().Substring(10, 4).Replace("-", "/") : ApSt.ApproveDate.ToString().Substring(10, 5).Replace("-", "/")) : eva.StartEvaDate.ToString().Substring(0, 9).Replace("-", "/") + " " + ((eva.StartEvaDate.ToString().ElementAt(11) == ':')?'0' + eva.StartEvaDate.ToString().Substring(10, 4).Replace("-", "/"): eva.StartEvaDate.ToString().Substring(10, 5).Replace("-", "/"));
tblEmployee empTemp = emp.Where(b => b.EmployeeNo.Replace(" ", "") == a.EmployeeNo).FirstOrDefault();
tmp["name_language"] = JsonConvert.DeserializeObject <JObject> ("{\"EN\":\"" + empTemp.EmployeeFirstName + " " + empTemp.EmployeeLastName + "\",\"TH\":\"" + empTemp.EmployeeFirstNameThai + " " + empTemp.EmployeeLastNameThai + "\"}");
ApObject.Add(tmp);
});
return(ApObject);
}
public List <JObject> ApproveFlow(int EvaID)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
tblApprove app = header.getApprove().Where(a => a.EvaID == EvaID).OrderByDescending(a => a.ID).FirstOrDefault();
List <tblFlowMaster> FlowList = header.getAllFlow().ToList();
List <tblApproveStatus> ApSList = header.GetApproveStatus().Where(a => a.ApproveID == app.ID).ToList();
List <JObject> Result = new List <JObject>();
List <tblEmployee> emp2 = header.getEmployees().ToList();
List <tblEmployeeOrganization> em = header.getEmployeeOrganization().Where(a => a.PositionNo == 21).ToList();
ApSList.ForEach(a => {
JObject tmp = new JObject();
tmp["Date"] = "";
string str = "";
tblEmployee emp = new tblEmployee();
emp = null;
if (a.EmployeeNO != null)
{
emp = emp2.Where(b => b.EmployeeNo.Trim() == a.EmployeeNO.Trim()).FirstOrDefault();
}
str = "{\"EN\":\"\",\"TH\":\"\"}";
if (emp != null)
{
str = "{\"EN\":\"" + emp.EmployeeFirstName + " " + emp.EmployeeLastName + "\",\"TH\":\"" + emp.EmployeeFirstNameThai + " " + emp.EmployeeLastNameThai + "\"}";
}
if (a.Status == 1)
{
tmp["Date"] = a.ApproveDate.ToString().Substring(0, 10).Replace("-", "/") + " " + ((a.ApproveDate.ToString().ElementAt(11) == ':')?'0' + a.ApproveDate.ToString().Substring(10, 4):a.ApproveDate.ToString().Substring(10, 5));
//((a.Date.ToString().ElementAt(11) == ':') ? '0' + a.Date.ToString().Substring(10, 4) : a.Date.ToString().Substring(10, 5))
}
tmp["EmployeeNo"] = (emp != null)?a.EmployeeNO.Trim():null;
tmp["Name"] = JsonConvert.DeserializeObject <JObject>(str);
tmp["ProjectCode"] = app.ProjectCode;
tmp["Role"] = "(" + a.FlowOrder + ")" + FlowList[(int)a.FlowOrder - 1].PositionName;;
tmp["Status"] = a.Status;
//tmp["NO"] = a.FlowOrder;
Result.Add(tmp);
});
return(Result);
}
public void ApproveState([FromBody] JObject Data)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
// var header = ServiceContainer.GetService<PesWeb.Service.Modules.EvaManage>();
tblApprove AllAp = header.GetAllApprove().Where(a => a.EvaID == Convert.ToInt32(Data["EvaID"].ToString())).OrderByDescending(a => a.ID).FirstOrDefault();
tblApproveStatus ApS = header.GetApproveStatus().Where(a => ((a.EmployeeNO != null)?a.EmployeeNO.Trim():a.EmployeeNO) == Data["EmpID"].ToString() && a.ApproveID == AllAp.ID).OrderByDescending(a => a.ID).FirstOrDefault();
ApS.Status = 1;//Convert.ToInt32(Data["Status"].ToString());
string type = "";
if (ApS.FlowOrder == 1)
{
AllAp.ST = 1;
type = "Project Manager";
}
else if (ApS.FlowOrder == 2)
{
type = "Staff";
AllAp.PM = 1;
//header.updateEvaluationStatus(Convert.ToInt32(Data["EvaID"].ToString()), 3);
}
else if (ApS.FlowOrder == 3)
{
AllAp.GM = 1;
type = "Group Manager";
}
else if (ApS.FlowOrder == 4)
{
AllAp.HR = 1;
type = "Human Resource";
header.updateEvaluationStatus(Convert.ToInt32(Data["EvaID"].ToString()), 3);
}
if (Convert.ToInt32(Data["Status"].ToString()) == 0)
{
ApS.Status = -1;
}
header.UpdateApproveData(AllAp);
header.UpdateApproveData(ApS);
insertLog(AllAp.Name, Data["EmpID"].ToString(), type + " Approve EvaID : " + Data["EvaID"].ToString());
}
public SP_InsertApproveState_Result insertApprove(tblApprove ap)
{
PSESEntities db = new PSESEntities();
return(db.SP_InsertApproveState(ap.EvaID, ap.Position, ap.PositionID, ap.ProjectCode, ap.Role, ap.Name, ap.EmployeeNo).FirstOrDefault());
}
public HttpResponseMessage InsertEva([FromBody] JObject Data)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
var header2 = ServiceContainer.GetService <PesWeb.Service.Modules.HeaderManage>();
List <tblEvaluation> evaAll = new List <tblEvaluation>();
if (evaAll.Count == 0)
{
int isAdd = 0;
string name = "";
tblProjectMember proj = new tblProjectMember();
if (Data["EmployeeNO"].ToString().Length > 10)
{
isAdd = 1;
List <string> nme = Data["EmployeeNO"].ToString().Split('-').ToList();
name = nme[1].Trim();
tblPart2Master role = header.getPart2Data().Where(a => a.Function.Trim() == Data["Position"].ToString().Trim()).FirstOrDefault();
tblProject project = header.getProject().Where(a => a.ProjectNameAlias.Trim() == Data["ProjectNO"].ToString().Trim()).FirstOrDefault();
if (project != null)
{
Data["ProjectNO"] = project.CustomerCompanyAlias + "-" + project.ProjectNameAlias;
}
proj.Part2ID = role.Part2ID;
Data["EmployeeNO"] = Data["EmployeeNO"].ToString().Split('-')[0].Trim();
}
else
{
proj = header.getProjectMember().Where(a => a.ProjectID == Data["ProjectNO"].ToString()).Where(a => a.StaffID == Data["EmployeeNO"].ToString()).FirstOrDefault();
}
header.GetAllEvaluation().Where(a => a.EvaluatorNO == Data["EvaluatorNO"].ToString() && a.EmployeeNO == Data["EmployeeNO"].ToString() && a.ProjectNO == Data["ProjectNO"].ToString() && a.PeriodID == Convert.ToInt32(Data["PeriodID"].ToString())).ToList();
tblEvaluation eva = new tblEvaluation();
Period p = header.GetPeriod().Where(a => a.Period_Id == Convert.ToInt32(Data["PeriodID"].ToString())).FirstOrDefault();
eva.EmployeeNO = Data["EmployeeNO"].ToString();
eva.EvaluatorNO = Data["EvaluatorNO"].ToString();
//eva.Job_ID = (isAdd==1)? Data["ProjectNO"].ToString().Split(':')
eva.Job_ID = proj.Part2ID;
eva.PeriodID = p.Period_Id;
eva.period = p.StartDate.ToString().Substring(3, 7);
eva.ProjectNO = Data["ProjectNO"].ToString();
eva.StartEvaDate = Convert.ToDateTime(Data["StartDate"].ToString());
eva.FinishEvaDate = Convert.ToDateTime(Data["FinishDate"].ToString());
tblProject pj = new tblProject();
if (isAdd == 0)
{
pj = header.getProject().Where(a => a.ProjectID == Data["ProjectNO"].ToString()).FirstOrDefault();
}
eva.ProjectCode = (isAdd == 1) ? Data["ProjectNO"].ToString() : pj.CustomerCompanyAlias + " " + pj.ProjectNameAlias;
SP_InsertEvaluation_Result evaid = header.InsertEvaData(eva);
int eva_ID = evaid.Eva_ID;
List <tblHeaderJob> hj = header2.getAllHeaderJob().Where(a => a.PositionNo == proj.Part2ID).ToList();
List <tblHeader> Ans = new List <tblHeader>();
List <tblScore> sc = header.GetAllScore();
List <SP_GetHeaderByPosition_Result> GetHeader = header2.getHeaderByPosition(proj.Part2ID, eva_ID).OrderBy(a => a.H_ID).ToList();
List <tblHeader> hd = header2.GetAllHeader().ToList();
tblHeader H_test = new tblHeader();
H_test.H_ID = 0;
// if (GetHeader.Count - GetHeader.Where(a => a.point).ToList().Count < FinalHeader(H_test, hd).ToList().Count)
foreach (tblHeaderJob tmpHJ in hj)
{
foreach (tblHeader hd2 in hd.Where(a => a.H_ID == tmpHJ.H1_ID))
{
foreach (tblHeader hd3 in FinalHeader(hd2, hd))
{
if (sc.Where(a => a.Eva_ID == eva_ID && a.H3_ID == hd3.H_ID).ToList().Count == 0)
{
//if (Ans.Where(a => a.H_ID == hd3.H_ID).ToList().Count == 0)
Ans.Add(hd3);
}
}
}
}
foreach (tblHeader h in Ans)
{
header.InsertSCORE(eva_ID, h.H_ID);
}
List <tblEmployee> emp = header.getEmployees();
int num = header.GetAllApprove().Where(a => a.EvaID == eva_ID).ToList().Count;
if (num == 0)
{
tblApprove ap = new tblApprove();
ap.EvaID = eva_ID;
ap.PositionID = header.getEmployees().Where(a => a.EmployeeNo.Replace(" ", "") == Data["EmployeeNO"].ToString().Replace(" ", "")).FirstOrDefault().PositionNo;
ap.Position = header.getPosition().Where(a => a.PositionNo == ap.PositionID).FirstOrDefault().PositionName;
tblProjectMember pm = header.getProjectMember().Where(a => a.StaffID.Replace(" ", "") == Data["EmployeeNO"].ToString().Replace(" ", "") && a.ProjectID == Data["ProjectNO"].ToString()).FirstOrDefault();
string role = (isAdd == 1)? Data["Position"].ToString(): header.getPart2Data().Where(a => a.Part2ID == pm.Part2ID).FirstOrDefault().Function;
if (isAdd == 0)
{
name = pm.StaffName;
}
ap.Role = role;
tblEmployee emptemp = emp.Where(a => a.EmployeeNo.Trim() == Data["EmployeeNO"].ToString().Trim()).FirstOrDefault();
ap.Name = (emptemp != null) ? emptemp.EmployeeFirstName + " " + emptemp.EmployeeLastName : "";
//tblProject pj = header.getProject().Where(a => a.ProjectID == Data["ProjectNO"].ToString()).FirstOrDefault();
ap.ProjectCode = eva.ProjectCode;
ap.EmployeeNo = Data["EmployeeNO"].ToString().Replace(" ", "");
int pID = header.insertApprove(ap).ID;
List <tblFlowMaster> AllFlow = header.getAllFlow();
foreach (tblFlowMaster a in AllFlow)
{
tblApproveStatus tmp = new tblApproveStatus();
tmp.Comment = "";
tmp.Status = 0;
tmp.FlowOrder = a.Flow;
if (a.CodeName == "PM")
{
tblEmployee emp2 = emp.Where(t => t.EmployeeNo.Replace(" ", "") == Data["EvaluatorNO"].ToString().Replace(" ", "")).FirstOrDefault();
tmp.Name = emp2.EmployeeFirstName + " " + emp2.EmployeeLastName;
tmp.EmployeeNO = emp2.EmployeeNo;
// tmp.Status = 1;
}
else if (a.CodeName == "ST")
{
tmp.Name = name;
tmp.EmployeeNO = Data["EmployeeNO"].ToString().Replace(" ", "");
}
else if (a.CodeName == "HR")
{
tblEmployee emp2 = emp.Where(t => t.PositionNo == 23).FirstOrDefault();
tmp.Name = emp2.EmployeeFirstName + " " + emp2.EmployeeLastName;
tmp.EmployeeNO = emp2.EmployeeNo;
}
else if (a.CodeName == "GM")
{
int organNo = (int)emp.Where(s => s.EmployeeNo.Replace(" ", "") == Data["EmployeeNO"].ToString().Replace(" ", "")).FirstOrDefault().OrganizationNo;
List <tblEmployeeOrganization> emO = header.getEmployeeOrganization().Where(t => t.OrganizationNo == organNo && t.PositionNo == 21).ToList();
if (emO.Count != 1)
{
tmp.Name = "";
tmp.EmployeeNO = "";
}
else
{
tblEmployee emp2 = emp.Where(t => t.EmployeeNo.Replace(" ", "") == emO.FirstOrDefault().EmployeeNo).FirstOrDefault();
if (emp2 != null)
{
tmp.Name = emp2.EmployeeFirstName + " " + emp2.EmployeeLastName;
tmp.EmployeeNO = emp2.EmployeeNo;
}
}
}
tmp.ApproveID = pID;
header.insertApproveStatus(tmp);
}
}
tblEmployee empLog = emp.Where(t => t.EmployeeNo.Replace(" ", "") == Data["EvaluatorNO"].ToString().Replace(" ", "")).FirstOrDefault();
insertLog(empLog.EmployeeFirstName + " " + empLog.EmployeeLastName, empLog.EmployeeNo, "new evaluation : " + eva_ID);
return(Request.CreateResponse(HttpStatusCode.OK));
}
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
public List <JObject> getApproveList(string EmpID)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
List <JObject> ApObject = new List <JObject>();
List <tblApproveStatus> AllAps = header.GetApproveStatus();
List <tblApproveStatus> ApS = AllAps.Where(a => ((a.EmployeeNO != null)?a.EmployeeNO.Trim():a.EmployeeNO) == EmpID.Trim()).ToList();
if (ApS != null)
{
List <tblEvaluation> ListEva = header.GetAllEvaluation();
List <tblApprove> Ap = new List <tblApprove>();
List <tblApprove> AllAp = header.GetAllApprove();
foreach (tblApproveStatus aps in ApS.Where(a => a.Status == 0).GroupBy(a => a.ApproveID).Select(a => a.First()).ToList())
{
int num = 0;
List <tblApproveStatus> tmp = AllAps.Where(a => a.ApproveID == aps.ApproveID).ToList();
foreach (tblApproveStatus n in tmp)
{
if (n.ID == aps.ID)
{
break;
}
else if (n.Status == 0)
{
num = 1;
}
}
if (num == 0)
{
tblApprove Approve = AllAp.Where(a => a.ID == aps.ApproveID).FirstOrDefault();
if (Approve != null)
{
tblEvaluation EvaData = ListEva.Where(a => a.Eva_ID == Approve.EvaID).FirstOrDefault();
if (EvaData != null && EvaData.EvaStatus == 1)
{
Ap.Add(Approve);
}
}
}
}
List <tblEvaluation> evalist = header.GetAllEvaluation().ToList();
List <tblEmployee> emp = header.getEmployees();
Ap.ForEach(a =>
{
JObject tmp = new JObject();
tmp["ApproverID"] = a.ApproverID;
tmp["ApproveState"] = a.ApproveState;
tmp["EvaID"] = a.EvaID;
tmp["GM"] = a.GM;
tmp["HR"] = a.HR;
tmp["ID"] = a.ID;
tmp["Name"] = a.Name;
tmp["PM"] = a.PM;
tmp["Position"] = a.Position;
tmp["PositionID"] = a.PositionID;
tmp["ProjectCode"] = a.ProjectCode;
tmp["Role"] = a.Role;
tmp["ST"] = a.ST;
tblEvaluation eva = evalist.Where(b => b.Eva_ID == a.EvaID && b.EvaStatus == 1).FirstOrDefault();
List <tblApproveStatus> aps = header.GetApproveStatus().Where(x => x.ApproveID == a.ID).ToList();
tmp["Date"] = eva.StartEvaDate.ToString().Substring(0, 9).Replace("-", "/") + " " + ((eva.StartEvaDate.ToString().ElementAt(11) == ':') ? '0' + eva.StartEvaDate.ToString().Substring(10, 4).Replace("-", "/") : eva.StartEvaDate.ToString().Substring(10, 5));
aps.ForEach(x =>
{
if (x.Status != 0)
{
tmp["Date"] = x.ApproveDate.ToString().Substring(0, 9).Replace("-", "/") + " " + ((x.ApproveDate.ToString().ElementAt(11) == ':') ? '0' + x.ApproveDate.ToString().Substring(10, 4).Replace("-", "/") : x.ApproveDate.ToString().Substring(10, 5));
}
});
tblEmployee empTemp = emp.Where(b => b.EmployeeNo.Replace(" ", "") == a.EmployeeNo).FirstOrDefault();
tmp["name_language"] = JsonConvert.DeserializeObject <JObject>("{\"EN\":\"" + empTemp.EmployeeFirstName + " " + empTemp.EmployeeLastName + "\",\"TH\":\"" + empTemp.EmployeeFirstNameThai + " " + empTemp.EmployeeLastNameThai + "\"}");
ApObject.Add(tmp);
});
}
return(ApObject);
}
public void UpdateHeader([FromBody] List <JObject> Data)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.HeaderManage>();
var header2 = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
int EvaID = 0;
foreach (JObject jo in Data)
{
if (jo.Count > 3)
{
header.UpdateScoreData(Convert.ToInt32(jo["EvaId"].ToString()), 0, Convert.ToInt32(jo["Id"].ToString()), jo["Comment"].ToString());
}
else
{
header.UpdateScoreData(Convert.ToInt32(jo["EvaId"].ToString()), Convert.ToInt32(jo["Score"].ToString()), Convert.ToInt32(jo["Id"].ToString()), "");
}
EvaID = Convert.ToInt32(jo["EvaId"].ToString());
}
int sum = 0, sum2 = 0;
List <tblHeaderAdditional> hAd = header.getHeaderAdditional().ToList();
List <tblScore> score = header2.GetAllScore().Where(a => a.Eva_ID == EvaID).OrderBy(a => a.H3_ID).ToList();
List <tblHeader> hd = header.GetAllHeader().ToList();
tblEvaluation eva = header2.GetAllEvaluation().Where(a => a.Eva_ID == EvaID).FirstOrDefault();
List <tblHeaderJob> hj = header.getAllHeaderJob().ToList();
List <tblHeaderJob> hjList = new List <tblHeaderJob>();
hj.ForEach(a =>
{
foreach (JObject jo in Data)
{
if (Convert.ToInt32(jo["Id"].ToString()) == a.H1_ID)
{
hjList.Add(a);
}
}
});
foreach (tblHeaderJob th in hjList)
{
if (hd.Where(a => a.H_ID == th.H1_ID).ToList().Count > 0)
{
List <tblHeader> H1 = hd.Where(a => a.Parent == th.H1_ID).ToList();
foreach (tblHeader th2 in H1)
{
List <tblHeader> H2 = hd.Where(a => a.Parent == th2.H_ID).ToList();
foreach (tblHeader th3 in H2)
{
sum += (int)score.Where(a => a.H3_ID == th3.H_ID).FirstOrDefault().point;
}
List <tblHeaderAdditional> Hd1 = hAd.Where(a => a.parent == th2.H_ID).ToList();
foreach (tblHeaderAdditional thA in Hd1)
{
sum += (int)thA.point;
}
if (H2.Count > 0 || Hd1.Count > 0)
{
header.UpdateScoreData(EvaID, sum / (H2.Count + Hd1.Count), th2.H_ID, score.Where(a => a.Eva_ID == EvaID && a.H3_ID == th2.H_ID).FirstOrDefault().Comment);
sum2 += sum / (H2.Count + Hd1.Count);
}
sum = 0;
}
header.UpdateScoreData(EvaID, sum2 / H1.Count, (int)th.H1_ID, score.Where(a => a.Eva_ID == EvaID && a.H3_ID == th.H1_ID).FirstOrDefault().Comment);
sum2 = 0;
}
}
sum = 0; sum2 = 0;
List <tblHeaderAdditional> hdaList = header.getHeaderAdditional().Where(a => a.Eva_ID == EvaID).ToList();
List <tblHeaderAdditional> hh = hdaList.Where(a => a.parent == 0 && a.Eva_ID == EvaID).ToList();
foreach (tblHeaderAdditional tmp in hh)
{
List <tblHeaderAdditional> h1 = hdaList.Where(a => a.parent == (-1) * tmp.H_ID).ToList();
foreach (tblHeaderAdditional tmp2 in h1)
{
List <tblHeaderAdditional> h2 = hdaList.Where(a => a.parent == (-1) * tmp2.H_ID).ToList();
foreach (tblHeaderAdditional tmp3 in h2)
{
sum += (int)tmp3.point;
}
sum = sum / (h2.Count);
header.UpdateScoreData(EvaID, sum, tmp2.H_ID, tmp2.Comment);
sum2 += sum;
sum = 0;
}
sum2 = sum2 / (h1.Count);
header.UpdateScoreData(EvaID, sum2, tmp.H_ID, tmp.Comment);
}
if (EvaID > 0)
{
header.UpdateEvaluationStatus(EvaID, 1);
}
tblApprove AllAp = header2.GetAllApprove().Where(a => a.EvaID == EvaID).OrderByDescending(a => a.ID).FirstOrDefault();
tblApproveStatus ApS = header2.GetApproveStatus().Where(a => a.FlowOrder == 1 && a.ApproveID == AllAp.ID).OrderByDescending(a => a.ID).FirstOrDefault();
AllAp.ST = 1;
ApS.Status = 1;
header2.UpdateApproveData(AllAp);
header2.UpdateApproveData(ApS);
tblEmployee emp = header2.getEmployees().Where(a => a.EmployeeNo.Replace(" ", "") == eva.EvaluatorNO).FirstOrDefault();
insertLog(emp.EmployeeFirstName + " " + emp.EmployeeLastName, eva.EvaluatorNO, "Update Score of EvaID : " + EvaID);
}
