//Удаление строки
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));
}
