Example #1
0
        public int InsertPrinterMapping(Model.PrinteJobDetailModel PrinterJob)
        {
            int result = 0;

            try
            {
                PRINTE_JOB_DETAIL item = new PRINTE_JOB_DETAIL();
                item.CategoryID            = PrinterJob.CategoryID;
                item.ProductID             = PrinterJob.ProductID;
                item.PrinterID             = PrinterJob.PrinterID;
                item.Status                = 1;
                _context.Entry(item).State = System.Data.Entity.EntityState.Added;
                _context.SaveChanges();
                result = 1;
            }
            catch (Exception ex)
            {
            }
            return(result);
        }
Example #2
0
        public int SaveDataPrinterJob(PrintJobModel data)
        {
            try
               {
               #region Update
               if (data.ID > 0)
               {
                   var printejob = _context.PRINT_JOB.Find(data.ID);
                   if (printejob != null)
                   {
                       printejob.PrintJobName = data.PrintJobName;
                       printejob.PrintContent = data.PrintContent;

                       printejob.UpdateBy = data.UpdateBy;
                       printejob.UpdateDate = DateTime.Now;

                       _context.Entry(printejob).State = System.Data.Entity.EntityState.Modified;
                       _context.SaveChanges();

                       foreach (var item in data.dataDetail)
                       {
                           if (item.ID > 0)
                           {
                               var tempitem = _context.PRINTE_JOB_DETAIL.Find(item.ID);
                               if (tempitem!=null)
                               {
                                   tempitem.CategoryID = item.CategoryID;
                                   tempitem.ProductID = item.ProductID;
                                   tempitem.PrinterID = item.PrinterID;
                                   tempitem.TemplatesID = item.TemplatesID;

                                   tempitem.UpdateBy = item.UpdateBy;
                                   tempitem.UpdateDate = DateTime.Now;

                                   _context.Entry(tempitem).State = System.Data.Entity.EntityState.Modified;
                                   _context.SaveChanges();

                               }
                           }
                           else
                           {
                               var tempitem = new PRINTE_JOB_DETAIL();

                               //tempitem.PrinteJobID = printejob.ID;

                               tempitem.CategoryID = item.CategoryID;
                               tempitem.ProductID = item.ProductID;
                               tempitem.PrinterID = item.PrinterID;
                               tempitem.TemplatesID = item.TemplatesID;

                               tempitem.Status = 1;

                               tempitem.Notes = item.Notes??"";

                               tempitem.CreateBy = item.CreateBy;
                               tempitem.CreateDate = DateTime.Now;

                               _context.Entry(tempitem).State = System.Data.Entity.EntityState.Added;
                               _context.SaveChanges();
                           }
                       }

                       return 1;
                   }
                   return 0;
               }

               #endregion Update

               #region Insert
               else
               {
                   var printejob = new PRINT_JOB();

                   printejob.PrintJobName = data.PrintJobName;
                   printejob.PrintContent = data.PrintContent;

                   printejob.Status = 1;

                   printejob.CreateBy = data.CreateBy;
                   printejob.CreateDate = DateTime.Now;

                   _context.Entry(printejob).State = System.Data.Entity.EntityState.Added;
                   _context.SaveChanges();

                   foreach (var item in data.dataDetail)
                   {

                       var tempitem = new PRINTE_JOB_DETAIL();

                       //tempitem.PrinteJobID = printejob.ID;

                       tempitem.CategoryID = item.CategoryID;
                       tempitem.ProductID = item.ProductID;
                       tempitem.PrinterID = item.PrinterID;
                       tempitem.TemplatesID = item.TemplatesID;

                       tempitem.Status = 1;

                       tempitem.Notes = item.Notes ?? "";

                       tempitem.CreateBy = item.CreateBy;
                       tempitem.CreateDate = DateTime.Now;

                       _context.Entry(tempitem).State = System.Data.Entity.EntityState.Added;
                       _context.SaveChanges();
                   }

                   return 1;
               }
               #endregion Insert

               }
               catch (Exception ex)
               {
               LogPOS.WriteLog("Service Printer Job:::::::::::::::::::SaveDataPrinterJob::::::::::::::::" + ex.Message);
               return 0;
               }
        }
