Example #1
0
        public DTO.ProductInfo.FormData GetProductInfoData(int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.ProductInfo.FormData data = new DTO.ProductInfo.FormData();
            data.Data = new DTO.ProductInfo.ProductDTO();
            data.Data.ReferenceImageDTOs = new List <DTO.ProductInfo.ReferenceImageDTO>();

            try
            {
                if (id > 0)
                {
                    using (Sample3MngEntities context = CreateContext())
                    {
                        data.Data = converter.DB2DTO_ProductInfo_Product(context.Sample3Mng_ProductInfo_Product_View
                                                                         .Include("Sample3Mng_ProductInfo_ReferenceImage_View")
                                                                         .FirstOrDefault(o => o.SampleProductID == id));
                    }
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #2
0
        public DTO.ItemData.FormData GetItemData(int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.ItemData.FormData data = new DTO.ItemData.FormData();
            data.Data = new DTO.ItemData.ProductDTO();

            try
            {
                if (id > 0)
                {
                    using (Sample3MngEntities context = CreateContext())
                    {
                        data.Data = converter.DB2DTO_ItemData_Product(context.Sample3Mng_ItemData_Product_View.FirstOrDefault(o => o.SampleProductID == id));
                    }
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #3
0
        public DTO.FactoryAssignment.FormData GetFactoryAssignmentData(int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.FactoryAssignment.FormData data = new DTO.FactoryAssignment.FormData();
            data.SupportList           = new DTO.SupportData();
            data.SupportList.Factories = new List <Support.DTO.Factory>();
            data.Data = new DTO.FactoryAssignment.ProductDTO();
            data.Data.SubFactoryDTOs = new List <DTO.FactoryAssignment.SubFactoryDTO>();

            try
            {
                if (id > 0)
                {
                    using (Sample3MngEntities context = CreateContext())
                    {
                        data.Data = converter.DB2DTO_FactoryAssignment_Product(context.Sample3Mng_FactoryAssignment_Product_View.Include("Sample3Mng_FactoryAssignment_SubFactory_View").FirstOrDefault(o => o.SampleProductID == id));
                    }
                }
                data.SupportList.Factories = supportFactory.GetFactory();
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #4
0
        public bool UpdateBuildingProcessData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
        {
            DTO.BuildingProcess.ProgressDTO dtoProgress = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.BuildingProcess.ProgressDTO>();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    SampleProgress dbItem;
                    if (id <= 0)
                    {
                        dbItem = new SampleProgress();
                        context.SampleProgress.Add(dbItem);
                        dbItem.UpdatedBy   = userId;
                        dbItem.UpdatedDate = DateTime.Now;
                    }
                    else
                    {
                        dbItem = context.SampleProgress.FirstOrDefault(o => o.SampleProgressID == id);
                    }

                    if (dbItem == null)
                    {
                        notification.Message = "Progress not found!";
                        return(false);
                    }
                    else
                    {
                        // check permission
                        if (userId != dbItem.UpdatedBy)
                        {
                            throw new Exception("Can not edit progress created by other user!");
                        }
                        if ((DateTime.Now - dbItem.UpdatedDate.Value).TotalDays > 1)
                        {
                            throw new Exception("Too late to edit this progress, progress can only be updatable within 2 days from the last update!");
                        }
                        converter.DTO2DB_BuildingProcess(dtoProgress, ref dbItem, FrameworkSetting.Setting.AbsoluteUserTempFolder + userId.ToString() + @"\");
                        context.SaveChanges();
                    }

                    dtoItem = converter.DB2DTO_BuildingProcess_Progress(context.Sample3Mng_BuildingProcess_Progress_View
                                                                        .Include("Sample3Mng_BuildingProcess_ProgressImage_View")
                                                                        .FirstOrDefault(o => o.SampleProgressID == dbItem.SampleProgressID));

                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification = new Library.DTO.Notification()
                {
                    Message = ex.Message, Type = Library.DTO.NotificationType.Error
                };
                return(false);
            }
        }
Example #5
0
        public DTO.SampleOrderOverview.OrderDTO GetOrderOverviewData(int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.SampleOrderOverview.OrderDTO data = new DTO.SampleOrderOverview.OrderDTO();
            data.ProductDTOs = new List <DTO.SampleOrderOverview.ProductDTO>();
            data.MonitorDTOs = new List <DTO.SampleOrderOverview.MonitorDTO>();
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    var dbItem = context.Sample3Mng_SampleOrderOverview_Order_View
                                 .Include("Sample3Mng_SampleOrderOverview_Monitor_View")
                                 .Include("Sample3Mng_SampleOrderOverview_Product_View")
                                 .Include("Sample3Mng_SampleOrderOverview_Product_View.Sample3Mng_SampleOrderOverview_ProductSubFactory_View")
                                 .Include("Sample3Mng_SampleOrderOverview_Product_View.Sample3Mng_SampleOrderOverview_ProductLocation_View")
                                 .FirstOrDefault(o => o.SampleOrderID == id);

                    if (dbItem == null)
                    {
                        throw new Exception("Sample Order not found!");
                    }
                    data = converter.DB2DTO_SampleOrderOverview(dbItem);
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #6
0
        public List <DTO.MonitorUserDTO> QuickSearchEurofarUsers(string query, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            List <DTO.MonitorUserDTO> result = new List <DTO.MonitorUserDTO>();
            int EurofarCompanyID             = 4;

            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    if (string.IsNullOrEmpty(query))
                    {
                        result = converter.DB2DTO_MonitorUserList(context.Sample3Mng_MonitorUser_View.Where(o => o.CompanyID.Value == EurofarCompanyID).ToList());
                    }
                    else
                    {
                        result = converter.DB2DTO_MonitorUserList(context.Sample3Mng_MonitorUser_View.Where(o => o.EmployeeNM.Contains(query) && o.CompanyID.Value == EurofarCompanyID).ToList());
                    }
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(result);
        }
Example #7
0
        public bool DeleteBuildingProcessData(int userId, int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    SampleProgress dbItem = context.SampleProgress.FirstOrDefault(o => o.SampleProgressID == id);
                    if (dbItem == null)
                    {
                        throw new Exception("Progress not found!");
                    }
                    else
                    {
                        // check permission
                        if (userId != dbItem.UpdatedBy)
                        {
                            throw new Exception("Can not delete progress created by other user!");
                        }
                        if ((DateTime.Now - dbItem.UpdatedDate.Value).TotalDays > 1)
                        {
                            throw new Exception("Too late to delete this progress, remark can only be deleted within 2 days from the last update!");
                        }

                        foreach (SampleProgressImage dbImage in dbItem.SampleProgressImage.ToArray())
                        {
                            if (!string.IsNullOrEmpty(dbImage.FileUD))
                            {
                                fwFactory.RemoveImageFile(dbImage.FileUD);
                            }
                            context.SampleProgressImage.Remove(dbImage);
                        }
                        context.SampleProgress.Remove(dbItem);
                        context.SaveChanges();
                    }
                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification = new Library.DTO.Notification()
                {
                    Message = ex.Message, Type = Library.DTO.NotificationType.Error
                };
                return(false);
            }
        }
Example #8
0
        public bool UpdateProductInfoData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
        {
            DTO.ProductInfo.ProductDTO dtoProduct = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.ProductInfo.ProductDTO>();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    SampleProduct dbItem;
                    if (id <= 0)
                    {
                        dbItem = new SampleProduct();
                        context.SampleProduct.Add(dbItem);
                    }
                    else
                    {
                        dbItem = context.SampleProduct.FirstOrDefault(o => o.SampleProductID == id);
                    }

                    if (dbItem == null)
                    {
                        notification.Message = "Sample Product not found!";
                        return(false);
                    }
                    else
                    {
                        converter.DTO2DB_ProductInfo(dtoProduct, ref dbItem, FrameworkSetting.Setting.AbsoluteUserTempFolder + userId.ToString() + @"\");
                        context.SaveChanges();
                    }

                    dtoItem = GetProductInfoData(dbItem.SampleProductID, out notification).Data;
                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification = new Library.DTO.Notification()
                {
                    Message = ex.Message, Type = Library.DTO.NotificationType.Error
                };
                return(false);
            }
        }
Example #9
0
        public DTO.SampleProductOverview.ProductDTO GetProductOverviewData(int id, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.SampleProductOverview.ProductDTO data = new DTO.SampleProductOverview.ProductDTO();
            data.InternalRemarkDTOs   = new List <DTO.SampleProductOverview.InternalRemarkDTO>();
            data.ItemLocationDTOs     = new List <DTO.SampleProductOverview.ItemLocationDTO>();
            data.ProgressDTOs         = new List <DTO.SampleProductOverview.ProgressDTO>();
            data.QARemarkDTOs         = new List <DTO.SampleProductOverview.QARemarkDTO>();
            data.ReferenceImageDTOs   = new List <DTO.SampleProductOverview.ReferenceImageDTO>();
            data.SubFactoryDTOs       = new List <DTO.SampleProductOverview.SubFactoryDTO>();
            data.TechnicalDrawingDTOs = new List <DTO.SampleProductOverview.TechnicalDrawingDTO>();
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    var dbItem = context.Sample3Mng_SampleProductOverview_Product_View
                                 .Include("Sample3Mng_SampleProductOverview_InternalRemark_View")
                                 .Include("Sample3Mng_SampleProductOverview_InternalRemark_View.Sample3Mng_SampleProductOverview_InternalRemarkImage_View")
                                 .Include("Sample3Mng_SampleProductOverview_ItemLocation_View")
                                 .Include("Sample3Mng_SampleProductOverview_Progress_View")
                                 .Include("Sample3Mng_SampleProductOverview_Progress_View.Sample3Mng_SampleProductOverview_ProgressImage_View")
                                 .Include("Sample3Mng_SampleProductOverview_QARemark_View")
                                 .Include("Sample3Mng_SampleProductOverview_QARemark_View.Sample3Mng_SampleProductOverview_QARemarkImage_View")
                                 .Include("Sample3Mng_SampleProductOverview_ReferenceImage_View")
                                 .Include("Sample3Mng_SampleProductOverview_SubFactory_View")
                                 .Include("Sample3Mng_SampleProductOverview_TechnicalDrawing_View")
                                 .FirstOrDefault(o => o.SampleProductID == id);

                    if (dbItem == null)
                    {
                        throw new Exception("Sample Product not found!");
                    }
                    data = converter.DB2DTO_SampleProductOverview(dbItem);
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #10
0
        public bool UpdateItemData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
        {
            DTO.ItemData.ProductDTO dtoProduct = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.ItemData.ProductDTO>();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    SampleProduct dbItem = context.SampleProduct.FirstOrDefault(o => o.SampleProductID == id);
                    if (dbItem == null)
                    {
                        notification.Message = "Sample Product not found!";
                        return(false);
                    }
                    else
                    {
                        converter.DTO2DB_ItemData(dtoProduct, ref dbItem);
                        context.SaveChanges();
                    }

                    dtoItem = GetItemData(dbItem.SampleProductID, out notification).Data;
                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification = new Library.DTO.Notification()
                {
                    Message = ex.Message, Type = Library.DTO.NotificationType.Error
                };
                return(false);
            }
        }
Example #11
0
        public DTO.OrderEditFormData GetOrderData(int id, int clientId, string season, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            DTO.OrderEditFormData data = new DTO.OrderEditFormData();
            data.SupportList = new DTO.SupportData();
            data.SupportList.SamplePurposes       = new List <Support.DTO.SamplePurpose>();
            data.SupportList.SampleTransportTypes = new List <Support.DTO.SampleTransportType>();

            data.Data = new DTO.SampleOrderDTO();
            data.Data.SampleMonitorDTOs = new List <DTO.SampleMonitorDTO>();

            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    if (id > 0)
                    {
                        data.Data = converter.DB2DTO_SampleOrder(context.Sample3Mng_SampleOrder_View.Include("Sample3Mng_SampleMonitor_View").FirstOrDefault(o => o.SampleOrderID == id));
                    }
                    else
                    {
                        var selectedClient = context.Sample3Mng_Client_View.FirstOrDefault(o => o.ClientID == clientId);
                        if (selectedClient == null)
                        {
                            throw new Exception("Client info is not valid!");
                        }
                        data.Data.ClientID            = clientId;
                        data.Data.ClientUD            = selectedClient.ClientUD;
                        data.Data.Season              = season;
                        data.Data.SampleOrderStatusID = 1;
                        data.Data.SampleOrderStatusNM = "PENDING";

                        int SampleMonitorIndex = 0;
                        // add default monitor person
                        foreach (Module.Support.DTO.NotificationMember nMember in supportFactory.GetNotificationMember("SampleVN_M"))
                        {
                            SampleMonitorIndex--;
                            data.Data.SampleMonitorDTOs.Add(new DTO.SampleMonitorDTO()
                            {
                                SampleMonitorID = SampleMonitorIndex, UserID = nMember.UserID, SampleMonitorGroupID = 1, FullName = nMember.EmployeeNM, InternalCompanyNM = nMember.InternalCompanyNM
                            });
                        }
                        foreach (Module.Support.DTO.NotificationMember nMember in supportFactory.GetNotificationMember("SampleNL_M"))
                        {
                            SampleMonitorIndex--;
                            data.Data.SampleMonitorDTOs.Add(new DTO.SampleMonitorDTO()
                            {
                                SampleMonitorID = SampleMonitorIndex, UserID = nMember.UserID, SampleMonitorGroupID = 2, FullName = nMember.EmployeeNM, InternalCompanyNM = nMember.InternalCompanyNM
                            });
                        }

                        // add monitor person base on the client
                        Sample3Mng_UserWithClient_View userClient = context.Sample3Mng_UserWithClient_View.FirstOrDefault(o => o.ClientID == clientId);
                        if (userClient != null)
                        {
                            if (userClient.SaleID.HasValue)
                            {
                                if (!data.Data.SampleMonitorDTOs.Select(o => o.UserID).ToArray().Contains(userClient.SaleID.Value))
                                {
                                    SampleMonitorIndex--;
                                    data.Data.SampleMonitorDTOs.Add(new DTO.SampleMonitorDTO()
                                    {
                                        SampleMonitorID = SampleMonitorIndex, UserID = userClient.SaleID.Value, SampleMonitorGroupID = 2, FullName = userClient.SaleNM, InternalCompanyNM = userClient.SaleCompNM
                                    });
                                }
                            }
                            if (userClient.Sale2ID.HasValue)
                            {
                                if (!data.Data.SampleMonitorDTOs.Select(o => o.UserID).ToArray().Contains(userClient.Sale2ID.Value))
                                {
                                    SampleMonitorIndex--;
                                    data.Data.SampleMonitorDTOs.Add(new DTO.SampleMonitorDTO()
                                    {
                                        SampleMonitorID = SampleMonitorIndex, UserID = userClient.Sale2ID.Value, SampleMonitorGroupID = 2, FullName = userClient.Sale2NM, InternalCompanyNM = userClient.SaleComp2NM
                                    });
                                }
                            }
                            if (userClient.SaleVNID.HasValue)
                            {
                                if (!data.Data.SampleMonitorDTOs.Select(o => o.UserID).ToArray().Contains(userClient.SaleVNID.Value))
                                {
                                    SampleMonitorIndex--;
                                    data.Data.SampleMonitorDTOs.Add(new DTO.SampleMonitorDTO()
                                    {
                                        SampleMonitorID = SampleMonitorIndex, UserID = userClient.SaleVNID.Value, SampleMonitorGroupID = 1, FullName = userClient.SaleVNNM, InternalCompanyNM = userClient.SaleCompVNNM
                                    });
                                }
                            }
                        }
                    }
                }

                data.SupportList.SamplePurposes       = supportFactory.GetSamplePurpose().ToList();
                data.SupportList.SampleTransportTypes = supportFactory.GetSampleTransportType().ToList();
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
Example #12
0
        public List <DTO.SampleOrderSearchResultDTO> GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            List <DTO.SampleOrderSearchResultDTO> result = new List <DTO.SampleOrderSearchResultDTO>();

            totalRows = 0;

            //try to get data
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    string SampleOrderUD       = null;
                    string Season              = null;
                    string ClientUD            = null;
                    string ClientNM            = null;
                    int?   PurposeID           = null;
                    int?   TransportTypeID     = null;
                    int?   SampleOrderStatusID = null;
                    if (filters.ContainsKey("SampleOrderUD") && !string.IsNullOrEmpty(filters["SampleOrderUD"].ToString()))
                    {
                        SampleOrderUD = filters["SampleOrderUD"].ToString().Replace("'", "''");
                    }
                    if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString()))
                    {
                        Season = filters["Season"].ToString().Replace("'", "''");
                    }
                    if (filters.ContainsKey("ClientUD") && !string.IsNullOrEmpty(filters["ClientUD"].ToString()))
                    {
                        ClientUD = filters["ClientUD"].ToString().Replace("'", "''");
                    }
                    if (filters.ContainsKey("ClientNM") && !string.IsNullOrEmpty(filters["ClientNM"].ToString()))
                    {
                        ClientNM = filters["ClientNM"].ToString().Replace("'", "''");
                    }
                    if (filters.ContainsKey("PurposeID") && filters["PurposeID"] != null && !string.IsNullOrEmpty(filters["PurposeID"].ToString()))
                    {
                        PurposeID = Convert.ToInt32(filters["PurposeID"].ToString());
                    }
                    if (filters.ContainsKey("TransportTypeID") && filters["TransportTypeID"] != null && !string.IsNullOrEmpty(filters["TransportTypeID"].ToString()))
                    {
                        TransportTypeID = Convert.ToInt32(filters["TransportTypeID"].ToString());
                    }
                    if (filters.ContainsKey("SampleOrderStatusID") && filters["SampleOrderStatusID"] != null && !string.IsNullOrEmpty(filters["SampleOrderStatusID"].ToString()))
                    {
                        SampleOrderStatusID = Convert.ToInt32(filters["SampleOrderStatusID"].ToString());
                    }
                    totalRows = context.Sample3Mng_function_SearchSampleOrder(SampleOrderUD, Season, ClientUD, ClientNM, PurposeID, TransportTypeID, SampleOrderStatusID, orderBy, orderDirection).Count();
                    var data = context.Sample3Mng_function_SearchSampleOrder(SampleOrderUD, Season, ClientUD, ClientNM, PurposeID, TransportTypeID, SampleOrderStatusID, orderBy, orderDirection);
                    result = converter.DB2DTO_SampleOrderSearchResultList(data.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(result);
        }
Example #13
0
        public bool UpdateOrderData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
        {
            DTO.SampleOrderDTO dtoOrder = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.SampleOrderDTO>();
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            try
            {
                using (Sample3MngEntities context = CreateContext())
                {
                    SampleOrder dbItem = null;
                    if (id == 0)
                    {
                        dbItem = new SampleOrder();
                        context.SampleOrder.Add(dbItem);
                        dbItem.CreatedBy           = userId;
                        dbItem.CreatedDate         = DateTime.Now;
                        dbItem.SampleOrderStatusID = 1; // pending status
                    }
                    else
                    {
                        dbItem = context.SampleOrder.FirstOrDefault(o => o.SampleOrderID == id);
                    }

                    if (dbItem == null)
                    {
                        notification.Message = "Sample Order not found!";
                        return(false);
                    }
                    else
                    {
                        dbItem.UpdatedBy   = userId;
                        dbItem.UpdatedDate = DateTime.Now;
                        converter.DTO2DB_SampleOrder(dtoOrder, ref dbItem);
                        context.SaveChanges();

                        if (id <= 0)
                        {
                            // generate order number
                            using (DbContextTransaction scope = context.Database.BeginTransaction())
                            {
                                context.Database.ExecuteSqlCommand("SELECT * FROM SampleOrder WITH (TABLOCKX, HOLDLOCK)");
                                try
                                {
                                    dbItem.SampleOrderUD = dbItem.SampleOrderID.ToString("D8");
                                    context.SaveChanges();
                                }
                                catch (Exception ex)
                                {
                                    throw ex;
                                }
                                finally
                                {
                                    scope.Commit();
                                }
                            }
                        }
                    }

                    dtoItem = GetOrderData(dbItem.SampleOrderID, 0, string.Empty, out notification).Data;
                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification = new Library.DTO.Notification()
                {
                    Message = ex.Message, Type = Library.DTO.NotificationType.Error
                };
                return(false);
            }
        }