//Удаление строки private void DeleteData(EQUIPMENT focusedRow) { if (focusedRow == null) { return; } ////во всех режимах выбранного АРМ удалим ссылки на удаляемое оборудование, если оно яв-ся корневым if (focusedRow.EQ_PARENT_ID == null && arm_one != null && arm_one.MODE != null) { foreach (var mode in arm_one.MODE.Where(p => p.MODE_EQ_ID == focusedRow.EQ_ID)) { mode.MODE_EQ_ID = (int?)null; } methodsEntities.SaveChanges(); } //сначала удалим все строки, для которых данная является родителем foreach (var eq in methodsEntities.EQUIPMENT.Where(p => p.EQ_PARENT_ID == focusedRow.EQ_ID)) { methodsEntities.EQUIPMENT.Remove(eq); } methodsEntities.EQUIPMENT.Remove(focusedRow); //удаление из контекста methodsEntities.SaveChanges(); data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id)); RaisePropertyChanged(() => data); RefreshData(); }
private string CalculateNextInspectionDate(TRACK_INSPECTION lastInspection, EQUIPMENT equipment) { if (lastInspection == null) { return(equipment.NextInspectionDate.ToShortDateString()); } else { var inspectEvery = equipment.InspectEvery; var typeEvery = equipment.InspectEveryUnitTypeId; if (typeEvery == (int)InspectEveryUnitType.Hours) { var added = inspectEvery / equipment.op_hrs_per_day; if (added.HasValue) { return(lastInspection.inspection_date.AddDays(added.Value).ToShortDateString()); } else { return(lastInspection.inspection_date.AddHours(inspectEvery).ToShortDateString()); } } else if (typeEvery == (int)InspectEveryUnitType.Days) { return(lastInspection.inspection_date.AddDays(inspectEvery).ToShortDateString()); } else { return(equipment.NextInspectionDate.ToShortDateString()); } } }
private void btnOK_Click(object sender, EventArgs e) { if (option == "Add") { EQUIPMENT rm = new EQUIPMENT(); rm.roomId = cbbPhongHoc.Text; rm.company = txtCongTy.Text; rm.equipmentId = txtMaThietBi.Text; rm.equipmentName = txtTenThietBi.Text; rm.dateOfInstallation = dateTimePicker_Ngaydat.Value; if (BUS_EquipmentData.Instance.BUS_CHECKEQUIPMENT(rm) == 0) { MessageBox.Show("Mã thiết bị đã bị trùng! Vui lòng thay đổi"); } else { BUS_EquipmentData.Instance.BUS_SETEQUIPMENT(rm); MessageBox.Show("Thêm thành công!"); } } else { txtMaThietBi.Text = equipmentid; EQUIPMENT rm2 = new EQUIPMENT(); rm2.roomId = cbbPhongHoc.Text; rm2.company = txtCongTy.Text; rm2.dateOfInstallation = dateTimePicker_Ngaydat.Value; rm2.equipmentId = txtMaThietBi.Text; rm2.equipmentName = txtTenThietBi.Text; BUS_EquipmentData.Instance.BUS_UPDATEEQUIPMENT(rm2); MessageBox.Show("Cập nhập thành công!"); } this.Dispose(); refresh(Text1); }
public ActionResult DeleteConfirmed(decimal id) { EQUIPMENT eQUIPMENT = db.EQUIPMENTS.Find(id); db.EQUIPMENTS.Remove(eQUIPMENT); db.SaveChanges(); return(RedirectToAction("Index")); }
private void CancelData(Object o) { isEnabled = false; equipmentNew = new EQUIPMENT(); RaisePropertyChanged(() => eqId); RaisePropertyChanged(() => eqModel); RaisePropertyChanged(() => eqSerial); }
private void SaveData(Object o) { if (eqId == null || eqId == 0) { MessageBox.Show("Выберите название оборудования."); return; } if (String.IsNullOrEmpty(eqModel)) { MessageBox.Show("Заполните поле 'Модель'."); return; } if (String.IsNullOrEmpty(eqSerial)) { MessageBox.Show("Заполните поле 'Серийный номер'."); return; } int selectedRowIdPrev = 0; equipmentNew.EQ_ARM_ID = arm_id; if (selectedRow != null) { selectedRowIdPrev = selectedRow.EQ_ID; } if (!addInRoot && selectedRow == null) { MessageBox.Show( "Выберите корневую строку или поставьте признак 'Добавлять оборудование в корень дерева'."); return; } else if (!addInRoot && selectedRow != null) { equipmentNew.EQ_PARENT_ID = selectedRow.EQ_ID; } try { methodsEntities.EQUIPMENT.Add(equipmentNew); methodsEntities.SaveChanges(); } catch (Exception) { throw; } data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id)); RaisePropertyChanged(() => data); RefreshData(); equipmentNew = new EQUIPMENT(); RaisePropertyChanged(() => equipmentNew); RaisePropertyChanged(() => eqId); RaisePropertyChanged(() => eqModel); RaisePropertyChanged(() => eqSerial); RaisePropertyChanged(() => eqF); RaisePropertyChanged(() => eqInMode); isEnabled = false; }
public ActionResult Edit([Bind(Include = "EQUIPMENT_ID,EQUIPMENT_NAME,QUANTITY")] EQUIPMENT eQUIPMENT) { if (ModelState.IsValid) { db.Entry(eQUIPMENT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(eQUIPMENT)); }
public EquipmentViewModelNew(MethodsEntities methodsEntities, ARM arm_one) { this.arm_one = arm_one; this.methodsEntities = methodsEntities; this.arm_id = arm_one.ARM_ID; data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id)); EquipmentTypes = new ObservableCollection <EQUIPMENT_TYPE>(methodsEntities.EQUIPMENT_TYPE); equipmentNew = new EQUIPMENT(); isEnabled = false; }
public ActionResult Create([Bind(Include = "EQUIPMENT_ID,EQUIPMENT_NAME,QUANTITY")] EQUIPMENT eQUIPMENT) { if (ModelState.IsValid) { db.EQUIPMENTS.Add(eQUIPMENT); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(eQUIPMENT)); }
// GET: Equipments/Delete/5 public ActionResult Delete(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EQUIPMENT eQUIPMENT = db.EQUIPMENTS.Find(id); if (eQUIPMENT == null) { return(HttpNotFound()); } return(View(eQUIPMENT)); }
private Equipment GetEquipment(EQUIPMENT equipment) { switch (equipment) { case EQUIPMENT.COMPUTER: return(new Computer()); case EQUIPMENT.TAPERECORDER: return(new TapeRecorder()); case EQUIPMENT.NOTHING: default: return(null); } }
private static void LogEQUIPMENT(EQUIPMENT eq, string logHeader) { //Log.Trace(logHeader + "uploadEventCode=" + eq.uploadEventCode); //Log.Trace(logHeader + "sn=" + eq.sn); //Log.Trace(logHeader + "accountId=" + eq.accountId); //Log.Trace( logHeader + "settingsRefId=" + eq.settingsRefId ); //LogSpecifiedDate( eq.time, eq.timeSpecified, logHeader, "time" ); //Log.Trace(logHeader + "partNumber=" + eq.partNumber); //Log.Trace(logHeader + "jobNumber=" + eq.jobNumber); //LogSpecifiedDate(eq.setupDate, eq.setupDateSpecified, logHeader, "setupDate"); //Log.Trace(logHeader + "setupTech=" + eq.setupTech); //Log.Trace(logHeader + "languageCode=" + eq.languageCode); //Log.Trace(logHeader + "location=" + eq.location); //Log.Trace(logHeader + "softwareVersion=" + eq.softwareVersion); //Log.Trace(logHeader + "hardwareVersion=" + eq.hardwareVersion); //LogSpecifiedProp(eq.operationMinutes, eq.operationMinutesSpecified, logHeader, "operationMinutes"); //Log.Trace(logHeader + "dataVersion=" + eq.dataVersion); }
private void SaveData(Object o) { if (selectedEquipmets == null || !selectedEquipmets.Any()) { return; //оборудование не выбрано } if (!addInRoot && selectedRow == null) { MessageBox.Show( "Выберите корневую строку или поставьте признак 'Добавлять оборудование в корень дерева'."); return; } int selectedRowIdPrev = 0; if (selectedRow != null) { selectedRowIdPrev = selectedRow.EQ_ID; } foreach (var eq in selectedEquipmets) { equipmentNew = new EQUIPMENT(); equipmentNew.EQ_EQT_ID = (eq as EQUIPMENT_TYPE).EQT_ID; equipmentNew.EQ_ARM_ID = arm_id; equipmentNew.EQ_PARENT_ID = selectedRowIdPrev; equipmentNew.EQ_MODEL = String.Empty; equipmentNew.EQ_IN_MODE = false; methodsEntities.EQUIPMENT.Add(equipmentNew); } try { methodsEntities.SaveChanges(); } catch (Exception) { throw; } data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id)); RaisePropertyChanged(() => data); RefreshData(); selectedEquipmets = new List <Object>(); }
public IHttpActionResult GetEquipment(string id) { EquipmentViewModel equipment = new EquipmentViewModel(); using (var context = new EquipmentEntities()) { EQUIPMENT emp = context.EQUIPMENTs.Where(s => s.ID == id).FirstOrDefault(); if (emp != null) { equipment.ID = emp.ID; equipment.Type = emp.Type; equipment.Name = emp.Name; equipment.Status = emp.Status; equipment.Description = emp.Description; } else { return(NotFound()); } } return(Ok(equipment)); }
private void StartActivity(int subject) { int teacher = 0; int group = 0; int activity = choiceActivity(); EQUIPMENT equipment = EQUIPMENT.NOTHING; ROOM room = ROOM.CLASSROOM; SUBACTIVITIES subActivities = SUBACTIVITIES.NOTHING; if (activity != 4) { teacher = ChoiceTeacher(subject); if (teacher == -2) { Console.WriteLine("//|Process stop|\\\\"); return; } if (teacher != -1) { group = ChoiseTeacherGroup(subject, teacher); if (group == -2) { Console.WriteLine("//|Process stop|\\\\"); return; } } } switch (activity) { case 1: equipment = ChoiceEQUIPMENT(); room = ChoiceROOM(); subActivities = ChoiceSUBACTIVITIES(); break; case 6: equipment = ChoiceEQUIPMENT(); subActivities = ChoiceSUBACTIVITIES(); break; case 2: case 3: case 4: case 5: case 7: equipment = ChoiceEQUIPMENT(); break; } if (teacher == -1) { int tCount = infoService.GetSubjTeacherCount(subject); int gCount = 0; for (int i = 0; i < tCount; i++) { gCount = infoService.GetTeacherGroupCount(subject, i); for (int j = 0; j < gCount; j++) { service.StartActivity(subject, equipment, subActivities, room, i, j, activity); } } } else if (group == -1) { int gCount = 0; gCount = infoService.GetTeacherGroupCount(subject, teacher); for (int j = 0; j < gCount; j++) { service.StartActivity(subject, equipment, subActivities, room, teacher, j, activity); } } else { service.StartActivity(subject, equipment, subActivities, room, teacher, group, activity); } }
public void BUS_SETEQUIPMENT(EQUIPMENT eq) { DAL_EquipmentData.Instance.DAL_SetEquipment(eq); }
public void BUS_UPDATEEQUIPMENT(EQUIPMENT eq2) { DAL_EquipmentData.Instance.DAL_UpdateEquipment(eq2); }
public bool StartActivity(int sub, EQUIPMENT Equip, SUBACTIVITIES SubAct, ROOM Room, int tIndex, int gIndex, int activity) { Subject subject = subjects[sub]; Teacher teacher; Group group; Room room = GetRoom(Room); Equipment equipment = GetEquipment(Equip); ISubActivities subActivities = GetSubactivities(SubAct); int successFactor = 0; if (activity != 4) { teacher = staff[subject][tIndex]; group = teacher.Groups[gIndex]; } else { List <Group> teachersGroups = new List <Group>(); if (staff[subject].Count == 0) { return(false); } teacher = staff[subject][0]; foreach (Teacher persone in staff[subject]) { teachersGroups.AddRange(persone.Groups); } subject.Lectures(teachersGroups, equipment); return(true); } switch (activity) { case 1: successFactor = subject.Lab(group, equipment, room, subActivities); break; case 2: successFactor = subject.Credit(group); break; case 3: successFactor = subject.Examination(group, equipment); break; case 5: successFactor = subject.ModulControlWork(group, equipment); break; case 6: successFactor = subject.Practice(group, equipment, subActivities); break; case 7: successFactor = subject.TermPaper(group, equipment); break; default: return(false); } return(true); }
public int BUS_CHECKEQUIPMENT(EQUIPMENT eq) { return(DAL_EquipmentData.Instance.DAL_CheckEquipment(eq)); }