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);
}
