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> 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 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 void UpdateApproveData(tblApproveStatus aps)
{
PSESEntities db = new PSESEntities();
db.SP_UpdateAprroveData(aps.Status, aps.ID);
}
public void insertApproveStatus(tblApproveStatus aps)
{
PSESEntities db = new PSESEntities();
db.SP_InsertApproveFlow(aps.Status, aps.FlowOrder, aps.ApproveID, aps.Comment, aps.Name, aps.EmployeeNO);
}
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> getEvaData(string EvaluatorID)
{
var header = ServiceContainer.GetService <PesWeb.Service.Modules.EvaManage>();
List <SP_GetEvaListByEvaluatorID_Result> evalist = header.getEvaListByEvaluatorID(EvaluatorID).Where(a => a.EvaStatus != 3).OrderByDescending(a => a.Eva_ID).ToList();
List <JObject> Jeva = new List <JObject>();
List <tblEmployee> emp = header.getEmployees();
List <tblApprove> ap = header.GetAllApprove();
List <tblProject> pr = header.getProject();
List <tblApproveStatus> ApS = header.GetApproveStatus();
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 && a.ProjectCode.Trim().Length > 0)
{
tblProject tt = pr.Where(x => x.ProjectNameAlias.Trim() == ((a.ProjectCode.Contains('-') ? a.ProjectCode.Trim().Split('-')[1] : a.ProjectCode))).FirstOrDefault();
tmp["CustomerCompanyAlias"] = (a.ProjectCode.Contains('-') ? a.ProjectCode.Trim().Split('-')[0] : "");
}
tblApproveStatus ApSt = ApS.Where(x => x.ApproveID == t.ID && x.Status != 0).OrderByDescending(x => x.ApproveID).FirstOrDefault();
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"] = (ApSt != null)?ApSt.ApproveDate.ToString().Substring(0, 10) + " " + ((ApSt.ApproveDate.ToString().ElementAt(11) == ':') ? '0' + ApSt.ApproveDate.ToString().Substring(10, 4) : ApSt.ApproveDate.ToString().Substring(10, 5)) : 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 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);
}