private void btnSendRequest_Click(object sender, EventArgs e)
{
Session2Entities db = new Session2Entities();
EmergencyMaintenance records = new EmergencyMaintenance();
//check has emergency closed?
Asset asset = (from x in db.Assets where x.AssetSN == lblAssetSNValue.Text select x).FirstOrDefault <Asset>();
EmergencyMaintenance em = (from x in db.EmergencyMaintenances where x.AssetID == asset.ID && x.EMEndDate == null select x).FirstOrDefault <EmergencyMaintenance>();
records.PriorityID = (cbPriority.SelectedItem as Priority).ID;
records.DescriptionEmergency = txtDescription.Text;
records.OtherConsiderations = txtOtherConsideration.Text;
records.EMReportDate = DateTime.Now.Date;
records.AssetID = asset.ID;
if (em != null)
{
MessageBox.Show("Asset is maintaining!", "Error");
return;
}
else
{
db.EmergencyMaintenances.Add(records);
db.SaveChanges();
}
}
private void Login(string strusername, string strpassword)
{
Session2Entities db = new Session2Entities();
Employee emp = (from x in db.Employees
where strpassword == x.Password && strusername == x.Usernname
select x).SingleOrDefault <Employee>();
if (emp != null)
{
//ADMIN
if (emp.isAdmin == false)
{
frmEmergencyMaintenanceManagement frmNext = new frmEmergencyMaintenanceManagement();
frmNext.username = strusername;
frmNext.ShowDialog();
}
else //USER
{
frmAccessRequesting frmAcc = new frmAccessRequesting();
frmAcc.Tag = strusername;
frmAcc.ShowDialog();
}
}
else
{
MessageBox.Show("Login Failed");
}
}
private void buttonImport_Click(object sender, EventArgs e)
{
string fileContent;
var file = new OpenFileDialog
{
Title = "Select csv file to be imported",
Filter = "csv file (*.csv)|*.csv",
Multiselect = false
};
if (file.ShowDialog() == DialogResult.OK)
{
using (var reader = new StreamReader(file.OpenFile()))
{
fileContent = reader.ReadToEnd();
}
var rows = fileContent.Split('\n');
using (var session = new Session2Entities())
{
foreach (var row in rows)
{
var cells = row.Split(',');
// NOT IMPLEMENTED
}
}
}
}
private void buttonCancelFlight_Click(object sender, EventArgs e)
{
if (selected)
{
int id = int.Parse(dataGridView.CurrentCell.OwningRow.Cells["ID"].Value.ToString());
using (var session = new Session2Entities())
{
var q = session.Schedules.FirstOrDefault(x => x.ID == id);
if (buttonCancelFlight.Text == "Confirm Flight")
{
q.Confirmed = true;
}
else
{
q.Confirmed = false;
}
session.SaveChanges();
System.Threading.Thread.Sleep(1000);
SetGrid();
}
}
else
{
MessageBox.Show($"Please select schedule that you want to {buttonCancelFlight.Text} first!");
}
}
private void frmEmergencyMaintenanceRequest_Load(object sender, EventArgs e)
{
Dictionary <string, string> tt = this.Tag as Dictionary <string, string>;
//Fill data to group box Selected Asset
lblAssetSNValue.Text = tt["AssetSN"];
lblAssetNameValue.Text = tt["AssetName"];
Session2Entities db = new Session2Entities();
Asset asset = (from x in db.Assets
where x.AssetSN == lblAssetSNValue.Text && x.AssetName == lblAssetNameValue.Text
select x).FirstOrDefault <Asset>();
IEnumerable <EmergencyMaintenance> list_em = from x in db.EmergencyMaintenances
where x.AssetID == asset.ID
select x;
DepartmentLocation departmentLocation = (from x in db.DepartmentLocations
where x.ID == asset.DepartmentLocationID
select x).FirstOrDefault <DepartmentLocation>();
Department department = (from x in db.Departments
where x.ID == departmentLocation.DepartmentID
select x).FirstOrDefault <Department>();
lblDepartmentValue.Text = department.Name;
//Load combobox
foreach (Priority temp in (from x in db.Priorities select x))
{
cbPriority.Items.Add(temp);
}
cbPriority.DisplayMember = "Name";
cbPriority.ValueMember = "ID";
cbPriority.SelectedIndex = 0;
}
private void LoadDataTable()
{
Session2Entities db = new Session2Entities();
dgvParts.Rows.Clear();
int emid = int.Parse(dataReceived["EmergencyMaintenanceID"]);
List <dynamic> listO = (from x in db.ChangedParts
from y in db.Parts
where x.PartID == y.ID && x.EmergencyMaintenanceID == emid
select new
{
ChangedPartID = x.ID,
EmergencyMaintenanceID = x.EmergencyMaintenanceID,
PartID = y.ID,
Amount = x.Amount,
PartName = y.Name
}).ToList <dynamic>();
foreach (dynamic o in listO)
{
Dictionary <string, string> row = new Dictionary <string, string>();
row["ChangedPartID"] = o.ChangedPartID;
row["EmergencyMaintenanceID"] = o.EmergencyMaintenanceID.ToString();
row["PartID"] = o.PartID;
row["Amount"] = o.Amount.ToString();
row["PartName"] = o.PartName;
row["Action"] = "Remove";
dgvParts.Rows.Add(row["PartName"], row["Amount"], row["Action"], row["PartID"], row["ChangedPartID"], row["EmergencyMaintenanceID"]);
}
}
private void LoadDataTable()
{
Session2Entities db = new Session2Entities();
//Get data at the first
dgvRequest.DataSource = db.SP_GetdgvRequest();
//convert element of DataSource to Dic<string,string>
List <Dictionary <string, string> > listO = new List <Dictionary <string, string> >();
for (int i = 0; i < dgvRequest.Rows.Count; i++)
{
Dictionary <string, string> temp = new Dictionary <string, string>();
temp["AssetSN"] = dgvRequest.Rows[i].Cells["AssetSN"].Value.ToString();
temp["AssetName"] = dgvRequest.Rows[i].Cells["AssetName"].Value.ToString();
if (dgvRequest.Rows[i].Cells["RequestDate"].Value == null)
{
temp["RequestDate"] = "--";
}
else
{
DateTime tdate = DateTime.Parse(dgvRequest.Rows[i].Cells["RequestDate"].Value.ToString());
temp["RequestDate"] = tdate.ToString("yyyy/MM/dd");
}
temp["EmployeeFullName"] = dgvRequest.Rows[i].Cells["EmployeeFullName"].Value.ToString();
temp["Department"] = dgvRequest.Rows[i].Cells["Department"].Value.ToString();
temp["AssetID"] = dgvRequest.Rows[i].Cells["AssetID"].Value.ToString();
temp["EmergencyMaintenanceID"] = dgvRequest.Rows[i].Cells["EmergencyMaintenanceID"].Value.ToString();
temp["EmployeeID"] = dgvRequest.Rows[i].Cells["EmployeeID"].Value.ToString();
temp["DepartmentLocationID"] = dgvRequest.Rows[i].Cells["DepartmentLocationID"].Value.ToString();
temp["DepartmentID"] = dgvRequest.Rows[i].Cells["DepartmentID"].Value.ToString();
temp["PriorityName"] = dgvRequest.Rows[i].Cells["PriorityName"].Value.ToString();
listO.Add(temp);
}
//sort Dic<string,string>
listO.Sort(CompareDynamic);
//set Dic<string, string which has just sorted to DataSource
int ii = 0;
foreach (Dictionary <string, string> temp in listO)
{
dgvRequest.Rows[ii].Cells["AssetSN"].Value = temp["AssetSN"];
dgvRequest.Rows[ii].Cells["AssetName"].Value = temp["AssetName"];
dgvRequest.Rows[ii].Cells["RequestDate"].Value = temp["RequestDate"];
dgvRequest.Rows[ii].Cells["EmployeeFullName"].Value = temp["EmployeeFullName"];
dgvRequest.Rows[ii].Cells["Department"].Value = temp["Department"];
dgvRequest.Rows[ii].Cells["AssetID"].Value = temp["AssetID"];
dgvRequest.Rows[ii].Cells["EmergencyMaintenanceID"].Value = int.Parse(temp["EmergencyMaintenanceID"]);
dgvRequest.Rows[ii].Cells["EmployeeID"].Value = temp["EmployeeID"];
dgvRequest.Rows[ii].Cells["DepartmentLocationID"].Value = temp["DepartmentLocationID"];
dgvRequest.Rows[ii].Cells["DepartmentID"].Value = temp["DepartmentID"];
dgvRequest.Rows[ii].Cells["PriorityName"].Value = temp["PriorityName"];
ii++;
}
}
private void LoadDataTable()
{
Session2Entities db = new Session2Entities();
dgvEmergencyMaintenance.DataSource = db.SP_GetdgvEmergency(this.username);
foreach (DataGridViewRow row in dgvEmergencyMaintenance.Rows)
{
string assetSN = row.Cells["AssetSN"].Value.ToString();
string assetName = row.Cells["AssetName"].Value.ToString();
string assetID = (from x in db.Assets where assetSN == x.AssetSN && assetName == x.AssetName select x.ID).SingleOrDefault <string>();
EmergencyMaintenance em = (from x in db.EmergencyMaintenances where assetID == x.AssetID && x.EMEndDate == null select x).FirstOrDefault <EmergencyMaintenance>();
if (em != null)
{
dgvEmergencyMaintenance.Rows[row.Index].DefaultCellStyle.BackColor = Color.Red;
}
}
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
if (!FieldsIsEmpty())
{
// 1 = earlier, 0 = same, -1 = later
if (DateTime.Compare(date, dateTimePicker.Value) >= 0)
{
if (TimeSpan.TryParseExact(textBoxTime.Text, @"hh\:mm\:ss", null, out TimeSpan t))
{
if (Decimal.TryParse(textBoxPrice.Text, out decimal d))
{
using (var session = new Session2Entities())
{
var q = session.Schedules.Where(x => x.ID == id).FirstOrDefault();
q.Date = dateTimePicker.Value;
q.Time = t;
q.EconomyPrice = d;
session.SaveChanges();
ManageFlight parent = (ManageFlight)Owner;
parent.SetGrid();
Close();
}
}
else
{
MessageBox.Show("Please enter a valid number for the price");
}
}
else
{
MessageBox.Show("Please enter a valid time (hh:mm:ss)");
}
}
else
{
MessageBox.Show("You cannot select date from the future.");
}
}
else
{
MessageBox.Show("Please don't leave any field empty");
}
}
private void GetSetAirport()
{
using (var db = new Session2Entities())
{
var q = db.Airports.Select(x => new { ID = x.IATACode, x.Name });
var r = q.ToList();
r.Insert(0, new { ID = "0", Name = "All Airports" });
comboBoxFrom.ValueMember = "ID";
comboBoxFrom.DisplayMember = "Name";
comboBoxFrom.DataSource = r;
comboBoxTo.BindingContext = new BindingContext();
comboBoxTo.ValueMember = "ID";
comboBoxTo.DisplayMember = "Name";
comboBoxTo.DataSource = r;
}
}
private void buttonCancel_Click(object sender, EventArgs e)
{
try
{
int id = int.Parse(dataGridView.CurrentCell.OwningRow.Cells["ID"].Value.ToString());
using (var db = new Session2Entities())
{
Schedule q = db.Schedules.FirstOrDefault(x => x.ID == id);
q.Confirmed = buttonCancel.Text == "Cancel Flight" ? false : true;
db.SaveChanges();
GetSetGrid();
GetSetGridColor();
}
}
catch
{
MessageBox.Show("Please select flight that you want to change the confirmation first!");
}
}
private void SetAirports()
{
using (var session = new Session2Entities())
{
var airports = session.Airports.Select(a => new { a.IATACode, a.Name }).ToList();
airports.Insert(0, new { IATACode = "0", Name = "All Airports" });
comboBoxFrom.ValueMember = "IATACode";
comboBoxFrom.DisplayMember = "Name";
comboBoxFrom.DataSource = airports;
// This is here because there will be telepathy problem if not
comboBoxTo.BindingContext = new BindingContext();
comboBoxTo.ValueMember = "IATACode";
comboBoxTo.DisplayMember = "Name";
comboBoxTo.DataSource = airports;
}
}
private void ScheduleEdit_Load(object sender, EventArgs e)
{
using (var session = new Session2Entities())
{
var q = session.Schedules.Where(x => x.ID == id).FirstOrDefault();
string from = q.Route.Airport.IATACode;
string to = q.Route.Airport1.IATACode;
string aircraft = q.Aircraft.Name;
date = q.Date;
TimeSpan time = q.Time;
decimal price = q.EconomyPrice;
labelFrom.Text = from;
labelTo.Text = to;
labelAircraft.Text = aircraft;
dateTimePicker.Value = date;
textBoxTime.Text = time.ToString();
textBoxPrice.Text = price.ToString();
}
}
public Schedule ToScheduleEntity(ScheduleDto scheduleDto)
{
try
{
Session2Entities session = new Session2Entities();
Schedule s = new Schedule();
s.ID = scheduleDto.Id;
s.Date = DateTime.ParseExact(scheduleDto.Date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
s.Time = TimeSpan.ParseExact(scheduleDto.Time, @"hh\:mm", CultureInfo.InvariantCulture);
s.AircraftID = scheduleDto.AircraftID;
s.RouteID = session.Routes.Single(r =>
r.Airport.IATACode.Equals(scheduleDto.From) &&
r.Airport1.IATACode.Equals(scheduleDto.To)).ID;
s.EconomyPrice = scheduleDto.EconomyPrice;
s.FlightNumber = scheduleDto.FlightNumber;
s.Confirmed = scheduleDto.Confirmed;
return(s);
}
catch (Exception)
{
return(null);
}
}
public ScheduleRepository()
{
_session2DbContext = new Session2Entities();
}
private void frmAccessRequestDetails_Load(object sender, EventArgs e)
{
//fill data to Selected Asset
dataReceived = this.Tag as Dictionary <string, string>;
lblAssetName.Text = dataReceived["AssetName"];
lblAssetSN.Text = dataReceived["AssetSN"];
lblDepartment.Text = dataReceived["Department"];
//dataReceived["EmergencyMaintenanceID"]
//Access EM report
Session2Entities db = new Session2Entities();
int emID = int.Parse(dataReceived["EmergencyMaintenanceID"]);
string startDate = (from x in db.EmergencyMaintenances
where x.ID == emID
select x).FirstOrDefault <EmergencyMaintenance>().EMStartDate.ToString();
if (startDate == "" || startDate == null)
{
;
}
else
{
mktStartDate.Text = DateTime.Parse(startDate).ToString("dd/MM/yyyy");
}
string endDate = (from x in db.EmergencyMaintenances
where x.ID == emID
select x).FirstOrDefault <EmergencyMaintenance>().EMEndDate.ToString();
if (endDate == "" || endDate == null)
{
;
}
else
{
mktCompleteOn.Text = DateTime.Parse(endDate).ToString("dd/MM/yyyy");
}
txtNote.Text = (from x in db.EmergencyMaintenances
where x.ID == emID
select x).FirstOrDefault <EmergencyMaintenance>().EMTechnicianNote.ToString();
if (txtNote.Text == "")
{
mktCompleteOn.Enabled = false;
}
else
{
mktCompleteOn.Enabled = true;
}
//Replacement Parts
var datacb = from x in db.Parts
select new
{
Name = x.Name,
ID = x.ID
};
cbPartName.DisplayMember = "Name";
cbPartName.ValueMember = "ID";
cbPartName.DataSource = datacb.ToList <object>();
LoadDataTable();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Session2Entities db = new Session2Entities();
//Check date in MaskedTextBox
DateTime startDate = new DateTime(), endDate = new DateTime();
try
{
startDate = DateTime.Parse(mktStartDate.Text);
}
catch (Exception)
{
bool flag = false;
for (int i = 0; i < mktStartDate.Text.Length; i++)
{
if (mktStartDate.Text[i] <= '9' && mktStartDate.Text[i] >= '0')
{
flag = true;
break;
}
}
if (flag)
{
MessageBox.Show("Start date invalid", "Error");
}
else
{
startDate = new DateTime();
}
}
try
{
endDate = DateTime.Parse(mktCompleteOn.Text);
}
catch (Exception)
{
bool flag = false;
for (int i = 0; i < mktCompleteOn.Text.Length; i++)
{
if (mktCompleteOn.Text[i] <= '9' && mktCompleteOn.Text[i] >= '0')
{
flag = true;
break;
}
}
if (flag)
{
MessageBox.Show("End date invalid", "Error");
}
else
{
endDate = new DateTime();
}
}
//submit StartDate, CompleteDate, TextNote
if (startDate.Equals(new DateTime()))
{
MessageBox.Show("Start date is empty", "Error");
return;
}
if (!startDate.Equals(new DateTime()) && !endDate.Equals(new DateTime()))
{
if (startDate > endDate)
{
MessageBox.Show("Start date must be before Complete On date", "Error");
return;
}
}
int emid = int.Parse(dataReceived["EmergencyMaintenanceID"]);
EmergencyMaintenance one1 = (from x in db.EmergencyMaintenances where x.ID == emid select x).SingleOrDefault <EmergencyMaintenance>();
one1.EMTechnicianNote = txtNote.Text;
if (startDate.Equals(new DateTime()) == false)
{
one1.EMStartDate = startDate;
}
if (endDate.Equals(new DateTime()) == false)
{
one1.EMEndDate = endDate;
}
db.SaveChanges();
//submit dgvParts
//delete changedpart where emid
IEnumerable <ChangedPart> temp = from x in db.ChangedParts
where x.EmergencyMaintenanceID == emid
select x;
foreach (ChangedPart cp in temp)
{
db.ChangedParts.Remove(cp);
}
db.SaveChanges();
//add changedpart from dgvParts
for (int i = 0; i < dgvParts.Rows.Count; i++)
{
ChangedPart one = new ChangedPart();
one.ID = "chp" + (i + 1) * DateTime.Now.ToString().GetHashCode();
one.EmergencyMaintenanceID = int.Parse(dataReceived["EmergencyMaintenanceID"]);
one.PartID = dgvParts.Rows[i].Cells["PartID"].Value.ToString();
one.Amount = Convert.ToDouble(dgvParts.Rows[i].Cells["Amount"].Value);
db.ChangedParts.Add(one);
}
db.SaveChanges();
//LoadDataTable
LoadDataTable();
MessageBox.Show("Submit successful", "Notification");
}
public void GetSetGrid()
{
if (!(comboBoxFrom.SelectedValue.ToString() == comboBoxTo.SelectedValue.ToString()) || (comboBoxFrom.SelectedValue.ToString() == "0" && comboBoxTo.SelectedValue.ToString() == "0"))
{
using (var db = new Session2Entities())
{
var q = db.Schedules.Select(x => new
{
x.ID,
x.Date,
x.Time,
From = x.Route.Airport.IATACode,
To = x.Route.Airport1.IATACode,
x.FlightNumber,
Aircraft = x.Aircraft.Name,
x.EconomyPrice,
BusinessPrice = Math.Floor(x.EconomyPrice * 135 / 100),
FirstClassPrice = Math.Floor(x.EconomyPrice * 135 / 100 * 130 / 100),
x.Confirmed
});
q = q.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(dateTimePicker.Value));
if (comboBoxFrom.SelectedValue.ToString() != "0")
{
q = q.Where(x => x.From == comboBoxFrom.SelectedValue.ToString());
}
if (comboBoxTo.SelectedValue.ToString() != "0")
{
q = q.Where(x => x.To == comboBoxTo.SelectedValue.ToString());
}
if (!string.IsNullOrEmpty(textBoxFlight.Text))
{
q = q.Where(x => x.FlightNumber == textBoxFlight.Text);
}
switch (comboBoxSort.SelectedValue.ToString())
{
case "Date-Time":
q = q.OrderBy(x => x.Date);
break;
case "Economy Price":
q = q.OrderBy(x => x.EconomyPrice);
break;
case "Cancelled":
q = q.OrderBy(x => x.Confirmed);
break;
}
dataGridView.DataSource = q.ToList();
dataGridView.Columns["ID"].Visible = false;
dataGridView.Columns["Confirmed"].Visible = false;
}
}
else
{
MessageBox.Show("You cannot select the same airport for the 'from' and 'to' criteria");
}
}
public void SetGrid()
{
using (var session = new Session2Entities())
{
if (comboBoxFrom.SelectedValue.ToString() != comboBoxTo.SelectedValue.ToString() || (comboBoxFrom.SelectedValue.ToString() == "0" && comboBoxTo.SelectedValue.ToString() == "0"))
{
var q = session.Schedules.Select(s => new
{
s.ID,
s.Date,
s.Time,
From = s.Route.Airport.IATACode,
To = s.Route.Airport1.IATACode,
s.FlightNumber,
s.Aircraft.Name,
s.EconomyPrice,
BusinessPrice = Math.Floor((s.EconomyPrice * 135) / 100),
FirstClassPrice = Math.Floor((((s.EconomyPrice * 135) / 100) * 130) / 100),
s.Confirmed
});
// 0 == All
if (comboBoxFrom.SelectedValue.ToString() != "0")
{
q = q.Where(s => s.From == comboBoxFrom.SelectedValue.ToString());
}
if (comboBoxTo.SelectedValue.ToString() != "0")
{
q = q.Where(s => s.To == comboBoxTo.SelectedValue.ToString());
}
q = q.Where(s => s.Date == dateTimePickerOutbound.Value);
if (!string.IsNullOrEmpty(textBoxFlightNumber.Text))
{
q = q.Where(s => s.FlightNumber == textBoxFlightNumber.Text);
}
// See void SetSortBy()
switch (comboBoxSortBy.SelectedValue.ToString())
{
case "0":
q = q.OrderBy(s => s.Date);
break;
case "1":
q = q.OrderBy(s => s.EconomyPrice);
break;
case "2":
q = q.OrderBy(s => s.Confirmed);
break;
}
// Array is faster here
dataGridView.DataSource = q.ToArray();
dataGridView.Columns["ID"].Visible = false;
dataGridView.Columns["Confirmed"].Visible = false;
SetGridColor();
}
else
{
MessageBox.Show("You cannot select the same Airport for From and To");
}
}
}
public ScheduleManager()
{
_scheduleRepository = new ScheduleRepository();
_airportRepository = new AirportRepository();
_session2DbContext = new Session2Entities();
}
public AirportRepository()
{
_session2DbContext = new Session2Entities();
}
