private List <CompanyUnit> ListGenerateUnit(DataTable aCompanyUnit)
{
// UnitCD, DT.UnitName, COUNT(*) UnitTotal, (SELECT COUNT(*) Unallocated
try
{
_conpanyUnits = new List <CompanyUnit>();
foreach (DataRow aRow in aCompanyUnit.Rows)
{
var conpanyUnit = new CompanyUnit
{
CompanyCode = aRow["CompanyCode"].ToString(),
CompanyName = aRow["CompanyName"].ToString(),
UnitCode = aRow["UnitCD"].ToString(),
UnitName = aRow["UnitName"].ToString(),
Budget = Convert.ToInt32(aRow["Budget"]),
Actual = Convert.ToInt32(aRow["Actual"]),
Shortage = Convert.ToInt32(aRow["Shortage"]),
Excess = Convert.ToInt32(aRow["Excess"]),
Unallocated = Convert.ToInt32(aRow["Unallocated"]),
ExcessCost = Convert.ToInt32(aRow["ExcessCost"])
};
_conpanyUnits.Add(conpanyUnit);
}
}
catch (Exception ex)
{
return(_conpanyUnits);
}
return(_conpanyUnits);
}
public async Task Update(CompanyUnit companyUnit)
{
if (!ExecuteValidation(new CompanyUnitValidation(), companyUnit))
{
return;
}
await _companyUnitRepository.Update(companyUnit);
}
public JsonResult Create(Person createData1, CompanyUnit createData2)
{
using (EmployeeData2Entities db = new EmployeeData2Entities())
{
db.Person.Add(createData1);
db.SaveChanges();
createData2.EmpID = createData1.EmpID;
db.CompanyUnit.Add(createData2);
db.SaveChanges();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult Remove(int empid)
{
using (EmployeeData2Entities db = new EmployeeData2Entities())
{
//Person pedata = db.Person.Where(x => x.EmpID == empid).FirstOrDefault(); [上下兩個與法都可以用]
Person pedata = db.Person.Find(empid);
db.Person.Remove(pedata);
//CompanyUnit comdata = db.CompanyUnit.Where(y => y.EmpID == empid).FirstOrDefault();
CompanyUnit comdata = db.CompanyUnit.Find(empid);
db.CompanyUnit.Remove(comdata);
db.SaveChanges();
return(RedirectToAction("ShowAllData"));
}
}
public async Task Add(CompanyUnit companyUnit)
{
if (!ExecuteValidation(new CompanyUnitValidation(), companyUnit))
{
return;
}
if (_companyUnitRepository.Get(c => c.Name == companyUnit.Name).Result.Any())
{
Notify("Já existe essa unidade cadastrada com esse nome.");
return;
}
await _companyUnitRepository.Add(companyUnit);
}
public JsonResult Edit(DataEmp getdata)
{
//if (!string.IsNullOrWhiteSpace(Convert.ToString(getdata.EmpID))) {
using (EmployeeData2Entities db = new EmployeeData2Entities())
{
Person pedata = db.Person.Where(x => x.EmpID == getdata.EmpID).FirstOrDefault();
pedata.EmpName = getdata.EmpName;
pedata.EmpBirthday = getdata.EmpBirthday;
pedata.Gender = getdata.Gender;
pedata.BuildDate = getdata.BuildDate;
pedata.LogingDate = getdata.LogingDate;
CompanyUnit comdata = db.CompanyUnit.Where(y => y.EmpID == getdata.EmpID).FirstOrDefault();
comdata.JobTitle = getdata.JobTitle;
comdata.UnitID = getdata.UnitID;
comdata.UnitName = getdata.UnitName;
comdata.Seniority = getdata.Seniority;
db.SaveChanges();
}
return(Json(getdata));
}