Example #1
0
        public static void DeleteWorkZone(int WorkZoneID)
        {
            using (DBContext db = new DBContext())
            {
                using (System.Data.Common.DbTransaction tran = db.UseTransaction())
                {
                    try
                    {
                        WorkZone wz = new WorkZone();
                        wz.WorkZoneId = WorkZoneID;
                        wz.Delete();

                        List <WorkZoneDetail> listWZD = WorkZoneDetail.GetWorkZoneDetailByWorkZoneID(WorkZoneID);
                        foreach (WorkZoneDetail wzd in listWZD)
                        {
                            wzd.Delete();
                        }

                        List <DetailProblem> listProblem = DetailProblem.GetAllDetailProblem(WorkZoneID);
                        foreach (DetailProblem p in listProblem)
                        {
                            p.Delete();
                        }
                    }
                    catch (Exception e)
                    {
                        tran.Rollback();
                        logger.Error("Error DeleteWorkZone", e);
                        throw e;
                    }
                }
            }
        }
Example #2
0
        public static void InsertUpdateWorkZone(string directoryApp, WorkZone info, List <WorkZoneDetail> listDetail)
        {
            logger.InfoFormat("Begin call InsertUpdateWorkZone , workZoneName = {0} , directoryApp = {1}", info.Name, directoryApp);
            WorkZone workZoneDb = WorkZone.GetWorkZoneFromMachine(info.MachineId, info.CompanyId, info.Name);

            info.CompanyName = Company.GetCompanyName(info.CompanyId);
            info.FactoryName = Factory.GetFactoryName(info.FactoryId);

            int idz = 0;

            using (DBContext db = new DBContext())
            {
                using (System.Data.Common.DbTransaction tran = db.UseTransaction())
                {
                    try
                    {
                        int nextWorkZoneDetailId = 1;
                        if (workZoneDb == null)
                        {
                            idz             = InsertWorkZoneWithID(info);
                            info.WorkZoneId = idz;
                            foreach (WorkZoneDetail wzd in listDetail)
                            {
                                wzd.WorkZoneId       = info.WorkZoneId;
                                wzd.WorkZoneDetailId = nextWorkZoneDetailId;
                                wzd.CreateAccount    = wzd.ModifiedAccount = info.CreateAccount;
                                wzd.Insert();
                                nextWorkZoneDetailId++;
                            }
                        }
                        else
                        {
                            info.WorkZoneId = workZoneDb.WorkZoneId;
                            info.Update();

                            // Insert , update , detail
                            List <WorkZoneDetail> listDetailDB = WorkZoneDetail.GetWorkZoneDetailByWorkZoneID(workZoneDb.WorkZoneId);
                            foreach (WorkZoneDetail i in listDetailDB)
                            {
                                i.Delete();
                            }

                            foreach (WorkZoneDetail i in listDetail)
                            {
                                i.WorkZoneId       = info.WorkZoneId;
                                i.WorkZoneDetailId = nextWorkZoneDetailId;
                                i.CreateAccount    = i.ModifiedAccount = info.CreateAccount;
                                i.Insert();
                                nextWorkZoneDetailId++;
                            }
                        }

                        //Upload file WorkZone
                        if (!string.IsNullOrEmpty(info.Base64Data))
                        {
                            string pathToUpload = directoryApp + Common.GetFolderWorkZone(info.CompanyId, info.CompanyName, info.FactoryId, info.FactoryName, info.WorkZoneId, info.Name);
                            pathToUpload = pathToUpload.Replace("/", "\\");
                            if (!Directory.Exists(pathToUpload))
                            {
                                Directory.CreateDirectory(pathToUpload);
                            }
                            pathToUpload = Path.Combine(pathToUpload, info.ImageFile);
                            Common.UploadFileToPath(info.Base64Data, pathToUpload);
                        }
                        //upload Detail
                        foreach (WorkZoneDetail i in listDetail)
                        {
                            if (!string.IsNullOrEmpty(i.Base64Data))
                            {
                                string pathToUpload = directoryApp + Common.GetFolderWorkZoneDetail(info.CompanyId, info.CompanyName, info.FactoryId, info.FactoryName, info.WorkZoneId, info.Name);
                                pathToUpload = pathToUpload.Replace("/", "\\");
                                if (!Directory.Exists(pathToUpload))
                                {
                                    Directory.CreateDirectory(pathToUpload);
                                }
                                pathToUpload = Path.Combine(pathToUpload, i.ImageFile);
                                Common.UploadFileToPath(i.Base64Data, pathToUpload);
                            }
                        }

                        tran.Commit();
                    }
                    catch (Exception ex)
                    {
                        tran.Rollback();
                        if (idz != 0)
                        {
                            info.Delete();
                        }
                        logger.Error("Error InsertUpdateWorkZone", ex);
                        throw ex;
                    }
                }
            }
        }