public ActionResult UpdateDepartment(DEPARTMENT departments, HttpPostedFileBase postedFile)
{
int departmentId = departments.Id;
DEPARTMENT department = ManageStudent.DEPARTMENTs.SingleOrDefault(u => u.Id == departmentId && u.Status == false);
if (ModelState.IsValid)
{
if (SaveImage(postedFile))
{
if (postedFile != null)
{
department.Images = "images/" + postedFile.FileName;
}
department.DepartmentName = departments.DepartmentName;
department.Description = departments.Description;
department.Seat = departments.Seat;
ManageStudent.SaveChanges();
ViewBag.Status = "Update " + departments.DepartmentName + " successful !!!";
}
else
{
ViewBag.Status = "Update " + departments.DepartmentName + " failed !!!";
}
}
List <DEPARTMENT> dep = ManageStudent.DEPARTMENTs.Where(u => u.Status == false).ToList <DEPARTMENT>();
return(View("Department", dep));
}
public IHttpActionResult PostDEPARTMENT(DEPARTMENT dEPARTMENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
dEPARTMENT.DEPARTMENT_ID = (short)(db.DEPARTMENTs.Max(t => t.DEPARTMENT_ID) + 1);
db.DEPARTMENTs.Add(dEPARTMENT);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (DEPARTMENTExists(dEPARTMENT.DEPARTMENT_ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = dEPARTMENT.DEPARTMENT_ID }, dEPARTMENT));
}
public IHttpActionResult Post(DEPARTMENT dEPARTMENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
db.PostSingleDepartment(dEPARTMENT);
}
catch (DbUpdateException)
{
if (db.DEPARTMENTExists(dEPARTMENT.DEPARTMENT_ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = dEPARTMENT.DEPARTMENT_ID }, dEPARTMENT));
}
public IHttpActionResult PutDEPARTMENT(short id, DEPARTMENT dEPARTMENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dEPARTMENT.DEPARTMENT_ID)
{
return(BadRequest());
}
db.Entry(dEPARTMENT).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DEPARTMENTExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void btnSave_Click(object sender, EventArgs e)
{
var obj = new DEPARTMENT();
obj.DEPARTMENT_CODE = popTxtDepartmentCode.Text;
obj.DEPARTMENT_NAME = txtDepartmentName.Text;
var cmd = new DepartmentService(obj);
if (flag.Text.Equals("Add"))
{
obj.Action = ActionEnum.Create;
obj.CREATE_DATE = DateTime.Now;
obj.CREATE_EMPLOYEE_ID = 0;
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Add();
}
else
{
obj.Action = ActionEnum.Update;
obj.DEPARTMENT_ID = Convert.ToInt32(ViewState["depId"].ToString());
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Edit();
}
ViewState["depId"] = null;
Response.Redirect("SearchDepartment.aspx");
}
private List <DEPARTMENT> MapDEPARTMENT(DataTable dt)
{
List <DEPARTMENT> rs = new List <DEPARTMENT>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DEPARTMENT obj = new DEPARTMENT();
if (dt.Columns.Contains("Department_ID"))
{
obj.Department_ID = dt.Rows[i]["Department_ID"].ToString();
}
if (dt.Columns.Contains("Department_Name"))
{
obj.Department_Name = dt.Rows[i]["Department_Name"].ToString();
}
if (dt.Columns.Contains("Description"))
{
obj.Description = dt.Rows[i]["Description"].ToString();
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
rs.Add(obj);
}
return(rs);
}
public string SinhMaBoPhan()
{
string MaKhachHang, MaTam;
MaKhachHang = "";
MaTam = "";
objdepartment = new DEPARTMENTController().DEPARTMENT_Top1();
MaTam = objdepartment.Department_ID;
if (MaTam != "")
{
long NumberKhuVuc = long.Parse(MaTam.Substring(2, 6)) + 1;
MaKhachHang = NumberKhuVuc.ToString();
for (int i = NumberKhuVuc.ToString().Length; i < 6; i++)
{
MaKhachHang = "0" + MaKhachHang;
//MessageBox.Show(MaKhuVuc);
}
MaKhachHang = "BP" + MaKhachHang;
}
else
{
MaKhachHang = "BP000001";
}
return(MaKhachHang);
}
private void RemoveDepartment(DEPARTMENT d)
{
DepartmentDao.Instace().Delete(d.DEPT_ID);
DeparmentLists = null;
DeparmentLists= new ObservableCollection<DEPARTMENT>(DepartmentDao.Instace().getAll());
}
public int Update(int input)
{
string nama;
var departments = context.Departments.Find(input);
Console.WriteLine("\n-------Data Sebelum Diupdate---------");
Console.WriteLine("Id : " + departments.department_id);
Console.WriteLine("Name Department : " + departments.name);
Console.WriteLine("-------------------------------------\n");
Console.Write("Masukan Nama Department : ");
nama = Console.ReadLine();
DEPARTMENT dEPARTMENT = GetById(input);
dEPARTMENT.name = nama;
context.Entry(dEPARTMENT).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
Console.WriteLine("\n-------Data Setelah Diupdate---------");
Console.WriteLine("Id : " + dEPARTMENT.department_id);
Console.WriteLine("Name Department : " + dEPARTMENT.name);
Console.WriteLine("-------------------------------------");
return(input);
}
public IHttpActionResult Put(short id, DEPARTMENT dEPARTMENT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dEPARTMENT.DEPARTMENT_ID)
{
return(BadRequest());
}
try
{
db.PutSingleDepartment(dEPARTMENT);
}
catch (DbUpdateConcurrencyException)
{
if (!db.DEPARTMENTExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtDepartment.Text.Trim() == "")
{
MessageBox.Show("Please fill the name field");
}
else
{
DEPARTMENT department = new DEPARTMENT();
if (!isUpdated)
{
department.DepartamentName = txtDepartment.Text;
BLL.DepartmentBLL.AddDepartment(department);
MessageBox.Show("Department added!");
txtDepartment.Clear();
}
else
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "Warning", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
department.ID = detail.ID;
department.DepartamentName = txtDepartment.Text;
DepartmentBLL.UpdateDepartment(department);
MessageBox.Show("Department updated!");
this.Close();
}
}
}
}
public ActionResult DeleteConfirmed(int id)
{
DEPARTMENT dEPARTMENT = db.DEPARTMENTs.Find(id);
db.DEPARTMENTs.Remove(dEPARTMENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public List <DEPARTMENT> GetALL(DEPARTMENT item)
{
using (var ctx = new SPWEntities())
{
var list = ctx.DEPARTMENT.Where(x => x.DEPARTMENT_CODE.Contains(item.DEPARTMENT_CODE)).ToList();
return(list);
}
}
public DEPARTMENT ReadDepartment(DEPARTMENT dept)
{
dept.DEPT_NAME = tbDeptName.Text;
dept.DEPT_CODE = tbDeptCode.Text;
dept.STATUS = ddlDeptStatus.SelectedValue;
isNew = false;
return(dept);
}
public static DEPARTMENT GetDEPARTMENTByID(int id)
{
DEPARTMENT dEPARTMENT = new DEPARTMENT();
SqlDEPARTMENTProvider sqlDEPARTMENTProvider = new SqlDEPARTMENTProvider();
dEPARTMENT = sqlDEPARTMENTProvider.GetDEPARTMENTByID(id);
return(dEPARTMENT);
}
public void Load_Data(DEPARTMENT objunit)
{
this.objunit = objunit;
txtMa.Text = objunit.Department_ID;
txtTenKV.Text = objunit.Department_Name;
txtGhiChu.Text = objunit.Description;
checkactive.Checked = objunit.Active;
}
public IHttpActionResult Post(DEPARTMENT student)
{
Db.DEPARTMENTs.Add(student);
Db.SaveChanges();
return(Ok());
}
public ICollection <EMPLOYEE> GetEmployeesByDepartmentID(int departID)
{
DEPARTMENT dEPARTMENT = db.DEPARTMENTs.Find(departID);
if (dEPARTMENT == null)
{
return(null);
}
return(dEPARTMENT.EMPLOYEEs);
}
protected void uclAdminList_OnDeptClick(decimal deptID)
{
PLANT plant = (PLANT)SessionManager.EffLocation.Plant;
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, (decimal)plant.COMPANY_ID, (decimal)plant.BUS_ORG_ID, (decimal)plant.PLANT_ID, deptID, "", false);
uclSubLists.ToggleVisible(null);
pnlAdminEdit.Visible = true;
uclAdminEdit.BindDeptartment(dept);
LocalOrg().EditObject = dept;
}
protected void uclAdminList_OnDeptClick(decimal deptID)
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, SessionManager.EffLocation.Company.COMPANY_ID, busOrg.BUS_ORG_ID, 0, deptID, "", false);
uclSubLists.ToggleVisible(null);
pnlAdminEdit.Visible = true;
uclAdminEdit.BindDeptartment(dept);
LocalOrg().EditObject = dept;
}
public ActionResult Edit([Bind(Include = "Name,Dept_ID,Last_update,Last_update_by")] DEPARTMENT dEPARTMENT)
{
if (ModelState.IsValid)
{
db.Entry(dEPARTMENT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dEPARTMENT));
}
/// <summary>
/// Add a new Department
/// </summary>
/// <param name="Department">The Department to add</param>
/// <returns>True if Department is added successfuly otherwise false</returns>
public bool AddDepartment(DEPARTMENT department)
{
if (department != null)
{
db.DEPARTMENTs.Add(department);
db.SaveChanges();
return(true);
}
return(false);
}
public ActionResult Edit([Bind(Include = "DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER,NOTED")] DEPARTMENT dEPARTMENT)
{
if (ModelState.IsValid)
{
db.Entry(dEPARTMENT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MANAGER = new SelectList(db.USERS, "USER_ID", "USERNAME", dEPARTMENT.MANAGER);
return(View(dEPARTMENT));
}
public IHttpActionResult GetDEPARTMENT(short id)
{
DEPARTMENT dEPARTMENT = db.DEPARTMENTs.Find(id);
if (dEPARTMENT == null)
{
return(NotFound());
}
return(Ok(dEPARTMENT));
}
public static void AddDepartment(DEPARTMENT department)
{
try
{
db.DEPARTMENTs.InsertOnSubmit(department);
db.SubmitChanges();
}catch (Exception ex)
{
throw ex;
}
}
public DEPARTMENT GetById(int input)
{
DEPARTMENT departments = context.Departments.Find(input);
if (departments == null)
{
Console.Write("Id " + input + " Tidak Ada");
Console.Read();
}
return(departments);
}
public ActionResult Create([Bind(Include = "Name,Dept_ID,Last_update,Last_update_by")] DEPARTMENT dEPARTMENT)
{
if (ModelState.IsValid)
{
db.DEPARTMENTs.Add(dEPARTMENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dEPARTMENT));
}
private void ShowEditForm(DEPARTMENT p)
{
if (p != null)
{
DepartmentEdit depart = new DepartmentEdit("update", this);
depart.Show();
depart.txtDepID.Text = p.DEPT_ID.ToString();
depart.txtDepID.IsReadOnly = true;
depart.txtName.Text = p.NAME;
}
}
public ActionResult Create([Bind(Include = "DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER,NOTED")] DEPARTMENT dEPARTMENT)
{
if (ModelState.IsValid)
{
db.DEPARTMENTS.Add(dEPARTMENT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MANAGER = new SelectList(db.USERS, "USER_ID", "USERNAME", dEPARTMENT.MANAGER);
return(View(dEPARTMENT));
}
public bool DeleteSingleDepartment(short departID)
{
DEPARTMENT dEPARTMENT = db.DEPARTMENTs.Find(departID);
if (dEPARTMENT == null)
{
return(false);
}
db.DEPARTMENTs.Remove(dEPARTMENT);
db.SaveChanges();
return(true);
}
public int SaveDataDeparment(DepartmentModel data)
{
try
{
if (data.DepartmentID == 0)
{
var departmentcheck = _context.DEPARTMENTs.Where(x => x.DepartmentName == data.DepartmentName).ToList();
if (departmentcheck.Count > 0)
{
return -1;
}
var department = new DEPARTMENT();
department.DepartmentName = data.DepartmentName;
department.Status = 1;
department.CreateBy = data.UpdateBy;
department.CreateDate = DateTime.Now;
department.UpdateBy = data.UpdateBy;
department.UpdateDate = DateTime.Now;
_context.Entry(department).State = EntityState.Added;
_context.SaveChanges();
return 1;
}
else
{
var departmentcheck = _context.DEPARTMENTs.Where(x => x.DepartmentName == data.DepartmentName && x.DepartmentID!=data.DepartmentID).ToList();
if (departmentcheck.Count > 0)
{
return -1;
}
var department = _context.DEPARTMENTs.Find(data.DepartmentID);
if (department != null)
{
department.DepartmentName = data.DepartmentName;
department.UpdateBy = data.UpdateBy;
department.UpdateDate = DateTime.Now;
_context.Entry(department).State = EntityState.Modified;
_context.SaveChanges();
return 1;
}
return 0;
}
}
catch (Exception ex)
{
LogPOS.WriteLog("SaveDataDeparment :::::::::::::::::::::::::" + ex.Message);
return 0;
}
}
