public string SaveDepartment(DepartmentModels departmentModel)
        {
            DepartmentDTO department = new DepartmentDTO();
            MessageDTO    message    = new MessageDTO();

            department.Company = new CompanyDTO {
                CompanyId = Convert.ToInt32(departmentModel.CompanyId)
            };
            department.DepartmentDescription = departmentModel.DepartmentDescription;
            department.DepartmentId          = Convert.ToInt32(departmentModel.Id);
            department.DepartmentStatus      = departmentModel.DepartmentStatus;
            department.SpendingCenter        = new SpendingCenterDTO {
                SpendingCenterId = Convert.ToInt32(departmentModel.SpendingCenterId)
            };
            department.User = new UserDTO {
                UserId = Convert.ToInt32(departmentModel.UserId)
            };

            if (String.Compare(departmentModel.Operation, "add", StringComparison.Ordinal) == 0)
            {
                message = business.SaveDepartment(department, "I");
            }
            else if (String.Compare(departmentModel.Operation, "edit", StringComparison.Ordinal) == 0)
            {
                message = business.SaveDepartment(department, "U");
            }

            JavaScriptSerializer oSerializer = new JavaScriptSerializer();
            string sJSON = oSerializer.Serialize(message);

            return(sJSON);
        }
示例#2
0
        public IHttpActionResult Put(int Id, DepartmentModels department)
        {
            //var dept_id = conn.Departments.FirstOrDefault(x => x.Id == Id);

            //if (dept_id == null)
            //{
            //    return Content(System.Net.HttpStatusCode.NotFound, "Id not found");
            //}
            //else if (department.Name == "")
            //{
            //    return Content(System.Net.HttpStatusCode.NotFound, "Name cannot empty");
            //}
            //else
            //{
            //    departments.Update(Id, department);
            //    return Ok("Update successfully");
            //}
            var put = departments.Update(Id, department);

            if (put > 0)
            {
                return(Ok("Department Update Successfully"));
            }
            return(BadRequest("Failed to Update Department"));
        }
示例#3
0
 public IHttpActionResult Post(DepartmentModels department)
 {
     if (department.Name == "")
     {
         return(Content(HttpStatusCode.NotFound, "Failed To Add"));
     }
     departments.Create(department);
     return(Ok("Department Add Successfully"));
 }
示例#4
0
        public int Create(DepartmentModels department)
        {
            //throw new NotImplementedException();
            var procName = "SP_InsertDepartment";

            parameters.Add("@Name", department.Name);
            var create = conn.Execute(procName, parameters, commandType: CommandType.StoredProcedure);

            return(create);
        }
示例#5
0
        public int Update(int Id, DepartmentModels department)
        {
            //throw new NotImplementedException();
            var procName = "SP_UpdateDepartment";

            parameters.Add("@Id", Id);
            parameters.Add("@Name", department.Name);
            var update = conn.Execute(procName, parameters, commandType: CommandType.StoredProcedure);

            return(update);
        }
        public IHttpActionResult CreateDepartments(DepartmentModels model)
        {
            var response = new DataResponse <EntityDepartments>();

            var entitydepartments = new EntityDepartments();

            entitydepartments.DepartmentName      = model.DepartmentName;
            entitydepartments.Description         = model.Description;
            entitydepartments.BusinessId          = CurrentBusinessId;
            entitydepartments.CreatedBy           = CurrentUserId;
            entitydepartments.CreatedOn           = DateTime.UtcNow;
            entitydepartments.DepartmentPrivilege = model.DepartmentPrivilege;
            response = repository.Insert(entitydepartments);
            return(Ok <DataResponse>(response));
        }
        public IHttpActionResult UpdateDepartment(DepartmentModels model)
        {
            var response = new DataResponse <EntityDepartments>();

            if (ModelState.IsValid)
            {
                var entityDepartments = new EntityDepartments();
                entityDepartments.Id                  = model.Id;
                entityDepartments.DepartmentName      = model.DepartmentName;
                entityDepartments.Description         = model.Description;
                entityDepartments.IsActive            = model.IsActive;
                entityDepartments.UpdatedBy           = CurrentUserId;
                entityDepartments.UpdatedOn           = System.DateTime.UtcNow;
                entityDepartments.DepartmentPrivilege = model.DepartmentPrivilege;
                response = repository.Update(entityDepartments);
            }
            return(Ok <DataResponse>(response));
        }
示例#8
0
        public static List <DepartmentModels> GetAllDepartment()
        {
            SqlConnection con = new SqlConnection(connection);
            SqlCommand    cmd = new SqlCommand("usp_Department_GetAll", con);

            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();
            SqlDataReader           reader   = cmd.ExecuteReader();
            List <DepartmentModels> dpmodels = new List <DepartmentModels>();

            while (reader.Read())
            {
                DepartmentModels models = new DepartmentModels();
                models.DepartName = DBNull.Value != reader["DepartmentName"] ? (string)reader["DepartmentName"] : default(string);
                models.Id         = DBNull.Value != reader["Id"] ? (int)reader["Id"] : default(int);
                dpmodels.Add(models);
            }
            reader.Close();
            con.Close();
            return(dpmodels);
        }
