public IActionResult CreateDepartament(Departament departament)
{
if (ModelState.IsValid)
{
var username = User.Identity.Name;
departament.Customer = (from customer in _context.CustomerInformations
where customer.Name == username
select customer).FirstOrDefault();
departament.Manager = (from users in _context.LoginUsers
where users.Name == departament.ManagerName
select users).FirstOrDefault();
_context.Departaments.Add(departament);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departament));
}
static void Main(string[] args)
{
Console.Write("Enter departament's name:");
string deptName = Console.ReadLine();
Console.WriteLine("Enter worker data: ");
Console.Write("Name:");
string name = Console.ReadLine();
Console.Write("Level");
WorkerLevel level = Enum.Parse <WorkerLevel>(Console.ReadLine());
Console.Write("Base salary:");
double basesalary = double.Parse(Console.ReadLine());
Departament dept = new Departament(deptName);
Worker worker = new Worker(name, level, basesalary, dept);
Console.Write("How many contracts for worker?");
int n = int.Parse(Console.ReadLine());
for (int i = 0; i < n; i++)
{
Console.WriteLine($"Enter {i} contracts data:");
DateTime date = DateTime.Parse(Console.ReadLine());
double valorperhour = double.Parse(Console.ReadLine());
int hours = int.Parse(Console.ReadLine());
HourContract contract = new HourContract(date, valorperhour, hours);
worker.AddContract(contract);
}
Console.Write("Entre com mes e ano para saber o ganho");
string monthAndYear = Console.ReadLine();
int month = int.Parse(monthAndYear.Substring(0, 2));
int year = int.Parse(monthAndYear.Substring(3));
Console.WriteLine("Name: " + worker.Name);
Console.WriteLine("Departament" + worker.Departament.Name);
Console.WriteLine("Income for" + monthAndYear + ":" + worker.Income(year, month));
}
/// <summary>
/// Добавить.
/// </summary>
private void Insert()
{
string productName = ProductNameTextBox.Text;
int amount = Convert.ToInt32(AmountTextBox.Text);
string unit = UnitComboBox.Text;
double price = Convert.ToDouble(PriceTextBox.Text);
int departamentId = Departament.GetDepartamentId(DepartamentNamesComboBox.Text);
// проверяем на уникальность
Product product = Product.GetProductByProductName(productName);
if (product.ProductName == productName)
{
MessageBox.Show($"Товар с наименованием '{productName}' уже зарегистрирован!", "Ошибка");
}
else
{
Product.Insert(productName, amount, unit, price, departamentId);
MessageBox.Show($"Товар '{productName}' успешно добавлен в базу данных.", "Сообщение");
Close();
}
}
public override List <T> SuperRetrieveByName <T>(BaseEntity entity)
{
var ObjDpt = (Departament)entity;
var lst = new List <T>();
List <Departament> MyList = new List <Departament>();
var Query = Context.SP_CRUD_DPT((int)CrudActionEnum.SuperRetrieveByName, ObjDpt.ID_Dpt, ObjDpt.IdSession, ObjDpt.Name_Dpt).ToList();
foreach (SP_CRUD_DPTResult Element in Query)
{
Departament Obj = new Departament(Element.ID_DPT, Element.NAME_DPT, Element.STATE_DPT, Element.CREATEBY_DPT, Element.UPDATEBY_DPT,
Element.CREATEDATE_DPT, Element.UPDATEDATE_DPT);
MyList.Add(Obj);
}
if (MyList.Count > 0)
{
foreach (var obj in MyList)
{
lst.Add((T)Convert.ChangeType(obj, typeof(T)));
}
}
return(lst);
}
private void filterButton_Click(object sender, RoutedEventArgs e)
{
try
{
Status statusFilter = (Status)statusBox.SelectedItem;
if (statusFilter.Id == -1)
{
statusFilter = null;
}
Departament departmenFilter = (Departament)departmentBox.SelectedItem;
if (departmenFilter.Id == -1)
{
departmenFilter = null;
}
Post postFilter = (Post)postBox.SelectedItem;
if (postFilter.Id == -1)
{
postFilter = null;
}
Filter filterOptions = new Filter()
{
Status = statusFilter,
Departament = departmenFilter,
Post = postFilter,
LastName = lastNameBox.Text
};
IEnumerable <Person> people = dataManage.GetPeople(filterOptions);
peopleDataGrid.ItemsSource = RefreshPeopleData(dataManage.GetPeople(filterOptions));
}
catch (System.Data.SqlClient.SqlException exception)
{
MessageBox.Show("Ошибка: " + exception.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ActionResult Edit(int id, Departament departamentRequest)
{
try
{
if (ModelState.IsValid)
{
Departament dep = db.Departamente.SingleOrDefault(b => b.DepId.Equals(id));
if (TryUpdateModel(dep))
{
dep.Denumire = departamentRequest.Denumire;
dep.NrAngajati = departamentRequest.NrAngajati;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(departamentRequest));
}
catch (Exception e)
{
return(View(departamentRequest));
}
}
public static void Update()
{
data.Clear();
using (var cn = Database.CreateConnection())
{
cn.Open();
OracleCommand cmd = new OracleCommand(selectSql, cn);
OracleDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int id = reader.GetInt32(0);
Departament departament = DepartamentsDataSet.FindById(reader.GetInt32(1));
Employee employee = EmployeesDataSet.FindById(reader.GetInt32(2));
data.Add(new DepartEmpl(id, departament, employee));
}
}
}
}
public void Enviar()
{
// Avalia se já existe dados no banco, se sim não faz nada
if (_context.Departament.Any() ||
_context.Vendedor.Any() ||
_context.Pedido.Any())
{
return;
}
Departament d1 = new Departament(1, "Artes Gráficas");
Departament d2 = new Departament(2, "Atendimento");
Departament d3 = new Departament(3, "Malharia");
Departament d4 = new Departament(4, "Administrativo");
Departament d5 = new Departament(5, "Servicos Gerais");
Vendedor v1 = new Vendedor(123, "Isabela", "Designer Gráfico", "*****@*****.**", 983602916, d1);
Vendedor v2 = new Vendedor(456, "Camila", "Recepcionista", "*****@*****.**", 97654357, d2);
Vendedor v3 = new Vendedor(789, "Joel", "Recortisa", "*****@*****.**", 97314357, d3);
Vendedor v4 = new Vendedor(342, "Jether", "Gerente", "*****@*****.**", 97114357, d4);
Vendedor v5 = new Vendedor(457, "Fabricio", "Estoquista", "*****@*****.**", 94454357, d5);
Pedido p1 = new Pedido(1, new DateTime(2018, 10, 25), new DateTime(2018, 10, 30), 500.0, v1, StatusPedido.Finalizado, d1);
Pedido p2 = new Pedido(2, new DateTime(2018, 11, 05), new DateTime(2018, 11, 12), 700.0, v1, StatusPedido.Finalizado, d1);
Pedido p3 = new Pedido(3, new DateTime(2018, 11, 15), new DateTime(2018, 12, 01), 200.0, v1, StatusPedido.Finalizado, d1);
Pedido p4 = new Pedido(4, new DateTime(2019, 01, 15), new DateTime(2019, 01, 30), 300.0, v2, StatusPedido.Finalizado, d2);
Pedido p5 = new Pedido(5, new DateTime(2019, 01, 18), new DateTime(2019, 01, 31), 200.0, v2, StatusPedido.Finalizado, d2);
Pedido p6 = new Pedido(6, new DateTime(2019, 02, 11), new DateTime(2019, 02, 18), 300.0, v2, StatusPedido.Finalizado, d2);
Pedido p7 = new Pedido(7, new DateTime(2019, 02, 15), new DateTime(2019, 02, 27), 1300.0, v4, StatusPedido.Finalizado, d3);
Pedido p8 = new Pedido(8, new DateTime(2019, 03, 15), new DateTime(2019, 03, 30), 100.0, v5, StatusPedido.Finalizado, d3);
// Adicionar dados ao BD
_context.AddRange(d1, d2, d3, d4, d5);
_context.AddRange(v1, v2, v3, v4, v5);
_context.AddRange(p1, p2, p3, p4, p5, p6, p7, p8);
_context.SaveChanges();
}
public ActionResult Create([Bind(Include = "DepartamentId,Name,Latitud,Longitud")] Departament departament)
{
if (ModelState.IsValid)
{
//db.Departaments.Add(departament);
//verifica dupplicati
// if (db.Departaments.Any(d => d.Name.Equals(departament.Name)))
//var singleUser = users.SingleOrDefault();
//var singleDepartamentName = db.Departaments.SingleOrDefault().Name;
if (db.Departaments.Any(d => d.Name.Equals(departament.Name)))
{
ModelState.AddModelError(string.Empty, "Esiste già un Registro con lo stesso valore");
}
else
{
// ??
db.Departaments.Add(departament);
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception exception)
{
//if (exception.InnerException?.InnerException != null && exception.InnerException.InnerException.Message.Contains("_Index"))
//{
// ModelState.AddModelError(string.Empty, "Esiste gia un Registro con lo stesso valore");
//}
//else
//{
ModelState.AddModelError(string.Empty, exception.Message);
//}
}
}
}
return(View(departament));
}
private void loadButton_Click(object sender, EventArgs e)
{
ana.addDepartaments("2016");
Departament dep1 = ana.allMunicipalities("2016", departament1.Text);
chart1.Series["Departamento1"].Points.AddXY(2016, dep1.Production);
Departament dep2 = ana.allMunicipalities("2016", departament2.Text);
chart1.Series["Departamento2"].Points.AddXY(2016, dep2.Production);
Departament dep3 = ana.allMunicipalities("2016", departament3.Text);
chart1.Series["Departamento3"].Points.AddXY(2016, dep3.Production);
ana.addDepartaments("2017");
Departament dep4 = ana.allMunicipalities("2017", departament1.Text);
chart1.Series["Departamento1"].Points.AddXY(2017, dep4.Production);
Departament dep5 = ana.allMunicipalities("2017", departament2.Text);
chart1.Series["Departamento2"].Points.AddXY(2017, dep5.Production);
Departament dep6 = ana.allMunicipalities("2017", departament3.Text);
chart1.Series["Departamento3"].Points.AddXY(2017, dep6.Production);
ana.addDepartaments("2018");
Departament dep7 = ana.allMunicipalities("2018", departament1.Text);
chart1.Series["Departamento1"].Points.AddXY(2018, dep7.Production);
Departament dep8 = ana.allMunicipalities("2018", departament2.Text);
chart1.Series["Departamento2"].Points.AddXY(2018, dep8.Production);
Departament dep9 = ana.allMunicipalities("2018", departament3.Text);
chart1.Series["Departamento3"].Points.AddXY(2018, dep9.Production);
MessageBox.Show("Se ha completado la grafica");
}
public ActionResult DeleteConfirmed(int id)
{
if (!AdminpanelMethods.CheckAdminLogin())
{
return(RedirectToAction("Index", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Departament departament = db.Departaments.Find(id);
if (departament == null)
{
return(HttpNotFound());
}
else
{
db.Departaments.Remove(departament);
db.SaveChanges();
return(Json(new { success = "deleted" }, JsonRequestBehavior.AllowGet));
}
}
// GET: Departaments/Create
public ActionResult Create()
{
var departament = new Departament();
var username = User.Identity.GetUserName();
departament.Customer = (from customer in db.CustomerInformation
where customer.Name == username
select customer).FirstOrDefault();
var listOfUsers = (from loginUser in db.LoginUser
where loginUser.Customer.Name == username
select loginUser).ToList().Select(u => new SelectListItem
{
Text = u.Name,
Value = u.Name
});
ViewBag.ListOfUsers = listOfUsers;
return(View());
}
public async Task <ActionResult> AddDepartament(Departament departament)
{
if (ModelState.IsValid)
{
var data = await payrollDb.Holdings.Where(x => x.Id == departament.HoldingId).FirstOrDefaultAsync();
if (data != null)
{
Departament departaments = new Departament
{
Name = departament.Name,
HoldingId = departament.HoldingId
};
await payrollDb.Departaments.AddAsync(departaments);
await payrollDb.SaveChangesAsync();
ModelState.AddModelError("", "Success");
}
ModelState.AddModelError("", "Check holding name");
}
return(RedirectToAction(nameof(AddDepartament)));
}
public async Task <IActionResult> Edit(int id, Departament departament)
{
if (!ModelState.IsValid)
{
return(View(departament));
}
if (await DepartamentExists(id))
{
return(RedirectToAction(nameof(Error), new { message = "ID mismacth!" }));
}
try
{
await _departamentService.UpdateAsync(departament);
return(RedirectToAction(nameof(Index)));
}
catch (ApplicationException e)
{
return(RedirectToAction(nameof(Error), new { message = e.Message }));
}
}
/// <summary>
/// Добавить.
/// </summary>
private void Insert()
{
string log = LogTextBox.Text;
string pass = PasswordBox.Password;
string fullname = FullnameTextBox.Text;
string tel = TelTextBox.Text;
int departamentId = Departament.GetDepartamentId(DepartamentNamesComboBox.Text);
int lvl = Convert.ToInt32(LvlsComboBox.Text);
// проверяем на уникальность
Worker worker = Worker.GetWorkerByLog(log);
if (worker.Log == log)
{
MessageBox.Show($"Пользователь с логином {log} уже зарегистрирован!", "Ошибка");
}
else
{
Worker.Insert(log, pass, fullname, tel, departamentId, lvl);
MessageBox.Show($"Пользователь {fullname} успешно добавлен в базу данных.", "Сообщение");
Close();
}
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SallesRecord.Any())
{
return; //DB is already seeded
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Electronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller sel1 = new Seller(1, "Eduardo Hermes", "*****@*****.**", new DateTime(2000, 9, 13), 1000.00, d1);
Seller sel2 = new Seller(2, "Amanda Hermes", "*****@*****.**", new DateTime(1999, 4, 27), 1000.00, d3);
SallesRecord sale = new SallesRecord(1, new DateTime(2020, 5, 31), 11000.00, SaleStatus.Billed, sel1);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(sel1, sel2);
_context.SallesRecord.AddRange(sale);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departament.Any() ||
_context.SalesRecord.Any() ||
_context.Saller.Any())
{
return;
}
Departament d1 = new Departament(new int(), "Eletronics");
Departament d2 = new Departament(new int(), "Ferramentas");
Saller s1 = new Saller(new int(), "Danilo", "*****@*****.**", new DateTime(1999, 3, 12), 1234.00, d1);
Saller s2 = new Saller(new int(), "Tais", "*****@*****.**", new DateTime(1999, 3, 12), 1234.00, d2);
SalesRecord w1 = new SalesRecord(new int(), new DateTime(23, 11, 12), 1200.00, SalesStatus.Pending, s1);
SalesRecord w2 = new SalesRecord(new int(), new DateTime(23, 11, 12), 1100.00, SalesStatus.Billed, s2);
_context.Departament.AddRange(d1, d2);
_context.Saller.AddRange(s1, s2);
_context.SalesRecord.AddRange(w1, w2);
_context.SaveChanges();
}
public IActionResult EditDepartament(int?id)
{
Departament departament = _context.Departaments.Find(id);
var username = User.Identity.Name;
departament.Customer = (from customer in _context.CustomerInformations
where customer.Name == username
select customer).FirstOrDefault();
var listOfUsers = (from users in _context.LoginUsers
where users.Customer.Name == username
select users).ToList().Select(u => new SelectListItem
{
Text = u.Name,
Value = u.Name
});
ViewBag.ListOfUsers = listOfUsers;
return(View(departament));
}
public ActionResult DeleteConfirmed(int id)
{
Departament departament = db.Departaments.Find(id);
db.Departaments.Remove(departament);
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception exception)
{
if (exception.InnerException?.InnerException != null && exception.InnerException.InnerException.Message.Contains("REFERENCE"))
{
ModelState.AddModelError(string.Empty, "Il Registro non puo essere eliminato perche esso ha degli altri registri collegati!");
}
else
{
ModelState.AddModelError(string.Empty, exception.Message);
}
return(View(departament));
}
}
public void TestServiceWithAutoFac()
{
try
{
// Create your builder.
var builder = new ContainerBuilder();
builder.RegisterType <DepartamentRepository>().As <IDepartamentRepository>();
builder.RegisterType <MainContext>().InstancePerRequest();
builder.RegisterType <DepartamentService>().As <IDepartamentService>();
Container = builder.Build();
using (var scope = Container.BeginLifetimeScope())
{
var writer = scope.Resolve <IDepartamentService>();
var dep = new Departament()
{
Name = "TI", Description = "Tecnologias de la comunicación"
};
var oldDep = writer.Get(x => x.Name.Equals("TI"));
if (oldDep == null)
{
writer.Insert(dep);
System.Console.Write("AAUP: " + dep.Id);
}
else
{
System.Console.Write("AAUP siii: " + oldDep.Name);
}
}
}
catch (Exception e)
{
System.Console.Write("AAUP: " + e.Message);
}
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // banco de dados ja foi populado
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.00, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 1500.00, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1998, 4, 21), 3500.00, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 2500.00, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 01, 09), 4000.00, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 03, 04), 3000.00, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.00, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 04), 7000.00, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.00, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.00, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.00, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.00, SaleStatus.Billed, s1);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6
);
_context.SaveChanges();
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
if (DepartamentsDataGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < DepartamentsDataGrid.SelectedItems.Count; i++)
{
if (DepartamentsDataGrid.SelectedItems[i] is Departament departament)
{
MessageBoxResult result = MessageBox.Show($"Вы действительно хотите удалить {departament.DepartamentName} из базы данных?", "Предупреждение", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
try
{
Departament.Delete(departament.DepartamentId);
MessageBox.Show($"{departament.DepartamentName} успешно удален из базы данных.", "Сообщение");
Refresh();
}
catch
{ }
}
}
}
}
}
public void Seed()
{
//testar se existe dados na tabela
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SallesRecord.Any())
{
return; // A base de dados Já foi populada
}
Departament d1 = new Departament(1, "TI", "Alberto");
Departament d2 = new Departament(2, "Impressão", "João");
Departament d3 = new Departament(3, "Pesos e Medidas", "Maria");
Departament d4 = new Departament(4, "Suprimentos", "Carlos");
Seller s1 = new Seller(1, "Vendedor Sistema", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Vendedor Sistema1", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
Seller s3 = new Seller(3, "Vendedor Sistema2", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Seller s4 = new Seller(4, "Vendedor Sistema3", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d4);
SallesRecord r1 = new SallesRecord(1, new DateTime(1998, 1, 21), 11000.0, SaleStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(1998, 1, 20), 11000.0, SaleStatus.Billed, s2);
SallesRecord r3 = new SallesRecord(3, new DateTime(1998, 1, 21), 11000.0, SaleStatus.Billed, s3);
SallesRecord r4 = new SallesRecord(4, new DateTime(1998, 1, 27), 11000.0, SaleStatus.Billed, s4);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SallesRecord.AddRange(r1, r2, r3, r4);
_context.SaveChanges();
}
public void Update(Departament modifiedItem)
{
_context.Departament.Update(modifiedItem);
_context.SaveChanges();
}
public void Seed()
{
//Teste se já existe dado na base de dados
if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; //Banco já populado
}
//Cria registros de departamentos
Departament d1 = new Departament {
Name = "Computers"
};
Departament d2 = new Departament {
Name = "Garden"
};
Departament d3 = new Departament {
Name = "Office"
};
Departament d4 = new Departament {
Name = "Bedroom"
};
Departament d5 = new Departament {
Name = "Living"
};
//Cria registros de vendedores
Seller s1 = new Seller("Tinky Winky", "*****@*****.**", new DateTime(1989, 5, 20), 1999.0, d1);
Seller s2 = new Seller("Dipsy the Green", "*****@*****.**", new DateTime(1989, 10, 31), 3500.0, d2);
Seller s3 = new Seller("Laa-Laa", "*****@*****.**", new DateTime(1988, 10, 31), 23350.0, d1);
Seller s4 = new Seller("Xuxa Meneguel", "*****@*****.**", new DateTime(1999, 1, 20), 3500.0, d4);
Seller s5 = new Seller("Po the Red", "*****@*****.**", new DateTime(2000, 3, 19), 4500.0, d3);
Seller s6 = new Seller("Power Ranger Amarelo", "*****@*****.**",
new DateTime(1977, 5, 24), 15900.0, d2);
//Cria registros de vendas
SalesRecord r1 = new SalesRecord(new DateTime(2018, 09, 25), 11000.0, SaleStatus.BILLED, s1);
SalesRecord r2 = new SalesRecord(new DateTime(2018, 09, 4), 7000.0, SaleStatus.BILLED, s5);
SalesRecord r3 = new SalesRecord(new DateTime(2018, 09, 13), 4000.0, SaleStatus.CANCELED, s4);
SalesRecord r4 = new SalesRecord(new DateTime(2018, 09, 1), 8000.0, SaleStatus.BILLED, s1);
SalesRecord r5 = new SalesRecord(new DateTime(2018, 09, 21), 3000.0, SaleStatus.BILLED, s3);
SalesRecord r6 = new SalesRecord(new DateTime(2018, 09, 15), 2000.0, SaleStatus.BILLED, s1);
SalesRecord r7 = new SalesRecord(new DateTime(2018, 09, 28), 13000.0, SaleStatus.BILLED, s2);
SalesRecord r8 = new SalesRecord(new DateTime(2018, 09, 11), 4000.0, SaleStatus.BILLED, s4);
SalesRecord r9 = new SalesRecord(new DateTime(2018, 09, 14), 11000.0, SaleStatus.PENDING, s6);
SalesRecord r10 = new SalesRecord(new DateTime(2018, 09, 7), 9000.0, SaleStatus.BILLED, s6);
SalesRecord r11 = new SalesRecord(new DateTime(2018, 09, 13), 6000.0, SaleStatus.BILLED, s2);
SalesRecord r12 = new SalesRecord(new DateTime(2018, 09, 25), 7000.0, SaleStatus.PENDING, s3);
SalesRecord r13 = new SalesRecord(new DateTime(2018, 09, 29), 10000.0, SaleStatus.BILLED, s4);
SalesRecord r14 = new SalesRecord(new DateTime(2018, 09, 4), 3000.0, SaleStatus.BILLED, s5);
SalesRecord r15 = new SalesRecord(new DateTime(2018, 09, 12), 4000.0, SaleStatus.BILLED, s1);
SalesRecord r16 = new SalesRecord(new DateTime(2018, 10, 5), 2000.0, SaleStatus.BILLED, s4);
SalesRecord r17 = new SalesRecord(new DateTime(2018, 10, 1), 12000.0, SaleStatus.BILLED, s1);
SalesRecord r18 = new SalesRecord(new DateTime(2018, 10, 24), 6000.0, SaleStatus.BILLED, s3);
SalesRecord r19 = new SalesRecord(new DateTime(2018, 10, 22), 8000.0, SaleStatus.BILLED, s5);
SalesRecord r20 = new SalesRecord(new DateTime(2018, 10, 15), 8000.0, SaleStatus.BILLED, s6);
SalesRecord r21 = new SalesRecord(new DateTime(2018, 10, 17), 9000.0, SaleStatus.BILLED, s2);
SalesRecord r22 = new SalesRecord(new DateTime(2018, 10, 24), 4000.0, SaleStatus.BILLED, s4);
SalesRecord r23 = new SalesRecord(new DateTime(2018, 10, 19), 11000.0, SaleStatus.CANCELED, s2);
SalesRecord r24 = new SalesRecord(new DateTime(2018, 10, 12), 8000.0, SaleStatus.BILLED, s5);
SalesRecord r25 = new SalesRecord(new DateTime(2018, 10, 31), 7000.0, SaleStatus.BILLED, s3);
SalesRecord r26 = new SalesRecord(new DateTime(2018, 10, 6), 5000.0, SaleStatus.BILLED, s4);
SalesRecord r27 = new SalesRecord(new DateTime(2018, 10, 13), 9000.0, SaleStatus.PENDING, s1);
SalesRecord r28 = new SalesRecord(new DateTime(2018, 10, 7), 4000.0, SaleStatus.BILLED, s3);
SalesRecord r29 = new SalesRecord(new DateTime(2018, 10, 23), 12000.0, SaleStatus.BILLED, s5);
SalesRecord r30 = new SalesRecord(new DateTime(2018, 10, 12), 5000.0, SaleStatus.BILLED, s2);
/*Uma vez que nossos objetos estão criados, basta adicionar eles no banco de dados, usando o EntityFramework*/
//AddRange permite adicionar um conjunto de objetos. Em outras palavras, vários objetos.
_context.Departament.AddRange(d1, d2, d3, d4, d5);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
//Método que efetiva o registro/gravação no banco de dados
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
public Employee(string firstName, string LastName, int id, decimal salary, Departament departament)
: base(firstName, LastName, id)
{
this.Departament = departament;
this.Salary = salary;
}
public static void Initialize(DocsDbContext context)
{
context.Database.EnsureCreated();
if (!context.Departament.Any())
{
var deps = new Departament[]
{
new Departament()
{
Name = "Відділ ІТ"
},
new Departament()
{
Name = "Торговий"
},
new Departament()
{
Name = "Юристи"
}
};
foreach (var item in deps)
{
context.Departament.Add(item);
}
context.SaveChanges();
}
if (!context.Employee.Any())
{
var employee = new Employee[]
{
new Employee()
{
Name = "Максим Біловус",
FirstName = "Максим",
SecondName = "Біловус",
Departament = context.Departament.FirstOrDefault(c => c.Name == "Відділ ІТ").Id
}
};
foreach (var item in employee)
{
context.Employee.Add(item);
}
context.SaveChanges();
}
if (!context.Company.Any())
{
var companies = new Company[]
{
new Company()
{
Name = "24 Карата"
},
new Company()
{
Name = "Діадема"
},
new Company()
{
Name = "Тіара"
},
new Company()
{
Name = "Вінтелепорт"
},
new Company()
{
Name = "Датагруп"
},
new Company()
{
Name = "Укртелеком"
}
};
foreach (var item in companies)
{
context.Company.Add(item);
}
context.SaveChanges();
}
//var username = "******";
//if (context.Users.Count(x => x.Email == username) == 0)
//{
// var user = context.Users.FirstOrDefault(u => u.UserName == username);
// if (user == null)
// {
// var hashedPassword = new PasswordHasher<IdentityUser>().HashPassword(null, username);
// user = new IdentityUser()
// {
// UserName = username,
// Email = username,
// EmailConfirmed = true,
// LockoutEnabled = true,
// NormalizedEmail = username,
// NormalizedUserName = username,
// PasswordHash = hashedPassword
// };
// context.Users.Add(user);
// }
//}
//var roleAdmin = "Admin";
//if (context.Roles.Count(x => x.Name == roleAdmin) == 0)
//{
// var role = context.Roles.FirstOrDefault(u => u.Name == roleAdmin);
// if (role == null)
// {
// role = new IdentityRole()
// {
// Name = roleAdmin
// };
// context.Roles.Add(role);
// }
//}
//if (!context.UserRoles.Any())
//{
// context.UserRoles.Add(new IdentityUserRole<string>()
// {
// UserId = context.Users.FirstOrDefault(u => u.UserName == username)?.Id,
// RoleId = context.Roles.FirstOrDefault(u => u.Name == roleAdmin)?.Id
// }
// );
//}
}
//Responsável por popular a base de dados
public void Seed()
{
//Testando se há alguma coisa na base de dados
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //corta a execução caso exista algo na base de dados
}
Departament dpt1 = new Departament(1, "Computers");
Departament dpt2 = new Departament(2, "Eletronics");
Departament dpt3 = new Departament(3, "Fashion");
Departament dpt4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, dpt1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 21), 2000.0, dpt2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1993, 5, 4), 1500.0, dpt3);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1945, 6, 3), 3500.0, dpt4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(1960, 8, 13), 7500.0, dpt4);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1990, 9, 23), 5500.0, dpt3);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
//Adicionar os objetos no BD
_context.Departament.AddRange(dpt1, dpt2, dpt3, dpt4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges(); //confirma a gravação no bd
}
public SalesEmployee(string id, string firstName, string lastName, decimal salary, Departament departament)
: base(id, firstName, lastName, salary, departament)
{
this.sales = new HashSet<Sale>();
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; //DB has been seeded
}
Departament d1 = new Departament(1, "Vendas");
Departament d2 = new Departament(2, "Gerência");
Departament d3 = new Departament(3, "Informática");
Seller s1 = new Seller(1, "Luiz Gustavo", "*****@*****.**", new DateTime(1977, 4, 21), 1000.0, d3);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d1);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d1);
/*
* SalesRecord r1 = new SalesRecord(1, new DateTime(2020, 09, 25), 11000.0, SaleStatus.Billed, s1);
* SalesRecord r2 = new SalesRecord(2, new DateTime(2020, 09, 4), 7000.0, SaleStatus.Billed, s5);
* SalesRecord r3 = new SalesRecord(3, new DateTime(2020, 09, 13), 4000.0, SaleStatus.Canceled, s4);
* SalesRecord r4 = new SalesRecord(4, new DateTime(2020, 09, 1), 8000.0, SaleStatus.Billed, s1);
* SalesRecord r5 = new SalesRecord(5, new DateTime(2020, 09, 21), 3000.0, SaleStatus.Billed, s3);
* SalesRecord r6 = new SalesRecord(6, new DateTime(2020, 09, 15), 2000.0, SaleStatus.Billed, s1);
* SalesRecord r7 = new SalesRecord(7, new DateTime(2020, 09, 28), 13000.0, SaleStatus.Billed, s2);
* SalesRecord r8 = new SalesRecord(8, new DateTime(2020, 09, 11), 4000.0, SaleStatus.Billed, s4);
* SalesRecord r9 = new SalesRecord(9, new DateTime(2020, 09, 14), 11000.0, SaleStatus.Pending, s6);
* SalesRecord r10 = new SalesRecord(10, new DateTime(2020, 09, 7), 9000.0, SaleStatus.Billed, s6);
* SalesRecord r11 = new SalesRecord(11, new DateTime(2020, 09, 13), 6000.0, SaleStatus.Billed, s2);
* SalesRecord r12 = new SalesRecord(12, new DateTime(2020, 09, 25), 7000.0, SaleStatus.Pending, s3);
* SalesRecord r13 = new SalesRecord(13, new DateTime(2020, 09, 29), 10000.0, SaleStatus.Billed, s4);
* SalesRecord r14 = new SalesRecord(14, new DateTime(2020, 09, 4), 3000.0, SaleStatus.Billed, s5);
* SalesRecord r15 = new SalesRecord(15, new DateTime(2020, 09, 12), 4000.0, SaleStatus.Billed, s1);
* SalesRecord r16 = new SalesRecord(16, new DateTime(2020, 10, 5), 2000.0, SaleStatus.Billed, s4);
* SalesRecord r17 = new SalesRecord(17, new DateTime(2020, 10, 1), 12000.0, SaleStatus.Billed, s1);
* SalesRecord r18 = new SalesRecord(18, new DateTime(2020, 10, 24), 6000.0, SaleStatus.Billed, s3);
* SalesRecord r19 = new SalesRecord(19, new DateTime(2020, 10, 22), 8000.0, SaleStatus.Billed, s5);
* SalesRecord r20 = new SalesRecord(20, new DateTime(2020, 10, 15), 8000.0, SaleStatus.Billed, s6);
* SalesRecord r21 = new SalesRecord(21, new DateTime(2020, 10, 17), 9000.0, SaleStatus.Billed, s2);
* SalesRecord r22 = new SalesRecord(22, new DateTime(2020, 10, 24), 4000.0, SaleStatus.Billed, s4);
* SalesRecord r23 = new SalesRecord(23, new DateTime(2020, 10, 19), 11000.0, SaleStatus.Canceled, s2);
* SalesRecord r24 = new SalesRecord(24, new DateTime(2020, 10, 12), 8000.0, SaleStatus.Billed, s5);
* SalesRecord r25 = new SalesRecord(25, new DateTime(2020, 10, 31), 7000.0, SaleStatus.Billed, s3);
* SalesRecord r26 = new SalesRecord(26, new DateTime(2020, 10, 6), 5000.0, SaleStatus.Billed, s4);
* SalesRecord r27 = new SalesRecord(27, new DateTime(2020, 10, 13), 9000.0, SaleStatus.Pending, s1);
* SalesRecord r28 = new SalesRecord(28, new DateTime(2020, 10, 7), 4000.0, SaleStatus.Billed, s3);
* SalesRecord r29 = new SalesRecord(29, new DateTime(2020, 10, 23), 12000.0, SaleStatus.Billed, s5);
* SalesRecord r30 = new SalesRecord(30, new DateTime(2020, 10, 12), 5000.0, SaleStatus.Billed, s2);
*
*
*
* _context.SalesRecord.AddRange(
* r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
* r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
* r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
* );
*/
_context.Departament.AddRange(d1, d2, d3);
_context.Seller.AddRange(s1, s2, s3, s5, s6);
_context.SaveChanges();
}
public Manager(int id, string firstName, string lastName, decimal salary,
Departament departament, List<Employee> employees)
: base(id, firstName, lastName, salary, departament)
{
this.Employees = employees;
}
public Manager(string id, string firstName, string LastName, Departament departament, decimal salary, HashSet<Employee> employees = null)
: base(id, firstName, LastName, departament, salary)
{
this.Employees = employees ?? new HashSet<Employee>();
}
public Employee(string id, string firstName, string lastName, Departament departament, decimal salary)
: base(id, firstName, lastName)
{
this.Salary = salary;
this.Departament = departament;
}
protected Employee(int id, string firstName, string lastName, decimal salary, Departament departament)
: base(id, firstName, lastName)
{
this.Salary = salary;
this.Departament = departament;
}
public Developer(string id, string firstName, string lastName, decimal salary, Departament departament)
: base(id, firstName, lastName, salary, departament)
{
this.projects = new HashSet<Project>();
}
public DepartamentViewModel()
{
Departaments = Departament.GetDepartaments();
}
public RegularEmployee(string id, string firstName, string lastName, decimal salary, Departament departament)
: base(id,firstName,lastName, departament, salary)
{
}
