public static int Insert(cInvoice inv)
{
List <ParamStruct> paramiters = new List <ParamStruct>();
if (inv.Equipment.Count != 0)
{
paramiters.Add(new ParamStruct("@invoiceId", 0, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Output));
paramiters.Add(new ParamStruct("@tax", inv.Tax, System.Data.DbType.Decimal, 4, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@total", inv.Total, System.Data.DbType.Decimal, 4, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@subtotal", inv.Subtotal, System.Data.DbType.Decimal, 4, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@date", DateTime.Today, System.Data.DbType.Date, 4, System.Data.ParameterDirection.Input));
DAL.DAL.SendData("insertInvoicwData", paramiters);
inv.InvioceNum = Convert.ToInt32(paramiters[0].paramValue);
paramiters.Clear();
}
for (int i = 0; i < inv.Equipment.Count - 1; i++)
{
if (inv.Equipment.Count != 0)
{
paramiters.Add(new ParamStruct("@dateReturn", inv.Equipment[i].DateIn, System.Data.DbType.Date, 3, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@invoiceId", inv.InvioceNum, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@equipmentId", inv.Equipment[i].EquipId, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Input));
paramiters.Add(new ParamStruct("@customerId", inv.Customer.CustomerId, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Input));
DAL.DAL.SendData("InsertInvoiceDetail", paramiters);
}
cEquipmentSQL.Update(inv.Equipment[i]);
paramiters.Clear();
}
return(1);
}
private void dgvCurrentInvoices_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (invoiceList != null)
{
if (dgvCurrentInvoices.SelectedRows.Count > 0)
{
SelectedInvoice = invoiceList[e.RowIndex];
FillInvoiceFields();
Equipmentlist = new BindingList <cEquipment>();
for (int i = 0; i < SelectedInvoice.Equipment.Count; i++)
{
Equipmentlist.Add(SelectedInvoice.Equipment[i]);
}
dgvEquipList.DataSource = Equipmentlist;
dgvEquipList.SelectedRows[0].Selected = false;
dgvEquipList.Columns[2].DefaultCellStyle.Format = "c2";
dgvEquipList.Columns[3].DefaultCellStyle.Format = "c2";
dgvEquipList.Columns[6].DefaultCellStyle.Format = "d";
dgvEquipList.Columns[7].DefaultCellStyle.Format = "d";
dgvEquipList.Columns[0].Visible = false;
dgvEquipList.Columns[5].Visible = false;
btnUpdate.Enabled = true;
}
}
}
public static EquipmentList Retrieve(cInvoice invoice)
{
EquipmentList list = new EquipmentList(invoice);
List <ParamStruct> paramiters = new List <ParamStruct>();
paramiters.Add(new ParamStruct("@invoiceId", invoice.InvioceNum, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Input));
DbDataReader reader = DAL.DAL.ReadData("retrieveInvoiceData", paramiters);
while (reader.Read())
{
cEquipment equip = cEquipmentSQL.RetrieveEquipment(Convert.ToInt32(reader["equipmentId"]));
list.AddEquipment(equip);
}
return(list);
}
public static BindingList <cInvoice> Retrieve(decimal taxAmount, int customerID)
{
BindingList <cInvoice> invoices = new BindingList <cInvoice>();
List <ParamStruct> paramiters = new List <ParamStruct>();
paramiters.Add(new ParamStruct("@customerId", customerID, System.Data.DbType.Int32, 4, System.Data.ParameterDirection.Input));
DbDataReader reader = DAL.DAL.ReadData("retrieveInvoiceData", paramiters);
//EquipmentList equip = new EquipmentList();
while (reader.Read())
{
cInvoice inv = cInvoice.Create(taxAmount);
inv.ReturnDate = DateTime.Today;
inv.InvioceNum = Convert.ToInt32(reader["invoiceId"]);
inv.Customer = cCustomerSQL.RetrieveData(retrieveCustomerData.getCustomerById, (Convert.ToInt32(reader["customerId"])));
inv.Equipment = EquipmentListSQl.Retrieve(inv);
}
reader.Close();
return(invoices);
// paramiters.Add(new ParamStruct("@invoiceId",
}
public frmRentals()
{
InitializeComponent();
SelectedCustomer = cCustomer.Create();
NewInvoice = cInvoice.Create(0.14M);
}
private void GetBlankInvoice()
{
NewInvoice = cInvoice.Create(0.14M);
}
//public static int Close()
//{ }
public static int Insert(cInvoice inv)
{
return(cInvoiceSQL.Insert(inv));
}
