public ActionResult DeleteEmployee(int?EmpID)
{
if (EmpID != 0)
{
System.Web.HttpContext.Current.Application.Lock();
DAL.MDEmployee delete = _db.MDEmployee.Where(p => p.EmpID == EmpID).FirstOrDefault();
_db.MDEmployee.Remove(delete);
_db.SaveChanges();
System.Web.HttpContext.Current.Application.UnLock();
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveEmployee(Models.EmployeeModel data)
{
if (!ModelState.IsValid)
{
if (data.EmpID == 0)
{
_db = new QSoft_WUEntities();
DAL.MDEmployee code = _db.MDEmployee.Where(p => p.EmpCode == data.EmpCode).FirstOrDefault();
if (code != null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
System.Web.HttpContext.Current.Application.Lock();
_db = new QSoft_WUEntities();
_db.MDEmployee.Add(new DAL.MDEmployee
{
EmpID = data.EmpID,
EmpCode = data.EmpCode,
EmpHead = data.EmpHead,
EmpTitle = data.EmpTitle,
EmpNameEng = data.EmpNameEng,
EmpName = data.EmpName,
EmpType = data.EmpType,
Tel = data.Tel,
Email = data.Email,
EmpStartDate = data.EmpStartDate,
EmpPromoteDate = data.EmpPromoteDate,
EmpResignDate = data.EmpResignDate,
EmpAddr1 = data.EmpAddr1,
District = data.District,
Amphur = data.Amphur,
Province = data.Province,
PostCode = data.PostCode,
EmpStatus = data.EmpStatus,
EmpTitleEng = data.EmpTitleEng,
EmpSignature = data.EmpSignature,
Username = data.Username,
DeptID = data.DeptID,
EmpGroupID = data.EmpGroupID,
PostID = data.PostID,
TaxID = data.TaxID,
IDCard = data.IDCard,
Remark = data.Remark,
ccode = data.ccode
});
_db.SaveChanges();
System.Web.HttpContext.Current.Application.UnLock();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
}
if (ModelState.IsValid)
{
if (data.EmpID != 0)
{
_db = new QSoft_WUEntities();
DAL.MDEmployee code = _db.MDEmployee.Where(p => p.EmpCode == data.EmpCode && p.EmpID != data.EmpID).FirstOrDefault();
if (code != null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
DAL.MDEmployee edit = _db.MDEmployee.Where(p => p.EmpID == data.EmpID).FirstOrDefault();
edit.EmpID = data.EmpID;
edit.EmpCode = data.EmpCode;
edit.EmpHead = data.EmpHead;
edit.EmpTitle = data.EmpTitle;
edit.EmpNameEng = data.EmpNameEng;
edit.EmpName = data.EmpName;
edit.EmpType = data.EmpType;
edit.Tel = data.Tel;
edit.Email = data.Email;
edit.EmpStartDate = data.EmpStartDate;
edit.EmpPromoteDate = data.EmpPromoteDate;
edit.EmpResignDate = data.EmpResignDate;
edit.EmpAddr1 = data.EmpAddr1;
edit.District = data.District;
edit.Amphur = data.Amphur;
edit.Province = data.Province;
edit.PostCode = data.PostCode;
edit.EmpStatus = data.EmpStatus;
edit.EmpTitleEng = data.EmpTitleEng;
edit.EmpSignature = data.EmpSignature;
edit.Username = data.Username;
edit.DeptID = data.DeptID;
edit.EmpGroupID = data.EmpGroupID;
edit.PostID = data.PostID;
edit.TaxID = data.TaxID;
edit.IDCard = data.IDCard;
edit.Remark = data.Remark;
edit.ccode = data.ccode;
_db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
}
return(View());
}
