public void loadProductRecords()
{
clsDBProductRecord dbProductRecord = new clsDBProductRecord();
List <clsProductRecord> productRecords = dbProductRecord.ProductRecordList();
Int32 Index = 0;
lstProductRecords.Items.Clear();
while (Index < productRecords.Count)
{
clsProductRecord productRecord = productRecords[Index];
ListViewItem NewItem = new ListViewItem();
NewItem.Text = productRecord.SerialNo_IMEI;
NewItem.SubItems.Add(productRecord.SupplierName);
NewItem.SubItems.Add(productRecord.DeviceModel);
NewItem.SubItems.Add("£" + productRecord.Price.ToString("F"));
NewItem.SubItems.Add(productRecord.DateBought.ToShortDateString());
NewItem.SubItems.Add(productRecord.Description);
NewItem.SubItems.Add(productRecord.Status);
NewItem.Tag = productRecord;
lstProductRecords.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lstProductRecords.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lstProductRecords.Items.Add(NewItem); //Add the item to ListView
Index++; //move the index to the next record
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (lstProductRecords.SelectedItems.Count > 0)
{
ListViewItem selectedItem = lstProductRecords.SelectedItems[0];
clsProductRecord productRecord = (clsProductRecord)selectedItem.Tag;
frmAddProductRecord showForm = new frmAddProductRecord(this, productRecord);
showForm.Show();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (isValid())
{
clsProductRecord productRecord = new clsProductRecord();
productRecord.SerialNo_IMEI = txtSerialNo_IMEI.Text;
clsDevice clsDevice = (clsDevice)cmbDeviceName.SelectedItem;
if (clsDevice != null)
{
productRecord.DeviceId = clsDevice.ID;
}
clsSupplier clsSupplier = (clsSupplier)cmbSupplierName.SelectedItem;
if (clsSupplier != null)
{
productRecord.SupplierId = clsSupplier.ID;
}
productRecord.Price = Convert.ToDecimal(txtPrice.Text);
productRecord.DateBought = dateTimePicker1.Value;
productRecord.Description = txtDescription.Text;
productRecord.Status = txtStatus.Text;
productRecord.Returned = chkReturned.Checked;
clsDBProductRecord fbs = new clsDBProductRecord();
Int32 added = 0;
if (txtID.Text.Length > 0)
{
productRecord.ID = Convert.ToInt32(txtID.Text);
added = fbs.UpdateProductRecord(productRecord);
}
else
{
added = fbs.InsertProductRecord(productRecord);
}
if (added > 0)
{
frmListProductRecord.loadProductRecords();
Close();
}
else
{
txtErrorMessage.Text = "Could not added ProductRecord.";
txtErrorMessage.Visible = true;
}
}
else
{
txtErrorMessage.Text = "Specify valid values";
txtErrorMessage.Visible = true;
}
}
public void TestProperties()
{
clsProductRecord pr = new clsProductRecord();
Int32 id = 1;
pr.ID = id;
Assert.AreEqual(pr.ID, id);
string serialNo_IMEI = "12345678910112";
pr.SerialNo_IMEI = serialNo_IMEI;
Assert.AreEqual(pr.SerialNo_IMEI, serialNo_IMEI);
Int32 supplierID = 2;
pr.SupplierId = supplierID;
Assert.AreEqual(pr.SupplierId, supplierID);
string supplierName = "Cosco";
pr.SupplierName = supplierName;
Assert.AreEqual(pr.SupplierName, supplierName);
Int32 deviceId = 3;
pr.DeviceId = deviceId;
Assert.AreEqual(pr.DeviceId, deviceId);
string deviceModel = "Samsung";
pr.DeviceModel = deviceModel;
Assert.AreEqual(pr.DeviceModel, deviceModel);
decimal price = 15;
pr.Price = price;
Assert.AreEqual(pr.Price, price);
string description = "Asdgdg";
pr.Description = description;
Assert.AreEqual(pr.Description, description);
string status = "Basfa";
pr.Status = status;
Assert.AreEqual(pr.Status, status);
Boolean returned = true;
pr.Returned = returned;
Assert.AreEqual(pr.Returned, returned);
}
public Int32 InsertProductRecord(clsProductRecord productRecord)
{
//add the parameters
db.AddParameter("@SerialNo_IMEI", productRecord.SerialNo_IMEI);
db.AddParameter("@SupplierId", productRecord.SupplierId);
db.AddParameter("@DeviceId", productRecord.DeviceId);
db.AddParameter("@Price", productRecord.Price);
db.AddParameter("@DateBought", productRecord.DateBought);
db.AddParameter("@Description", productRecord.Description);
//db.AddParameter("@Status", productRecord.Status);
db.AddParameter("@Returned", productRecord.Returned);
//execute the stored procedure returning the primary key value of the new record
return(db.Execute("sproc_tblProductRecord_Insert"));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstProductRecords.SelectedItems.Count > 0)
{
ListViewItem selectedItem = lstProductRecords.SelectedItems[0];
clsProductRecord productRecord = (clsProductRecord)selectedItem.Tag;
// Display a message box asking users if they
// want to delete the selected ProductRecord.
if (MessageBox.Show("Are you sure to Delete this ProductRecord ", "Delete ProductRecord",
MessageBoxButtons.YesNo, MessageBoxIcon.Question)
== DialogResult.Yes)
{
// code for deleting the record goes here
clsDBProductRecord dbProductRecord = new clsDBProductRecord();
dbProductRecord.DeleteProductRecord(productRecord.ID);
loadProductRecords();
}
}
}
public void loadSuppliers(clsProductRecord productRecord)
{
clsDBSupplier dbSupplier = new clsDBSupplier();
List <clsSupplier> suppliers = dbSupplier.SupplierList();
Int32 Index = 0;
cmbSupplierName.DisplayMember = "Name";
cmbSupplierName.ValueMember = "ID";
cmbSupplierName.Items.Clear();
while (Index < suppliers.Count)
{
clsSupplier supplier = suppliers[Index];
cmbSupplierName.Items.Add(supplier); //add the supplier to the list
if (productRecord != null && (productRecord.SupplierId == supplier.ID))
{
cmbSupplierName.SelectedItem = supplier;
}
Index++; //move the index to the next record
}
}
public void loadDevices(clsProductRecord productRecord)
{
clsDBDevice dbDevice = new clsDBDevice();
List <clsDevice> devices = dbDevice.DeviceList();
Int32 Index = 0;
cmbDeviceName.DisplayMember = "Model";
cmbDeviceName.ValueMember = "ID";
while (Index < devices.Count)
{
clsDevice device = devices[Index];
cmbDeviceName.Items.Add(device);
if (productRecord != null && (productRecord.DeviceId == device.ID))
{
cmbDeviceName.SelectedItem = device;
}
Index++; //move the index to the next record
}
}
public frmAddProductRecord(frmProductRecords frmSup, clsProductRecord productRecord)
{
InitializeComponent();
frmListProductRecord = frmSup;
if (productRecord != null)
{
txtID.Text = Convert.ToString(productRecord.ID);
txtSerialNo_IMEI.Text = productRecord.SerialNo_IMEI;
cmbSupplierName.SelectedItem = productRecord.SupplierId;
cmbDeviceName.SelectedItem = productRecord.DeviceId;
txtPrice.Text = productRecord.Price.ToString("F");
dateTimePicker1.Value = productRecord.DateBought;
txtDescription.Text = productRecord.Description;
txtStatus.Text = productRecord.Status;
chkReturned.Checked = productRecord.Returned;
btnAdd.Text = "Edit";
}
loadDevices(productRecord);
loadSuppliers(productRecord);
}
public List <clsProductRecord> ProductRecordList()
{
//create an array list of type lstProductRecords
List <clsProductRecord> lstProductRecords = new List <clsProductRecord>();
//var to store the count of records
Int32 RecordCount;
//var to store the index for the loop
Int32 Index = 0;
//get the count of records
db.Execute("sproc_tblProductRecord_SelectAll");
RecordCount = db.Count;
//keep looking till all records are processed
while (Index < RecordCount)
{
//create a blank productRecord
clsProductRecord productRecord = new clsProductRecord();
//copy the data from the table to the RAM
productRecord.ID = Convert.ToInt32(db.DataTable.Rows[Index]["ProductId"]);
productRecord.SerialNo_IMEI = Convert.ToString(db.DataTable.Rows[Index]["SerialNo_IMEI"]);
productRecord.SupplierId = Convert.ToInt32(db.DataTable.Rows[Index]["SupplierId"]);
productRecord.SupplierName = Convert.ToString(db.DataTable.Rows[Index]["SupplierName"]);
productRecord.DeviceId = Convert.ToInt32(db.DataTable.Rows[Index]["DeviceId"]);
productRecord.DeviceModel = Convert.ToString(db.DataTable.Rows[Index]["Model"]);
productRecord.Price = Convert.ToDecimal(db.DataTable.Rows[Index]["Price"]);
productRecord.DateBought = Convert.ToDateTime(db.DataTable.Rows[Index]["DateBought"]);
productRecord.Description = Convert.ToString(db.DataTable.Rows[Index]["Description"]);
productRecord.Status = Convert.ToString(db.DataTable.Rows[Index]["Status"]);
productRecord.Returned = Convert.ToBoolean(db.DataTable.Rows[Index]["Returned"]);
//add the blank page to the array list
lstProductRecords.Add(productRecord);
//increase the index
Index++;
}
//return the list as the return value of the function
return(lstProductRecords);
}
public void InstanceOK()
{
clsProductRecord pr = new clsProductRecord();
Assert.IsNotNull(pr);
}
