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"; } }