public void Print(string fileOrPath, int printerId, string pages) { string prName = db.Printers.FirstOrDefault(p => p.Id == printerId).Prn_name; //if all pages if (String.IsNullOrEmpty(pages)) { SpirePrAPI.PrintAll(fileOrPath, prName); } else //if selectRange pages { SpirePrAPI.PrintSelectionPages(fileOrPath, prName, pages); } }
public void InitializePrintersToDb() { #region DropCreateDB /*Database.SetInitializer(new ContexInitializer()); * db.Database.Initialize(true); */ #endregion //clear table var countPr = db.Printers.Count(); if (countPr != 0) { db.Printers.RemoveRange(db.Printers); } // allPrinters.ForEach(p => db.Printers.Add(p)); SpirePrAPI.GetAllPrinters().ForEach(p => db.Printers.Add(p)); db.SaveChanges(); //reset id db.Database.ExecuteSqlCommand(@"ALTER SEQUENCE dbo.""Printers_Id_seq"" RESTART"); db.Database.ExecuteSqlCommand(@"UPDATE dbo.""Printers"" SET ""Id"" = DEFAULT"); }