예제 #1
0
 public static bool Update(Printer printer)
 {
     try
     {
         return PrinterDL.Update(printer);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #2
0
 public static bool Save(Printer printer, out string message)
 {
     try
     {
         if (PrinterDL.PrinterExists(printer))
         {
             message = string.Format("Printer with serial number: {0} exists already", printer.PrinterSrNo);
             return false;
         }
         else
         {
             message = string.Empty;
             return PrinterDL.Save(printer);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #3
0
        public static Printer GetPrinterBySerialNumber(string printerSerialNumber)
        {
            try
            {
                var existingPrinter = new Printer();
                using (var context = new PrinterMonitorDBEntities())
                {
                    existingPrinter = context.Printers
                                    .Include("Branch")
                                    .Where(t => t.PrinterSrNo.Equals(printerSerialNumber))
                                    .FirstOrDefault();
                }

                return existingPrinter;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #4
0
        public static bool PrinterExists(Printer printer)
        {
            try
            {
                var existingPrinter = new Printer();
                using (var context = new PrinterMonitorDBEntities())
                {
                    existingPrinter = context.Printers
                                    .Include("Branch")
                                    .Where(t => t.PrinterSrNo.Equals(printer.PrinterSrNo))
                                    .FirstOrDefault();
                }

                if (existingPrinter == null)
                    return false;
                else
                    return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #5
0
 public static bool Save(Printer printer)
 {
     try
     {
         using (var context = new PrinterMonitorDBEntities())
         {
             context.Printers.Add(printer);
             context.SaveChanges();
         }
         return true;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #6
0
        public static bool Update(Printer printer)
        {
            try
            {
                Printer existingPrinter = new Printer();
                using (var context = new PrinterMonitorDBEntities())
                {
                    existingPrinter = context.Printers
                                    .Where(t => t.ID == printer.ID)
                                    .FirstOrDefault();
                }

                if (existingPrinter != null)
                {
                    existingPrinter.PrinterSrNo = printer.PrinterSrNo;
                    existingPrinter.PrinterName = printer.PrinterName;
                    existingPrinter.PrinterBrand = printer.PrinterBrand;
                    existingPrinter.BranchID = printer.BranchID;

                    using (var context = new PrinterMonitorDBEntities())
                    {
                        context.Entry(existingPrinter).State = EntityState.Modified;

                        context.SaveChanges();
                    }

                    return true;
                }
                else
                {
                    return false;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }