Beispiel #1
0
 public override bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
 {
     notification = new Library.DTO.Notification()
     {
         Type = Library.DTO.NotificationType.Success
     };
     DTO.ProductionStatisticsDTO dtoProductionStatistics = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.ProductionStatisticsDTO>();
     try
     {
         int?companyID = fw_factory.GetCompanyID(userId);
         using (ProductionStatisticsMngEntities context = CreateContext())
         {
             ProductionStatistics dbItem = null;
             if (id == 0)
             {
                 dbItem = new ProductionStatistics();
                 context.ProductionStatistics.Add(dbItem);
             }
             else
             {
                 dbItem = context.ProductionStatistics.Where(o => o.ProductionStatisticsID == id).FirstOrDefault();
             }
             if (dbItem == null)
             {
                 notification.Message = "data not found!";
                 return(false);
             }
             else
             {
                 //convert dto to db
                 converter.DTO2DB_ProductionStatistics(dtoProductionStatistics, ref dbItem, userId, companyID);
                 //remove orphan
                 context.ProductionStatisticsDetail.Local.Where(o => o.ProductionStatistics == null).ToList().ForEach(o => context.ProductionStatisticsDetail.Remove(o));
                 //save data
                 context.SaveChanges();
                 //get return data
                 dtoItem = GetData(userId, dbItem.ProductionStatisticsID, null, out notification).Data;
                 return(true);
             }
         }
     }
     catch (Exception ex)
     {
         notification.Type    = Library.DTO.NotificationType.Error;
         notification.Message = Library.Helper.GetInnerException(ex).Message;
         return(false);
     }
 }
Beispiel #2
0
        public override DTO.EditFormData GetData(int userId, int id, Hashtable param, out Library.DTO.Notification notification)
        {
            DTO.EditFormData editFormData = new DTO.EditFormData();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (ProductionStatisticsMngEntities context = CreateContext())
                {
                    int?companyID = fw_factory.GetCompanyID(userId);
                    if (id > 0)
                    {
                        var dbItem = context.ProductionStatisticsMng_ProductionStatistics_View.Where(o => o.CompanyID == companyID).FirstOrDefault(o => o.ProductionStatisticsID == id);
                        editFormData.Data = converter.DB2DTO_ProductionStatistics(dbItem);
                    }
                    else
                    {
                        //initialize item data base on selected workorder
                        int    workCenterID = Convert.ToInt32(param["workCenterID"]);
                        string producedDate = param["producedDate"].ToString();

                        //init value
                        editFormData.Data.WorkCenterID = workCenterID;
                        editFormData.Data.ProducedDate = producedDate;
                        editFormData.Data.WorkCenterNM = new Module.Support.DAL.DataFactory().GetWorkCenter().Where(o => o.WorkCenterID == workCenterID).FirstOrDefault().WorkCenterNM;

                        //get planning production by workcenter
                        var planningProductionTeam = context.ProductionStatisticsMng_function_GetPlanningProductionTeam(companyID, workCenterID, producedDate).ToList();
                        editFormData.Data.ProductionStatisticsDetailDTOs = AutoMapper.Mapper.Map <List <ProductionStatisticsMng_PlanningProductionTeam_View>, List <DTO.ProductionStatisticsDetailDTO> >(planningProductionTeam);
                    }
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = Library.Helper.GetInnerException(ex).Message;
            }
            return(editFormData);
        }
Beispiel #3
0
 public override object GetInitData(int userId, out Notification notification)
 {
     DTO.InitFormData data = new DTO.InitFormData();
     notification = new Library.DTO.Notification()
     {
         Type = Library.DTO.NotificationType.Success
     };
     try
     {
         using (ProductionStatisticsMngEntities context = CreateContext())
         {
             var wc = context.WorkCenter.Where(o => o.IsVirtual.HasValue && o.IsVirtual.Value).ToList();
             data.WorkCenterDTOs = AutoMapper.Mapper.Map <List <WorkCenter>, List <DTO.WorkCenterDTO> >(wc);
         }
     }
     catch (Exception ex)
     {
         notification.Type    = Library.DTO.NotificationType.Error;
         notification.Message = Library.Helper.GetInnerException(ex).Message;
     }
     return(data);
 }
Beispiel #4
0
        public override DTO.SearchFormData GetDataWithFilter(int userId, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
        {
            DTO.SearchFormData searchFormData = new DTO.SearchFormData();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            totalRows = 0;
            try
            {
                int?   workCenterID = null;
                string producedDate = null;

                int?companyID = fw_factory.GetCompanyID(userId);

                if (filters.ContainsKey("workCenterID") && filters["workCenterID"] != null)
                {
                    workCenterID = Convert.ToInt32(filters["workCenterID"]);
                }
                if (filters.ContainsKey("producedDate") && !string.IsNullOrEmpty(filters["producedDate"].ToString()))
                {
                    producedDate = filters["producedDate"].ToString().Replace("'", "''");
                }
                using (ProductionStatisticsMngEntities context = CreateContext())
                {
                    totalRows = context.ProductionStatisticsMng_function_SearchProductionStatistics(orderBy, orderDirection, companyID, workCenterID, producedDate).Count();
                    var result = context.ProductionStatisticsMng_function_SearchProductionStatistics(orderBy, orderDirection, companyID, workCenterID, producedDate);
                    searchFormData.Data = converter.DB2DTO_Search(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = Library.Helper.GetInnerException(ex).Message;
            }
            return(searchFormData);
        }
Beispiel #5
0
        public List <DTO.PlanningProductionTeamDTO> GetPlanningProductionTeam(int userId, int workCenterID, string producedDate, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            List <DTO.PlanningProductionTeamDTO> data = new List <DTO.PlanningProductionTeamDTO>();

            try
            {
                using (ProductionStatisticsMngEntities context = CreateContext())
                {
                    int?companyID = fw_factory.GetCompanyID(userId);
                    var planningProductionTeam = context.ProductionStatisticsMng_function_GetPlanningProductionTeam(companyID, workCenterID, producedDate).ToList();
                    data = AutoMapper.Mapper.Map <List <ProductionStatisticsMng_PlanningProductionTeam_View>, List <DTO.PlanningProductionTeamDTO> >(planningProductionTeam);
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = Library.Helper.GetInnerException(ex).Message;
            }
            return(data);
        }