Example #3
0
        public int SaveDataPrinterJob(PrintJobModel data)
        {
            try
            {
                #region Update
                if (data.ID > 0)
                {
                    var printejob = _context.PRINT_JOB.Find(data.ID);
                    if (printejob != null)
                    {
                        printejob.PrintJobName = data.PrintJobName;
                        printejob.PrintContent = data.PrintContent;

                        printejob.UpdateBy   = data.UpdateBy;
                        printejob.UpdateDate = DateTime.Now;

                        _context.Entry(printejob).State = System.Data.Entity.EntityState.Modified;
                        _context.SaveChanges();

                        foreach (var item in data.dataDetail)
                        {
                            if (item.ID > 0)
                            {
                                var tempitem = _context.PRINTE_JOB_DETAIL.Find(item.ID);
                                if (tempitem != null)
                                {
                                    tempitem.CategoryID  = item.CategoryID;
                                    tempitem.ProductID   = item.ProductID;
                                    tempitem.PrinterID   = item.PrinterID;
                                    tempitem.TemplatesID = item.TemplatesID;

                                    tempitem.UpdateBy   = item.UpdateBy;
                                    tempitem.UpdateDate = DateTime.Now;

                                    _context.Entry(tempitem).State = System.Data.Entity.EntityState.Modified;
                                    _context.SaveChanges();
                                }
                            }
                            else
                            {
                                var tempitem = new PRINTE_JOB_DETAIL();

                                //tempitem.PrinteJobID = printejob.ID;

                                tempitem.CategoryID  = item.CategoryID;
                                tempitem.ProductID   = item.ProductID;
                                tempitem.PrinterID   = item.PrinterID;
                                tempitem.TemplatesID = item.TemplatesID;

                                tempitem.Status = 1;

                                tempitem.Notes = item.Notes ?? "";

                                tempitem.CreateBy   = item.CreateBy;
                                tempitem.CreateDate = DateTime.Now;

                                _context.Entry(tempitem).State = System.Data.Entity.EntityState.Added;
                                _context.SaveChanges();
                            }
                        }

                        return(1);
                    }
                    return(0);
                }

                #endregion Update

                #region Insert
                else
                {
                    var printejob = new PRINT_JOB();

                    printejob.PrintJobName = data.PrintJobName;
                    printejob.PrintContent = data.PrintContent;

                    printejob.Status = 1;

                    printejob.CreateBy   = data.CreateBy;
                    printejob.CreateDate = DateTime.Now;

                    _context.Entry(printejob).State = System.Data.Entity.EntityState.Added;
                    _context.SaveChanges();

                    foreach (var item in data.dataDetail)
                    {
                        var tempitem = new PRINTE_JOB_DETAIL();

                        //tempitem.PrinteJobID = printejob.ID;

                        tempitem.CategoryID  = item.CategoryID;
                        tempitem.ProductID   = item.ProductID;
                        tempitem.PrinterID   = item.PrinterID;
                        tempitem.TemplatesID = item.TemplatesID;

                        tempitem.Status = 1;

                        tempitem.Notes = item.Notes ?? "";

                        tempitem.CreateBy   = item.CreateBy;
                        tempitem.CreateDate = DateTime.Now;

                        _context.Entry(tempitem).State = System.Data.Entity.EntityState.Added;
                        _context.SaveChanges();
                    }

                    return(1);
                }
                #endregion Insert
            }
            catch (Exception ex)
            {
                LogPOS.WriteLog("Service Printer Job:::::::::::::::::::SaveDataPrinterJob::::::::::::::::" + ex.Message);
                return(0);
            }
        }
Example #4
0
        public int InsertPrinterMapping(Model.PrinteJobDetailModel PrinterJob)
        {
            int result = 0;
            try
            {
                PRINTE_JOB_DETAIL item = new PRINTE_JOB_DETAIL();
                item.CategoryID = PrinterJob.CategoryID;
                item.ProductID = PrinterJob.ProductID;
                item.PrinterID = PrinterJob.PrinterID;
                item.Status = 1;
                _context.Entry(item).State = System.Data.Entity.EntityState.Added;
                _context.SaveChanges();
                result = 1;
            }
            catch (Exception ex)
            {

            }
            return result;
        }