public void loadRepairs()
{
clsDBRepair dbRepair = new clsDBRepair();
List <clsRepair> repairs = dbRepair.RepairList();
Int32 Index = 0;
lstRepairJobs.Items.Clear();
while (Index < repairs.Count)
{
clsRepair repair = repairs[Index];
ListViewItem NewItem = new ListViewItem();
NewItem.Text = repair.CustomerName;
NewItem.SubItems.Add(repair.PhoneModel);
NewItem.SubItems.Add(repair.SerialNo_IMEI);
NewItem.SubItems.Add(repair.Fault);
NewItem.SubItems.Add("£" + repair.Balance.ToString("F"));
NewItem.SubItems.Add(repair.CollectionDate.ToShortDateString());
NewItem.Tag = repair;
lstRepairJobs.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lstRepairJobs.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lstRepairJobs.Items.Add(NewItem); //Add the item to ListView
Index++; //move the index to the next record
}
}
public void TestProperties()
{
clsRepair cr = new clsRepair();
Int32 id = 1;
cr.ID = id;
Assert.AreEqual(cr.ID, id);
string customerName = "Emma";
cr.CustomerName = customerName;
Assert.AreEqual(cr.CustomerName, customerName);
string customerPhoneNo = "07912546789";
cr.CustomerPhoneNo = customerPhoneNo;
Assert.AreEqual(cr.CustomerPhoneNo, customerPhoneNo);
string phoneModel = "Iphone7";
cr.PhoneModel = phoneModel;
Assert.AreEqual(cr.PhoneModel, phoneModel);
string serialNo_IMEI = "12345678910112";
cr.SerialNo_IMEI = serialNo_IMEI;
Assert.AreEqual(cr.SerialNo_IMEI, serialNo_IMEI);
string fault = "screen broken";
cr.Fault = fault;
Assert.AreEqual(cr.Fault, fault);
string password = "******";
cr.Password = password;
Assert.AreEqual(cr.Password, password);
decimal cost = 10;
cr.Cost = cost;
Assert.AreEqual(cr.Cost, cost);
decimal deposit = 5;
cr.Deposit = deposit;
Assert.AreEqual(cr.Deposit, deposit);
decimal balance = 5;
cr.Balance = balance;
Assert.AreEqual(cr.Balance, balance);
string comment = "Something";
cr.Comment = comment;
Assert.AreEqual(cr.Comment, comment);
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (lstRepairJobs.SelectedItems.Count > 0)
{
ListViewItem selectedItem = lstRepairJobs.SelectedItems[0];
clsRepair repair = (clsRepair)selectedItem.Tag;
frmAddRepairJob showForm = new frmAddRepairJob(this, repair);
showForm.Show();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (isValid())
{
clsRepair repair = new clsRepair();
repair.CustomerName = txtCustomerName.Text;
repair.CustomerPhoneNo = txtCustomerPhoneNo.Text;
repair.Date = dateTime.Value;
clsDevice clsDevice = (clsDevice)cmbPhoneModel.SelectedItem;
if (clsDevice != null)
{
repair.PhoneModel = clsDevice.Model.ToString();
}
repair.SerialNo_IMEI = txtSerialNo_IMEI.Text;
repair.Fault = txtFault.Text;
repair.Password = txtPassword.Text;
repair.Cost = Convert.ToDecimal(txtCost.Text);
repair.Deposit = Convert.ToDecimal(txtDeposit.Text);
repair.Balance = Convert.ToDecimal(txtBalance.Text);
repair.CollectionDate = dateTimePicker1.Value;
repair.Comment = txtComment.Text;
clsDBRepair fbs = new clsDBRepair();
Int32 added = 0;
if (txtID.Text.Length > 0)
{
repair.ID = Convert.ToInt32(txtID.Text);
added = fbs.UpdateRepair(repair);
}
else
{
added = fbs.InsertRepair(repair);
}
if (added > 0)
{
frmListRepair.loadRepairs();
Close();
}
else
{
txtErrorMessage.Text = "Could not added Repair.";
txtErrorMessage.Visible = true;
}
}
else
{
txtErrorMessage.Text = "Specify valid values";
txtErrorMessage.Visible = true;
}
}
public Int32 InsertRepair(clsRepair repair)
{
//add the parameters
db.AddParameter("@CustomerName", repair.CustomerName);
db.AddParameter("@CustomerPhoneNo", repair.CustomerPhoneNo);
db.AddParameter("@Date", repair.Date);
db.AddParameter("@PhoneModel", repair.PhoneModel);
db.AddParameter("@SerialNo_IMEI", repair.SerialNo_IMEI);
db.AddParameter("@Fault", repair.Fault);
db.AddParameter("@Password", repair.Password);
db.AddParameter("@Cost", repair.Cost);
db.AddParameter("@Deposit", repair.Deposit);
db.AddParameter("@Balance", repair.Balance);
db.AddParameter("@CollectionDate", repair.CollectionDate);
db.AddParameter("@Comment", repair.Comment);
//execute the stored procedure returning the primary key value of the new record
return(db.Execute("sproc_tblRepair_Insert"));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstRepairJobs.SelectedItems.Count > 0)
{
ListViewItem selectedItem = lstRepairJobs.SelectedItems[0];
clsRepair repair = (clsRepair)selectedItem.Tag;
// Display a message box asking users if they
// want to delete the selected Repair.
if (MessageBox.Show("Are you sure to Delete this RepairJob", "Delete Repair",
MessageBoxButtons.YesNo, MessageBoxIcon.Question)
== DialogResult.Yes)
{
// code for deleting the record goes here
clsDBRepair dbRepair = new clsDBRepair();
dbRepair.DeleteRepair(repair.ID);
loadRepairs();
}
}
}
public void loadDevices(clsRepair repair)
{
clsDBDevice dbDevice = new clsDBDevice();
List <clsDevice> devices = dbDevice.DeviceList();
Int32 Index = 0;
cmbPhoneModel.DisplayMember = "Model";
cmbPhoneModel.ValueMember = "ID";
while (Index < devices.Count)
{
clsDevice device = devices[Index];
cmbPhoneModel.Items.Add(device);
if (repair != null && (repair.PhoneModel == device.Model.ToString()))
{
cmbPhoneModel.SelectedItem = device;
}
Index++; //move the index to the next record
}
}
public List <clsRepair> RepairList()
{
//create an array list of type lstRepairs
List <clsRepair> lstRepairs = new List <clsRepair>();
//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_tblRepair_SelectAll");
RecordCount = db.Count;
//keep looking till all records are processed
while (Index < RecordCount)
{
//create a blank repair
clsRepair repair = new clsRepair();
//copy the data from the table to the RAM
repair.ID = Convert.ToInt32(db.DataTable.Rows[Index]["RepairID"]);
repair.CustomerName = Convert.ToString(db.DataTable.Rows[Index]["CustomerName"]);
repair.CustomerPhoneNo = Convert.ToString(db.DataTable.Rows[Index]["CustomerPhoneNo"]);
repair.Date = Convert.ToDateTime(db.DataTable.Rows[Index]["Date"]);
repair.PhoneModel = Convert.ToString(db.DataTable.Rows[Index]["PhoneModel"]);
repair.SerialNo_IMEI = Convert.ToString(db.DataTable.Rows[Index]["SerialNo_IMEI"]);
repair.Fault = Convert.ToString(db.DataTable.Rows[Index]["Fault"]);
repair.Password = Convert.ToString(db.DataTable.Rows[Index]["Password"]);
repair.Cost = Convert.ToDecimal(db.DataTable.Rows[Index]["Cost"]);
repair.Deposit = Convert.ToDecimal(db.DataTable.Rows[Index]["Deposit"]);
repair.Balance = Convert.ToDecimal(db.DataTable.Rows[Index]["Balance"]);
repair.CollectionDate = Convert.ToDateTime(db.DataTable.Rows[Index]["CollectionDate"]);
repair.Comment = Convert.ToString(db.DataTable.Rows[Index]["Comment"]);
//add the blank page to the array list
lstRepairs.Add(repair);
//increase the index
Index++;
}
//return the list as the return value of the function
return(lstRepairs);
}
public frmAddRepairJob(frmRepairJob frmRep, clsRepair repair)
{
InitializeComponent();
frmListRepair = frmRep;
if (repair != null)
{
txtID.Text = Convert.ToString(repair.ID);
txtCustomerName.Text = repair.CustomerName;
txtCustomerPhoneNo.Text = repair.CustomerPhoneNo;
dateTime.Value = repair.Date;
txtSerialNo_IMEI.Text = repair.SerialNo_IMEI;
txtFault.Text = repair.Fault;
txtPassword.Text = repair.Password;
txtCost.Text = repair.Cost.ToString("F");
txtDeposit.Text = repair.Deposit.ToString("F");
txtBalance.Text = repair.Balance.ToString("F");
dateTimePicker1.Value = repair.CollectionDate;
txtComment.Text = repair.Comment;
btnAdd.Text = "Edit";
}
loadDevices(repair);
}
public void InstanceOK()
{
clsRepair cr = new clsRepair();
Assert.IsNotNull(cr);
}
