public static void UploadTable(string path)
{
try
{
string[] Load = File.ReadAllLines(path);
using (AccidentContext db = new AccidentContext())
{
foreach (var VARIABLE in Load)
{
try
{
string[] Loads = VARIABLE.Split(new char[] { ';' });
AccidentObj accident = new AccidentObj();
accident.DataTime = Loads[1];
accident.Adress = Loads[2];
accident.Accident = Loads[3];
accident.TimeAccident = Loads[4];
accident.AddDispetcher = Loads[5];
accident.RemoveDispetcher = Loads[6];
accident.Computer = Loads[7];
accident.District = Loads[8];
accident.Kind = Loads[9];
db.Accidents.Add(accident);
}
catch {}
}
db.SaveChanges();
}
}
catch (Exception e)
{
myException = new MyException(e);
}
}
/// <summary>
/// Добавление происшествия
/// </summary>
/// <param name="district">Район</param>
/// <param name="adress">Адрес</param>
/// <param name="accident">Происшествие</param>
/// <param name="timeAccident">Время происшествия</param>
public static void AddAccident(AccidentObj accident)
{
try
{
using (AccidentContext db = new AccidentContext())
{
db.Accidents.Add(accident);
db.SaveChanges();
}
}
catch (Exception e)
{
myException = new MyException(e);
}
}
/// <summary>
/// создание таблицы
/// </summary>
public static void CreateTable()
{
try
{
using (AccidentContext db = new AccidentContext())
{
AccidentObj accident = new AccidentObj("", "", "", "");
db.Accidents.Add(accident);
db.SaveChanges();
}
}
catch (Exception e)
{
myException = new MyException(e);
}
}
/// <summary>
/// Удаление происшествия
/// </summary>
/// <param name="objAccident"></param>
public static void DeleteAccident(AccidentObj accident)
{
try
{
using (AccidentContext db = new AccidentContext())
{
var accidents = db.Accidents.Where(p => p.DataTime == accident.DataTime);
accidents.FirstOrDefault().Kind = "Удален";
accidents.FirstOrDefault().RemoveDispetcher = Environment.UserName;
db.SaveChanges();
}
}
catch (Exception e)
{
myException = new MyException(e);
}
Transfer = true;
}
public static void ChangeAccident(AccidentObj oldAccident, AccidentObj newAccident)
{
try
{
using (AccidentContext db = new AccidentContext())
{
var accidents = db.Accidents.Where(p => p.DataTime == oldAccident.DataTime);
accidents.FirstOrDefault().Kind = "Изменен";
accidents.FirstOrDefault().RemoveDispetcher = Environment.UserName;
db.Accidents.Add(newAccident);
db.SaveChanges();
}
}
catch (Exception e)
{
myException = new MyException(e);
}
Transfer = true;
//AccidentList = copyAccidents.GetRange(0, copyAccidents.Count);
}