private void btnSave_Click(object sender, EventArgs e)
{
switch (mode)
{
case DatabseMode.Update:
{
UpdateSelectedEquip();
GetSelected();
cEquipmentCU.Update(SelectedEquip);
break;
}
case DatabseMode.Insert:
{
grpItemDtls.Enabled = false;
EnableButtons(ButtonModes.RecordSelected);
cEquipment Equip = cEquipment.Create();
Equip.Serial = txtItemName.Text;
Equip.RentPrice = Convert.ToDecimal(txtRentPrice.Text);
Equip.ListPrice = Convert.ToDecimal(txtListValue.Text);
Equip.Status = (StatusTypes)cmbStatus.SelectedItem;
Equip.DateOut = dtpOut.Value;
Equip.DateIn = dtpReturn.Value;
Equip.Category = (EquipmentTypes)cmbDesc.SelectedValue;
cEquipmentCU.Insert(Equip);
break;
}
}
}
private void AddEquipment()
{
cEquipment selected = (cEquipment)lstAvailItems.SelectedItem;
selected.Status = Types.StatusTypes.Out;
Equipment.Add(selected);
NewInvoice.Equipment.AddEquipment(selected);
UpdateLabels();
equip.Remove(selected);
BindEquipmentList();
}
public static bool Update(cEquipment equipment)
{
if (cEquipmentSQL.Update(equipment) == 1)
{
return(true);
}
else
{
return(false);
}
}
public static bool Insert(cEquipment equip)
{
if (cEquipmentSQL.Insert(equip) == 1)
{
return(true);
}
else
{
return(false);
}
}
private bool IsInList(cEquipment e)
{
foreach (cEquipment equip1 in Equipment)
{
if (equip1.EquipId == e.EquipId)
{
return(true);
}
}
return(false);
}
public static int Insert(cEquipment Equip)
{
List <ParamStruct> paramiters = new List <ParamStruct>();
paramiters.Add(new ParamStruct("@serial", Equip.Serial, DbType.String, 20, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@rentPrice", Equip.RentPrice, DbType.Decimal, 4, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@listPrice", Equip.ListPrice, DbType.Decimal, 4, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@status", (int)Equip.Status, DbType.Int32, 4, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@dateOut", Equip.DateOut, DbType.DateTime, 8, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@In", Equip.DateIn, DbType.DateTime, 8, ParameterDirection.Input));
paramiters.Add(new ParamStruct("@category", (int)Equip.Category, DbType.Int32, 4, ParameterDirection.Input));
return(DAL.DAL.SendData("InsertEquipment", paramiters));
}
private void dgvEquipList_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
SelectedEquipment = Equipmentlist[e.RowIndex];
this.chkReturned.CheckedChanged -= new System.EventHandler(this.chkReturned_CheckedChanged);
if (SelectedEquipment.Status == StatusTypes.In)
{
chkReturned.Checked = true;
}
else
{
chkReturned.Checked = false;
}
this.chkReturned.CheckedChanged += new System.EventHandler(this.chkReturned_CheckedChanged);
FillEquipmentFields();
}
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);
}
private static List <cEquipment> Repackager(DbDataReader reader, retrieveEquipmentData type)
{
List <cEquipment> EquipList = new List <cEquipment>();
while (reader.Read())
{
cEquipment equip = cEquipment.Create();
equip.trustedSource = true;
switch (type)
{
case retrieveEquipmentData.getEquipmentIdSerial:
{
equip.EquipId = Convert.ToInt32(reader["equipmentId"]);
equip.Serial = reader["serial"].ToString();
break;
}
case retrieveEquipmentData.getEquipmentById:
case retrieveEquipmentData.getEquipmentByCategory:
case retrieveEquipmentData.getEquipmentDetail:
case retrieveEquipmentData.getEquipmentExcludNotAvail:
{
equip.EquipId = Convert.ToInt32(reader["equipmentId"]);
equip.Serial = reader["serial"].ToString();
equip.RentPrice = Convert.ToDecimal(reader["rentPrice"]);
equip.ListPrice = Convert.ToDecimal(reader["listPrice"]);
equip.Status = (StatusTypes)reader["availStatus"];
if (reader["dateOut"] != DBNull.Value)
{
equip.DateOut = Convert.ToDateTime(reader["dateOut"]);
}
if (reader["dateIn"] != DBNull.Value)
{
equip.DateIn = Convert.ToDateTime(reader["dateIn"]);
}
equip.Category = (EquipmentTypes)reader["category"];
break;
}
}
equip.trustedSource = false;
EquipList.Add(equip);
}
return(EquipList);
}
private void RemoveEquipment()
{
cEquipment selected = null;
foreach (cEquipment e in Equipment)
{
if (e.EquipId == Convert.ToInt32(dgvItemDetail.SelectedRows[0].Cells["EquipId"].Value))
{
selected = e;
break;
}
}
selected.Status = Types.StatusTypes.In;
Equipment.Remove(selected);
NewInvoice.Equipment.RemoveEquipment(selected);
UpdateLabels();
if (selected.Category == (EquipmentTypes)cmbItems.SelectedItem)
{
equip.Add(selected);
BindEquipmentList();
}
//lstAvailItems.Items.Add(dgvItemDetail.SelectedRow);
}