public static bool Update(Printer printer)
{
try
{
return PrinterDL.Update(printer);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}