private JF_TasksStats myJF_TasksStats(EM_Employee gEM, DateTime sTime, DateTime eTime)
{
JF_TasksStats myJF_TasksStats = new JF_TasksStats();
myJF_TasksStats.EMRealName = gEM.EMRealName;
myJF_TasksStats.EmType = db.SYS_DD.Where(s => s.DDCode == gEM.EmType && s.DDType == "EmType").FirstOrDefault().DDName;
switch (gEM.EmType)
{
case "01":
myJF_TasksStats.BaseScore = db.JF_Tasks.Where(s => s.Executor == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.ExecutorGetScore);
break;
case "02":
myJF_TasksStats.BaseScore = db.JF_Tasks.Where(s => s.TestEmployee == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.TestScore);
break;
default:
myJF_TasksStats.BaseScore = db.JF_Tasks.Where(s => s.DemandEmployee == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.DemandScore);
break;
}
double?ExecutorGetScore = db.JF_Tasks.Where(s => (s.FinishStatus == "04" || s.FinishStatus == "05") && s.Executor == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.ExecutorGetScore);
double?TestScore = db.JF_Tasks.Where(s => s.FinishStatus == "05" && s.TestEmployee == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.TestScore);
double?DemandScore = db.JF_Tasks.Where(s => (s.FinishStatus == "04" || s.FinishStatus == "05") && s.DemandEmployee == gEM.EmID && s.CreatedOn >= sTime && s.CreatedOn <= eTime).Sum(s => s.DemandScore);
myJF_TasksStats.GetScore = (ExecutorGetScore == null ? 0 : ExecutorGetScore) + (TestScore == null ? 0 : TestScore) + (DemandScore == null ? 0 : DemandScore);
myJF_TasksStats.Money = myJF_TasksStats.GetScore * 5;
return(myJF_TasksStats);
}
public async Task <ActionResult> DeleteConfirmed(Guid id)
{
EM_Employee em_employee = await db.EM_Employee.FindAsync(id);
db.EM_Employee.Remove(em_employee);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "EmID,EMUserName,EMPassWord,EMRealName,EmType,Mobile,IsDisabled,CreatedOn,CreatedBy")] EM_Employee em_employee)
{
if (ModelState.IsValid)
{
db.Entry(em_employee).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(em_employee));
}
/// <summary>
/// Assembles the entity.
/// </summary>
/// <param name="employee">The employee.</param>
/// <returns></returns>
private EmployeeEntity AssembleEntity(EM_Employee employee)
{
EmployeeEntity entity = new EmployeeEntity();
entity.Address = employee.Address;
entity.Email = employee.Email;
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Phone = employee.Phone;
return entity;
}
public async Task <ActionResult> Create([Bind(Include = "EmID,EMUserName,EMPassWord,EMRealName,EmType,Mobile,IsDisabled,CreatedOn,CreatedBy")] EM_Employee em_employee)
{
if (ModelState.IsValid)
{
em_employee.EmID = Guid.NewGuid();
db.EM_Employee.Add(em_employee);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(em_employee));
}
// GET: /EM/EM_Employee/Details/5
public async Task <ActionResult> Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EM_Employee em_employee = await db.EM_Employee.FindAsync(id);
if (em_employee == null)
{
return(HttpNotFound());
}
return(View(em_employee));
}
// GET: /EM/EM_Employee/Edit/5
public async Task <ActionResult> Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EM_Employee em_employee = await db.EM_Employee.FindAsync(id);
ViewBag.EmType = new SelectList(db.SYS_DD.Where(s => s.DDType == "EmType"), "DDCode", "DDName", em_employee.EmType);
if (em_employee == null)
{
return(HttpNotFound());
}
return(View(em_employee));
}
/// <summary>
/// There are no comments for EM_Employee in the schema.
/// </summary>
public void AddToEM_Employee(EM_Employee eM_Employee)
{
base.AddObject("EM_Employee", eM_Employee);
}
/// <summary>
/// Create a new EM_Employee object.
/// </summary>
/// <param name="externalId">Initial value of ExternalId.</param>
public static EM_Employee CreateEM_Employee(string externalId)
{
EM_Employee eM_Employee = new EM_Employee();
eM_Employee.ExternalId = externalId;
return eM_Employee;
}