示例#9
0
        public ActionResult addDepartment(DepartmentModels pModel)
        {
            DepartmentCOMMON unDpto = new DepartmentCOMMON();

            unDpto.Name = pModel.Name;
            List <DepartmentCOMMON> theList = new List <DepartmentCOMMON>();

            if (Session["LaLista"] != null)
            {
                theList = (List <DepartmentCOMMON>)Session["LaLista"];
            }

            theList.Add(unDpto);
            Fachada Fachada = new Fachada();

            Fachada.Department_Add(unDpto);
            Session["LaLista"] = theList;
            #region Vaciar Textboxs

            pModel.mensaje = "Ingreso Correcto";
            #endregion
            return(View(pModel));
        }
示例#10
0
        private void Initialize()
        {
            List <string> Product_List = ProductID.Split(',').ToList();

            Db2HoldReason.Conditions = string.Format("where lot_type='Production' and prodspec_id in ('{2}')  and claim_time between '{0}' and '{1}'", StartTime.ToString("yyyy-MM-dd HH:mm:ss"), EndTime.ToString("yyyy-MM-dd HH:mm:ss"), string.Join("','", Product_List));
            var Models = Db2HoldReason.GetEntities().EntityList;
            //if (Models.Count == 0) return;
            //lotCount
            int lotCount = Models.Select(s => s.Lot_ID).Distinct().Count();
            //所有Hold数据
            var HoldModels = Models.Where(w => w.Hold_Type != "" && w.Ope_Category.Substring(w.Ope_Category.Length - 4) == "Hold");
            //5码的Hold数据
            var HoldModels_5 = HoldModels.Where(w => w.Hold_Reason_Code.Length == 5);
            //4码的hold数据
            var         HoldModels_4 = HoldModels.Where(w => w.Hold_Reason_Code.Length == 4);
            List <FRPD> PD_List      = new List <FRPD>();

            if (HoldModels_4.Count() > 0)
            {
                PDCatcher.Conditions = string.Format("where pd_id in ('{0}')", string.Join("','", HoldModels_4.Select(s => s.PD_ID)));
                PD_List = PDCatcher.GetEntities().EntityList.ToList();
            }
            var Departments = DepartmentCatcher.GetEntities().EntityList;

            foreach (var department in Departments)
            {
                //对每个部门计算该部门对应的hold list
                var list5 = HoldModels_5.Where(w => w.Hold_Reason_Code.Substring(0, 1) == department.Code_ID);
                var list4 = HoldModels_4.Where(w => PD_List.Where(p => p.Department == department.Code_ID).DefaultIfEmpty().Select(s => s.PD_ID).Contains(w.PD_ID));
                var list  = list4.Union(list5);
                List <ReqRpt014DepartmentTableEntity> l = new List <ReqRpt014DepartmentTableEntity>();
                if (list.Count() == 0)  //如果没有元素,则不进行查找
                {
                    DepartmentModels.Add(new ReqRpt014DepartmentTableModel(l)
                    {
                        Department = department.Description
                    });
                    continue;
                }
                //如果存在元素,则进行下去
                var ReasonList = list.GroupBy(g => g.Hold_Reason_Code).Select(s => new { Hold_Reason_Code = s.Key, Hold_Count = s.Count() });
                foreach (var item in ReasonList)
                {
                    ReqRpt014DepartmentTableEntity tableEntity = new ReqRpt014DepartmentTableEntity()
                    {
                        HoldCode = item.Hold_Reason_Code, HoldRate = item.Hold_Count / lotCount, LotCount = list.Where(w => w.Hold_Reason_Code == item.Hold_Reason_Code).Select(s => s.Lot_ID).Distinct().Count()
                    };
                    l.Add(tableEntity);
                }
                DepartmentModels.Add(new ReqRpt014DepartmentTableModel(l)
                {
                    Department = department.Description
                });
            }

            //by product部分
            foreach (string prod in Product_List)
            {
                var list = HoldModels.Where(s => s.ProdSpec_ID == prod);
                List <ReqRpt014ProductTableEntity> l = new List <ReqRpt014ProductTableEntity>();

                if (list is null)  //如果没有元素,则不进行查找
                {
                    ProductModels.Add(new ReqRpt014ProductTableModel(l)
                    {
                        ProductID = prod
                    });
                    continue;
                }
                //如果存在元素,则进行下去
                var ReasonList = list.GroupBy(g => g.Hold_Reason_Code).Select(s => new { Hold_Reason_Code = s.Key, HoldCount = s.Count() });
                foreach (var item in ReasonList)
                {
                    ReqRpt014ProductTableEntity tableEntity = new ReqRpt014ProductTableEntity()
                    {
                        HoldCode = item.Hold_Reason_Code, HoldRate = item.HoldCount / lotCount, LotCount = list.Where(w => w.Hold_Reason_Code == item.Hold_Reason_Code).Select(s => s.Lot_ID).Distinct().Count()
                    };
                    l.Add(tableEntity);
                }
                ProductModels.Add(new ReqRpt014ProductTableModel(l)
                {
                    ProductID = prod
                });
            }
        }