public IActionResult CreateSAP([FromBody] StockAndProcedure sap)
{
if (!ModelState.IsValid)
{
return(BadRequest(DefaultMessages.nonStandardCreate));
}
context.TB_StockAndProcedure.Add(sap);
int rs = context.SaveChanges();
if (rs < 1)
{
return(BadRequest(DefaultMessages.internalfailureCreate));
}
else
{
return(Ok(sap));
}
}
public static void Init(DataBaseContext dbContext)
{
dbContext.Database.EnsureCreated();
if (dbContext.TB_People.Any())
{
return;
}
var PeopleClient = new People()
{
name = "Agatha Lorena Gomes",
email = "*****@*****.**",
phoneNumber = "34993896109",
typePeople = Utils.TypePeople.Client
};
dbContext.TB_People.Add(PeopleClient);
var PeopleEmployee = new People()
{
name = "Mariana Souza",
email = "*****@*****.**",
phoneNumber = "5511961235780",
typePeople = Utils.TypePeople.Employee
};
dbContext.TB_People.Add(PeopleEmployee);
var Login = new Login()
{
peopleId = PeopleEmployee.idPeople,
user = "******",
password = "******",
accessLevel = Utils.AccessLevel.Master,
typeEmployee = Utils.TypeEmployee.Efetivo,
typeArea = Utils.TypeArea.CabeleireiroHairStylist
};
dbContext.TB_Login.Add(Login);
var ProductHair = new Product()
{
name = "Xampú RankaKaspa",
make = "Kikabelo",
description = "Xampú anticaspa profissional."
};
dbContext.TB_Product.Add(ProductHair);
var ProductEstetica = new Product()
{
name = "Esfoliante Intenso",
make = "EsfoliaPro",
description = "Esfoliante profissional."
};
dbContext.TB_Product.Add(ProductEstetica);
var Supp = new Supplier()
{
supplierName = "Perfurmaria Amaral LTDA",
phoneNumber = "1127249384",
description = "Perfurmaria mais barata de produtos em geral."
};
dbContext.TB_Supplier.Add(Supp);
var Stock = new Stock()
{
productId = ProductHair.idProduct,
quantity = 240,
typeProduct = Utils.TypeProduct.Xampu,
supplierId = Supp.idSupplier
};
dbContext.TB_Stock.Add(Stock);
var Stock2 = new Stock()
{
productId = ProductEstetica.idProduct,
quantity = 80,
typeProduct = Utils.TypeProduct.Mascara,
supplierId = Supp.idSupplier
};
dbContext.TB_Stock.Add(Stock2);
//var Stock00 = new Stock()
//{
// productId = ProductHair.idProduct,
// quantity = 240,
// typeProduct = Utils.TypeProduct.Xampu,
// supplierId = Supp.idSupplier
//};
//dbContext.TB_Stock.Add(Stock00);
//var Stock01 = new Stock()
//{
// productId = ProductEstetica.idProduct,
// quantity = 80,
// typeProduct = Utils.TypeProduct.Mascara,
// supplierId = Supp.idSupplier
//};
//dbContext.TB_Stock.Add(Stock01);
var ProcedureHair = new Procedure()
{
name = "Hidratação Capilar",
description = "Esse procedimento transforma seu cabelo seboso e fedido em um cabelo lindo e cheiroso!!!",
estimitedTime = new TimeSpan(0, 40, 0),
price = 49.90M,
typeArea = Utils.TypeArea.CabeleireiroHairStylist
};
dbContext.TB_Procedure.Add(ProcedureHair);
var ProcedureEstetica = new Procedure()
{
name = "Limpeza de pele",
description = "Esse procedimento transforma sua pele sebosa e fedida em uma pele linda e cheirosa!!!",
estimitedTime = new TimeSpan(0, 30, 0),
price = 39.90M,
typeArea = Utils.TypeArea.Esteticismo
};
dbContext.TB_Procedure.Add(ProcedureEstetica);
//var Relation_ProcedureStock00 = new StockAndProcedure()
//{
// //StockId = Stock00.idStock,
// procedureId = ProcedureHair.idProcedure
// //,requiredQuantity = 2
//};
//dbContext.TB_StockAndProcedure.Add(Relation_ProcedureStock00);
//var Relation_ProcedureStock01 = new StockAndProcedure()
//{
// //StockId = Stock01.idStock,
// procedureId = ProcedureEstetica.idProcedure
// //,requiredQuantity = 1
//};
//dbContext.TB_StockAndProcedure.Add(Relation_ProcedureStock01);
var Combo = new Combo()
{
name = "S.O.S Combo",
description = "Podemos já vislumbrar o modo pelo qual a adoção de políticas " +
"descentralizadoras deve passar por modificações independentemente das formas de ação.",
price = 69.90M
};
dbContext.TB_Combo.Add(Combo);
var Relation_ComboProcedure00 = new ComboAndProcedure()
{
comboId = Combo.idCombo, procedureId = ProcedureHair.idProcedure
};
dbContext.TB_ComboAndProcedure.Add(Relation_ComboProcedure00);
var Relation_ComboProcedure01 = new ComboAndProcedure()
{
comboId = Combo.idCombo,
procedureId = ProcedureEstetica.idProcedure
};
dbContext.TB_ComboAndProcedure.Add(Relation_ComboProcedure01);
var xpto = new StockAndProcedure()
{
stockId = Stock.idStock, procedureId = ProcedureHair.idProcedure, requiredQuantity = 10
};
dbContext.TB_StockAndProcedure.Add(xpto);
var xptoo1 = new StockAndProcedure()
{
stockId = Stock2.idStock, procedureId = ProcedureHair.idProcedure, requiredQuantity = 5
};
dbContext.TB_StockAndProcedure.Add(xptoo1);
var xpto1 = new StockAndProcedure()
{
stockId = Stock2.idStock, procedureId = ProcedureEstetica.idProcedure, requiredQuantity = 1
};
dbContext.TB_StockAndProcedure.Add(xpto1);
var Sale = new Sale()
{
comboId = Combo.idCombo,
amount = Combo.price,
clientId = PeopleClient.idPeople,
procedureId = ProcedureHair.idProcedure
};
dbContext.TB_Sale.Add(Sale);
var Scheduling = new Scheduling()
{
checkIn = new DateTime(2021, 08, 20, 16, 30, 0),
checkOut = new DateTime(2021, 08, 20, 18, 00, 0),
saleId = Sale.idSale,
employeeId = Login.IdLogin,
clientId = PeopleClient.idPeople,
status = Utils.StatusScheduling.Marcado
};
dbContext.TB_Scheduling.Add(Scheduling);
dbContext.SaveChanges();
}
