public ViewRequest() { this.InitializeComponent(); db = new PrsEntities(); this.Loaded += new RoutedEventHandler(ViewRequest_Loaded); User = App.Current.Properties["User"] as UserModel; }
public PoGenerateWindow() { this.InitializeComponent(); db = new PrsEntities(); pdf = new PdfManager(); CurrentUser = (UserModel)App.Current.Properties["User"]; }
public RfqProcessRequest() { this.InitializeComponent(); this.Loaded += new RoutedEventHandler(RfqProcessRequest_Loaded); db = new PrsEntities(); CurrentUser = (UserModel)App.Current.Properties["User"]; }
public AddItem() { this.InitializeComponent(); db = new PrsEntities(); User = App.Current.Properties["User"] as UserModel; if (User.UserTypeId == (int)UserTypes.Purchasing) { isRequestItemOnly = false; } }
public Register(MainWindow mainWindow) : this() { this.mainWindow = mainWindow; background = new AsyncWork(mainWindow); background2 = new AsyncWork(mainWindow); background3 = new AsyncWork(mainWindow); asyncUserCheck = new AsyncWork(mainWindow); CurrentUser = App.Current.Properties["User"] as UserModel; if (CurrentUser == null) { stackUserType.Visibility = Visibility.Collapsed; } }
public PurchaseRequestScreen() { this.InitializeComponent(); db = new PrsEntities(); User = (UserModel)App.Current.Properties["User"]; }
private void SetPOCompanyHeader(UserModel RequestUser) { SetFontSizeTo(8); if (RequestUser.CompanyName == "SONIC STEEL INDUSTRIES, INC.") { PrintText("SONIC STEEL INDUSTRIES, INC.", 375, 0); PrintText("8F Gedisco Tower, 534 Asuncion St., Binondo, Manila", 375, 10); PrintText("Tel. Nos. : 241-9251 to 58; Fax No. 241-7826", 375, 20); PrintText("Plant Address: Barangay Hugo Perez, Trece Martirez City", 375, 30); PrintText("Cavite", 375, 40); PrintText("TIN: 001-778-048-000 VAT", 375, 50); } else if (RequestUser.CompanyName == "UNITED STEEL TECHNOLOGY INT'L. CORP.") { PrintText("UNITED STEEL TECHNOLOGY INTERNATIONAL CORPORATION", 375, 0); PrintText("8F Gedisco Tower, 534 Asuncion St., Binondo, Manila", 375, 10); PrintText("Tel. Nos. : 241-9251 to 58; Fax No. 241-7826", 375, 20); PrintText("Plant Address: Km. 49 Indang Road, Barangay Inocencio", 375, 30); PrintText("Trece Martirez City, Cavite", 375, 40); PrintText("TIN: 007-106-703", 375, 50); } else if (RequestUser.CompanyName == "SOMICO STEEL MILL CORPORATION") { PrintText("SOMICO STEEL MILL CORPORATION", 375, 0); PrintText("8F Gedisco Tower, 534 Asuncion St., Binondo, Manila", 375, 10); PrintText("Tel. Nos. : 244-9293 to 96; Fax No. 241-7826", 375, 20); PrintText("Plant Address: Km. 29 Indang Road, Barangay Inocencio, ", 375, 30); PrintText("Trece Martirez City, Cavite", 375, 40); } }
public void RenderCanvasSheet(Stream stream, IEnumerable<CanvasItemModel> items, UserModel currentUser,UserModel requestedBy, PurchaseRequest Pr, string[] Vendors) { Document document = new Document(PageSize.LETTER); try { PdfWriter writer = PdfWriter.GetInstance(document, stream); document.Open(); // Create a page in the document and add it to the bottom layer document.NewPage(); //Pass Document to this CurrentDoc = document; page = writer.DirectContentUnder; page.BeginText(); int top = (int)document.GetTop(0); SetFontSizeTo(16); PrintText("CANVASS SHEET", 20, 10); SetFontSizeTo(10); //Header PrintText("Company Name: " + requestedBy.CompanyName, 20, 30); // Company Name PrintText("Department: " + requestedBy.DepartmentName, 20, 45); // Company Address PrintText("Purpose: " + Pr.Purpose, 20, 60); // Purpose PrintTextRight("Date: {0}".WithTokens(DateTime.Now.ToShortDateString()), 70, 30); // Date Created PrintTextRight("PR No: {0}".WithTokens(Pr.PRNo), 70, 45); // PR Number SetFontSizeTo(8); // START HERE ---------------------------- Paragraph Grid = new Paragraph("\n"); Grid.Alignment = 1; Grid.SpacingAfter = 10f; document.Add(Grid); Paragraph Grid2 = new Paragraph(); Grid2.Alignment = 1; Grid2.SpacingBefore = 35f; //Start Table ----------------------------------- PdfPTable rightTable = new PdfPTable(7); int[] widths = { 1, 7, 2, 2, 2, 2, 2 }; rightTable.SetWidths(widths); rightTable.TotalWidth = 570f; rightTable.LockedWidth = true; Font tableFont = new Font(Font.FontFamily.HELVETICA, 8); PdfPCell rightAlignedCell = new PdfPCell(); rightAlignedCell.HorizontalAlignment = Element.ALIGN_CENTER; //Headers rightAlignedCell.Phrase = new Phrase("Item No.", tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase("Item Description", tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase("Quantity", tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase("UOM", tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase(Vendors[0], tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase(Vendors[1], tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase(Vendors[2], tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.HorizontalAlignment = Element.ALIGN_RIGHT; foreach (var item in items) { string priceVendor1 = item.PriceVendor1 == 0 ? "NONE" : item.PriceVendor1.ToString(); string priceVendor2 = item.PriceVendor2 == 0 ? "NONE" : item.PriceVendor2.ToString(); string priceVendor3 = item.PriceVendor3 == 0 ? "NONE" : item.PriceVendor3.ToString(); rightTable.AddCell(new Phrase(item.ItemNumber.ToString(), tableFont)); rightTable.AddCell(new Phrase(item.ItemDescription, tableFont)); rightAlignedCell.Phrase = new Phrase(item.Quantity.ToString(), tableFont); rightTable.AddCell(rightAlignedCell); rightTable.AddCell(new Phrase(item.UOM, tableFont)); rightAlignedCell.Phrase = new Phrase(priceVendor1, tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase(priceVendor2, tableFont); rightTable.AddCell(rightAlignedCell); rightAlignedCell.Phrase = new Phrase(priceVendor3, tableFont); rightTable.AddCell(rightAlignedCell); } Grid2.Add(rightTable); document.Add(Grid2); // Footer SetFontSizeTo(10); PrintTextBottom("Requested By:", 20, 105); PrintTextBottom("{0} {1}".WithTokens(requestedBy.FirstName, requestedBy.LastName), 20, 35); PrintTextBottom("Prepared By:", 265, 105); PrintTextBottom("{0} {1}".WithTokens(currentUser.FirstName, currentUser.LastName), 265, 35); PrintTextBottom("Approved By:", 450, 105); PrintTextBottom("{0}".WithTokens("______________________"), 450, 35); page.EndText(); writer.Flush(); } finally { document.Close(); } }
public void RenderRfq(Stream stream, VendorModel vendor, IEnumerable<ItemModel> items, UserModel user, int RfqNumber, PurchaseRequest Pr, DateTime DateRequested) { Document document = new Document(PageSize.LETTER); try { PdfWriter writer = PdfWriter.GetInstance(document, stream); document.Open(); // Create a page in the document and add it to the bottom layer document.NewPage(); //Pass Document to this CurrentDoc = document; page = writer.DirectContentUnder; page.BeginText(); int top = (int)document.GetTop(0); SetFontSizeTo(16); PrintText("REQUEST FOR QUOTATION (THIS IS NOT AN ORDER)", 20, 10); SetFontSizeTo(10); //Header PrintText("Company Name: {0}".WithTokens(Pr.User.Company.Name), 20, 30); // Company Name PrintText("Address: 8th Floor Gedisco Tower, 534 Asuncion St., Binondo, Manila", 20, 45); // Company Address PrintText("Purchasing Department", 20, 60); PrintText("Issued By: {0} {1}".WithTokens(user.FirstName, user.LastName), 20, 75); // Requested By PrintTextRight("RFQ NO: {0}".WithTokens(RfqNumber), 70, 30); // RFQ Number PrintTextRight("Date: {0}".WithTokens(DateTime.Now.ToShortDateString()), 70, 45); // Date Created PrintTextRight("PR No: {0}".WithTokens(Pr.PRNo), 70, 60); // PR Number //Body SetFontSizeTo(14); PrintText("BID/OFFER/QUOTE MUST BE RECEIVED BY:", 20, 105); // Requested By PrintTextRight("Date: {0}".WithTokens(DateRequested.ToShortDateString()), 95, 105); // Date Required SetFontSizeTo(10); PrintText("Attention: {0} {1}".WithTokens(user.FirstName, user.LastName), 40, 125); // Vendor Contact Person PrintText("Tel No: {0}".WithTokens("+63 2 244 9296"), 40, 140); // Vendor Tel No PrintText("Email Address: {0}".WithTokens(user.Email), 40, 155); // Vendor Email PrintText("Fax No: {0}".WithTokens("+63 2 241 7826"), 240, 125); // Vendor Fax No SetFontSizeTo(8); PrintText("Unless otherwise requested, quote on each item separately. Unit Prices shall be shown. If unable to furnish", 20, 175); // Vendor Email PrintText("items as specified, submit sample and/or descriptive specifications of substitute offered.", 20, 185); // Vendor Email //Items SetFontSizeTo(8); PrintText("_______________________________________________________________________________________________________________________", 20, 210); PrintText("Item No.", 20, 205); PrintText("Item Description", 70, 205); PrintText("Quantity", 370, 205); PrintText("Unit Price", 420, 205); PrintText("Discount", 470, 205); PrintText("Total", 520, 205); //// Items.. //int staryY = 225; //int itemCount = 1; //foreach (var item in items) { // PrintItem(itemCount.ToString(), item.Description, item.Quantity.ToString(), ref staryY); // itemCount++; //} //PrintText("********** NOTHING FOLLOWS **********", 75, staryY + 15); // START HERE ---------------------------- Paragraph Grid = new Paragraph("\n\n\n\n\n\n\n\n\n"); Grid.Alignment = 1; Grid.SpacingAfter = 35f; document.Add(Grid); Paragraph Grid2 = new Paragraph(); Grid2.Alignment = 1; Grid2.SpacingBefore = 35f; //Start Table ----------------------------------- PdfPTable rightTable = new PdfPTable(7); int[] widths = { 1, 1, 1, 7, 2, 2, 2 }; rightTable.SetWidths(widths); rightTable.TotalWidth = 570f; rightTable.LockedWidth = true; Font tableFont = new Font(Font.FontFamily.HELVETICA, 8); rightTable.HorizontalAlignment = Element.ALIGN_CENTER; rightTable.AddCell(new Phrase("Item No.", tableFont)); rightTable.AddCell(new Phrase("Item Description", tableFont)); rightTable.AddCell(new Phrase("Quantity", tableFont)); rightTable.AddCell(new Phrase("Unit Price", tableFont)); rightTable.AddCell(new Phrase("Discount", tableFont)); rightTable.AddCell(new Phrase("Total Amount", tableFont)); rightTable.HorizontalAlignment = Element.ALIGN_LEFT; int itemCount = 1; foreach (var item in items) { rightTable.AddCell(new Phrase(item.ItemNumber.ToString(), tableFont)); rightTable.AddCell(new Phrase(item.Description, tableFont)); rightTable.AddCell(new Phrase(item.Quantity.ToString(), tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); itemCount++; } //Nothing Follows rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("******** NOTHING FOLLOWS ********", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("")); Grid2.Add(rightTable); document.Add(Grid2); // End of table ----------------------------------- // Footer SetFontSizeTo(10); PrintTextBottom("If accepted within _____ days, the undersigned offers and agrees to honor this quotation.", 20, 85); PrintTextBottom("Print Name of Person:", 20, 65); PrintTextBottom("Company Name:", 20, 50); PrintTextBottom("Address:", 20, 35); PrintTextBottom("Email Address:", 20, 20); PrintTextBottom("No. of Days to Deliver:", 200, 65); PrintTextBottom("Telephone No.:", 200, 50); PrintTextBottom("Fax No.:", 200, 35); page.EndText(); writer.Flush(); } finally { document.Close(); } }
public void RenderPurchaseOrder(Stream stream, int PoNumber, IEnumerable<PoItemModel> PoItems, int RequestNumber, string VendorName, string VendorCode, string VendorAddress, DateTime DateCreated, DateTime DeliveryDate, UserModel RequestUser, UserModel CurrentUser) { Document document = new Document(PageSize.LETTER); try { PdfWriter writer = PdfWriter.GetInstance(document, stream); document.Open(); // Create a page in the document and add it to the bottom layer document.NewPage(); //Pass Document to this CurrentDoc = document; string logoLocation = sonicLogo; float logoPosition = 50; string CurrentCompany = RequestUser.CompanyName; //Image if (RequestUser.CompanyId == (int)CompanyIds.SonicSteel) { logoLocation = sonicLogo; logoPosition = 70; } else if (RequestUser.CompanyId == (int)CompanyIds.SteelTech) { logoLocation = steeltechLogo; } else if (RequestUser.CompanyId == (int)CompanyIds.Somico) { logoLocation = somicoLogo; } Image logo = Image.GetInstance(Directory.GetCurrentDirectory() + logoLocation); logo.SetAbsolutePosition(20, (int)CurrentDoc.GetTop(logoPosition)); // START HERE ---------------------------- Paragraph Grid = new Paragraph("\n\n\n\n\n\n\n\n\n"); Grid.Alignment = 1; Grid.SpacingAfter = 35f; document.Add(Grid); Paragraph Grid2 = new Paragraph(); Grid2.Alignment = 1; Grid2.SpacingBefore = 35f; //Start Table ----------------------------------- PdfPTable rightTable = new PdfPTable(7); int[] widths = { 1, 1, 1, 7, 2, 2, 2 }; rightTable.SetWidths(widths); rightTable.TotalWidth = 570f; rightTable.LockedWidth = true; Font tableFont = new Font(Font.FontFamily.HELVETICA, 8); rightTable.HorizontalAlignment = Element.ALIGN_CENTER; rightTable.AddCell(new Phrase("Item No.", tableFont)); rightTable.AddCell(new Phrase("Quantity", tableFont)); rightTable.AddCell(new Phrase("UOM", tableFont)); rightTable.AddCell(new Phrase("Item Description", tableFont)); rightTable.AddCell(new Phrase("Unit Price", tableFont)); rightTable.AddCell(new Phrase("Discount", tableFont)); rightTable.AddCell(new Phrase("Total Amount", tableFont)); rightTable.HorizontalAlignment = Element.ALIGN_LEFT; int itemCount = 1; foreach (var poItem in PoItems) { rightTable.AddCell(new Phrase(itemCount.ToString(), tableFont)); rightTable.AddCell(new Phrase(poItem.Quantity.ToString(), tableFont)); rightTable.AddCell(new Phrase(poItem.UOM, tableFont)); rightTable.AddCell(new Phrase(poItem.Description, tableFont)); rightTable.AddCell(new Phrase(poItem.Price.ToString(), tableFont)); rightTable.AddCell(new Phrase(poItem.Discount.ToString(), tableFont)); rightTable.AddCell(new Phrase(poItem.TotalPrice.ToString(), tableFont)); itemCount++; } //Nothing Follows rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("******** NOTHING FOLLOWS ********", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("")); //Grand Total rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("", tableFont)); rightTable.AddCell(new Phrase("")); rightTable.AddCell(new Phrase("Grand Total:", new Font(Font.FontFamily.HELVETICA, 12))); rightTable.AddCell(new Phrase(PoItems.Sum(x => x.TotalPrice).ToString(), new Font(Font.FontFamily.HELVETICA, 12))); Grid2.Add(rightTable); document.Add(Grid2); // End of table ----------------------------------- page = writer.DirectContentUnder; page.AddImage(logo); page.Stroke(); // For "Purchase Order" Text PrintRectangle(20, 120, 570, 50); //For two tables PrintRectangle(20, 230, 350, 100); PrintRectangle(370, 230, 220, 100); //For Footer PrintRectangleBottom(20, 20, 570, 50); page.BeginText(); SetFontSizeTo(24); PrintText("PURCHASE ORDER", 180, 105); SetPOCompanyHeader(RequestUser); SetFontSizeTo(10); // Header PrintText("To:", 25, 140); // Vendor Name SetFontSizeTo(8); PrintText(VendorName, 40, 140); // Vendor Name SetFontSizeTo(7); PrintText(VendorAddress, 25, 155); // Vendor Address SetFontSizeTo(10); PrintText("Vendor Code: " + VendorCode, 25, 220); // Venodr Id PrintText("PO Number: " + PoNumber, 375, 140); // Vendor Name PrintText("PO Date: " + DateTime.Now.ToShortDateString(), 375, 160); // Date Now PrintText("PR Number: " + RequestNumber, 375, 180); // Request Number PrintText("Delivery Date: " + DeliveryDate.ToShortDateString(), 375, 220); // Delivery Date //Footer SetFontSizeTo(8); PrintTextBottom("Purchase Orders are not valid unless signed by the Authorized Signatories. " + CurrentCompany + " will not recognize claims ", 20, 130); PrintTextBottom("based on verbal orders. If delivery is not made by the date indicated in this Purchase Order, United Steel Technology International Corporation may cancel this ", 20, 115); PrintTextBottom("Purchase Order, without any liability whatsoever. Seller expressly warrants that all goods or services furnished under this agreement shall conform to all ", 20, 100); PrintTextBottom("specifications and appropriate standards, will be new and will be free from defects in material or workmanship.", 20, 85); PrintTextBottom("Prepared By:", 25, 55); PrintTextBottom(CurrentUser.FirstName + " " + CurrentUser.LastName, 25, 30); PrintTextBottom("Noted By:", 255, 55); PrintTextBottom("Approved By:", 450, 55); //PrintTextBottom("No. of Days to Deliver:", 200, 65); //PrintTextBottom("Telephone No.:", 200, 50); //PrintTextBottom("Fax No.:", 200, 35); page.EndText(); writer.Flush(); } finally { document.Close(); } }
public VicePresident() { this.InitializeComponent(); User = (UserModel)App.Current.Properties["User"]; }
public OverallHead() { this.InitializeComponent(); User = (UserModel)App.Current.Properties["User"]; }
public Requisitioner() { this.InitializeComponent(); User = (UserModel)App.Current.Properties["User"]; }
private void VerifyUser() { var user = db.Users.Where(x => x.Username == Username).Select(x => new UserModel { FirstName = x.FirstName, LastName = x.LastName, Id = x.Id, UserTypeId = x.UserType.Id, AccessLevel = x.UserType.AccessLevel, Password = x.Password, CompanyName = x.Company.Name, DepartmentName = x.Department.Name, CompanyId = x.CompanyId, Email = x.Email }); UserExists = user.Any(); if (UserExists) { User = user.SingleOrDefault(); UserVerified = Salt.VerifyHash(Password, "SHA512", User.Password); } }
public SelectCostObjective() { this.InitializeComponent(); db = new PrsEntities(); CurrentUser = App.Current.Properties["User"] as UserModel; }
public CsApprove() { this.InitializeComponent(); db = new PrsEntities(); User = (UserModel)App.Current.Properties["User"]; }
public Purchasing() { this.InitializeComponent(); User = (UserModel)App.Current.Properties["User"]; }
private void PopulateDataForPrinting() { var model = SelectedPoModel; PoItems = db.mPo_mRfqItems.Where(x => x.PurchaseOrderId == model.Id).Select(x => new PoItemModel() { Id = x.Id, ItemNumber = x.mRfqs_mItemsRequests.mItemsRequest.Item.ItemNumber, Description = x.mRfqs_mItemsRequests.mItemsRequest.Item.Description + ", " + x.mRfqs_mItemsRequests.mItemsRequest.Item.ItemBrand.Name + ", " + x.mRfqs_mItemsRequests.mItemsRequest.Item.CodeSize, Quantity = x.mRfqs_mItemsRequests.mItemsRequest.Quantity, UOM = x.mRfqs_mItemsRequests.mItemsRequest.Item.UnitOfMeasurement.Name, Price = x.mRfqs_mItemsRequests.UnitPrice.HasValue ? x.mRfqs_mItemsRequests.UnitPrice.Value : 0, Discount = x.mRfqs_mItemsRequests.Discount.HasValue ? x.mRfqs_mItemsRequests.Discount.Value : 0, TotalPrice = x.mRfqs_mItemsRequests.TotalPrice.HasValue ? x.mRfqs_mItemsRequests.TotalPrice.Value : 0 }); var request = db.PurchaseRequests.Where(x => x.Id == RequestId).SingleOrDefault(); RequestUser = db.Users.Where(x => x.Id == request.User.Id).Select(x => new UserModel() { CompanyId = x.CompanyId, CompanyName = x.Company.Name, Id = x.Id, DepartmentName = x.Department.Name, FirstName = x.FirstName, LastName = x.LastName, UserTypeId = x.UserTypeId, }).SingleOrDefault(); RequestNumber = request.PRNo; }