public void Insert(DepartmentParam param)
{
var department = new Department(param.Name);
db.Departments.Add(department);
db.SaveChanges();
}
public ActionResult Edit(int?id)
{
var department = _departmentRepository.Get(id);
var toview = new DepartmentParam(department);
return(View(toview));
}
public void Update(int?id, DepartmentParam param)
{
var department = Get(id);
department.Update(param.Name);
db.SaveChanges();
}
public object DeleteDepartment(DepartmentParam MP)
{
try
{
Tbl_Department_Master objdepartment = db.Tbl_Department_Master.Where(r => r.DepartmentID == MP.DepartmentID).FirstOrDefault();
if (objdepartment.Status == 1)
{
objdepartment.Status = 0;
}
else
{
objdepartment.Status = 1;
}
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Department Updated Successfully!"
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public Department(DepartmentParam departmentparam)
{
this.Name = departmentparam.Name;
this.Companies.Name = departmentparam.Companies;
this.CreateDate = DateTimeOffset.Now.LocalDateTime;
this.CreatedBy = departmentparam.Id;
}
public virtual void Update(DepartmentParam departmentparam)
{
this.Id = departmentparam.Id;
this.Name = departmentparam.Name;
this.Companies.Name = departmentparam.Companies;
this.UpdateDate = DateTimeOffset.Now.LocalDateTime;
this.UpdatedBy = departmentparam.Id;
}
public ActionResult Edit(int?id, DepartmentParam param)
{
if (ModelState.IsValid)
{
_departmentRepository.Update(id, param);
return(RedirectToAction("Index"));
}
return(View(param));
}
public object SaveDepartment(DepartmentParam MP)
{
try
{
string msg = "";
if (MP.BtnStatus == "Save")
{
var usercode = db.Tbl_Department_Master.Where(r => r.Department == MP.Department.ToUpper()).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "Department Name Already Exists!"
});
}
Tbl_Department_Master objDepartment = new Tbl_Department_Master();
objDepartment.Department = MP.Department.ToUpper();
objDepartment.CreatedBy = MP.CreatedBy;
objDepartment.CreatedDate = DateTime.Now;
objDepartment.Status = 1;
db.Tbl_Department_Master.Add(objDepartment);
db.SaveChanges();
msg = "Department Saved Successfully!";
}
else
{
Tbl_Department_Master objDepartment = db.Tbl_Department_Master.Where(r => r.DepartmentID == MP.DepartmentID).FirstOrDefault();
var Data = db.Tbl_Department_Master.Where(r => r.Department == MP.Department.ToUpper()).FirstOrDefault();
if (Data != null)
{
return(new Error()
{
IsError = true, Message = "Department Name Already Exists!"
});
}
objDepartment.Department = MP.Department.ToUpper();
objDepartment.ModifiedDate = DateTime.Now;
objDepartment.DepartmentID = MP.DepartmentID;
db.SaveChanges();
msg = "Department Updated Successfully!";
}
return(new Result()
{
IsSucess = true, ResultData = msg
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public bool Update(int?id, DepartmentParam departmentParam)
{
if (_departmentRepository.Get(id) == null)
{
MessageBox.Show("Sorry, your data is not found");
}
else
{
status = _departmentRepository.Update(id, departmentParam);
}
return(status);
}
public bool Insert(DepartmentParam departmentParam)
{
if (departmentParam.Name.ToString() == " ")
{
MessageBox.Show("Don't insert white space");
}
else
{
status = _departmentRepository.Insert(departmentParam);
}
return(status);
}
public bool Insert(DepartmentParam departmentParam)
{
var result = 0;
department.Name = departmentParam.Name;
department.CreateDate = DateTimeOffset.Now.LocalDateTime;
_context.Departments.Add(department);
result = _context.SaveChanges();
if (result > 0)
{
status = true;
MessageBox.Show("Insert Successfully");
}
return(status);
}
public object GetSingleDepartment(DepartmentParam objgr)
{
try
{
var SingleDepartmentlist = db.ViewDepartmentLists.Where(r => r.DepartmentID == objgr.DepartmentID).FirstOrDefault();
return(SingleDepartmentlist);
}
catch (Exception E)
{
return(new Error()
{
IsError = true, Message = E.Message
});
}
}
public object SaveDepartment([FromBody] DepartmentParam PR)
{
try
{
DepartmentBL OBJSAVE = new DepartmentBL();
var result = OBJSAVE.SaveDepartment(PR);
return(result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object DeleteDepartment([FromBody] DepartmentParam MP)
{
try
{
DepartmentBL obj = new DepartmentBL();
var result = obj.DeleteDepartment(MP);
return(result);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object GetSingleDepartmentInfo([FromBody] DepartmentParam OBJGR)
{
try
{
DepartmentBL obj = new DepartmentBL();
var SingleGR = obj.GetSingleDepartment(OBJGR);
return(SingleGR);
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object GetDepartmentMaster([FromBody] DepartmentParam objid)
{
try
{
var status = objid.Status;
DepartmentBL obj = new DepartmentBL();
var ERPDepartment = obj.GetDepartmentList(status);
return(ERPDepartment);
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public bool Update(int?id, DepartmentParam departmentParam)
{
var result = 0;
var department = Get(id);
department.Name = departmentParam.Name;
department.UpdateDate = DateTimeOffset.Now.LocalDateTime;
result = _context.SaveChanges();
if (result > 0)
{
status = true;
MessageBox.Show("Update Successfully");
}
else
{
MessageBox.Show("Update Failed");
}
return(status);
}
//查询
private void query(int pageNo)
{
try
{
resultInfo("正在查询，请稍后...");
isQuery = true;
//清空面板
clear();
departmentList = null;
DepartmentParam param = new DepartmentParam();
param.pageNo = pageNo.ToString();
param.hospital_code = RegistrationClass.hospitalInfo.hospital_code;
param.pageSize = "12";
departmentList = RegistrationAccess.DepartmentQuery(param);
if ("9999".Equals(departmentList.success))
{
resultInfo(departmentList.msg);
return;
}
if (departmentList.data.rows.Count == 0)
{
resultInfo("该医院暂未提供预约信息");
return;
}
for (int i = 0; i < departmentList.data.rows.Count; i++)
{
setButton(this, ("button" + (i + 1)), ("name" + (i + 1)), departmentList.data.rows[i].dept_name);
}
resultInfo("请选择科室");
return;
}
catch (ThreadAbortException ae) { log.Write("error:" + ae.Message); }
catch (Exception ex)
{
resultInfo("暂无预约信息");
log.Write("error:FormRegistrationDepartment_2:query():" + ex.Message);
}
finally
{
isQuery = false;
}
}
public bool Update(int?id, DepartmentParam departmentParam)
{
if (_departmentRepository.Get(id) == null)
{
MessageBox.Show("Sorry, your data is not found");
}
else if (id.ToString() == " ")
{
MessageBox.Show("Don't insert white space in Id");
}
else
{
if (departmentParam.Name.ToString() == " ")
{
MessageBox.Show("Don't insert white space in Name");
}
else
{
status = _departmentRepository.Update(id, departmentParam);
}
}
return(status);
}
public JsonResult Update(int id, DepartmentParam param)
{
_departmentRepository.Update(id, param);
return(Json(JsonRequestBehavior.AllowGet));
}
public virtual void Delete(DepartmentParam departmentparam)
{
this.IsDelete = true;
this.DeleteDate = DateTimeOffset.Now.LocalDateTime;
}
public bool Insert(DepartmentParam departmentParam)
{
return(_departmentRepository.Insert(departmentParam));
}
public ActionResult Create(DepartmentParam param)
{
_departmentRepository.Insert(param);
return(RedirectToAction("Index"));
}
public JsonResult Add(DepartmentParam param)
{
_departmentRepository.Insert(param);
return(Json(Index(), JsonRequestBehavior.AllowGet));
}
public void Insert(DepartmentParam param)
{
_departmentRepository.Insert(param);
}
public void Update(int?id, DepartmentParam param)
{
_departmentRepository.Update(id, param);
}
