/// <summary>
/// Save a car based on inputs, proform validation check, then go back to cars page and get a list of cars
/// </summary>
protected void lbtnSaveCar_Click(object sender, EventArgs e)
{
if (Page.IsValid) // if any validation control failed, this will be false
{
// inserts data into database table
CarsBLL car = new CarsBLL();
car.Serial = int.Parse(lblSerial.Text);
car.CustomerName = "(Instock)";
car.Make = txtMake.Text;
car.Model = txtModel.Text;
car.Year = txtYear.Text;
car.Color = txtColor.Text;
car.PurchaseDate = lblPurchaseDate.Text;
car.PurchaseFrom = txtPurchasesName.Text;
car.PurchaseCost = decimal.Parse(txtPurchaseCost.Text);
car.ListPrice = decimal.Parse(txtPrice.Text);
if (bll.InsertCar(car))
{
Session["msg"] = "Car " + car.Serial + " added";
Response.Redirect("~/Cars.aspx");
}
}
else
{
lblMessage.Text = "Validation failed. Please try again";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
/// <summary>
/// Get a car by serial number, return a car object
/// </summary>
public CarsBLL GetCarBySerial(int serial)
{
// fetch a row from the database
int rowsFetched = adpCars.FillBySerial(tblCars, serial);
CarsBLL car = null;
if (rowsFetched == 1)
{
car = new CarsBLL();
var row = tblCars[0];
car.Serial = row.Serial;
car.CustomerName = row.CustomerName;
car.Make = row.Make;
car.Model = row.Model;
car.Year = row.Year;
car.Color = row.Color;
car.PurchaseDate = row.PurchaseDate;
car.PurchaseFrom = row.PurchaseFrom;
car.PurchaseCost = row.PurchaseCost;
car.ListPrice = row.ListPrice;
}
return(car);
}
// public methods
/// <summary>
/// Get all cars and return a car list to BLL from database
/// </summary>
public List <CarsBLL> GetAllCars()
{
adpCars.Fill(tblCars);
listCars = null;
// if table has rows
if (tblCars.Count > 0)
{
// instantiate the List<>
listCars = new List <CarsBLL>();
// loop through the table
foreach (var row in tblCars)
{
CarsBLL car = new CarsBLL();
// assign the values from row to Car Business object
car.Serial = row.Serial;
car.CustomerName = row.CustomerName;
car.Make = row.Make;
car.Model = row.Model;
car.Year = row.Year;
car.Color = row.Color;
car.PurchaseDate = row.PurchaseDate;
car.PurchaseFrom = row.PurchaseFrom;
car.PurchaseCost = row.PurchaseCost;
car.ListPrice = row.ListPrice;
listCars.Add(car);
}
}
return(listCars);
}
/// <summary>
/// Save a sales invoice based on inputs and update car's customer name, proform validation check, then go back to sales invoices page and get a list of sales invoices
/// </summary>
protected void lbtnSaveSalesInvoice_Click(object sender, EventArgs e)
{
if (Page.IsValid) // if any validation control failed, this will be false
{
SalesInvoicesBLL salesInvoice = new SalesInvoicesBLL();
salesInvoice.InvoiceId = int.Parse(lblSalesInvoiceId.Text);
salesInvoice.CustomerName = txtCustomerName.Text;
salesInvoice.Serial = int.Parse(txtSerial.Text);
salesInvoice.SalesDate = lblSalesDate.Text;
salesInvoice.Salesman = txtSalesman.Text;
salesInvoice.NetPrice = decimal.Parse(lblNetPrice.Text);
salesInvoice.Tax = decimal.Parse(lblTax.Text);
salesInvoice.TotalPrice = decimal.Parse(lblTotalPrice.Text);
int num = int.Parse(txtSerial.Text);
// get a car object by serial number and update car's customer name, then insert sals invoice into database
CarsBLL car = bllc.GetCarBySerial(num);
if (car != null)
{
car.CustomerName = txtCustomerName.Text;
try
{
if (blls.InsertSalesInvoice(salesInvoice))
{
car.UpdateCar(car);
Session["msg"] = "Sales Invoice " + salesInvoice.InvoiceId + " added";
Response.Redirect("~/SalesInvoices.aspx");
}
else
{
lblMessage.Text = "Validation failed. Please try again";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
else
{
lblMessage.Text = "Validation failed. Please try again";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
// constructor
public AddSalesInvoice()
{
blls = new SalesInvoicesBLL();
bllc = new CarsBLL();
}
/// <summary>
/// Update a car
/// </summary>
public bool UpdateCar(CarsBLL car)
{
return(carDAL.UpdateCar(car));
}
/// <summary>
/// Insert a car
/// </summary>
public bool InsertCar(CarsBLL car)
{
return(carDAL.InsertCar(car));
}
// constructor
public Cars()
{
bll = new CarsBLL();
}
// constructor
public AddCar()
{
bll = new CarsBLL();
}
/// <summary>
/// Insert a car into the database
/// </summary>
public bool InsertCar(CarsBLL car)
{
int result = adpCars.Insert(car.Serial, car.CustomerName, car.Make, car.Model, car.Year, car.Color, car.PurchaseDate, car.PurchaseFrom, car.PurchaseCost, car.ListPrice);
return(result == 1);
}