예제 #1
0
        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
                });
            }
        }
예제 #2
0
        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
                });
            }
        }