public ActionResult EmployeeCondition(string eid, string ename, string eassi, string emach, string eacc)
{
var x = from o in db.EmpDb
orderby o.EmployeeID ascending
select o;
//卡登入
if (Session["Member"] == null)
{
return(RedirectToAction("Login"));
}
//卡上班狀態
if (eassi == "上班" || eassi == "1")
{
eassi = "1";
}
else if (eassi == "休假" || eassi == "2")
{
eassi = "2";
emach = "0";
}
else if (eassi == "請假" || eassi == "0")
{
eassi = "0";
emach = "0";
}
else
{
ViewBag.alertt = "輸入錯誤,請重輸";
}
EmpDb emp = new EmpDb
{
EmployeeID = eid,
EmployeeName = ename,
Assignment = Convert.ToInt32(eassi),
MachineId = emach,
Account = eacc
};
//db.Configuration.ValidateOnSaveEnabled = false;
db.EmpDb.Attach(emp);
db.Entry(emp).Property(m => m.EmployeeName).IsModified = true;
db.Entry(emp).Property(m => m.Assignment).IsModified = true;
db.Entry(emp).Property(m => m.MachineId).IsModified = true;
db.Entry(emp).Property(m => m.Account).IsModified = true;
db.SaveChanges();
//db.Entry(emp).State = EntityState.Unchanged;
//db.Entry(emp).State = EntityState.Modified;
if (Session["Permission"].ToString() == "1")
{
return(View(x.ToList()));
}
else
{
return(View("EmployeeCondition", "_Layout3", x.ToList()));
}
}
public ActionResult EmployeeEdit(string eid, string ename, string eacc, string epw, string epho, string eadd, string esex, string ebir, string email, string eaddr, string eper)
{
if (Session["Member"] == null)
{
return(RedirectToAction("Login"));
}
var x = from o in db.EmpDb
orderby o.EmployeeID
select o;
//if (edate != "yyyy/MM/dd" || edate != "yyyy-MM-dd")
//{
// ViewBag.msg = "日期錯誤,請重新輸入";
//}
//var emp = db.EmpDbs.Find(ename);
EmpDb emp = new EmpDb
{
EmployeeID = eid,
EmployeeName = ename,
Account = eacc,
PassWord = epw,
PhoneNum = epho.Trim(),
AddDate = eadd.Replace('-', '/'),
Sex = esex.ToUpper(),
Birthday = ebir.Replace('-', '/'),
Email = email,
Address = eaddr,
UpdateTime = DateTime.Now.ToString("yyyy/MM/dd"),
Permission = Convert.ToInt32(eper),
};
//Modified要在.IsModified前
db.Entry(emp).State = EntityState.Modified;
db.Entry(emp).Property(m => m.EmployeeID).IsModified = false;
db.Entry(emp).Property(m => m.Assignment).IsModified = false;
db.Entry(emp).Property(m => m.MachineId).IsModified = false;
try
{
db.SaveChanges();
}
catch (Exception)
{
return(View(x.ToList()));
}
return(View(x.ToList()));
}
public ActionResult CreateEmp(string eeacc, string eepass, string eename, string eepho, string eesex, string eemail,
string eeaddr, string eebir, string eeper)
{
var x = db.EmpDb.AsNoTracking().Where(m => m.Account == eeacc).FirstOrDefault();
if (x == null)
{
//計算資料筆數成ID編號
var eeid = db.EmpDb.Count();
EmpDb eemp = new EmpDb
{
Account = eeacc,
PassWord = eepass,
EmployeeName = eename,
EmployeeID = (eeid + 1).ToString().Trim(),
PhoneNum = eepho,
Sex = eesex.ToUpper(),
Email = eemail,
Address = eeaddr,
Birthday = eebir,
AddDate = DateTime.Now.ToString("yyyy/MM/dd"),
UpdateTime = DateTime.Now.ToString("yyyy/MM/dd"),
Permission = Convert.ToInt32(eeper),
Assignment = 0,
MachineId = "0"
};
db.EmpDb.Add(eemp);
try
{
db.SaveChanges();
}
catch (Exception)
{
goto CreateError;
}
}
else
{
ViewBag.CreateError = "帳號重複,請重新建立";
}
CreateError:
return(RedirectToAction("EmployeeEdit"));
}
