public IList <EmployeeExt> GetEmployeeExt()
{
List <EmployeeExt> lst = new List <EmployeeExt>();
using (var context = (HRM_ROHTOEntities)Activator.CreateInstance(typeof(HRM_ROHTOEntities), _connectionStr))
{
foreach (var item in context.TBL_EMPLOYEE)
{
TBL_DEPARTMENT department = context.TBL_DEPARTMENT.FirstOrDefault(x => x.DepartmentID == item.DepartmentID);
TBL_POSITION position = context.TBL_POSITION.FirstOrDefault(x => x.PositionID == item.PositionID1);
EmployeeExt ext = new EmployeeExt
{
EmployeeID = item.EmployeeID,
EmployeeCode = item.EmployeeCode,
FullName = item.FullName,
ContractNo = item.ContractNo,
CardNumber = item.CardNumber,
DepartmentName = department != null ? department.DepartmentName : "",
PositionName = position != null ? position.PositionName : "",
IsLeaveOut = item.IsLeaveOut == true ? "Nghỉ việc" : "Đang làm"
};
lst.Add(ext);
}
}
lst.OrderBy(n => n.DepartmentName).ThenBy(n => n.EmployeeCode);
return(lst);
}
public ActionResult Edit(TBL_DEPARTMENT Item)
{
try
{
RepairToShow(Item.DepartmentID);
if (Item.ParentID == 0)
{
Item.ParentID = null;
Item.LevelID = 1;
}
else
{
int parentLevelID = DA_Department.Instance.GetLevelIDOfParent(Item.ParentID);
Item.LevelID = parentLevelID + 1;
}
DA_Department.Instance.Update(Item);
//Ghi log
TBL_DEPARTMENT oldDepartment = DA_Department.Instance.GetById(Item.DepartmentID);
WriteLog("Department", "Edit", oldDepartment, Item);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(TBL_DEPARTMENT Item)
{
try
{
RepairToShow();
if (Item.ParentID == 0)
{
Item.ParentID = null;
Item.LevelID = 1;
}
else
{
int parentLevelID = DA_Department.Instance.GetLevelIDOfParent(Item.ParentID);
Item.LevelID = parentLevelID + 1;
}
DA_Department.Instance.Insert(Item);
//Ghi log
WriteLog("Department", "Create", null, Item);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(string id)
{
int _id = int.Parse(id);
TBL_DEPARTMENT obj = DA_Department.Instance.GetById(_id);
if (obj == null)
{
return(HttpNotFound());
}
RepairToShow();
return(View(obj));
}
//public int GetLevelID(long? ParentID)
//{
// int lv = 0;
// if (ParentID != null && ParentID > 0)
// {
// lv = DA_Department.Instance.GetLevelIDOfDepartment((long)ParentID);
// }
// return (lv + 1);
//}
public ActionResult Delete(string id)
{
int _id = int.Parse(id);
DA_Department.Instance.DeleteAdvance(_id);
//Ghi log
TBL_DEPARTMENT oldDepartment = DA_Department.Instance.GetById(id);
WriteLog("Department", "Delete", oldDepartment, null);
return(RedirectToAction("Index"));
}
public JsonResult AddOrUpdateEntity(TBL_DEPARTMENT item, bool isEdit)
{
if (!string.IsNullOrWhiteSpace(item.DepartmentName) && ((isEdit && item.DepartmentID > 0) || !isEdit))
{
try
{
int result = isEdit ? DA_Department.Instance.Update(item) : DA_Department.Instance.Insert(item);
return(Json(result > 0 ? 1 : 0));
}
catch (Exception ex) { }
}
return(Json(0));
}
public ActionResult Create()
{
TBL_DEPARTMENT Item = new TBL_DEPARTMENT();
if (Request.QueryString["p"] != null)
{
int parent = 0;
int.TryParse(Request.QueryString["p"].ToString(), out parent);
Item.ParentID = parent;
}
RepairToShow();
return(View(Item));
}
public HttpResponseMessage DepartmentAdd(DepartmentModel _DepartmentModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
if (_DepartmentModel.DEPARTMENT_ID == null || _DepartmentModel.DEPARTMENT_ID == 0)
{
TBL_DEPARTMENT gd = new TBL_DEPARTMENT();
gd.COMPANY_ID = _DepartmentModel.COMPANY_ID;
gd.DEPARTMENT_NAME = _DepartmentModel.DEPARTMENT_NAME;
gd.SORT_INDEX = _DepartmentModel.SORT_INDEX;
gd.IS_DELETE = false;
gd.STATUS = _DepartmentModel.STATUS;
gd.CREATED_BY = _DepartmentModel.CREATED_BY;
gd.CREATED_DATE = System.DateTime.Now;
db.TBL_DEPARTMENT.Add(gd);
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, "ok"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
public JsonResult delete()
{
try
{
//jQuery DataTables Param
string id = (Request.Form.GetValues("id").FirstOrDefault() == null
? ""
: Request.Form.GetValues("id").FirstOrDefault().ToString());
if (id.All(Char.IsDigit))
{
TBL_DEPARTMENT department = DA_Department.Instance.GetById(Convert.ToInt32(id));
return(Json(department == null ? 0 : DA_Department.Instance.Delete(department)));
}
return(Json(0));
}
catch (Exception ex)
{
return(Json(0));
}
}
