public CreateACustomer() { CustDB = new CustomerDB(); }
private void initVariables() { CustomerDB.fillLedgerTypeComboNew(cmbCustomer, "Customer"); pnlUI.Controls.Add(pnlList); setButtonVisibility("init"); }
public static Customer GetCustomer(string CustomerID) { return(CustomerDB.Get(CustomerID)); }
public static bool UpdateCustomer(Customer data) { return(CustomerDB.Update(data)); }
public static Customer GetCustomer(string customerId) { return(CustomerDB.Get(customerId)); }
// just before form closes, save data private void frmProducts_FormClosing(object sender, FormClosingEventArgs e) { CustomerDB.SaveCustomers(customers); }
/// <summary> /// /// </summary> /// <param name="searchValue"></param> /// <returns></returns> public static int Customer_Count(string searchValue) { return(CustomerDB.Count(searchValue)); }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Session["user"] != null) { //calling member class to the session of user Customer c = (Customer)Session["user"]; c.Name = tbxName.Text; c.Gender = tbxGender.Text; c.DateOfBirth = Convert.ToDateTime(tbxDOB.Text); c.Address = tbxAddress.Text; c.PostalCode = tbxPostalCode.Text; c.PersonalID = tbxPID.Text; c.Nationality = tbxNationality.Text; c.PhoneNumber = Convert.ToInt32(tbxPhone.Text); c.CustEmail = tbxEmail.Text; c.Password = tbxPassword.Text; Session["user"] = c; int row = CustomerDB.updateCustomer(c); //display an output lblOutput.Text = "Update successfully!"; databindedCust(); } else if (Session["userAttraction"] != null) { Attraction a = (Attraction)Session["userAttraction"]; a.Name = tbxCName.Text; a.RegID = tbxRID.Text; a.Address = tbxCAddress.Text; a.PostalCode = tbxCPostalCode.Text; a.City = tbxCCity.Text; a.Country = tbxCCountry.Text; a.Password = tbxCpass.Text; a.ContactNo = tbxCPhone.Text; a.OrgEmail = tbxCEmail.Text; a.Password = tbxCPassword.Text; a.Description = tbxDesc.Text; a.OpeningHours = tbxOHour.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); a.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + a.Photo; } Session["userAttraction"] = a; lblOutput.Text = "Update successfully!"; int row = AttractionDB.updateAttraction(a); databindedOrg(); } else if (Session["userRestaurant"] != null) { Restaurant r = (Restaurant)Session["userRestaurant"]; r.Name = tbxCName.Text; r.RegID = tbxRID.Text; r.Address = tbxCAddress.Text; r.PostalCode = tbxCPostalCode.Text; r.City = tbxCCity.Text; r.Country = tbxCCountry.Text; r.Password = tbxCpass.Text; r.ContactNo = tbxCPhone.Text; r.OrgEmail = tbxCEmail.Text; r.Password = tbxCPassword.Text; r.Description = tbxDesc.Text; r.OpeningHours = tbxOHour.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); r.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + r.Photo; } r.License = tbxLicenseNo.Text; Session["userRestaurant"] = r; lblOutput.Text = "Update successfully!"; int row = RestaurantDB.updateRestaurant(r); databindedROrg(); } else if (Session["userHotel"] != null) { Hotel h = (Hotel)Session["userHotel"]; h.Name = tbxCName.Text; h.RegID = tbxRID.Text; h.Address = tbxCAddress.Text; h.PostalCode = tbxCPostalCode.Text; h.City = tbxCCity.Text; h.Country = tbxCCountry.Text; h.Password = tbxCpass.Text; h.ContactNo = tbxCPhone.Text; h.OrgEmail = tbxCEmail.Text; h.Password = tbxCPassword.Text; h.Description = tbxDesc.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); h.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + h.Photo; } h.License = tbxOHour.Text; Session["userHotel"] = h; lblOutput.Text = "Update successfully!"; int row = HotelDB.updateHotel(h); databindedHOrg(); } }
/// <summary> /// /// </summary> /// <param name="customerID"></param> /// <returns></returns> public static bool Customer_Delete(string[] customerID) { return(CustomerDB.Delete(customerID)); }
/// <summary> /// /// </summary> /// <param name="customerID"></param> /// <returns></returns> public static Customer Customer_Get(string customerID) { return(CustomerDB.Get(customerID)); }
/// <summary> /// /// </summary> /// <param name="data"></param> /// <returns></returns> public static int Customer_Add(Customer data) { return(CustomerDB.Add(data)); }
public OrderStatusDB(SqlConnection conn) { this.conn = conn; custDB = new CustomerDB(conn); ItemDB = new ItemDB(conn); }
protected void btnConfirm_Click(object sender, EventArgs e) { //checking whether the credit card entered is valid or not int cardValid = Utility.validateCreditCard(tbxCardNumber.Text); if (cardValid < 0) { lblOutput.Text = "Invalid card number. Please enter valid card number"; } else { ShoppingCart sc = (ShoppingCart)Session["cart"]; //retrieve from the shopping cart session Booking b = null; //when booking id is null DiscountCoupon dc = null; //when discount coupon is null if (Session["DC"] != null) //to check whether the discount coupon is not null { dc = (DiscountCoupon)Session["DC"]; //retrieve from the discount coupon session } //add the booking details b = new Booking("", DateTime.Now, DateTime.Now, sc.NetAMount, sc.Tax, 7, sc.TotalPrice, sc.DiscountedAmt, amtPayable, tbxCardholderName.Text, "Visa", Convert.ToInt64(tbxCardNumber.Text), tbxCvv.Text, Convert.ToDateTime("24/" + ddlMonth.SelectedItem.Text + "/" + ddlYear.SelectedItem.Text), "", (Customer)Session["user"], dc); //insert the booking info in the database result = ShoppingCartDB.confirmBooking(sc, b, Session["user"].ToString()); if (result >= 0) //checking the result is not null or minus { try { //sending booking information to the customer SmtpClient client = new SmtpClient("smtp.gmail.com"); client.EnableSsl = true; client.Credentials = new NetworkCredential("*****@*****.**", "smart-travel1005"); MailMessage msg, msg1; Customer c = CustomerDB.getACustomerByEmail(Session["emailUser"].ToString()); //retrieve the customer session msg = new MailMessage("*****@*****.**", c.CustEmail); List <CartItem> acmList = sc.RoomCI; //retrieve the cartitem from room details List <CartItem> ticList = sc.TicketCI; //retrieve the cartitem from ticket details List <CartItem> resList = sc.RestaurantCI; //retrieve the cart item from restaurant details msg.Subject = "Your Booking Request"; msg.Body = "Booking ID: BK" + result + ". You have requested to book the following services: \r\n\r\n"; //add the accommodation info included in the shopping cart to the email body for (int i = 0; i < acmList.Count; i++) { msg.Body += acmList[i].SCRoom.Hotel.Name + "\r\nRoom ID: " + acmList[i].SCRoom.RoomID + "\r\nCheck-in Date: " + acmList[i].RoomCIDate + "\r\nCheck out Date: " + acmList[i].RoomCODate + "\r\n \r\n"; msg1 = new MailMessage("*****@*****.**", acmList[i].SCRoom.Hotel.OrgEmail); msg1.Subject = "New Booking Request"; msg1.Body = "A new booking request regarding your room at " + acmList[i].SCRoom.RoomID + " has been received. Please check your SmartTravel account to accept or reject booking request. Thanks"; client.Send(msg1); } //add the ticket type info included in the shopping cart to the email body for (int n = 0; n < ticList.Count; n++) { msg.Body += ticList[n].AttractionName + "\r\n Date: " + ticList[n].TICdate + "\r\nTotal Amount: " + ticList[n].TICtotalAMT + "\r\nTotal People " + ticList[n].TICqty + "\r\n\r\n"; msg1 = new MailMessage("*****@*****.**", ticList[n].TICTicket.Attraction.OrgEmail); msg1.Subject = "New Booking Request"; msg1.Body = "A new booking request regarding your Ticket Details " + ticList[n].TICketID + " " + ticList[n].TICketID + " has been received. Please check your SmartTravel account to accept or reject booking request. Thanks"; client.Send(msg1); } //add the restaurant info included in the shopping cart to the email body for (int n = 0; n < resList.Count; n++) { msg.Body += resList[n].RESname + "\r\n Address: " + resList[n].RESaddress + "\r\n Date: " + resList[n].RESdate + "\r\n Time: " + resList[n].REStime + "\r\nNumber of People: " + resList[n].RESguest + "\r\n\r\n"; msg1 = new MailMessage("*****@*****.**", resList[n].RESrestaurant.OrgEmail); msg1.Subject = "New Booking Request"; msg1.Body = "A new booking request regarding your Reservation Details " + "\r\n Date: " + resList[n].RESdate + "\r\n Time: " + resList[n].REStime + " " + " has been received. Please check your SmartTravel account to accept or reject booking request. Thanks"; client.Send(msg1); } int count = 1; //initialize the count Random r = new Random(); //initialize the random number generator companyName = "SmartTravel"; //set the company name customerName = c.Name; //set the customer name from the session orderNo = r.Next(0, 10000); //initialize the order no from random number generator DataTable dt = new DataTable(); //initialize the datatable //add data column into receipt -- pdf generator dt.Columns.AddRange(new DataColumn[5] { new DataColumn("ID", typeof(string)), new DataColumn("Name", typeof(string)), new DataColumn("Price", typeof(int)), new DataColumn("Quantity", typeof(int)), new DataColumn("Total", typeof(int)) }); //add the accomodation info included in the shopping cart to the digital receipt for (int i = 0; i < acmList.Count; i++) { dt.Rows.Add(count++, acmList[i].SCRoom.Hotel.Name + " -- Room ID: " + acmList[i].SCRoom.RoomID, acmList[i].SCRoom.Price, acmList[i].NoofRoom, acmList[i].RoomTotalAmt); } //add the ticket info included in the shopping cart to the digital receipt for (int n = 0; n < ticList.Count; n++) { dt.Rows.Add(count++, ticList[n].TICTicket.Attraction.Name + " -- " + ticList[n].TICtype, ticList[n].TICTicket.Price, ticList[n].TICqty, ticList[n].TICtotalAMT); } //add the restaurant info included in the shopping cart to the digital receipt for (int n = 0; n < resList.Count; n++) { dt.Rows.Add(count++, resList[n].RESname, 0, resList[n].RESguest, 0); } using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); //initialize the stringbuilder //Generate Invoice (Bill) Header. sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>"); sb.Append("<tr><td align='center' colspan = '2'><b>Order Sheet</b></td></tr>"); sb.Append(" </td></tr>"); sb.Append("<tr><td colspan = '2'><b>Customer Name: </b>"); sb.Append(customerName); sb.Append("<tr><td colspan = '2'></td></tr>"); sb.Append("<tr><td><b>Order No: </b>"); sb.Append(orderNo); sb.Append("</td><td align = 'right'><b>Date: </b>"); sb.Append(DateTime.Now); sb.Append(" </td></tr>"); sb.Append("<tr><td colspan = '2'><b>Company Name: </b>"); sb.Append(companyName); sb.Append("</td></tr>"); sb.Append("<tr><td colspan = '2'><b>Booking ID: </b>"); sb.Append("BK" + result); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("<br />"); //Generate Invoice (Bill) Items Grid. sb.Append("<table border = '1'>"); sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<th style = 'background-color: #D20B0C;color:#ffffff'>"); sb.Append(column.ColumnName); sb.Append("</th>"); } sb.Append("</tr>"); foreach (DataRow row in dt.Rows) { sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<td>"); sb.Append(row[column]); sb.Append("</td>"); } sb.Append("</tr>"); } sb.Append("<tr><td align = 'right' colspan = '"); sb.Append(dt.Columns.Count - 1); sb.Append("'>Total</td>"); sb.Append("<td>"); sb.Append(dt.Compute("sum(Total)", "")); sb.Append("</td>"); sb.Append("</tr></table>"); sb.Append("<br />"); sb.Append("<br />"); sb.Append("<br />"); sb.Append("<br />"); sb.Append("<br />"); sb.Append("<br />"); sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>"); sb.Append("<tr><td align='left' color='red' colspan = '2'><b>*Note:</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Price is SGD</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>This receipt does not include the tax and booking charges</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><br/><br/><br/><br/><br/><br/></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Please ensure all information listed above is correct and keep this receipt for your records</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>If you have any questions, please see the contact of the webpage</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Contact +65 6390 9000</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Thank You.</b></td></tr>"); sb.Append(" </td></tr>"); sb.Append("</table>"); StringReader sr = new StringReader(sb.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); using (MemoryStream memoryStream = new MemoryStream()) //use memory stream to generate the pdfDoc { PdfWriter writer = PdfWriter.GetInstance(pdfDoc, memoryStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); byte[] bytes = memoryStream.ToArray(); memoryStream.Close(); msg.Attachments.Add(new Attachment(new MemoryStream(bytes), "Invoice.pdf")); //add the attachment into an email client.Send(msg); //sending email } } } btnPrint.Visible = true; //print the booking successful message lblOutput.Text = "Booking request successfully. Your booking ID is BK" + result + ". Thanks you for choosing SmartTravel."; Session["bID"] = "BK" + result; } catch (Exception er) { lblOutput.Text = "internet connection required"; } } else { lblOutput.Text = "Unsuccessful"; //when the shopping cart cannot successfully inserted into database } } }
private void GeneratePDF(DataTable dt) //to generate PDF { Customer c = CustomerDB.getACustomerByEmail(Session["emailUser"].ToString()); //retrieve the customer email using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); //Generate Invoice (Bill) Header. sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>"); sb.Append("<tr><td align='center' colspan = '2'><b>Order Sheet</b></td></tr>"); sb.Append(" </td></tr>"); sb.Append("<tr><td colspan = '2'><b>Customer Name: </b>"); sb.Append(customerName); sb.Append("<tr><td colspan = '2'></td></tr>"); sb.Append("<tr><td><b>Order No: </b>"); sb.Append(orderNo); sb.Append("</td><td align = 'right'><b>Date: </b>"); sb.Append(DateTime.Now); sb.Append(" </td></tr>"); sb.Append("<tr><td colspan = '2'><b>Company Name: </b>"); sb.Append(companyName); sb.Append(" </td></tr>"); sb.Append("<tr><td colspan = '2'><b>Booking ID: </b>"); sb.Append(Session["bID"]); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("<br />"); //Generate Invoice (Bill) Items Grid. sb.Append("<table border = '1'>"); sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<th style = 'background-color: #D20B0C;color:#ffffff'>"); sb.Append(column.ColumnName); sb.Append("</th>"); } sb.Append("</tr>"); foreach (DataRow row in dt.Rows) { sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<td>"); sb.Append(row[column]); sb.Append("</td>"); } sb.Append("</tr>"); } sb.Append("<tr><td align = 'right' colspan = '"); sb.Append(dt.Columns.Count - 1); sb.Append("'>Total</td>"); sb.Append("<td>"); sb.Append(dt.Compute("sum(Total)", "")); sb.Append("</td>"); sb.Append("</tr></table>"); sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>"); sb.Append("<tr><td align='left' color='red' colspan = '2'><b>*Note:</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Price is SGD</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>This receipt does not include the tax and booking charges</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><br/><br/><br/><br/><br/><br/></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Please ensure all information listed above is correct and keep this receipt for your records</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>If you have any questions, please see the contact of the webpage</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Contact +65 6390 9000</b></td></tr>"); sb.Append("<tr><td align='left' colspan = '2'><b>Thank You.</b></td></tr>"); sb.Append(" </td></tr>"); sb.Append("</table>"); //Export HTML String as PDF. StringReader sr = new StringReader(sb.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + orderNo + ".pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.End(); } } }
/// <summary> /// the function is used to create a session of UserID /// </summary> protected void GettingCustomerID() { string userEmail = User.Identity.Name; Session["UserID"] = Convert.ToString(CustomerDB.GetCustomerID(userEmail).CustomerId); }
private void BalanceInquiry_Load(object sender, EventArgs e) { //will always find, otherwise wouldn't open the form; if (File.Exists(filePath1)) { dictCustomer = CustomerDB.ReadFromFile(); dictCustomer.TryGetValue(Int32.Parse(code), out aCustomer); } else { System.Windows.Forms.MessageBox.Show("CUSTOMER Database not found", "ERROR"); } if (File.Exists(filePath2)) { dictAccount = AccountDB.ReadFromFile(); } else { System.Windows.Forms.MessageBox.Show("ACCOUNT Database not found", "ERROR"); } if (File.Exists(filePath3) && File.Exists(filePath4)) { dictTransaction = TransactionDB.ReadFromFile(); sortedTransaction = TransactionDB.ReadFromFileSorted(); lastValueTransac = sortedTransaction.Keys.Last(); } else { System.Windows.Forms.MessageBox.Show("TRANSACTION Database not found", "ERROR"); lastValueTransac = 30000; } if (aCustomer.customerAccount == null) { MessageBox.Show("No accounts to show"); } dictAccount = aCustomer.customerAccount; AcclistView.Items.Clear(); if (dictAccount != null) { foreach (Account current in dictAccount.Values) { ListViewItem item = new ListViewItem(current.AccNumber.ToString()); item.SubItems.Add(Convert.ToString(current.Acctype)); item.SubItems.Add(current.OpenDate.ToShortDateString()); item.SubItems.Add("CAD " + current.Balance); AcclistView.Items.Add(item); Dictionary <int, Transaction> tempDictTransaction = new Dictionary <int, Transaction>(); tempDictTransaction = current.accTransactionDict; foreach (Transaction transac in tempDictTransaction.Values) { ListViewItem secItem = new ListViewItem(transac.TransNumber.ToString()); secItem.SubItems.Add(Convert.ToString(transac.TransType)); secItem.SubItems.Add(current.AccNumber.ToString()); secItem.SubItems.Add(Convert.ToString(current.Acctype)); secItem.SubItems.Add(transac.Date.ToShortDateString()); secItem.SubItems.Add("CAD" + transac.Amount.ToString()); TransacListView.Items.Add(secItem); //dictTransaction.Add(transac.TransNumber, transac); } } } else { MessageBox.Show("No Data"); } }
private void CustomerBill_Load(object sender, EventArgs e) { customers = CustomerDB.ReadCustomers(); DisplayCustomers(); Statistics(); }
public static List <Customer> ListOfCustomers() { return(CustomerDB.List(1, -1, "", "")); }
//form private void CustomerBill_FormClosing(object sender, FormClosingEventArgs e) { CustomerDB.SaveCustomers(customers); }
public CustomerController() { CustomerDB = new CustomerDB(); }
// Save data just before form closes (ie. data in listbox to file) private void Form1_FormClosing(object sender, FormClosingEventArgs e) { CustomerDB.SaveCustomers(customerList); }
public void PrintExportIO(invoiceoutheader ioh, List <invoiceoutdetail> IODetails, string taxStr, string podocID) { try { Dictionary <string, string> companyInfo = getCompanyInformation(); string[] pos = ioh.TrackingNos.Split(';'); int b = 0; int[] a = (from s in pos where int.TryParse(s, out b) select b).ToArray(); int min = a.Min(); string[] dates = ioh.TrackingDates.Split(';'); string poStr = ""; string billingAdd = ""; //StringBuilder sb = new StringBuilder(); for (int i = 0; i < pos.Length - 1; i++) { string custPOStr = POPIHeaderDB.getCustomerPOAndDateForInvoiceOut(Convert.ToInt32(pos[i]), Convert.ToDateTime(dates[i]), podocID); string[] custPO = custPOStr.Split(Main.delimiter1); if (Convert.ToInt32(pos[i]) == min) { billingAdd = custPO[2]; } poStr = poStr + custPO[0] + " dated " + custPO[1] + "\n"; } companybank cb = CompanyBankDB.getCompBankDetailForIOPrint(ioh.BankAcReference); CompanyDataDB datadb = new CompanyDataDB(); string ieccode = ""; cmpnydata cdata = datadb.getData("1").FirstOrDefault(c => c.DataID == "ImportExportCode"); if (cdata != null) { ieccode = cdata.DataValue; } customer custDetail = CustomerDB.getCustomerDetailForPO(ioh.ConsigneeID); string[] companyBillingAdd = CompanyAddressDB.getCompTopBillingAdd(Login.companyID); string ConsgAdd = "Consignee:\n" + custDetail.name + Main.delimiter2 + "\n" + ioh.DeliveryAddress + "\n"; string buyer = "Buyer:\n" + custDetail.name + Main.delimiter2 + "\n" + billingAdd + "\n"; if (custDetail.StateName.ToString().Length != 0) { ConsgAdd = ConsgAdd + "Sate Name:" + custDetail.StateName; buyer = buyer + "Sate Name:" + custDetail.StateName; if (custDetail.StateCode.ToString().Length != 0) { ConsgAdd = ConsgAdd + " ,\nState Code:" + custDetail.StateCode; buyer = buyer + " ,\nState Code:" + custDetail.StateCode; } } else { if (custDetail.StateCode.ToString().Length != 0) { ConsgAdd = ConsgAdd + "\nState Code:" + custDetail.StateCode; buyer = buyer + "\nState Code:" + custDetail.StateCode; } } //string buyer = if (custDetail.OfficeName.ToString().Length != 0) { ConsgAdd = ConsgAdd + "\nGST:" + custDetail.OfficeName; // For GST Code buyer = buyer + "\nGST:" + custDetail.OfficeName; // For GST Code } if (CustomerDB.getCustomerPANForInvoicePrint(ioh.ConsigneeID).Length != 0) { ConsgAdd = ConsgAdd + "\nPAN:" + custDetail.OfficeName; // For PAN Code buyer = buyer + "\nPAN:" + custDetail.OfficeName; // For PAN Code } string HeaderString = companyBillingAdd[0] + Main.delimiter2 + "\n" + companyBillingAdd[1] + "\nGST:" + companyInfo["GST"] + "\nCIN:" + companyInfo["CIN"] + "\nPAN:" + companyInfo["PAN"] + Main.delimiter1 + "Invoice No : " + ioh.InvoiceNo + ", Date : " + ioh.InvoiceDate.ToString("dd-MM-yyyy") + Main.delimiter1 + "Reference : " + poStr + Main.delimiter1 + "IEC Code : " + ieccode + Main.delimiter1 + "AD Code : " + ioh.ADCode + Main.delimiter1 + ConsgAdd + Main.delimiter1 + "Country of origin of goods : " + ioh.OriginCountryName + Main.delimiter1 + "Country of final destination : " + ioh.FinalDestinatoinCountryName + Main.delimiter1 + "Pre-Carriage by : " + ioh.PreCarriageTransportationName + Main.delimiter1 + "Place of Receipt by pre-carrier : " + ioh.PreCarrierReceiptPlace + Main.delimiter1 + "Port of Loading : " + ioh.ExitPort + Main.delimiter1 + buyer + Main.delimiter1 + "Port of Discharge : " + ioh.EntryPort + Main.delimiter1 + "Final Destination : " + ioh.FinalDestinationPlace + Main.delimiter1 + "Terms of Delivery : " + ioh.TermsOfDelivery + Main.delimiter1 + ioh.SpecialNote; string footer1 = "Amount In Words\n\n"; string ColHeader = "SI No.;Description of Goods;HSN;Quantity;Unit;Unit Rate;Amount"; string footer2 = "\n\nBank : " + cb.BankName + "\nBranch : " + cb.BranchName + "\nAC Type : " + cb.AccountType + "\nAC No : " + cb.AccountCode + "\nSWIFT Code : " + cb.CompanyID + "\nIFSC Code : " + cb.CreateUser; string footer3 = "For Cellcomm Solutions Limited;Authorised Signatory"; //string termsAndCond = getTCString(poh.TermsAndCondition); double totQuant = 0.00; double totAmnt = 0.00; int n = 1; string ColDetailString = ""; var count = IODetails.Count(); ////string HSNCode = ""; foreach (invoiceoutdetail iod in IODetails) { ////if ((ioh.DocumentID == "SERVICEINVOICEOUT") || (ioh.DocumentID == "SERVICEEXPORTINVOICEOUT")) ////{ //// HSNCode = ServiceHSNMappingDB.getHSNCode(iod.StockItemID); ////} ////else ////{ //// HSNCode = ProductHSNMappingDB.getHSNCode(iod.StockItemID, iod.ModelNo); ////} //+ : main.delimiter1 if (n == count) { //ColDetailString = ColDetailString + n + "+" + iod.CustomerItemDescription + "+" + HSNCode + "+" + iod.Quantity + "+" // + iod.Unit + "+" + iod.Price + "+" + (iod.Quantity * iod.Price); ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode + Main.delimiter1 + iod.Quantity + Main.delimiter1 + iod.Unit + Main.delimiter1 + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price); if (iod.Tax != 0) { //ColDetailString = ColDetailString + Main.delimiter2 + "" + "+" + iod.TaxCode + "+" + "" + "+" // + "" + "+" + "" + "+" + "" + "+" + iod.Tax; ColDetailString = ColDetailString + Main.delimiter2 + "" + Main.delimiter1 + iod.TaxCode + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + iod.Tax; } } else { ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode + Main.delimiter1 + iod.Quantity + Main.delimiter1 + iod.Unit + Main.delimiter1 + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price) + Main.delimiter2; if (iod.Tax != 0) { //ColDetailString = ColDetailString + "" + "+" + iod.TaxCode + "+" + "" + "+" // + "" + "+" + "" + "+" + "" + "+" + iod.Tax + Main.delimiter2; ColDetailString = ColDetailString + "" + Main.delimiter1 + iod.TaxCode + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + iod.Tax + Main.delimiter2; } } totQuant = totQuant + iod.Quantity; totAmnt = totAmnt + (iod.Quantity * iod.Price); n++; } SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "Save As PDF"; sfd.Filter = "Pdf files (*.Pdf)|*.pdf"; sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); sfd.FileName = ioh.DocumentID + "-" + ioh.InvoiceNo; if (sfd.ShowDialog() == DialogResult.Cancel || sfd.FileName == "") { return; } FileStream fs = new FileStream(sfd.FileName, FileMode.Create, FileAccess.Write); Rectangle rec = new Rectangle(PageSize.A4); iTextSharp.text.Document doc = new iTextSharp.text.Document(rec); PdfWriter writer = PdfWriter.GetInstance(doc, fs); MyEvent evnt = new MyEvent(); writer.PageEvent = evnt; doc.Open(); Font font1 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Font font2 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD, BaseColor.BLACK); Font font3 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.ITALIC, BaseColor.BLACK); Font font4 = FontFactory.GetFont("Arial", 5, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); String URL = "Cellcomm2.JPG"; iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(URL); img.Alignment = Element.ALIGN_LEFT; PdfPTable tableMain = new PdfPTable(2); tableMain.WidthPercentage = 100; PdfPCell cellImg = new PdfPCell(); Paragraph pp = new Paragraph(); pp.Add(new Chunk(img, 0, 0)); cellImg.AddElement(pp); cellImg.Border = 0; tableMain.AddCell(cellImg); PdfPCell cellAdd = new PdfPCell(); Paragraph ourAddr = new Paragraph(); CompanyDetailDB compDB = new CompanyDetailDB(); cmpnydetails det = compDB.getdetails().FirstOrDefault(comp => comp.companyID == 1); if (det != null) { //string addr = det.companyname + "\n" + det.companyAddress; ourAddr.Add(new Chunk(det.companyname + "\n", font2)); ourAddr.Add(new Chunk(det.companyAddress + "\n", font4)); ourAddr.SetLeading(0.0f, 1.5f); //ourAddr = new Paragraph(new Phrase(addr, font2)); ourAddr.Alignment = Element.ALIGN_RIGHT; } cellAdd.AddElement(ourAddr); cellAdd.Border = 0; tableMain.AddCell(cellAdd); Paragraph paragraph = new Paragraph(new Phrase("Invoice", font2)); paragraph.Alignment = Element.ALIGN_CENTER; PrintPurchaseOrder prog = new PrintPurchaseOrder(); string[] HeaderStr = HeaderString.Split(Main.delimiter1); PdfPTable table = new PdfPTable(7); table.SpacingBefore = 20f; table.WidthPercentage = 100; float[] HWidths = new float[] { 0.5f, 8f, 1.5f, 2f, 1.5f, 2f, 3f }; table.SetWidths(HWidths); PdfPCell cell; int[] arr = { 3, 7, 9, 10 }; float wid = 0; for (int i = 0; i < HeaderStr.Length; i++) { if (i == 0 || i == 5 || i == 11) { string[] format = HeaderStr[i].Split(Main.delimiter2); Phrase phr = new Phrase(); phr.Add(new Chunk(format[0], font2)); phr.Add(new Chunk(format[1], font1)); cell = new PdfPCell(phr); if (i == 5) { cell.Rowspan = 5; } else { cell.Rowspan = 4; } cell.Colspan = 2; cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right table.AddCell(cell); } //else if (arr.Contains(i)) //{ // cell = new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1)); // cell.Colspan = 5; // cell.MinimumHeight = wid; // table.AddCell(cell); //} else { cell = new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1)); cell.Colspan = 5; //if (i % 2 != 0) // cell.Colspan = 3; //else // cell.Colspan = 2; table.AddCell(cell); } } string[] ColHeaderStr = ColHeader.Split(';'); PdfPTable table1 = new PdfPTable(7); table1.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.WidthPercentage = 100; float[] width = new float[] { 0.5f, 8f, 1.5f, 2f, 1.5f, 2f, 3f }; table1.SetWidths(width); for (int i = 0; i < ColHeaderStr.Length; i++) { if (i == 5 || i == 6) { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim() + "\n(" + ioh.CurrencyID + ")", font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(hcell); } else { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim(), font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(hcell); } } //--- PdfPCell foot = new PdfPCell(new Phrase("")); foot.Colspan = 7; foot.BorderWidthTop = 0; foot.MinimumHeight = 0.5f; table1.AddCell(foot); table1.HeaderRows = 2; table1.FooterRows = 1; table1.SkipFirstHeader = false; table1.SkipLastFooter = true; //--- int track = 0; decimal dc1 = 0; decimal dc2 = 0; string[] DetailStr = ColDetailString.Split(Main.delimiter2); float hg = 0f; for (int i = 0; i < DetailStr.Length; i++) { track = 0; hg = table1.GetRowHeight(i + 1); string[] str = DetailStr[i].Split(Main.delimiter1); for (int j = 0; j < str.Length; j++) { PdfPCell pcell; if (j == 3 || j == 5 || j == 6) { decimal p = 1; if (Decimal.TryParse(str[j], out p)) { pcell = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(str[j])), font1)); } else { pcell = new PdfPCell(new Phrase("")); } pcell.Border = 0; if (j == 6) { if (str[0].Length == 0) { pcell.BorderWidthBottom = 0.01f; track = 1; dc2 = Convert.ToDecimal(str[j]); } else { dc1 = Convert.ToDecimal(str[j]); } } } else { if (j == 2) { if (str[j].Trim().Length == 0) { pcell = new PdfPCell(new Phrase("", font1)); } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else if (j == 4) { int m = 1; if (Int32.TryParse(str[j], out m) == true) { if (Convert.ToInt32(str[j]) == 0) { pcell = new PdfPCell(new Phrase("", font1)); } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } pcell.Border = 0; } //pcell.Border = 0; //if (i == DetailStr.Length - 1) //{ // pcell.MinimumHeight = 50; //} //else pcell.MinimumHeight = 10; //pcell.MinimumHeight = 20; if (j == 1) { pcell.HorizontalAlignment = PdfPCell.ALIGN_LEFT; } else { pcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; } pcell.BorderWidthLeft = 0.01f; pcell.BorderWidthRight = 0.01f; table1.AddCell(pcell); } if (track == 1) { for (int j = 0; j < 7; j++) { PdfPCell pcell1; if (j == 6) { pcell1 = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(dc1 + dc2)), font1)); pcell1.Border = 0; pcell1.BorderWidthBottom = 0.01f; } else { pcell1 = new PdfPCell(new Phrase("")); pcell1.Border = 0; } pcell1.HorizontalAlignment = PdfPCell.ALIGN_CENTER; pcell1.BorderWidthLeft = 0.01f; pcell1.BorderWidthRight = 0.01f; table1.AddCell(pcell1); } } } double roundedAmt = Math.Round(ioh.InvoiceAmount, 0); double diffAmount = roundedAmt - ioh.InvoiceAmount; if (diffAmount != 0) { table1.AddCell(""); table1.AddCell(""); PdfPCell cellRound = new PdfPCell(new Phrase("Round off Adj.", font1)); cellRound.Colspan = 4; cellRound.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(cellRound); table1.AddCell(new Phrase(String.Format("{0:0.00}", diffAmount), font1)); //table1.AddCell(""); } table1.AddCell(""); table1.AddCell(""); PdfPCell cellRoundTot = new PdfPCell(new Phrase("Total", font1)); cellRoundTot.Colspan = 4; cellRoundTot.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(cellRoundTot); PdfPCell roundTot = new PdfPCell(new Phrase(String.Format("{0:0.00}", roundedAmt), font1)); roundTot.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(roundTot); string total = footer1 + NumberToString.convertFC(roundedAmt.ToString(), ioh.CurrencyID).Replace("INR", ioh.CurrencyID) + "\n\n"; PdfPCell fcell1 = new PdfPCell(new Phrase((total), font1)); fcell1.Colspan = 6; //fcell1.MinimumHeight = 30; fcell1.HorizontalAlignment = PdfPCell.ALIGN_LEFT; fcell1.BorderWidthBottom = 0; fcell1.BorderWidthRight = 0; fcell1.BorderWidthTop = 0; table1.AddCell(fcell1); PdfPCell fcell4 = new PdfPCell(new Phrase("E. & O.E", font1)); //fcell4.MinimumHeight = 50; fcell4.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; fcell4.BorderWidthBottom = 0; //fcell4.BorderWidthRight = 0; fcell4.BorderWidthLeft = 0; fcell4.BorderWidthTop = 0; table1.AddCell(fcell4); //if (ioh.SpecialNote.Trim().Length != 0) //{ // PdfPCell SplNote = new PdfPCell(new Phrase(("Note:\n" + ioh.SpecialNote.Trim() + "\n"), font1)); // SplNote.Colspan = 5; // SplNote.MinimumHeight = 50; // SplNote.HorizontalAlignment = PdfPCell.ALIGN_LEFT; // SplNote.BorderWidthBottom = 0; // SplNote.BorderWidthRight = 0; // SplNote.BorderWidthTop = 0; // table1.AddCell(SplNote); // PdfPCell temp1 = new PdfPCell(new Phrase("")); // temp1.Colspan = 2; // temp1.MinimumHeight = 50; // temp1.HorizontalAlignment = PdfPCell.ALIGN_LEFT; // temp1.BorderWidthBottom = 0; // temp1.BorderWidthLeft = 0; // temp1.BorderWidthTop = 0; // table1.AddCell(temp1); // //table1.AddCell(""); //} PdfPCell pcelNo = new PdfPCell(new Phrase("", font1)); pcelNo.BorderWidthTop = 0; pcelNo.BorderWidthRight = 0; table1.AddCell(pcelNo); Phrase phrs = new Phrase(); phrs.Add(new Chunk("Bank Details", font2)); phrs.Add(new Chunk(footer2, font1)); //PdfPCell fcell2 = new PdfPCell(new Phrase(footer2, font1)); PdfPCell fcell2 = new PdfPCell(phrs); fcell2.HorizontalAlignment = PdfPCell.ALIGN_MIDDLE; //fcell2.BorderWidthTop = 0; //fcell2.BorderWidthRight = 0; table1.AddCell(fcell2); PdfPCell pcelMid = new PdfPCell(new Phrase("", font1)); pcelMid.Colspan = 3; //pcelMid.Border = 0; pcelMid.BorderWidthTop = 0; pcelMid.BorderWidthLeft = 0; pcelMid.BorderWidthRight = 0; table1.AddCell(pcelMid); string[] ft = footer3.Split(';'); PdfPCell fcell3 = new PdfPCell(); Chunk ch1 = new Chunk(ft[0], font1); Chunk ch2 = new Chunk(ft[1], font1); Phrase phrase = new Phrase(); phrase.Add(ch1); for (int i = 0; i < 3; i++) { phrase.Add(Chunk.NEWLINE); } phrase.Add(ch2); Paragraph para = new Paragraph(); para.Add(phrase); para.Alignment = Element.ALIGN_RIGHT; fcell3.AddElement(para); fcell3.Border = 0; fcell3.Colspan = 3; fcell3.BorderWidthTop = 0f; fcell3.BorderWidthLeft = 0f; fcell3.BorderWidthRight = 0.5f; fcell3.BorderWidthBottom = 0.5f; fcell3.MinimumHeight = 50; table1.AddCell(fcell3); table1.KeepRowsTogether(table1.Rows.Count - 4, table1.Rows.Count); //------------------------- double dd = 0; PdfPTable taxTab = new PdfPTable(3); taxTab.WidthPercentage = 100; float[] twidth = new float[] { 3f, 3f, 10f }; taxTab.SetWidths(twidth); if (ioh.TaxAmount != 0) { PdfPCell pcell; pcell = new PdfPCell(new Phrase("Tax Details", font2)); taxTab.AddCell(pcell); PdfPCell pcellc = new PdfPCell(new Phrase("Amount(" + ioh.CurrencyID + ")", font2)); taxTab.AddCell(pcellc); PdfPCell pcelllst = new PdfPCell(new Phrase("", font1)); pcelllst.Border = 0; taxTab.AddCell(pcelllst); string[] tax = taxStr.Split(Main.delimiter2); for (int i = 0; i < tax.Length - 1; i++) { string[] subtax = tax[i].Split(Main.delimiter1); PdfPCell pcell1; pcell1 = new PdfPCell(new Phrase(subtax[0], font1)); PdfPCell pcell2; pcell2 = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(subtax[1])), font1)); PdfPCell pcell3 = new PdfPCell(new Phrase("", font1)); pcell3.Border = 0; taxTab.AddCell(pcell1); taxTab.AddCell(pcell2); taxTab.AddCell(pcell3); } taxTab.AddCell(new Phrase("Total Tax Amount", font2)); taxTab.AddCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(ioh.TaxAmount)), font2)); PdfPCell pcellt = new PdfPCell(new Phrase("", font1)); pcellt.Border = 0; taxTab.AddCell(pcellt); taxTab.KeepTogether = true; taxTab.SpacingAfter = 2f; taxTab.SpacingBefore = 3f; } //PdfPTable TCTab = new PdfPTable(2); ; //if (poh.TermsAndCondition.Trim().Length != 0) //{ // Chunk TCchunk = new Chunk("Terms And Conditions:\n", font2); // TCchunk.SetUnderline(0.2f, -2f); // TCTab = new PdfPTable(2); // TCTab.WidthPercentage = 100; // PdfPCell TCCell = new PdfPCell(); // TCCell.Colspan = 2; // TCCell.Border = 0; // TCCell.AddElement(TCchunk); // TCTab.AddCell(TCCell); // try // { // string[] ParaTC = termsAndCond.Split(Main.delimiter2); // for (int i = 0; i < ParaTC.Length - 1; i++) // { // TCCell = new PdfPCell(); // TCCell.Colspan = 2; // TCCell.Border = 0; // Paragraph header = new Paragraph(); // Paragraph details = new Paragraph(); // details.IndentationLeft = 12f; // details.IndentationRight = 12f; // string paraHeaderStr = (i + 1) + ". " + ParaTC[i].Substring(0, ParaTC[i].IndexOf(Main.delimiter1)) + ":"; // string paraFooterStr = ParaTC[i].Substring(ParaTC[i].IndexOf(Main.delimiter1) + 1); // header.Add(new Phrase(paraHeaderStr, font2)); // details.Add(new Phrase(paraFooterStr, font1)); // TCCell.AddElement(header); // TCCell.AddElement(details); // TCTab.AddCell(TCCell); // } // } // catch (Exception ex) // { // MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error-" + ex.ToString()); // } // try // { // if (TCTab.Rows.Count >= 3) // { // TCTab.KeepRowsTogether(0, 3); // } // } // catch (Exception ex) // { // MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error-" + ex.ToString()); // } //} //doc.Add(jpg); doc.Add(tableMain); doc.Add(paragraph); doc.Add(table); doc.Add(table1); if (ioh.TaxAmount != 0) { doc.Add(taxTab); } //if(poh.TermsAndCondition.Trim().Length != 0) // doc.Add(TCTab); doc.Close(); MessageBox.Show("Document Saved"); //-----watermark String wmurl = ""; if (ioh.status == 98) { //cancelled wmurl = "003.png"; } else { //approved wmurl = "001.png"; } ////String wmurl = "napproved-1.jpg"; iTextSharp.text.Image wmimg = iTextSharp.text.Image.GetInstance(URL); PrintWaterMark.PdfStampWithNewFile(wmurl, sfd.FileName); //----- } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error-" + ex.ToString()); MessageBox.Show("Failed TO Save"); } }
public void PrintWO(workorderheader woh, List <workorderdetail> WODetail, string totalTaxDetail) { Dictionary <string, string> companyInfo = getCompanyInformation(); customer custDetail = CustomerDB.getCustomerDetailForPO(woh.CustomerID); string[] companyBillingAdd = CompanyAddressDB.getCompTopBillingAdd(Login.companyID); string contractorAdd = "Contractor:\n" + custDetail.name + Main.delimiter1 + "\n" + woh.POAddress + "\n"; if (custDetail.StateName.ToString().Length != 0) { contractorAdd = contractorAdd + "Sate Name:" + custDetail.StateName; } if (custDetail.StateCode.ToString().Length != 0) { contractorAdd = contractorAdd + "\nState Code:" + custDetail.StateCode; } if (custDetail.OfficeName.ToString().Length != 0) { contractorAdd = contractorAdd + "\nGST:" + custDetail.OfficeName; // For GST Code } string InvoiceTo = "Invoice To: \n" + companyBillingAdd[0] + Main.delimiter1 + "\n" + companyBillingAdd[1] + "\nGST:" + companyInfo["GST"] + "\nCIN:" + companyInfo["CIN"] + "\nPAN:" + companyInfo["PAN"]; string declaration = "We, Cellcomm Solutions Limited (also referred to as “CSL”), are pleased to place" + " this Purchase Order (also referred to as 'PO') with the Contractor addressed below.In accepting this Purchase Order, the Contractor" + " undertakes to execute the work described herein as per the details and instructions shown below" + " (such details and instructions being the Specific Terms and Conditions agreed between the Parties) " + "and also subject to the General Terms & Conditions contained herein."; string HeaderString = contractorAdd + Main.delimiter2 + "PO No : S-" + woh.WONo + " , Date : " + String.Format("{0:dd MMMM, yyyy}", Convert.ToDateTime(woh.WODate)) + Main.delimiter2 + "Contractor Reference : " + woh.ContractorReference + Main.delimiter2 + "Target Date : " + String.Format("{0:dd MMMM, yyyy}", Convert.ToDateTime(woh.TargetDate)) + Main.delimiter2 + InvoiceTo + Main.delimiter2 + "Payment Terms : " + PTDefinitionDB.getPaymentTermString(woh.PaymentTerms) + Main.delimiter2 + woh.SpecialNote; string footer1 = "Amount in words\n\n"; string ColHeader = "SI No.;Description of Work;Location;Quantity;Rate;Amount"; string footer2 = "This Purchase Order, being computer generated, does not require physical signature."; string footer3 = "for Cellcomm Solutions Limited;Authorised Signatory"; string termsAndCond = getTCString(woh.TermsAndCond, woh.DocumentID); double totQuant = 0.00; double totAmnt = 0.00; int n = 1; string ColDetailString = ""; var count = WODetail.Count(); //+ : main.delimeter1 //; : main.delimiter2 try { foreach (workorderdetail wod in WODetail) { if (n == count) { ColDetailString = ColDetailString + n + Main.delimiter1 + wod.Description + Main.delimiter1 + wod.WorkLocation + Main.delimiter1 + wod.Quantity + Main.delimiter1 + wod.Price + Main.delimiter1 + (wod.Quantity * wod.Price); } else { ColDetailString = ColDetailString + n + Main.delimiter1 + wod.Description + Main.delimiter1 + wod.WorkLocation + Main.delimiter1 + wod.Quantity + Main.delimiter1 + wod.Price + Main.delimiter1 + (wod.Quantity * wod.Price) + Main.delimiter2; } totQuant = totQuant + wod.Quantity; totAmnt = totAmnt + (wod.Quantity * wod.Price); n++; } } catch (Exception ex) { MessageBox.Show("Failed to Save 1 : " + ex.ToString()); } try { SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "Save As PDF"; sfd.Filter = "Pdf files (*.Pdf)|*.pdf"; sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); if (woh.Status == 0 && woh.DocumentStatus < 99) { sfd.FileName = woh.DocumentID + "-Temp-" + woh.TemporaryNo; } else { sfd.FileName = woh.DocumentID + "-" + woh.WONo; } //sfd.ShowDialog(); if (sfd.ShowDialog() == DialogResult.Cancel || sfd.FileName == "") { return; } FileStream fs = new FileStream(sfd.FileName, FileMode.Create, FileAccess.Write); Rectangle rec = new Rectangle(PageSize.A4); //rec.Bottom = 10; iTextSharp.text.Document doc = new iTextSharp.text.Document(rec); PdfWriter writer = PdfWriter.GetInstance(doc, fs); MyEvent evnt = new MyEvent(); writer.PageEvent = evnt; doc.Open(); Font font1 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Font font2 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD, BaseColor.BLACK); Font font3 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.ITALIC, BaseColor.BLACK); Font font4 = FontFactory.GetFont("Arial", 5, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); //String imageURL = @"D:\Smrutiranjan\PurchaseOrder\index.jpg"; //iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageURL); String URL = "Cellcomm2.JPG"; iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(URL); img.Alignment = Element.ALIGN_LEFT; //-- PdfPTable tableHeader = new PdfPTable(2); tableHeader.WidthPercentage = 100; PdfPCell cellImg = new PdfPCell(); Paragraph pp = new Paragraph(); pp.Add(new Chunk(img, 0, 0)); cellImg.AddElement(pp); cellImg.Border = 0; tableHeader.AddCell(cellImg); PdfPCell cellAdd = new PdfPCell(); Paragraph ourAddr = new Paragraph(""); CompanyDetailDB compDB = new CompanyDetailDB(); cmpnydetails det = compDB.getdetails().FirstOrDefault(comp => comp.companyID == 1); if (det != null) { ourAddr.Add(new Chunk(det.companyname + "\n", font2)); ourAddr.Add(new Chunk(det.companyAddress.Replace("\r\n", "\n"), font4)); StringBuilder sb = new StringBuilder(); sb.Append("\nGST : " + companyInfo["GST"] + "\nState Code for GST : " + companyInfo["StateCode"] + "\nCIN : " + companyInfo["CIN"] + "\nPAN : " + companyInfo["PAN"]); ourAddr.Add(new Chunk(sb.ToString(), font4)); ourAddr.Alignment = Element.ALIGN_RIGHT; ourAddr.SetLeading(0.0f, 1.5f); } cellAdd.AddElement(ourAddr); cellAdd.Border = 0; tableHeader.AddCell(cellAdd); //---- Paragraph paragraphDocumentName = new Paragraph(new Phrase("PURCHASE ORDER", font2)); paragraphDocumentName.Alignment = Element.ALIGN_CENTER; Paragraph paragraphOpenCluse = new Paragraph(new Phrase(declaration, font1)); paragraphOpenCluse.Alignment = Element.ALIGN_JUSTIFIED; paragraphDocumentName.SpacingAfter = 15; //PrintPurchaseOrder prog = new PrintPurchaseOrder(); string[] HeaderStr = HeaderString.Split(Main.delimiter2); PdfPTable TableAddress = new PdfPTable(6); TableAddress.SpacingBefore = 20f; TableAddress.WidthPercentage = 100; float[] HWidths = new float[] { 0.5f, 4.5f, 2f, 2f, 2f, 3f }; TableAddress.SetWidths(HWidths); PdfPCell cell; float wid = 0; for (int i = 0; i < HeaderStr.Length; i++) { if (i == 0 || i == 4) { string[] format = HeaderStr[i].Split(Main.delimiter1); Phrase phr = new Phrase(); phr.Add(new Chunk(format[0], font2)); phr.Add(new Chunk(format[1], font1)); cell = new PdfPCell(phr); cell.Colspan = 3; if (i == 0) { cell.Rowspan = 3; } else { cell.Rowspan = 2; } cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right TableAddress.AddCell(cell); } else { cell = new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1)); cell.Colspan = 3; cell.MinimumHeight = wid; TableAddress.AddCell(cell); } } string[] ColHeaderStr = ColHeader.Split(';'); PdfPTable TableItemDetails = new PdfPTable(6); TableItemDetails.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetails.WidthPercentage = 100; float[] width = new float[] { 0.5f, 4.5f, 2f, 2f, 2f, 3f }; TableItemDetails.SetWidths(width); for (int i = 0; i < ColHeaderStr.Length; i++) { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim(), font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetails.AddCell(hcell); } //--- PdfPCell foot = new PdfPCell(new Phrase("")); foot.Colspan = 6; foot.BorderWidthTop = 0; foot.MinimumHeight = 0.5f; TableItemDetails.AddCell(foot); TableItemDetails.HeaderRows = 2; TableItemDetails.FooterRows = 1; TableItemDetails.SkipFirstHeader = false; TableItemDetails.SkipLastFooter = true; //--- int track = 0; decimal dc1 = 0; decimal dc2 = 0; string[] DetailStr = ColDetailString.Split(Main.delimiter2); float hg = 0f; for (int i = 0; i < DetailStr.Length; i++) { hg = TableItemDetails.GetRowHeight(i + 1); string[] str = DetailStr[i].Split(Main.delimiter1); for (int j = 0; j < str.Length; j++) { PdfPCell pcell; if (j == 3 || j == 4 || j == 5) { decimal p = 1; if (Decimal.TryParse(str[j], out p)) { pcell = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(str[j])), font1)); } else { pcell = new PdfPCell(new Phrase("")); } pcell.Border = 0; if (j == 5) { if (str[0].Length == 0) { pcell.BorderWidthBottom = 0.01f; track = 1; dc2 = Convert.ToDecimal(str[j]); } else { dc1 = Convert.ToDecimal(str[j]); } } } else { pcell = new PdfPCell(new Phrase(str[j], font1)); pcell.Border = 0; } pcell.MinimumHeight = 10; pcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; pcell.BorderWidthLeft = 0.01f; pcell.BorderWidthRight = 0.01f; TableItemDetails.AddCell(pcell); } } double roundedAmt = Math.Round(totAmnt, 0); double diffAmount = roundedAmt - totAmnt; if (diffAmount != 0) { TableItemDetails.AddCell(""); TableItemDetails.AddCell(""); PdfPCell cellTot = new PdfPCell(new Phrase("", font1)); cellTot.Colspan = 3; cellTot.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetails.AddCell(cellTot); TableItemDetails.AddCell(new Phrase(String.Format("{0:0.00}", totAmnt), font2)); TableItemDetails.AddCell(""); TableItemDetails.AddCell(""); PdfPCell cellRound = new PdfPCell(new Phrase("Rounding off", font1)); cellRound.Colspan = 3; cellRound.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetails.AddCell(cellRound); TableItemDetails.AddCell(new Phrase(String.Format("{0:0.00}", diffAmount), font1)); } TableItemDetails.AddCell(""); TableItemDetails.AddCell(""); PdfPCell cellTotal = new PdfPCell(new Phrase("Total", font1)); cellTotal.Colspan = 3; cellTotal.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetails.AddCell(cellTotal); TableItemDetails.AddCell(new Phrase(String.Format("{0:0.00}", roundedAmt), font2)); //----- string total = footer1 + NumberToString.convert(roundedAmt.ToString()); PdfPCell fcell1 = new PdfPCell(new Phrase((total), font3)); fcell1.Colspan = 6; fcell1.MinimumHeight = 50; fcell1.HorizontalAlignment = PdfPCell.ALIGN_LEFT; //fcell1.BorderWidthBottom = 0; TableItemDetails.AddCell(fcell1); PdfPTable tableSub = new PdfPTable(1); tableSub.DefaultCell.Border = 0; tableSub.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; tableSub.AddCell(new Phrase("Subject To Bangalore Jurisdiction", font2)); PdfPCell celSub = new PdfPCell(tableSub); celSub.Border = 0; celSub.Colspan = 6; TableItemDetails.AddCell(celSub); TableItemDetails.KeepRowsTogether(TableItemDetails.Rows.Count - 5, TableItemDetails.Rows.Count); Paragraph footer = new Paragraph(new Phrase("Note : " + footer2, font3)); footer.Alignment = Element.ALIGN_LEFT; //-------------------- PdfPTable TCTab = new PdfPTable(2); if (woh.TermsAndCond.Trim().Length != 0) { Chunk TCchunk = new Chunk("General Terms & Conditions\n", font2); TCchunk.SetUnderline(0.2f, -2f); TCTab = new PdfPTable(2); TCTab.WidthPercentage = 100; PdfPCell TCCell = new PdfPCell(); TCCell.Colspan = 2; TCCell.Border = 0; TCCell.AddElement(TCchunk); TCTab.AddCell(TCCell); try { string[] ParaTC = termsAndCond.Split(Main.delimiter2); for (int i = 0; i < ParaTC.Length + 1; i++) { TCCell = new PdfPCell(); TCCell.Colspan = 2; TCCell.Border = 0; Paragraph header = new Paragraph(); Paragraph details = new Paragraph(); details.IndentationLeft = 12f; details.IndentationRight = 12f; details.Alignment = Element.ALIGN_JUSTIFIED; string paraHeaderStr = (i + 1) + ". " + ParaTC[i].Substring(0, ParaTC[i].IndexOf(Main.delimiter1)) + ":"; string paraFooterStr = ParaTC[i].Substring(ParaTC[i].IndexOf(Main.delimiter1) + 1); header.Add(new Phrase(paraHeaderStr, font2)); details.Add(new Phrase(paraFooterStr, font1)); TCCell.AddElement(header); TCCell.AddElement(details); TCTab.AddCell(TCCell); } } catch (Exception ex) { ////MessageBox.Show("Failed to Save 2 : "+ex.ToString()); } try { TCTab.KeepRowsTogether(0, 3); } catch (Exception ex) { MessageBox.Show("Failed to Save 3 : " + ex.ToString()); } } doc.Add(tableHeader); doc.Add(paragraphDocumentName); doc.Add(paragraphOpenCluse); doc.Add(TableAddress); doc.Add(TableItemDetails); doc.Add(footer); if (woh.TermsAndCond.Length != 0) { doc.Add(TCTab); } doc.Close(); if (woh.Status == 0 && woh.DocumentStatus < 99) { String wmurl = ""; wmurl = "004.png"; PrintWaterMark.PdfStampWithNewFile(wmurl, sfd.FileName); } MessageBox.Show("Document Saved"); } catch (Exception ex) { MessageBox.Show("Failed to Save 4 : " + ex.ToString()); } }
public static int AddCustomer(Customer data) { return(CustomerDB.Add(data)); }
protected void BtnSubmit_Click(object sender, EventArgs e) { //take the answers and check if correct. //if so, set the third panel visible to display the password. //in real cases, the password should be sent to the user email. // Pnl3.Visible = true; //Pnl2.Visible = true; //get the security answers, verify if correct. try { cs = WebConfigurationManager.ConnectionStrings["localConnection"].ConnectionString; con = new SqlConnection(cs); //get a list of security questions from the user SqlCommand cmd = new SqlCommand("select sa1 from vw_customerSq1 where email = '" + uname + "'", con); con.Open(); // LblPwd.Text = "where1"; SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow); //LblSq1.Text = reader["question"]; reader.Read(); //LblPwd.Text = "where2"; //LblSq1.Text = reader.GetValue(0).ToString(); string sa1 = reader.GetValue(0).ToString(); //string sa1 = ""; //LblPwd.Text = reader.GetValue(0).ToString(); //LblPwd.Text = "where3"; reader.Close(); cmd = new SqlCommand("select sa2 from vw_customerSq2 where email = '" + uname + "'", con); reader = cmd.ExecuteReader(CommandBehavior.SingleRow); reader.Read(); string sa2 = reader.GetValue(0).ToString(); reader.Close(); con.Close(); if ((TxtAns1.Text == sa1) && (TxtAns2.Text == sa2)) { //get the password Pnl2.Visible = false; //LblPwd.Text = "Your password is: " + CustomerDB.GetPwd(uname); string msg = "<a href=\"http://www.cs.iupui.edu\">Your password </a> is " + CustomerDB.GetPwd(uname); if (EmailPwd("*****@*****.**", uname, "Password Recovery", msg)) { LblMsg.Text = "The password has been sent to your email account. "; } else { LblMsg.Text = "There is an error sending the password. Please try again later."; } } else { //send message LblPwd.Text = "in correct answer"; //Pnl2.Visible = false; //Pnl3.Visible = true; LblMsg2.Text = "Information you entered is incorrect. Please try again."; } } catch (Exception err) { // LblMsg.Text = "Cannot submit information now. Please try again later."; } finally //must make sure the connection is properly closed { //the finally block will always run whether there is an error or not con.Close(); } }
public static int DeleteCustomers(string[] CustomerIDs) { return(CustomerDB.Delete(CustomerIDs)); }
//this function will pull a list of transactions from this user //three sql clauses must be sent as they are used because order by cannot be used in the count(*) statement protected void DisplayTransaction(string headSql, string whereSql, string orderSql) { //headSql is "select ID, name, itemNumber, type, model, stockAmount, stockDate, cost, price, description from vw_instruInfo "; //whereSql defines the where clause int count = 0; count = CustomerDB.GetOneInt("select count(*) from vw_instruInfo " + whereSql); //LblMsg.Text = "select count(*) from vw_instruInfo " + whereSql + orderSql; if (count == 0) {//no transaction, create an empty row LblMsgNoResult.Text = "No Result is Found"; } else { ArrayList res = new ArrayList(); res = CustomerDB.GetRows(headSql + whereSql + orderSql); // LblMsg.Text = headSql + whereSql + orderSql; for (int j = 0; j < res.Count; j++) { //loop through each row to get the content and create a panel to add to the web page ArrayList oneRow = new ArrayList(); oneRow = (ArrayList)res[j]; Panel panel = new Panel(); //use unique IDs to dynamically create new web object to gurantee that each object has a unique ID panel.ID = "pnlResult" + oneRow[0].ToString(); Label lblName = new Label(); lblName.ID = "lblName" + oneRow[0].ToString(); lblName.Text = "Name:"; lblName.Height = 20; lblName.Font.Size = 13; lblName.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblName); Label lblNameValue = new Label(); lblNameValue.ID = "lblNameValue" + oneRow[0].ToString(); lblNameValue.Height = 18; lblNameValue.Font.Size = 12; lblNameValue.ForeColor = System.Drawing.Color.Black; lblNameValue.Text = oneRow[1].ToString(); panel.Controls.Add(lblNameValue); Label lblItemNumber = new Label(); lblItemNumber.ID = "lblItemNumber" + oneRow[0].ToString(); lblItemNumber.Text = "Item Number:"; lblItemNumber.Height = 20; lblItemNumber.Font.Size = 13; lblItemNumber.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblItemNumber); Label lblItemNumberValue = new Label(); lblItemNumberValue.ID = "lblItemNumberValue" + oneRow[0].ToString(); lblItemNumberValue.Height = 18; lblItemNumberValue.Font.Size = 12; lblItemNumberValue.ForeColor = System.Drawing.Color.Black; lblItemNumberValue.Text = oneRow[2].ToString(); panel.Controls.Add(lblItemNumberValue); Label lblType = new Label(); lblType.ID = "lblType" + oneRow[0].ToString(); lblType.Text = "Type:"; lblType.Height = 20; lblType.Font.Size = 13; lblType.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblType); Label lblTypeValue = new Label(); lblTypeValue.ID = "lblItemNumberValue" + oneRow[0].ToString(); lblTypeValue.Height = 18; lblTypeValue.Font.Size = 12; lblTypeValue.ForeColor = System.Drawing.Color.Black; lblTypeValue.Text = oneRow[3].ToString(); panel.Controls.Add(lblTypeValue); Label lblModel = new Label(); lblModel.ID = "lblModel" + oneRow[0].ToString(); lblModel.Text = "Model:"; lblModel.Height = 20; lblModel.Font.Size = 13; lblModel.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblModel); Label lblModelValue = new Label(); lblModelValue.ID = "lblModelValue" + oneRow[0].ToString(); lblModelValue.Height = 18; lblModelValue.Font.Size = 12; lblModelValue.ForeColor = System.Drawing.Color.Black; lblModelValue.Text = oneRow[4].ToString(); panel.Controls.Add(lblModelValue); Label lblPrice = new Label(); lblPrice.ID = "lblPrice" + oneRow[0].ToString(); lblPrice.Text = "Price:"; lblPrice.Height = 20; lblPrice.Font.Size = 13; lblPrice.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblPrice); Label lblPriceValue = new Label(); lblPriceValue.ID = "lblPriceValue" + oneRow[0].ToString(); lblPriceValue.Height = 18; lblPriceValue.Font.Size = 12; lblPriceValue.ForeColor = System.Drawing.Color.Black; lblPriceValue.Text = oneRow[8].ToString(); panel.Controls.Add(lblPriceValue); Label lblDescription = new Label(); lblDescription.ID = "lblDescription" + oneRow[0].ToString(); lblDescription.Text = "Description:"; lblDescription.Height = 20; lblDescription.Font.Size = 13; lblDescription.ForeColor = System.Drawing.Color.Red; panel.Controls.Add(lblDescription); Label lblDescriptionValue = new Label(); lblDescriptionValue.ID = "lblDescriptionValue" + oneRow[0].ToString(); lblDescriptionValue.Height = 18; lblDescriptionValue.Font.Size = 12; lblDescriptionValue.ForeColor = System.Drawing.Color.Black; lblDescriptionValue.Text = oneRow[9].ToString(); panel.Controls.Add(lblDescriptionValue); panel.BorderWidth = Unit.Pixel(5); PnlTrans.Controls.Add(panel); } } }
public CreateACustomer(string name, string address, string[] paymentDetails) { CustDB = new CustomerDB(); }
//make a transaction private void ConfirmButton_Click(object sender, EventArgs e) { UpdateTempData(); Checking tempCheckAccount = new Checking(); Saving tempSavAccount = new Saving(); double amount; Transaction aTransac = new Transaction(); if (Double.TryParse(AmountTextBox.Text, out amount)) { if (amount > 0) { aTransac.Date = DateTime.Now; aTransac.Amount = Convert.ToDouble(AmountTextBox.Text); aTransac.AccNumber = Int32.Parse(AccNumTextBox.Text); aTransac.AccType = dictAccount[Int32.Parse(AccNumTextBox.Text)].Acctype; } else { MessageBox.Show("Amount must be a positive value!"); aTransac = null; } } else { MessageBox.Show("Invalid amount!"); } /* * if (aTransac.AccType == Account.EnumType.Checkings) * { * foreach (Checking current in aCustomer.customerAccount.Values) * { * tempCheckAccount = (Checking)current; * } * if (tempCheckAccount.Counter < tempCheckAccount.LimitTransac) * { * tempCheckAccount.Counter++; * } * else * { * aTransac = null; * MessageBox.Show("You have reached your transaction limit for this account"); * } * } * * if (aTransac.AccType == Account.EnumType.Savings) * { * foreach (Saving current in aCustomer.customerAccount.Values) * { * tempSavAccount = (Saving)current; * } * } */ if (!(checkBoxWithdraw.Checked || checkBoxDeposit.Checked)) { MessageBox.Show("Please Select a Transaction Type"); aTransac = null; } if (aTransac != null && (Double.TryParse(AmountTextBox.Text, out amount)))/////CHECAR REPETICAO AQUI! { if (checkBoxWithdraw.Checked) { aTransac.TransNumber = transacNum.NextValue(lastValueTransac); aTransac.TransType = Transaction.EnumType.Withdraw; dictAccount[Int32.Parse(AccNumTextBox.Text)].Balance -= aTransac.Amount; dictCustomer[Int32.Parse(code)].customerAccount[Int32.Parse(AccNumTextBox.Text)].Balance -= aTransac.Amount; } else if (checkBoxDeposit.Checked) { aTransac.TransNumber = transacNum.NextValue(lastValueTransac); aTransac.TransType = Transaction.EnumType.Deposit; dictAccount[Int32.Parse(AccNumTextBox.Text)].Balance += aTransac.Amount; dictCustomer[Int32.Parse(code)].customerAccount[Int32.Parse(AccNumTextBox.Text)].Balance += aTransac.Amount; } TransactionNumberTextBox.Text = Convert.ToString(aTransac.TransNumber); NewBalanceTextBox.Text = Convert.ToString(dictCustomer[Int32.Parse(code)].customerAccount[Int32.Parse(AccNumTextBox.Text)].Balance); sortedTransaction.Add(aTransac.TransNumber, aTransac); TransactionDB.SaveToFile(sortedTransaction); dictTransaction.Add(aTransac.TransNumber, aTransac); TransactionDB.SaveToFile(dictTransaction); dictAccount[Int32.Parse(AccNumTextBox.Text)].accTransactionDict.Add(aTransac.TransNumber, aTransac); AccountDB.SaveToFile(dictAccount); dictCustomer[Int32.Parse(code)].customerAccount[Int32.Parse(AccNumTextBox.Text)].accTransactionDict.Add(aTransac.TransNumber, aTransac); CustomerDB.SaveToFile(dictCustomer); DisplayTransacList(dictCustomer[Int32.Parse(code)].customerAccount[Int32.Parse(AccNumTextBox.Text)].accTransactionDict); Dictionary <int, Account> tempDictAccount = new Dictionary <int, Account>(); tempDictAccount = dictCustomer[Int32.Parse(code)].customerAccount; DisplayAccList(tempDictAccount);//ATUALIZAR lastValueTransac++; ConfirmButton.Enabled = false; } }
// just before form closes, save data private void kWLabelInd_FormClosing(object sender, FormClosingEventArgs e) { CustomerDB.SaveCustomers(customers); }
public CustomertsRigistrationController(CustomerDB context) { _context = context; }