private void loadmaintenancerequests(object sender, EventArgs e)
{
//load all emergency maintenance requests
maintenanceRequeststable.Rows.Clear();
using (Session2Entities db = new Session2Entities())
{
var emrequests = db.EmergencyMaintenances.ToList();
foreach (var item in emrequests)
{
var employeeID = item.Asset.EmployeeID;
var employeedetails = db.Employees.Where(emp => emp.ID == employeeID).FirstOrDefault();
string employeefullname = employeedetails.FirstName + " " + employeedetails.LastName;
object[] row = new object[6];
row[0] = item.Asset.AssetSN;
row[1] = item.Asset.AssetName;
row[2] = item.EMReportDate.ToString("yyyy-MM-dd");
row[3] = employeefullname;
row[4] = item.Asset.DepartmentLocation.Department.Name;
row[5] = item.ID;
maintenanceRequeststable.Rows.Add(row);
}
}
}
private void loadAssetstable(object sender, EventArgs e)
{
UID = GV.userID;
assetTable.Rows.Clear();
using (Session2Entities db = new Session2Entities())
{
var getAssets = db.Assets.Where(a => a.EmployeeID == UID).ToList();
foreach (var item in getAssets)
{
AID = item.ID;
object[] row = new object[5];
var lastClosedEm = (from em in db.EmergencyMaintenances
where em.AssetID == AID
orderby em.EMEndDate descending
select new
{
em.EMEndDate
}).FirstOrDefault();
if (lastClosedEm == null)
{
row[2] = "";
}
else
{
row[2] = lastClosedEm.EMEndDate;
}
row[0] = item.AssetSN;
row[1] = item.AssetName;
row[3] = db.EmergencyMaintenances.Where(a => a.AssetID == AID && a.EMEndDate != null).Count();
row[4] = AID;
assetTable.Rows.Add(row);
}
}
}
private void submitbutton_Click(object sender, EventArgs e)
{
if (techniciannote.Text == "")
{
MessageBox.Show("Enter valid technician details");
}
else if (startdatepicker.Value > enddatepicker.Value)
{
MessageBox.Show("End date cannot be before start date");
}
else
{
//getting technician note
string techNote = techniciannote.Text;
//getting EMstartdate and EMenddate
var EMstartdate = Convert.ToDateTime(startdatepicker.Value).Date;
var EMenddate = Convert.ToDateTime(enddatepicker.Value).Date;
//saving changes to the list of changed parts by overwrting to the list
using (Session2Entities db = new Session2Entities())
{
var emreq = db.EmergencyMaintenances.Where(em => em.ID == EMID).FirstOrDefault();
emreq.EMEndDate = EMenddate;
emreq.EMStartDate = EMstartdate;
emreq.EMReportDate = EMstartdate;
emreq.EMTechnicianNote = techNote;
var listofexistingparts = db.ChangedParts.Where(cp => cp.EmergencyMaintenanceID == EMID);
foreach (var existingpart in listofexistingparts)
{
db.ChangedParts.Remove(existingpart);
}
foreach (var newPart in newList)
{
ChangedPart np = new ChangedPart();
np.EmergencyMaintenanceID = EMID;
np.PartID = newPart.partid;
np.Amount = newPart.amount;
db.ChangedParts.Add(np);
}
try
{
db.SaveChanges();
MessageBox.Show("Changes saved");
refreshForm(sender, e);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("an error has occurred. Details: " + ex.Message);
}
}
}
}
private void loadAssetdetails(object sender, EventArgs e)
{
using (Session2Entities db = new Session2Entities())
{
var getdetails = db.Assets.Where(a => a.ID == AID);
label8.Text = getdetails.FirstOrDefault().DepartmentLocation.Department.Name.ToString();
label7.Text = getdetails.FirstOrDefault().AssetName;
label6.Text = getdetails.FirstOrDefault().AssetSN;
}
}
private void loadAssetdetails(object sender, EventArgs e)
{
using (Session2Entities db = new Session2Entities())
{
var getmaintenancedetails = db.EmergencyMaintenances.Where(em => em.ID == EMID).FirstOrDefault();
AID = getmaintenancedetails.AssetID;
var getassetdetails = db.Assets.Where(a => a.ID == AID).FirstOrDefault();
label6.Text = getassetdetails.AssetSN;
label7.Text = getassetdetails.AssetName;
label8.Text = getassetdetails.DepartmentLocation.Department.Name;
startdatepicker.Value = Convert.ToDateTime(getmaintenancedetails.EMStartDate).Date;
}
}
private void loginbutton_Click(object sender, EventArgs e)
{
username = this.usernamebox.Text;
password = this.passwordbox.Text;
using (Session2Entities db = new Session2Entities())
{
var getUserdetails = (from a in db.Employees
where a.Username.Equals(username)
select new
{
a
}).FirstOrDefault();
if (getUserdetails == null)
{
MessageBox.Show("Invalid Username");
}
else
{
if (getUserdetails.a.Password.Equals(password))
{
var isAdmin = getUserdetails.a.isAdmin;
if (isAdmin == true)
{
GV.isAdmin = true;
GV.userID = getUserdetails.a.ID;
MMmanagement mmForm = new MMmanagement();
this.Hide();
mmForm.ShowDialog();
Close();
}
else if (isAdmin == null)
{
GV.isAdmin = false;
GV.userID = getUserdetails.a.ID;
EMmanagementAP apform = new EMmanagementAP();
this.Hide();
apform.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("Incorrect Password");
}
}
}
}
private void loadPartslist(object sender, EventArgs e)
{
partsKvp = new Dictionary <long, string>();
using (Session2Entities db = new Session2Entities())
{
var partsList = db.Parts;
foreach (var item in partsList)
{
var pid = item.ID;
var pname = item.Name;
partsKvp.Add(pid, pname);
}
partscombobox.DataSource = new BindingSource(partsKvp, null);
partscombobox.DisplayMember = "Value";
partscombobox.ValueMember = "Key";
}
}
//method to add new EM Request
private void newEMrequest(object sender, EventArgs e)
{
string emergencydescription = emDescription.Text;
string otherconsiderations = emOthers.Text;
EmergencyMaintenance newEM = new EmergencyMaintenance();
long pid = ((KeyValuePair <long, string>)prioritybox.SelectedItem).Key;
newEM.AssetID = AID;
newEM.PriorityID = pid;
newEM.DescriptionEmergency = emergencydescription;
newEM.OtherConsiderations = otherconsiderations;
newEM.EMReportDate = DateTime.Now.Date;
newEM.EMStartDate = DateTime.Now.Date;
newEM.EMEndDate = null;
//newEM.EMTechnicianNote = null;
using (Session2Entities db = new Session2Entities())
{
db.EmergencyMaintenances.Add(newEM);
db.SaveChanges();
}
}
private void getExistingparts(object sender, EventArgs e)
{
using (Session2Entities db = new Session2Entities())
{
//getting existing changed parts
var getParts = db.ChangedParts.Where(p => p.EmergencyMaintenanceID == EMID).ToList();
if (getParts != null)
{
newList = new List <parts>();
foreach (var item in getParts)
{
parts p = new parts();
p.partid = item.PartID;
p.amount = item.Amount;
p.partname = item.Part.Name;
newList.Add(p);
currentList.Add(item);
}
loadchangedParts(sender, e);
}
}
}
private void loadprioritybox(object sender, EventArgs e)
{
using (Session2Entities db = new Session2Entities())
{
//getting priorities
var getp = from p in db.Priorities
orderby p.ID ascending
select new
{
p
};
priorities = new Dictionary <long, string>();
foreach (var item in getp)
{
var pid = item.p.ID;
var pName = item.p.Name;
priorities.Add(pid, pName);
}
prioritybox.DataSource = new BindingSource(priorities, null);
prioritybox.DisplayMember = "Value";
prioritybox.ValueMember = "Key";
}
}
