public static string UpdateDept(string Deptstr)
{
string str = string.Empty;
try
{
tbDepartment tb = JsonConvert.DeserializeObject <tbDepartment>(Deptstr);
AchieveDBEntities myDbContext = new AchieveDBEntities();
tbDepartment data = myDbContext.tbDepartment.Where(p => p.Id == tb.Id).FirstOrDefault();
data.DepartmentName = tb.DepartmentName;
data.ParentId = tb.ParentId;
data.Sort = tb.Sort;
data.UpdateBy = tb.UpdateBy;
data.UpdateTime = DateTime.Now;
int DataCount = myDbContext.tbDepartment.Where(p => p.DepartmentName == data.DepartmentName && p.Id != data.Id).Count <tbDepartment>();
if (DataCount > 0)
{
throw new Exception(string.Format("部门名：{0}重复，请重新输入", data.DepartmentName));
}
myDbContext.SaveChanges();
str = ResponseHelper.ResponseMsg("1", "更新成功", "");
}
catch (Exception ex)
{
str = ResponseHelper.ResponseMsg("-1", ex.Message, "");
}
return(str);
}
public static string GetDeptById(int Id)
{
string str = string.Empty;
try
{
IsoDateTimeConverter timeFormat = new IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
tbDepartment temp = new tbDepartment();
AchieveDBEntities myDbContext = new AchieveDBEntities();
List <tbDepartment> templist = myDbContext.tbDepartment.Where(p => p.Id == Id).ToList();
if (templist != null && templist.Count > 0)
{
temp = templist[0];
str = JsonConvert.SerializeObject(temp, Formatting.Indented, timeFormat);
str = ResponseHelper.ResponseMsg("1", "取数成功", str);
}
else
{
str = JsonConvert.SerializeObject(temp, Formatting.Indented, timeFormat);
str = ResponseHelper.ResponseMsg("-1", "部门不存在", str);
}
}
catch (Exception ex)
{
str = ResponseHelper.ResponseMsg("-1", ex.Message, "");
}
return(str);
}
public async Task <IActionResult> CreateDepartment(tbDepartment model)
{
if (ModelState.IsValid)
{
await _db.Departments.AddAsync(model);
await _db.SaveChangesAsync();
return(Ok(model));
}
return(BadRequest());
}
// POST: api/Emp
public void Post([FromBody] EmployeeCustomClass emp)
{
Console.WriteLine(emp);
tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(emp.DeptName));
tbEmployee newEmp = new tbEmployee();
newEmp.e_name = emp.EmpName;
newEmp.tbDepartment = dep;
//ef
empDb.tbEmployees.Add(newEmp);
empDb.SaveChanges();
}
// PUT: api/Emp/5
public void Put(int id, [FromBody] EmployeeCustomClass updateEmp)
{
if (updateEmp != null)
{
tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == updateEmp.EmpId);
tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(updateEmp.DeptName));
emp.e_name = updateEmp.EmpName;
emp.tbDepartment = dep;
empDb.SaveChanges();
}
}
public async Task <IActionResult> EditDepartment(string id, tbDepartment model)
{
if (id == null)
{
return(BadRequest(" ID cannot null!"));
}
var dep = await _db.Departments.FindAsync(id);
if (dep != null)
{
dep.Name = model.Name;
dep.Description = model.Description;
_db.Update(dep);
await _db.SaveChangesAsync();
return(Ok("Edit Success!"));
}
return(NotFound());
}
public static string AddDept(string Deptstr)
{
string str = string.Empty;
try
{
tbDepartment tb = JsonConvert.DeserializeObject <tbDepartment>(Deptstr);
tbDepartment newtb = new tbDepartment()
{
CreateBy = tb.CreateBy,
CreateTime = DateTime.Now,
DepartmentName = tb.DepartmentName,
ParentId = tb.ParentId,
Sort = tb.Sort,
UpdateBy = tb.CreateBy,
UpdateTime = DateTime.Now
};
AchieveDBEntities myDbContext = new AchieveDBEntities();
int DataCount = myDbContext.tbDepartment.Where(p => p.DepartmentName == newtb.DepartmentName).Count <tbDepartment>();
if (DataCount > 0)
{
throw new Exception(string.Format("部门名：{0}重复，请重新输入", newtb.DepartmentName));
}
myDbContext.tbDepartment.Add(newtb);
myDbContext.SaveChanges();
str = ResponseHelper.ResponseMsg("1", "保存成功", "");
}
catch (Exception ex)
{
str = ResponseHelper.ResponseMsg("-1", ex.Message, "");
}
return(str);
}
