public ActionResult Create([Bind(Include = "buildingID,name,address,addressReference,country,state,city,district,apartmentQuantity,active,createDate,createUser,updateDate,updateUser")] Building building)
{
try
{
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
building.createDate = DateTime.Now;
building.createUser = Helper.GetCurrentUser().userID;
db.Building.Add(building);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(building));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Buildings";
objError.option = "Create-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Create([Bind(Include = "roleID,name,active,createDate,createUser,updateDate,updateUser,selected")] Role role)
{
try
{
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
role.createDate = DateTime.Now;
role.createUser = Helper.GetCurrentUser().userID;
db.Role.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Roles";
objError.option = "Create-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public Material Create(Material material)
{
var result = context.Materials.Add(material);
context.SaveChanges();
return(result);
}
public User Create(User user)
{
var result = context.Users.Add(user);
context.SaveChanges();
return(result);
}
public ActionResult Create([Bind(Include = "postID,postCategoryID,title,content,active,createDate,createUser,updateDate,updateUser")] Post post)
{
try
{
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
db.Post.Add(post);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.postCategoryID = new SelectList(db.PostCategory, "postCategoryID", "name", post.postCategoryID);
return(View(post));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Post";
objError.option = "Create-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Create([Bind(Include = "apartmentID,sectionID,name,active,createDate,createUser,updateDate,updateUser")] Apartment apartment)
{
try {
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
apartment.createDate = DateTime.Now;
apartment.createUser = Helper.GetCurrentUser().userID;
db.Apartment.Add(apartment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.sectionID = new SelectList(db.Section, "sectionID", "name", apartment.sectionID);
return(View(apartment));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Apartments";
objError.option = "Create-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Index(RoleOptionView objRoleOptionView)
{
try
{
if (DataUtil.Validation())
{
RoleOptionView objRoleOptionView2 = new RoleOptionView();
try
{
if (Request.Form["ActionForm"] == "Registrar")
{
var RemoveAll = db.RoleOption.Where(x => x.roleID == objRoleOptionView.role.roleID);
db.RoleOption.RemoveRange(RemoveAll);
db.SaveChanges();
RoleOption objRoleOption = new RoleOption();
foreach (var item in objRoleOptionView.options)
{
if (item.selected)
{
objRoleOption.roleID = objRoleOptionView.role.roleID;
objRoleOption.optionID = item.optionID;
db.RoleOption.Add(objRoleOption);
db.SaveChanges();
}
}
objRoleOptionView2.roleOptionList = db.RoleOption.Include(u => u.option).Include(u => u.role).Where(u => u.role.roleID == objRoleOptionView.role.roleID).ToList();
objRoleOptionView2.options = db.Database.SqlQuery <Option>("select o.optionid, o.name, CAST(ISNULL((select 1 from roleOptions ro where ro.roleID = @roleID and ro.optionID = o.optionID),0) AS BIT) selected, o.active, o.createdate, o.createuser, o.updatedate, o.updateuser from options o where o.active = 1", new SqlParameter("@roleID", objRoleOptionView.role.roleID)).ToList();
objRoleOptionView2.role = db.Role.Find(objRoleOptionView.role.roleID);
ModelState.Clear();
}
}
catch (Exception ex)
{
}
return(View(objRoleOptionView2));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "RoleOptions";
objError.option = "Index-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Index(UserRoleView objUserRoleView)
{
try
{
if (DataUtil.Validation())
{
UserRoleView objUserRoleView2 = new UserRoleView();
try
{
if (Request.Form["ActionForm"] == "Registrar")
{
var RemoveAll = db.UserRole.Where(x => x.userID == objUserRoleView.user.userID);
db.UserRole.RemoveRange(RemoveAll);
db.SaveChanges();
UserRole objUserRole = new UserRole();
foreach (var item in objUserRoleView.roles)
{
if (item.selected)
{
objUserRole.userID = objUserRoleView.user.userID;
objUserRole.roleID = item.roleID;
db.UserRole.Add(objUserRole);
db.SaveChanges();
}
}
objUserRoleView2.userRoleList = db.UserRole.Include(u => u.role).Include(u => u.user).Where(u => u.user.userID == objUserRoleView.user.userID).ToList();
objUserRoleView2.roles = db.Database.SqlQuery <Role>("select r.roleid, r.name, CAST(ISNULL((select 1 from userRoles ur where ur.userID = @userID and ur.roleID = r.roleID),0) AS BIT) selected, r.active, r.createdate, r.createuser, r.updatedate, r.updateuser from roles r where r.active = 1 ", new SqlParameter("@userID", objUserRoleView.user.userID)).ToList();
objUserRoleView2.user = db.User.Find(objUserRoleView.user.userID);
ModelState.Clear();
}
}
catch (Exception ex)
{
}
return(View(objUserRoleView2));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "UserRoles";
objError.option = "Index-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public void AddBuilding()
{
var newBuilding = new Building(Year, CountFloors);
_db.Buildings.Add(newBuilding);
_db.SaveChanges();
Buildings.Add(newBuilding);
Vertices.Add(newBuilding.ToVertex());
ToStartState();
}
public void Execute(IJobExecutionContext context)
{
Debug.WriteLine("Time to update!");
var db = new BuildingContext();
var url = "https://data.melbourne.vic.gov.au/resource/q8hp-qgps.json";
var jsonString = Download_JSON(url);
List <Buildinginfo> buildings = new List <Buildinginfo>();
buildings = JsonConvert.DeserializeObject <
List <Buildinginfo> >(jsonString);
//Debug.WriteLine("Count: " + buildings.Count);
//Buildinginfo b = buildings[0];
//Debug.WriteLine("Building 1: " + b.suburb);
//remove null rateings & duplicate records
buildings = buildings.Where(b => b.accessibility_rating != null).ToList();
buildings = buildings.DistinctBy(b => b.property_id).ToList();
db.Database.ExecuteSqlCommand("TRUNCATE TABLE Buildinginfoes");
foreach (Buildinginfo b in buildings)
{
db.Buildinginfoes.Add(b);
}
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "Name,Architect")] BuildingModel buildingModel)
{
try
{
if (ModelState.IsValid)
{
db.Buildings.Add(buildingModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (DataException dex)
{
//Log the error
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(buildingModel));
}
public User Create(User user)
{
using (var context
= new BuildingContext(ConnectionString))
{
var result = context.Users.Add(user);
context.SaveChanges();
return(result);
}
}
public ActionResult Create(User user)
{
try
{
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
db.User.Add(user);
db.SaveChanges();
UserRole objUserRole = new UserRole();
objUserRole.userID = user.userID;
objUserRole.roleID = 4;
db.UserRole.Add(objUserRole);
db.SaveChanges();
ApartmentUser objApartmentUser = new ApartmentUser();
objApartmentUser.userID = user.userID;
objApartmentUser.apartmentID = user.apartmentID;
objApartmentUser.principal = user.principal;
db.ApartmentUser.Add(objApartmentUser);
db.SaveChanges();
return(RedirectToAction("Index", new { id = user.apartmentID }));
}
return(View(user));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "ApartmentUsers";
objError.option = "Create-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public bool Delete(int id)
{
using (var context
= new BuildingContext(ConnectionString))
{
var user = context.Users.Find(id);
user.IsDeleted = true;
context.SaveChanges();
return(user.IsDeleted);
}
}
public void SendV2(string chatID, string userReceive, string message)
{
var sender = ConnectedUsers.First(u => u.ID.Equals(Context.ConnectionId));
Clients.All.broadcastMessage(chatID, sender.Name, userReceive, message);
Chat objChat = new Chat();
objChat.chatCode = chatID;
objChat.createDate = DateTime.Now;
objChat.message = "<div class='ui-chatbox-msg' style='display: block; max-width: 208px;'><b>" + sender.Name + ": </b><span>" + message + "</span></div>";
db.Chat.Add(objChat);
db.SaveChanges();
}
public void Save(Report report)
{
var entity = _buildingContext.Reports.Include(r => r.Quantities).ToList().SingleOrDefault(r => r.Id == report.Id) ?? new Entities.Report();
entity.CreatedDate = DateTime.UtcNow;
entity.ReportDate = report.Date;
entity.WorkersCount = report.NumberOfWorkers;
entity.ReporterId = report.ReporterId.Value;
if (entity.Quantities != null)
{
entity.Quantities.RemoveAll(q => report.Work.All(w => w.EstimationId != q.EstimationId));
foreach (var work in report.Work)
{
var quantity = entity.Quantities.SingleOrDefault(q => q.EstimationId == work.EstimationId);
if (quantity != null)
{
quantity.Quantity = work.Quantity;
}
else
{
entity.Quantities.Add(new ReportQuantity
{
EstimationId = work.EstimationId,
Quantity = work.Quantity
});
}
}
}
else
{
entity.Quantities = report.Work.Select(w => new ReportQuantity
{
EstimationId = w.EstimationId,
Quantity = w.Quantity
}).ToList();
}
if (report.Id == 0)
{
_buildingContext.Reports.Add(entity);
}
_buildingContext.SaveChanges();
if (report.Id == 0)
{
report.SetId(entity.Id);
}
}
public void Create(FileStream stream, int mainContractorId)
{
var hssfwb = new XSSFWorkbook(stream);
var sheet = hssfwb.GetSheetAt(0);
for (var i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++)
{
var row = sheet.GetRow(i);
var entity = new Estimation
{
EstimationId = row.GetCell(0).ToString(),
SpecNumber = row.GetCell(1).ToString(),
Description = row.GetCell(2).ToString(),
Unit = row.GetCell(3).ToString(),
Quantity = (decimal)row.GetCell(4).NumericCellValue,
UnitPrice = (decimal)row.GetCell(5).NumericCellValue,
Amount = (decimal)row.GetCell(6).NumericCellValue,
CompanyId = mainContractorId
};
_buildingContext.Estimations.Add(entity);
}
_buildingContext.SaveChanges();
}
public string Post([FromBody] TblEntryoff tblEntryoff)
{
try
{
// WebapiContext context = new WebapiContext();
using (BuildingContext Context = new BuildingContext())
{
Context.TblEntryoffs.Add(tblEntryoff);
Context.SaveChanges();
return("success ");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ImportKota(FormCollection formCollection)
{
var dataList = new List <Lokasi>();
if (Request != null)
{
HttpPostedFileBase file = Request.Files["UploadKota"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var listData = new Lokasi();
listData.ID = Convert.ToInt32(workSheet.Cells[rowIterator, 1].Value);
listData.IDProvinsi = workSheet.Cells[rowIterator, 2].Value.ToString();
listData.Provinsi = workSheet.Cells[rowIterator, 3].Value.ToString();
listData.Kota = workSheet.Cells[rowIterator, 4].Value.ToString();
dataList.Add(listData);
}
}
}
}
using (BuildingContext importDB = new BuildingContext())
{
foreach (var item in dataList)
{
importDB.Lokasi.Add(item);
}
importDB.SaveChanges();
}
return(View("Index"));
}
public ActionResult UpdatePassword(User objUser)
{
try
{
if (objUser.username == "" || objUser.password == "" || objUser.newpassword == "" || objUser.username == null || objUser.password == null || objUser.newpassword == null)
{
objUser.result = 3;
}
else
{
User oUser = new User();
oUser = db.User.FirstOrDefault(u => u.username.ToUpper() == objUser.username.ToUpper() && u.password == objUser.password);
if (objUser != null)
{
oUser.password = objUser.newpassword;
db.Entry(oUser).State = EntityState.Modified;
db.SaveChanges();
objUser.result = 1;
}
else
{
objUser.result = 2;
}
}
return(View(objUser));
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Home";
objError.option = "UpdatePassword-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public void GenerateEstimation()
{
var optionsBuilder = new DbContextOptionsBuilder <BuildingContext>();
optionsBuilder.UseSqlServer("Server=.;Database=BuildingDatabase;User Id=sa;Password=Bubelsoft1");
var buildingcontext = new BuildingContext(optionsBuilder.Options);
var rand = new Random();
for (var m = 1; m < 13; m++)
{
for (var i = 1; i < 15; i++)
{
var guid = Guid.NewGuid().ToString().Substring(0, 5);
var createdDate = DateTime.UtcNow;
var report = new Report
{
CreatedDate = createdDate,
ReportDate = new DateTime(2017, m, rand.Next(1, 27)),
WorkersCount = rand.Next(4, 20),
ReporterId = 1,
Quantities = new List <ReportQuantity>
{
new ReportQuantity
{
EstimationId = rand.Next(30000, 100000),
Quantity = rand.Next(1, 10)
}
}
};
buildingcontext.Reports.Add(report);
buildingcontext.SaveChanges();
}
}
}
public void AddNewProductionLineName(BuildingContext context, string LineName, int count)
{
List <ProductionLineName> _lineName = new List <ProductionLineName>();
if (LineName == "L")
{
for (int i = 0; i < count; i++)
{
_lineName.Add(new ProductionLineName
{
SystemCode = $"L{i + 1}9",
LineCode = $"L{i + 1}",
DisplayCode = $"L{i + 1}",
});
}
_lineName.Add(new ProductionLineName
{
SystemCode = "LJ9",
LineCode = "L1A",
DisplayCode = "L1",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LK9",
LineCode = "L1B",
DisplayCode = "L1",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LH9",
LineCode = "L2A",
DisplayCode = "L2",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LI9",
LineCode = "L2A",
DisplayCode = "L2",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LL9",
LineCode = "L3A",
DisplayCode = "L3",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LM9",
LineCode = "L3B",
DisplayCode = "L3",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LN9",
LineCode = "L4A",
DisplayCode = "L4",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LO9",
LineCode = "L4B",
DisplayCode = "L4",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LP9",
LineCode = "L5A",
DisplayCode = "L5",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LQ9",
LineCode = "L5B",
DisplayCode = "L5",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LR9",
LineCode = "L6A",
DisplayCode = "L6",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "LT9",
LineCode = "L6B",
DisplayCode = "L6",
});
context.ProductionLineNames.AddRange(_lineName);
context.SaveChanges();
return;
}
if (LineName == "M")
{
_lineName.Add(new ProductionLineName
{
SystemCode = "MA9", // begin H ->M
LineCode = "M1",
DisplayCode = "M1",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "MB9", // begin H ->M
LineCode = "M2",
DisplayCode = "M2",
});
_lineName.Add(new ProductionLineName
{
SystemCode = "MC9", // begin H ->M
LineCode = "M3",
DisplayCode = "M3",
});
}
//Line O
for (int i = 0; i < count; i++)
{
if (LineName == "M")
{
_lineName.Add(new ProductionLineName
{
SystemCode = $"M{(char)(i + 72)}9", // begin H ->M
LineCode = $"M{i + 1}A",
DisplayCode = $"M{i + 1}",
});
_lineName.Add(new ProductionLineName
{
SystemCode = $"M{(char)(i + 72 + 1)}9",
LineCode = $"M{i + 1}B",
DisplayCode = $"M{i + 1}",
});
}
else
{
_lineName.Add(new ProductionLineName
{
SystemCode = $"{LineName}{(char)(i + 65)}9",
LineCode = $"{LineName}{i + 1}",
DisplayCode = $"{LineName}{i + 1}",
});
}
}
context.ProductionLineNames.AddRange(_lineName);
context.SaveChanges();
}
public ActionResult Profile([Bind(Include = "userID,categoryUserID,name,lastname,username,password,active,email,dni,phonenumber,createDate,createUser,updateDate,updateUser")] User user, HttpPostedFileBase postedFile)
{
try
{
if (DataUtil.Validation())
{
if (ModelState.IsValid)
{
var objUserEmail = db.User.FirstOrDefault(u => u.email == user.email && u.userID != user.userID);
if (objUserEmail != null)
{
user.messageErrorEmail = "El email ingresado ya existe!.";
}
else
{
user.updateDate = DateTime.Now;
user.updateUser = Helper.GetCurrentUser().userID;
user.name = user.name.ToUpper();
user.lastname = user.lastname.ToUpper();
user.imageURL = System.Configuration.ConfigurationManager.AppSettings["userImgURL"] + user.userID.ToString() + ".jpg";
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
if (postedFile != null)
{
var versions = new Dictionary <string, string>();
string path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["userImgURLFinal"]);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
postedFile.SaveAs(path + Helper.GetCurrentUser().userID.ToString() + Path.GetExtension(postedFile.FileName));
versions.Add("", "maxwidth=120&maxheight=120&format=jpg");
foreach (var suffix in versions.Keys)
{
postedFile.InputStream.Seek(0, SeekOrigin.Begin);
ImageBuilder.Current.Build(
new ImageJob(
postedFile.InputStream,
path + user.userID.ToString() + suffix,
new Instructions(versions[suffix]),
false,
true));
}
ViewBag.Message = "File uploaded successfully.";
}
}
return(RedirectToAction("Profile"));
}
return(View(user));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "Users";
objError.option = "Edit-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public void Building()
{
using (var context = new BuildingContext(Database))
{
if (context.Database.Exists())
{
Console.WriteLine("BuildingContext is existing");
return;
}
context.Database.Create();
Console.WriteLine("BuildingContext is created successfully");
Building l = new Building
{
Name = "L",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 6; i++)
{
l.ProductionLines.Add(new ProductionLine {
LineName = $"L{i}"
});
}
context.Buildings.Add(l);
Building E = new Building
{
Name = "E",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 7; i++)
{
E.ProductionLines.Add(new ProductionLine {
LineName = $"E{i}"
});
}
context.Buildings.Add(E);
Building I = new Building
{
Name = "I",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 11; i++)
{
I.ProductionLines.Add(new ProductionLine {
LineName = $"I{i}"
});
}
context.Buildings.Add(I);
Building O = new Building
{
Name = "O",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 2; i++)
{
O.ProductionLines.Add(new ProductionLine {
LineName = $"O{i}"
});
}
context.Buildings.Add(O);
Building P = new Building
{
Name = "P",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 7; i++)
{
P.ProductionLines.Add(new ProductionLine {
LineName = $"P{i}"
});
}
context.Buildings.Add(P);
Building M = new Building
{
Name = "M",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 3; i++)
{
M.ProductionLines.Add(new ProductionLine {
LineName = $"M{i}"
});
}
context.Buildings.Add(M);
Building J = new Building
{
Name = "J",
ProductionLines = new List <ProductionLine>()
};
for (int i = 1; i <= 3; i++)
{
J.ProductionLines.Add(new ProductionLine {
LineName = $"J{i}"
});
}
context.Buildings.Add(J);
context.SaveChanges();
// add line O
AddNewProductionLineName(context, "O", 2);
// add line P
AddNewProductionLineName(context, "P", 7);
// add line I
AddNewProductionLineName(context, "L", 7);
// add line E
AddNewProductionLineName(context, "I", 11);
// add line L
AddNewProductionLineName(context, "J", 3);
// add line J
AddNewProductionLineName(context, "M", 3);
// add line L
AddNewProductionLineName(context, "E", 7);
try
{
context.Database.ExecuteSqlCommand("DROP TABLE [__MigrationHistory]");
context.SaveChanges();
}
catch { }
}
}