private void btnSave_Click(object sender, EventArgs e)
{
if (txtCategory.Text != null)
{
ve = new VehicleManagementEntities();
if (ve.Categories.Any(o => o.Category1 == txtCategory.Text))
{
MessageBox.Show("Category already exists");
}
else
{
Category category = new Category()
{
Category1 = txtCategory.Text,
};
ve.Categories.Add(category);
ve.SaveChanges();
txtCategory.Text = "";
MessageBox.Show("Successfully added!");
displayData();
txtCategory.Text = "";
}
}
else
{
MessageBox.Show("All fields are required!");
}
}
private void btnAddExpense_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtExpTitle.Text) && !string.IsNullOrEmpty(cmbExpType.Text))
{
ve = new VehicleManagementEntities();
if (ve.Expenses.Any(r => r.ExpenseTitle == txtExpTitle.Text))
{
MessageBox.Show("This expense is already exists!");
}
else
{
Expens expenses = new Expens()
{
ExpenseTitle = txtExpTitle.Text,
VehicleId = vehicleId,
ExpenseType = cmbExpType.Text,
Amount = long.Parse(numExpAmount.Value.ToString()),
DateCreated = DateTime.Now
};
ve.Expenses.Add(expenses);
ve.SaveChanges();
MessageBox.Show("Expense successfully added!");
fetchExpenses();
clearExpenseFields();
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void btnAddSale_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBuyerName.Text) && !string.IsNullOrEmpty(txtBuyerNIC.Text) && !string.IsNullOrEmpty(txtBuyerPhone.Text) &&
!string.IsNullOrEmpty(txtBuyerAddress.Text))
{
if (numSaleAmount.Value != 0)
{
ve = new VehicleManagementEntities();
SaleVehicle sale = new SaleVehicle()
{
VehicleId = vehicleId,
BuyerName = txtBuyerName.Text,
NIC = txtBuyerNIC.Text,
Address = txtBuyerAddress.Text,
Phone = txtBuyerPhone.Text,
SaleAmount = float.Parse(numSaleAmount.Value.ToString()),
Status = "0",
DateSold = DateTime.Now
};
ve.SaleVehicles.Add(sale);
ve.SaveChanges();
MessageBox.Show("Contractor successfully added!");
fetchSale();
clearSaleFields();
}
else
{
MessageBox.Show("You must enter sale amount!");
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtItem.Text != null)
{
ve = new VehicleManagementEntities();
if (ve.InventoryItems.Any(o => o.ItemName == txtItem.Text))
{
MessageBox.Show("Item already exists");
}
else
{
InventoryItem inventoryItem = new InventoryItem()
{
ItemName = txtItem.Text
};
ve.InventoryItems.Add(inventoryItem);
ve.SaveChanges();
MessageBox.Show("Successfully saved");
clearValues();
displayData();
}
}
else
{
MessageBox.Show("Cannot submit empty fields");
}
}
private void listSale_SelectedIndexChanged(object sender, EventArgs e)
{
btnAddSale.Enabled = false;
btnUpdateSale.Enabled = true;
btnBuyerView.Enabled = true;
txtBuyerName.Enabled = true;
numSaleAmount.Enabled = true;
txtBuyerNIC.Enabled = true;
txtBuyerPhone.Enabled = true;
txtBuyerAddress.Enabled = true;
ListView.SelectedListViewItemCollection itemCollection = listSale.SelectedItems;
foreach (ListViewItem item in itemCollection)
{
selectedSaleId = Int32.Parse(item.SubItems[0].Text);
using (ve = new VehicleManagementEntities())
{
List <SaleVehicle> saleList = ve.SaleVehicles.Where(r => r.VehicleId == vehicleId).ToList();
if (saleList.Any())
{
foreach (SaleVehicle sale in saleList)
{
ListViewItem saleItem = new ListViewItem(sale.SaleId.ToString());
txtBuyerName.Text = sale.BuyerName;
txtBuyerAddress.Text = sale.Address;
txtBuyerNIC.Text = sale.NIC;
txtBuyerPhone.Text = sale.Phone;
numSaleAmount.Value = (decimal)sale.SaleAmount;
}
}
}
}
}
private void btnAddIncome_Click(object sender, EventArgs e)
{
if (numInstAmount.Value != 0 && !string.IsNullOrEmpty(txtInvoiceNumber.Text))
{
if (totalDueAmount < numInstAmount.Value)
{
MessageBox.Show("Installment amount should be less than total vehicle value.");
}
else
{
ve = new VehicleManagementEntities();
Payment payment = new Payment()
{
VehicleId = vehicleId,
SaleId = selectedSaleId,
Installment = (installmentCount + 1).ToString(),
InvoiceNumber = txtInvoiceNumber.Text,
Amount = (double)numInstAmount.Value,
DatePayed = DateTime.Now
};
ve.Payments.Add(payment);
ve.SaveChanges();
MessageBox.Show("Payment saved succesfully!");
clearPaymentFields();
fetchPayments();
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void fetchJobs()
{
btnAddJob.Enabled = true;
btnUpdateJob.Enabled = false;
btnDeleteJob.Enabled = false;
using (ve = new VehicleManagementEntities())
{
List <Job> jobList = ve.Jobs.Where(r => r.VehicleId == vehicleId).ToList();
listJobs.Items.Clear();
if (jobList.Any())
{
foreach (Job j in jobList)
{
ListViewItem item = new ListViewItem(j.JobId.ToString());
item.SubItems.Add(j.JobTitle);
item.SubItems.Add(j.Contractor1.ContractorName);
item.SubItems.Add(j.Contractor1.ContractorType);
item.SubItems.Add(j.Amount.ToString());
item.SubItems.Add(j.Status.ToString());
item.SubItems.Add(j.CreatedDate.ToString());
listJobs.Items.Add(item);
}
}
}
}
private void BtnSave(object sender, EventArgs e)
{
if (txtUsername.Text != null && txtPassword.Text != null)
{
ve = new VehicleManagementEntities();
if (ve.Users.Any(o => o.Username == txtUsername.Text))
{
MessageBox.Show("User already exists");
}
else
{
User users = new User()
{
Username = txtUsername.Text,
Password = BCrypt.Net.BCrypt.HashString(txtPassword.Text),
};
ve.Users.Add(users);
ve.SaveChanges();
txtUsername.Text = "";
txtPassword.Text = "";
MessageBox.Show("Successfully added!");
displayData();
txtUsername.Text = "";
txtPassword.Text = "";
}
}
else
{
MessageBox.Show("All fields are required!");
}
}
private void btnUpdateIncome_Click(object sender, EventArgs e)
{
if (numInstAmount.Value != 0 && !string.IsNullOrEmpty(txtInvoiceNumber.Text))
{
if (totalDueAmount < numInstAmount.Value)
{
MessageBox.Show("Installment amount should be less than total vehicle value.");
}
else
{
ve = new VehicleManagementEntities();
var singlePayment = ve.Payments.Where(r => r.PaymentId == selectedPayment).First();
singlePayment.InvoiceNumber = txtInvoiceNumber.Text;
singlePayment.Amount = float.Parse(numInstAmount.Value.ToString());
ve.SaveChanges();
MessageBox.Show("Payment successfully updated!");
fetchPayments();
clearPaymentFields();
selectedPayment = 0;
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBrand.Text))
{
ve = new VehicleManagementEntities();
if (ve.Brands.Any(o => o.Brand1 == txtBrand.Text) == false)
{
Brand brand = new Brand()
{
Brand1 = txtBrand.Text
};
ve.Brands.Add(brand);
ve.SaveChanges();
MessageBox.Show("Brand added successfully!");
clearValues();
fetchData();
}
else
{
MessageBox.Show("this brand already exists in the system");
}
}
else
{
MessageBox.Show("Ypu cannot submit empty values");
}
}
private void btnAddJob_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtJobTitle.Text) && !string.IsNullOrEmpty(cmbContractors.Text) && !string.IsNullOrEmpty(cmbConStatus.Text))
{
ve = new VehicleManagementEntities();
if (ve.Jobs.Any(r => r.JobTitle == txtJobTitle.Text))
{
MessageBox.Show("This job is already exists!");
}
else
{
cmbBoxValues selCon = cmbContractors.SelectedItem as cmbBoxValues;
int selectedContractor = selCon.cmbVal;
Job job = new Job()
{
JobTitle = txtJobTitle.Text,
VehicleId = vehicleId,
Contractor = long.Parse(selectedContractor.ToString()),
Amount = float.Parse(txtJobAmount.Value.ToString()),
Status = cmbConStatus.Text,
CreatedDate = DateTime.Now
};
ve.Jobs.Add(job);
ve.SaveChanges();
MessageBox.Show("Contractor successfully added!");
fetchJobs();
clearJobFields();
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (selectedId == 0)
{
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtAddress.Text) &&
!string.IsNullOrEmpty(txtPhone.Text) && !string.IsNullOrEmpty(cmbType.Text))
{
ve = new VehicleManagementEntities();
if (ve.VehicleSellers.Any(r => r.SellerName == txtName.Text && r.VehicleNumber == regNum) == false)
{
VehicleSeller vehicleSeller = new VehicleSeller()
{
SellerName = txtName.Text,
SellerAddress = txtAddress.Text,
SellerContactNumber = txtPhone.Text,
SellerType = cmbType.Text,
VehicleNumber = regNum
};
ve.VehicleSellers.Add(vehicleSeller);
ve.SaveChanges();
MessageBox.Show("Seller data saved successfully!");
clearValues();
frmSingleVehicle singleVehicle = new frmSingleVehicle();
singleVehicle.fetchSellerData();
btnSave.Text = "Update";
btnSave.Enabled = false;
}
else
{
MessageBox.Show("This seller already exists");
}
}
else
{
MessageBox.Show("All fields are required");
}
}
else
{
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtAddress.Text) &&
!string.IsNullOrEmpty(txtPhone.Text) && !string.IsNullOrEmpty(cmbType.Text))
{
ve = new VehicleManagementEntities();
var singleSeller = ve.VehicleSellers.Where(r => r.VehicleSellerId == selectedId).First();
singleSeller.SellerName = txtName.Text;
singleSeller.SellerAddress = txtAddress.Text;
singleSeller.SellerContactNumber = txtPhone.Text;
singleSeller.SellerType = cmbType.Text;
ve.SaveChanges();
MessageBox.Show("Successfully updated!");
btnSave.Text = "Update";
btnSave.Enabled = false;
}
}
}
private void fetchInventoryData()
{
using (ve = new VehicleManagementEntities())
{
List <InventoryItem> inventoryItems = ve.InventoryItems.ToList();
foreach (InventoryItem inv in inventoryItems)
{
ListViewItem item = new ListViewItem(inv.InventoryItemId.ToString());
item.SubItems.Add(inv.ItemName.ToString());
listPartInventory.Items.Add(item);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtVehicleType.Text))
{
ve = new VehicleManagementEntities();
var singleVehiType = ve.VehicleTypes.Where(r => r.VehicleTypeId == Id).First();
singleVehiType.VehiType = txtVehicleType.Text;
ve.SaveChanges();
displayData();
MessageBox.Show("Successfully updated!");
Id = 0;
txtVehicleType.Text = "";
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Are you sure you want to Delete?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
ve = new VehicleManagementEntities();
var singleContractor = ve.Contractors.Where(r => r.ContractorId == id).First();
ve.Contractors.Remove(singleContractor);
ve.SaveChanges();
MessageBox.Show("Contractor successfully deleted!");
displayData();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBrand.Text))
{
ve = new VehicleManagementEntities();
var singleBrand = ve.Brands.Where(r => r.BrandId == Id).First();
singleBrand.Brand1 = txtBrand.Text;
ve.SaveChanges();
MessageBox.Show("Brand updated successfully!");
clearValues();
fetchData();
Id = 0;
}
}
private void btnDeleteJob_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Are you sure you want to Delete this Job?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
ve = new VehicleManagementEntities();
var singleJob = ve.Jobs.Where(r => r.JobId == selectedJobID).First();
ve.Jobs.Remove(singleJob);
ve.SaveChanges();
MessageBox.Show("Job successfully deleted!");
fetchJobs();
clearJobFields();
}
}
private void btnDeleteExpense_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Are you sure you want to Delete this Expense?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
ve = new VehicleManagementEntities();
var singleExp = ve.Expenses.Where(r => r.ExpenseId == selectedExpenseId).First();
ve.Expenses.Remove(singleExp);
ve.SaveChanges();
MessageBox.Show("Expense successfully deleted!");
fetchExpenses();
clearExpenseFields();
}
}
private void displayData()
{
Cursor.Current = Cursors.WaitCursor;
listInventoryItem.Items.Clear();
using (ve = new VehicleManagementEntities())
{
List <InventoryItem> list = ve.InventoryItems.ToList();
foreach (InventoryItem u in list)
{
ListViewItem item = new ListViewItem(u.InventoryItemId.ToString());
item.SubItems.Add(u.ItemName);
listInventoryItem.Items.Add(item);
}
}
Cursor.Current = Cursors.Default;
}
private void btnDeleteIncome_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Are you sure you want to Delete this Payment? You cannot reverse this action.", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
ve = new VehicleManagementEntities();
var singlePayment = ve.Payments.Where(r => r.PaymentId == selectedPayment).First();
ve.Payments.Remove(singlePayment);
ve.SaveChanges();
MessageBox.Show("Payment successfully deleted!");
fetchPayments();
clearPaymentFields();
selectedPayment = 0;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtNic.Text) && !string.IsNullOrEmpty(txtPhone.Text) && !string.IsNullOrEmpty(cmbType.Text))
{
bool isPhone = validatePhone();
bool isNic = validateNic();
if (isPhone == false)
{
MessageBox.Show("A Phone number should have 10 digits.");
}
else
{
if (isNic == false)
{
MessageBox.Show("A NIC should have 10 or 12 digits.");
}
else
{
ve = new VehicleManagementEntities();
if (ve.Contractors.Any(c => c.ContractorNic == txtNic.Text))
{
MessageBox.Show("This contractor is already exists!");
}
else
{
Contractor contractor = new Contractor()
{
ContractorName = txtName.Text,
ContractorNic = txtNic.Text,
ContractorPhone = txtPhone.Text,
ContractorType = cmbType.Text
};
ve.Contractors.Add(contractor);
ve.SaveChanges();
MessageBox.Show("Contractor successfully added!");
displayData();
clearFields();
}
}
}
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtItem.Text))
{
ve = new VehicleManagementEntities();
var singleItem = ve.InventoryItems.Where(r => r.InventoryItemId == Id).First();
singleItem.ItemName = txtItem.Text;
ve.SaveChanges();
clearValues();
displayData();
MessageBox.Show("Succesfully updated!");
}
else
{
MessageBox.Show("Cannot submit empty fields");
}
}
private void displayData()
{
Cursor.Current = Cursors.WaitCursor;
listVehicleCategory.Items.Clear();
btnSave.Visible = true;
btnUpdate.Visible = false;
using (ve = new VehicleManagementEntities())
{
List <Category> list = ve.Categories.ToList();
foreach (Category c in list)
{
ListViewItem item = new ListViewItem(c.CategoryId.ToString());
item.SubItems.Add(c.Category1);
listVehicleCategory.Items.Add(item);
}
}
Cursor.Current = Cursors.Default;
}
private void displayData()
{
Cursor.Current = Cursors.WaitCursor;
btnSave.Visible = true;
btnUpdate.Visible = false;
listVehicleTypes.Items.Clear();
using (ve = new VehicleManagementEntities())
{
List <VehicleType> list = ve.VehicleTypes.ToList();
foreach (VehicleType v in list)
{
ListViewItem item = new ListViewItem(v.VehicleTypeId.ToString());
item.SubItems.Add(v.VehiType);
listVehicleTypes.Items.Add(item);
}
}
Cursor.Current = Cursors.Default;
}
private void fetchData()
{
Cursor.Current = Cursors.WaitCursor;
listBrands.Items.Clear();
using (ve = new VehicleManagementEntities())
{
List <Brand> brands = ve.Brands.ToList();
foreach (Brand b in brands)
{
ListViewItem item = new ListViewItem(b.BrandId.ToString());
item.SubItems.Add(b.Brand1.ToString());
listBrands.Items.Add(item);
}
}
btnSave.Visible = true;
btnUpdate.Visible = false;
Cursor.Current = Cursors.Default;
}
private void loadContractors()
{
using (ve = new VehicleManagementEntities())
{
cmbContractors.Items.Clear();
List <Contractor> list = ve.Contractors.ToList();
List <cmbBoxValues> cmbData = new List <cmbBoxValues>();
foreach (Contractor c in list)
{
cmbData.Add(new cmbBoxValues()
{
cmbVal = Int32.Parse(c.ContractorId.ToString()), cmbName = c.ContractorName, extraValues = c.ContractorType.ToString()
});
}
cmbContractors.DataSource = cmbData;
cmbContractors.DisplayMember = "cmbName";
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtUsername.Text) && !string.IsNullOrEmpty(txtPassword.Text))
{
ve = new VehicleManagementEntities();
var singleUser = ve.Users.Where(r => r.UserId == Id).First();
singleUser.Username = txtUsername.Text;
singleUser.Password = BCrypt.Net.BCrypt.HashString(txtPassword.Text);
ve.SaveChanges();
MessageBox.Show("Successfully updated!");
Id = 0;
displayData();
txtPassword.Text = "";
txtUsername.Text = "";
}
else
{
MessageBox.Show("Cannot update empty fields!");
}
}
private void btnUpdateExpense_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtExpTitle.Text) && !string.IsNullOrEmpty(cmbExpType.Text))
{
ve = new VehicleManagementEntities();
var singleExp = ve.Expenses.Where(r => r.ExpenseId == selectedExpenseId).First();
singleExp.ExpenseTitle = txtExpTitle.Text;
singleExp.ExpenseType = cmbExpType.Text;
singleExp.Amount = float.Parse(numExpAmount.Value.ToString());
ve.SaveChanges();
MessageBox.Show("Expense successfully updated!");
fetchExpenses();
clearExpenseFields();
selectedExpenseId = 0;
}
else
{
MessageBox.Show("You must fill all fields!");
}
}
private void fetchSale()
{
using (ve = new VehicleManagementEntities())
{
List <SaleVehicle> saleList = ve.SaleVehicles.Where(r => r.VehicleId == vehicleId).ToList();
listSale.Items.Clear();
if (saleList.Any())
{
btnAddSale.Enabled = false;
btnUpdateSale.Enabled = false;
txtBuyerName.Enabled = false;
numSaleAmount.Enabled = false;
txtBuyerNIC.Enabled = false;
txtBuyerPhone.Enabled = false;
txtBuyerAddress.Enabled = false;
btnAddIncome.Enabled = true;
btnUpdateIncome.Enabled = true;
btnDeleteIncome.Enabled = true;
numInstAmount.Enabled = true;
foreach (SaleVehicle sale in saleList)
{
ListViewItem item = new ListViewItem(sale.SaleId.ToString());
selectedSaleId = (int)sale.SaleId;
totalVehicleAmount = (decimal)sale.SaleAmount;
item.SubItems.Add(sale.BuyerName);
item.SubItems.Add(sale.SaleAmount.ToString());
listSale.Items.Add(item);
}
}
else
{
btnAddIncome.Enabled = false;
btnUpdateIncome.Enabled = false;
btnDeleteIncome.Enabled = false;
numInstAmount.Enabled = false;
}
}
}
public void fetchSellerData()
{
using (ve = new VehicleManagementEntities())
{
List <VehicleSeller> vehicleSellers = ve.VehicleSellers.Where(v => v.VehicleNumber == vehicleNumber).ToList();
if (vehicleSellers.Any())
{
btnAddSeller.Text = "&Add / Update Info";
foreach (VehicleSeller seller in vehicleSellers)
{
lblSellerName.Text = seller.SellerName;
lblSellerPhone.Text = seller.SellerContactNumber;
lblSellerAddress.Text = seller.SellerAddress;
lblSellerType.Text = seller.SellerType;
}
}
else
{
btnAddSeller.Text = "&Add Info";
}
}
}
