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