static void Main(string[] args) { // Initialize variables InvoiceClass invoice = new InvoiceClass("A101-01", "Hammer", 2, 9.99M); // Display invoice values Console.WriteLine("Values of invoice"); DisplayInvoice(invoice); // Modify invoice invoice.Quantity = 1; // Display invoice values again Console.WriteLine("Change quantity to 1"); DisplayInvoice(invoice); // Modify invoice with an invalid quantity invoice.Quantity = -1; // Display invoice values again Console.WriteLine("Change quantity to -1"); DisplayInvoice(invoice); //Freeze console window Console.ReadLine(); }
private void BindAllInvoice() { invObj = new InvoiceClass(); DataTable dtInv = invObj.GetAllInvoiceDetails(); rptInvoiceView.DataSource = dtInv.Rows.Count > 0 ? dtInv : null; rptInvoiceView.DataBind(); }
private void FillListUnpaidInvoices() { InvoiceClass FillUnpaidList = new InvoiceClass(); for (int iCountUnpaidInvoices = 0; iCountUnpaidInvoices < FillUnpaidList.lstUnpaid.Count(); iCountUnpaidInvoices++) { lstvUnpaidInvoices.Items.Add(FillUnpaidList.lstUnpaid[iCountUnpaidInvoices]); } }
private void FillListUnsendInvoices() { InvoiceClass FillUnsendList = new InvoiceClass(); for (int iCountUnsendWeeks = 0; iCountUnsendWeeks < FillUnsendList.lstUnsend.Count(); iCountUnsendWeeks++) { lstvUnsendInvoices.Items.Add(FillUnsendList.lstUnsend[iCountUnsendWeeks]); } }
// Display Invoice class variables public static void DisplayInvoice(InvoiceClass i) { string formatA = "{0, -20}{1, 12}"; string formatB = "{0, -20}{1, 12:C}"; Console.WriteLine(formatA, "Part Number:", i.PartNumber); Console.WriteLine(formatA, "Part Description:", i.PartDescription); Console.WriteLine(formatA, "Quantity:", i.Quantity); Console.WriteLine(formatB, "Price Per Item:", i.PricePerItem); Console.WriteLine(formatB, "Invoice Amount:", i.GetInvoiceAmount()); Console.WriteLine(); }
public ActionResult Create(InvoiceClass invoiceclass) { if (ModelState.IsValid) { invoiceclass.id = Guid.NewGuid(); db.InvoiceClasses.Add(invoiceclass); db.SaveChanges(); return RedirectToAction("Index"); } return View(invoiceclass); }
protected void lbEdit_Click(object sender, EventArgs e) { try { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(((LinkButton)sender).CommandArgument); Response.Redirect("~/Windows/Default.aspx?uc=11&iid=" + invObj.invId); } catch (Exception ex) { ex.Message.ToString(); } }
private void BindQuotationNos() { invObj = new InvoiceClass(); DataTable dtQuot = invObj.GetQuotationNoForInvoice(); if (dtQuot.Rows.Count > 0) { ddlQuotationNumber.DataSource = dtQuot; ddlQuotationNumber.DataValueField = "quotNo"; ddlQuotationNumber.DataTextField = "QquotNo"; ddlQuotationNumber.DataBind(); } ddlQuotationNumber.Items.Insert(0, new ListItem("-- Quotation No --", "0")); }
public int UpdateInvoice(string _invoice) { invObj = new InvoiceClass(); invoiceArray inv = JsonConvert.DeserializeObject <invoiceArray>(_invoice); if (!ValidateInvoiceNo(inv.invoiceNo, inv.invId.ToString())) { invObj.invId = inv.invId; invObj.custId = inv.custId; invObj.custName = inv.custName; invObj.invoiceNo = inv.invoiceNo; invObj.invoiceDate = Convert.ToDateTime(inv.invoiceDate).ToString("yyyy-MM-dd"); invObj.amount = inv.amount; invObj.invUniqueNo = Convert.ToInt32(inv.invUniqueNo); if (invObj.UpdateInvoiceMaster()) { if (invObj.InvoiceDetailsDeleteByInvId()) { for (int i = 0; i < inv.invoiceDetailsArray.Count; i++) { invObj.prodId = inv.invoiceDetailsArray[i].prodId; invObj.prodDescription = inv.invoiceDetailsArray[i].product; invObj.qty = inv.invoiceDetailsArray[i].qty; invObj.prodPrice = inv.invoiceDetailsArray[i].unitPrice; invObj.totalPrice = inv.invoiceDetailsArray[i].totalPrice; invObj.SaveInvoiceDetails(); } } invObj.totalExVat = inv.totExVat; invObj.vatPer = inv.vatPer; invObj.vatAmt = inv.vatAmt; invObj.totalInTax = inv.totInVat; invObj.termsAndConditions = inv.termsAndConditions; invObj.UpdateinvoicePaymentDetails(); return(invObj.invId); } else { return(0); } } else { return(0); } }
public void GetOpenInvoiceNos() { invObj = new InvoiceClass(); DataTable dtInv = invObj.GetOpenInvoiceNos(); if (dtInv.Rows.Count > 0) { ddlPendingInvoiceNumber.DataSource = dtInv; ddlPendingInvoiceNumber.DataValueField = "invIdUniqueNo"; ddlPendingInvoiceNumber.DataTextField = "invoiceNo"; ddlPendingInvoiceNumber.DataBind(); ddlPendingInvoiceNumber.Items.Insert(0, new ListItem("-- Select Invoice No --", "0")); } else { ddlPendingInvoiceNumber.Items.Insert(0, new ListItem("-- No Pending Invoice --", "0")); } }
public string EditInvoice(string _invId) { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(_invId); DataSet dsInv = invObj.GetInvoiceDetailsByInvId(); if (dsInv.Tables[0].Rows.Count > 0) { dsInv.Tables[1].Columns["prodDescription"].ColumnName = "product"; dsInv.Tables[1].Columns["prodPrice"].ColumnName = "unitPrice"; dsInv.Tables[1].Columns.Add("arrId"); string json = JsonConvert.SerializeObject(dsInv, Newtonsoft.Json.Formatting.Indented); return(json); } else { return(""); } }
protected void lbDelete_Click(object sender, EventArgs e) { try { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(((LinkButton)sender).CommandArgument); if (invObj.DeleteInvoiceByInvId()) { BindAllInvoice(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "successfull('Invoice Deleted Successfully.','')", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "failed('Failed to Delete Invoice.','')", true); } } catch (Exception ex) { ex.Message.ToString(); } }
public bool ValidateInvoiceNo(string _invoiceNo, string _invId) { if (!string.IsNullOrEmpty(_invoiceNo)) { invObj = new InvoiceClass(); invObj.invoiceNo = _invoiceNo; invObj.invId = Convert.ToInt32(_invId); if (invObj.ValidateInvoiceNo()) { return(true); } else { return(false); } } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["invId"])) { invObj = new InvoiceClass(); invObj.invId = Convert.ToInt32(Request.QueryString["invId"]); DataSet dsInv = invObj.GetInvoiceDetailsByInvId(); if (dsInv.Tables[0].Rows.Count > 0) { lblCustomerName.Text = dsInv.Tables[0].Rows[0]["custName"].ToString(); lblInvoiceNo.Text = dsInv.Tables[0].Rows[0]["invoiceNo"].ToString(); lblInvoiceDate.Text = Convert.ToDateTime(dsInv.Tables[0].Rows[0]["invoiceDate"].ToString()).ToString("dd-MM-yyyy"); rptInvoiceDetails.DataSource = dsInv.Tables[1]; rptInvoiceDetails.DataBind(); lblVat1.Text = lblVat2.Text = dsInv.Tables[2].Rows[0]["vatPer"].ToString(); lblAmtExVatSR.Text = dsInv.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[0]; lblAmtExVatH.Text = dsInv.Tables[2].Rows[0]["totalExVat"].ToString().Split('.')[1]; lblVatAmtSR.Text = dsInv.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[0]; lblVatAmtH.Text = dsInv.Tables[2].Rows[0]["vatAmt"].ToString().Split('.')[1]; lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(dsInv.Tables[2].Rows[0]["totalInTax"])); lblAmtInVatSR.Text = dsInv.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[0]; lblAmtInVatH.Text = dsInv.Tables[2].Rows[0]["totalInTax"].ToString().Split('.')[1]; lblTermsAndConditions.Text = dsInv.Tables[2].Rows[0]["termsAndContions"].ToString(); btnEdit.CommandArgument = Request.QueryString["invId"]; } } } } catch (Exception ex) { ex.Message.ToString(); } }
private void GetNextInvoiceNo() { invObj = new InvoiceClass(); txtInvoiceNo.Text = invObj.GetNextInvoiceNo(); }
public ActionResult Edit(InvoiceClass invoiceclass) { if (ModelState.IsValid) { db.Entry(invoiceclass).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(invoiceclass); }