public void OnAddEquipment()
{
Model.Equipment equipment = new Model.Equipment()
{
EquipmentId = SelectedEquipment.EquipmentId
};
CustomerEquipments.Add(SelectedEquipment);
_customerRepository.AddCustomerEquipment(equipment, SelectedCustomer.CustomerID);
}
private Model.Equipment UpdateEquipment()
{
var equipment = new Model.Equipment();
((DelegateCommand)UpdateCommand).RaiseCanExecuteChanged();
_eventAggregator.GetEvent <AfterEquipmentCreated>().Publish();
//_equipmentRepository.Update(equipment);
return(equipment);
}
public void Update(Model.Equipment model)
{
var Entity = _context.Equipments.Find(model.EquipmentId);
if (Entity == null)
{
return;
}
//_context.Entry(model).CurrentValues.SetValues(model);
}
private Model.Equipment GetEquipmentByOracleDataReader(OracleDataReader rdr)
{
string[] colsName;
int[] colsOrdinal;
const int colsCount = 5;
Model.Equipment equipment;
colsName = new string[colsCount] {
"DBID", "DESCIRPTION", "MACID",
"OWNER", "STATUS"
};
colsOrdinal = new int[colsCount];
if (GetColumnsOrdinal(rdr, colsName, colsOrdinal) < 0)
{
throw (new Exception("Error"));
}
equipment = new Model.Equipment();
for (int i = 0; i < colsCount; i++)
{
if (colsOrdinal[i] < 0 || rdr.IsDBNull(colsOrdinal[i]))
{
continue;
}
switch (i)
{
case 0:
equipment.DbId = rdr.GetInt32(colsOrdinal[i]);
break;
case 1:
equipment.Description = rdr.GetString(colsOrdinal[i]);
break;
case 2:
equipment.MacId = rdr.GetString(colsOrdinal[i]);
break;
case 3:
equipment.Owner = rdr.GetString(colsOrdinal[i]);
break;
case 4:
equipment.Status = rdr.GetString(colsOrdinal[i]);
break;
}
}
return(equipment);
}
private List <Model.Equipment> getEquipmentList(DataTable dt)
{
List <Model.Equipment> equipmentList = new List <Model.Equipment>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Model.Equipment equipment = new Model.Equipment();
if (dt.Rows[i]["DBID"] != null)
{
equipment.DbId = long.Parse(dt.Rows[i]["DBID"].ToString());
}
if (dt.Rows[i]["MACID"] != null)
{
equipment.MacId = dt.Rows[i]["MACID"].ToString();
}
if (dt.Rows[i]["OWNER"] != null)
{
equipment.Owner = dt.Rows[i]["OWNER"].ToString();
}
if (dt.Rows[i]["STATUS"] != null)
{
equipment.Status = dt.Rows[i]["STATUS"].ToString();
}
if (dt.Rows[i]["DESCIRPTION"] != null)
{
equipment.Description = dt.Rows[i]["DESCIRPTION"].ToString();
}
equipmentList.Add(equipment);
}
return(equipmentList);
}
public EquipmentWrapper(Model.Equipment model)
{
Model = model;
}
public void AddCustomerEquipment(Model.Equipment equipment, int customerId)
{
_context.Customers.Where(c => c.CustomerId == customerId).FirstOrDefault().Equipments.Add(equipment);
}
public void Remove(Model.Equipment model)
{
_context.Equipments.Remove(model); //delete equipment from the db
}
public void Add(Model.Equipment equipment)
{
_context.Equipments.Add(equipment); //call insert to add new equipement to table
}
