public List <RepairType> GetAll()
{
using (repairContext = new RepairContext())
{
return(repairContext.RepairTypes.ToList());
}
}
public List <Car> GetAll()
{
using (repairContext = new RepairContext())
{
return(repairContext.Cars.ToList());
}
}
public RepairType Get(int id)
{
using (repairContext = new RepairContext())
{
return(repairContext.RepairTypes.Find(id));
}
}
private void CreateTablePart()
{
try
{
DataTable tableofParts = new DataTable();
DataColumn PartIdColumn = new DataColumn("Номер запчати", typeof(int));
DataColumn PartNameColumn = new DataColumn("Наименование детали", typeof(string));
DataColumn PartUnitColumn = new DataColumn("Еденица измерения", typeof(string));
tableofParts.Columns.AddRange(new DataColumn[]
{
PartIdColumn,
PartNameColumn,
PartUnitColumn
});
using (RepairContext context = new RepairContext())
{
var query = context.Parts.ToList();
int i = 0;
foreach (var p in query)
{
DataRow newRow = tableofParts.NewRow();
newRow["Номер запчати"] = p.PartId;
newRow["Наименование детали"] = p.PartName;
newRow["Еденица измерения"] = p.PartUnit;
tableofParts.Rows.Add(newRow);
i++;
}
dataGridViewParts.DataSource = tableofParts;
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "Ошибка");
}
}
public Car Get(int id)
{
using (repairContext = new RepairContext())
{
return(repairContext.Cars.Find(id));
}
}
public void Add(Car Car)
{
using (repairContext = new RepairContext())
{
repairContext.Cars.Add(Car);
repairContext.SaveChanges();
}
}
public void Add(RepairType repairType)
{
using (repairContext = new RepairContext())
{
repairContext.RepairTypes.Add(repairType);
repairContext.SaveChanges();
}
}
public void Update(RepairType repairType)
{
using (repairContext = new RepairContext())
{
var item = repairContext.RepairTypes.Find(repairType.Id);
repairContext.Entry(item).CurrentValues.SetValues(repairType);
repairContext.SaveChanges();
}
}
public void Update(Car Car)
{
using (repairContext = new RepairContext())
{
var item = repairContext.Cars.Find(Car.Id);
repairContext.Entry(item).CurrentValues.SetValues(Car);
repairContext.SaveChanges();
}
}
public void Delete(int id)
{
using (repairContext = new RepairContext())
{
var item = repairContext.RepairTypes.Find(id);
if (item != null)
{
repairContext.RepairTypes.Remove(item);
repairContext.SaveChanges();
}
}
}
private void buttonDepartureDelete_Click(object sender, EventArgs e)
{
try
{
RepairContext db = new RepairContext();
int did = Convert.ToInt32(dataGridViewDeparture.SelectedCells[0].Value);
var d = db.Departures.Find(did);
db.Departures.Remove(d);
db.SaveChanges();
tabControl1_SelectedIndexChanged(sender, e);
}
catch (Exception gg)
{
MessageBox.Show(gg.Message);
}
}
protected override void Seed(FixMeApplication.Models.ApplicationDbContext context)
{
// This method will be called after migrating to the latest version.
RepairContext repairContext = new RepairContext();
var repairTypes1 = repairContext.RepairTypes.
Where(e => e.Id % 2 == 0)
.ToList();
var repairTypes2 = repairContext.RepairTypes.
Where(e => e.Id % 2 == 1)
.ToList();
repairContext.RepairShops.Add(new RepairShop(
)
{
Name = "Repair Alpha",
Address = "42.5105141,27.4740824",
RepairTypes = repairTypes1
});
repairContext.RepairShops.Add(new RepairShop(
)
{
Name = "Repair Beta",
Address = "42.5033381,27.4559481",
RepairTypes = repairTypes2
});
repairContext.RepairShops.Add(new RepairShop(
)
{
Name = "Repair Gamma",
Address = "42.5156312,27.4347075",
RepairTypes = repairTypes1
});
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
}
private void CreateTableArrival()
{
try
{
DataTable tableofArrival = new DataTable();
DataColumn ArrivalIdColumn = new DataColumn("Номер поступления", typeof(int));
DataColumn ArrivalPartNameColumn = new DataColumn("Наименование запчасти", typeof(string));
DataColumn ArrivalDocNameColumn = new DataColumn("Наименование документа", typeof(string));
DataColumn ArrivalQuantityColumn = new DataColumn("Количество", typeof(int));
DataColumn ArrivalCostColumn = new DataColumn("Цена", typeof(decimal));
DataColumn ArrivalSumColumn = new DataColumn("Сумма", typeof(decimal));
tableofArrival.Columns.AddRange(new DataColumn[]
{
ArrivalIdColumn,
ArrivalPartNameColumn,
ArrivalDocNameColumn,
ArrivalQuantityColumn,
ArrivalCostColumn,
ArrivalSumColumn
});
using (RepairContext context = new RepairContext())
{
var query = context.Arrivals.Include(c => c.Part).Include(a => a.ArrivalDoc).ToList();
int i = 0;
foreach (var a in query)
{
DataRow newRow = tableofArrival.NewRow();
newRow["Номер поступления"] = a.ArrivalId;
newRow["Наименование запчасти"] = a.Part.PartName;
newRow["Наименование документа"] = a.ArrivalDoc.ArrivalDocName;
newRow["Количество"] = a.ArrivalQuantity;
newRow["Цена"] = a.ArrivalCost;
newRow["Сумма"] = a.ArrivalSum;
tableofArrival.Rows.Add(newRow);
i++;
}
dataGridViewArrival.DataSource = tableofArrival;
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "Ошибка");
}
}
/// <summary>
/// 初始化基础数据
/// </summary>
/// <param name="context"></param>
private static void InitData(RepairContext context)
{
InitSqlScript(context);
string dir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "baseData");
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
return;
}
var files = Directory.GetFiles(dir, "*.sql");
if (files.Length <= 0)
{
return;
}
using (var connection = context.Database.GetDbConnection())
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
foreach (var file in files)
{
string name = Path.GetFileName(file);
if (string.IsNullOrEmpty(name))
{
continue;
}
//检查系统表是否存在数据
var hasData = connection.ExecuteScalar($"select count(1) from {name}");
if (hasData != null)
{
continue; //已经存在数据不再初始化
}
string script = File.ReadAllText(file);
if (string.IsNullOrEmpty(script))
{
continue;
}
connection.Execute(script);
}
}
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
using (RepairContext db = new RepairContext())
{
if (tabControl1.SelectedIndex == 0)
{
CreateTablePart();
}
if (tabControl1.SelectedIndex == 1)
{
CreateTableArrival();
CreateTableArrivalDoc();
}
if (tabControl1.SelectedIndex == 2)
{
CreateTableDeparture();
CreateTableDeparturelDoc();
}
}
}
private void CreateTableDeparturelDoc()
{
try
{
DataTable tableofDepartureDoc = new DataTable();
DataColumn DepartureDocIdColumn = new DataColumn("Номер документа", typeof(int));
DataColumn DepartureDocNameColumn = new DataColumn("Наименование документа", typeof(string));
DataColumn DepartureDocSenderColumn = new DataColumn("Отправитель", typeof(string));
DataColumn DepartureDocRecipientColumn = new DataColumn("Получатель", typeof(string));
DataColumn DepartureDocDateColumn = new DataColumn("Дата", typeof(DateTime));
tableofDepartureDoc.Columns.AddRange(new DataColumn[]
{
DepartureDocIdColumn,
DepartureDocNameColumn,
DepartureDocSenderColumn,
DepartureDocRecipientColumn,
DepartureDocDateColumn
});
using (RepairContext context = new RepairContext())
{
var query = context.DepartureDocs.ToList();
int i = 0;
foreach (var d in query)
{
DataRow newRow = tableofDepartureDoc.NewRow();
newRow["Номер документа"] = d.DepartureDocId;
newRow["Наименование документа"] = d.DepartureDocName;
newRow["Отправитель"] = d.DepartureDocSender;
newRow["Получатель"] = d.DepartureDocRecipient;
newRow["Дата"] = d.DepartureDocDate;
tableofDepartureDoc.Rows.Add(newRow);
i++;
}
dataGridViewDepartureDoc.DataSource = tableofDepartureDoc;
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "Ошибка");
}
}
public RepairsController(RepairContext context)
{
_context = context;
if (!context.Repairs.Any())
{
_context.AddRange(new List <Repair>
{
new Repair
{
Requester = new Requester {
Name = "John Smith", PhoneNumber = "0675214572", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "West corner of Microsoft Way, Redmond", AssetType = "Street Light"
}
},
new Repair
{
Requester = new Requester {
Name = "Claire Smith", PhoneNumber = "0622486247", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "Intersection of Four Lanes & Cycle Track, Berlin", AssetType = "Generator"
}
},
new Repair
{
Requester = new Requester {
Name = "Luis Vasque", PhoneNumber = "0614756328", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "Out front of central station, The Hague", AssetType = "Switch Box"
}
}
});
_context.SaveChanges();
}
}
private void Hook()
{
if (hooked)
{
return;
}
equipContext = new EquipmentContext(settings);
repairContext = new RepairContext(settings);
if (hooked)
{
TreeHooks.Instance.RemoveHook("TreeStart", root);
}
root = Agil.CreateBehavior(equipContext, repairContext);
TreeHooks.Instance.InsertHook("TreeStart", 0, root);
Logger.AgilMessage("Hooked.");
hooked = true;
timer.Stop();
timer.Start();
}
private void CreateTableDeparture()
{
try
{
DataTable tableofDeparture = new DataTable();
DataColumn DepartureIdColumn = new DataColumn("Номер списания", typeof(int));
DataColumn DeparturePartNameColumn = new DataColumn("Наименование запчасти", typeof(string));
DataColumn DepartureDocNameColumn = new DataColumn("Наименование документа", typeof(string));
DataColumn DepartureQuantityColumn = new DataColumn("Количество", typeof(int));
tableofDeparture.Columns.AddRange(new DataColumn[]
{
DepartureIdColumn,
DeparturePartNameColumn,
DepartureDocNameColumn,
DepartureQuantityColumn,
});
using (RepairContext context = new RepairContext())
{
var query = context.Departures.Include(c => c.Part).Include(a => a.DepartureDoc).ToList();
int i = 0;
foreach (var d in query)
{
DataRow newRow = tableofDeparture.NewRow();
newRow["Номер списания"] = d.DepartureId;
newRow["Наименование запчасти"] = d.Part.PartName;
newRow["Наименование документа"] = d.DepartureDoc.DepartureDocName;
newRow["Количество"] = d.DepartureQuantity;
tableofDeparture.Rows.Add(newRow);
i++;
}
dataGridViewDeparture.DataSource = tableofDeparture;
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "Ошибка");
}
}
private void CreateTableArrivalDoc()
{
try
{
DataTable tableofArrivalDoc = new DataTable();
DataColumn ArrivalDocIdColumn = new DataColumn("Номер документа", typeof(int));
DataColumn ArrivalDocNameColumn = new DataColumn("Наименование документа", typeof(string));
DataColumn ArrivalDocProviderColumn = new DataColumn("Поставщик", typeof(string));
DataColumn ArrivalDocDateColumn = new DataColumn("Дата", typeof(DateTime));
tableofArrivalDoc.Columns.AddRange(new DataColumn[]
{
ArrivalDocIdColumn,
ArrivalDocNameColumn,
ArrivalDocProviderColumn,
ArrivalDocDateColumn
});
using (RepairContext context = new RepairContext())
{
var query = context.ArrivalDocs.ToList();
int i = 0;
foreach (var a in query)
{
DataRow newRow = tableofArrivalDoc.NewRow();
newRow["Номер документа"] = a.ArrivalDocId;
newRow["Наименование документа"] = a.ArrivalDocName;
newRow["Поставщик"] = a.ArrivalDocProvider;
newRow["Дата"] = a.ArrivalDocDate;
tableofArrivalDoc.Rows.Add(newRow);
i++;
}
dataGridViewArrivalDoc.DataSource = tableofArrivalDoc;
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "Ошибка");
}
}
/// <summary>
/// 初始化视图、函数、存储过程等
/// </summary>
private static void InitSqlScript(RepairContext context)
{
string dir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "schema");
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
return;
}
var files = Directory.GetFiles(dir, "*.sql");
if (files.Length <= 0)
{
return;
}
using (var connection = context.Database.GetDbConnection())
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
foreach (var file in files)
{
string name = Path.GetFileName(file);
if (string.IsNullOrEmpty(name))
{
continue;
}
string script = File.ReadAllText(file);
if (string.IsNullOrEmpty(script))
{
continue;
}
connection.Execute(script);
}
}
}
public static void Initialize(RepairContext context)
{
context.Database.EnsureCreated();
// Look for any existing repairs.
if (context.Repair.Any())
{
return; // DB has been seeded
}
var repairs = new Repair[]
{
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-16-2017"), RepairType = "Oil Change", Miles = 83015, Workshop = "Home", Workdone = "Used Mobil 1 oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("07-12-2016"), RepairType = "Oil Change", Miles = 74815, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-11-2016"), RepairType = "Oil Change", Miles = 68600, Workshop = "Walmart, Lynwood", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("04-12-2009"), RepairType = "Oil Change", Miles = 72431, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("07-28-2015"), RepairType = "Oil Change", Miles = 62717, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("11-19-2008"), RepairType = "Oil Change", Miles = 65420, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("10-29-2007"), RepairType = "Oil Change", Miles = 59528, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("04-06-2007"), RepairType = "Oil Change", Miles = 51323, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("11-21-2006"), RepairType = "Oil Change", Miles = 44111, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("05-12-2006"), RepairType = "Oil Change", Miles = 39220, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-19-2015"), RepairType = "Oil Change", Miles = 56319, Workshop = "Walmart", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("10-23-2014"), RepairType = "Oil Change", Miles = 51624, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("04-05-2014"), RepairType = "Oil Change", Miles = 45261, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("10-05-2013"), RepairType = "Oil Change", Miles = 63990, Workshop = "Subaru dealership", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Toyota RAV4 V6 3.5L", RepairDate = DateTime.Parse("10-28-2012"), RepairType = "Oil Change", Miles = 102864, Workshop = "Toyota Dealership, Kirkland", Workdone = "Used Pennzoil Oil and Fram oil filter."
},
new Repair {
Vehicle = "Honda Civic 1.7L", RepairDate = DateTime.Parse("04-02-2006"), RepairType = "Oil Change", Miles = 36441, Workshop = "Honda Dealership, Roseville", Workdone = "Castrol 5W-30 oil and Fram oil filter."
}
};
foreach (Repair r in repairs)
{
context.Repair.Add(r);
}
context.SaveChanges();
}
public RepairsController(RepairContext ctx, ILoggerFactory logfactory)
{
_context = ctx;
_logger = logfactory.CreateLogger("RazorMvcGarage.Controllers.RepairsController");
}
