public ActionResult DoAdd(FormCollection fc)
{
ProdSale record = new ProdSale();
record.name = fc["name"];
//
record.newprice = 0;
if (fc["newprice"] != "")
{
record.newprice = Convert.ToInt32(fc["newprice"]);
}
//
record.oldprice = 0;
if (fc["oldprice"] != "")
{
record.oldprice = Convert.ToInt32(fc["oldprice"]);
}
//
record.id_Category = Convert.ToInt32(fc["id_Category"]);
//
int Random = 0;
if (Request.Form["Random"] != null)
{
Random = 1;
}
record.Random = Convert.ToBoolean(Random);
//
int Bestseller = 0;
if (Request.Form["Bestseller"] != null)
{
Bestseller = 1;
}
record.Bestseller = Convert.ToBoolean(Bestseller);
//
int HotSale = 0;
if (Request.Form["HotSale"] != null)
{
HotSale = 1;
}
record.HotSale = Convert.ToBoolean(HotSale);
//
int HotDeals = 0;
if (Request.Form["HotDeals"] != null)
{
HotDeals = 1;
}
record.HotDeals = Convert.ToBoolean(HotDeals);
//
string img = "";
if (Request.Files["img"].FileName != "")
{
img = Request.Files["img"].FileName;
var duongDanAnh = Server.MapPath("~/Assets/Upload/Product/" + img);
Request.Files["img"].SaveAs(duongDanAnh);
}
//
record.Random = Convert.ToBoolean(Random);
record.Bestseller = Convert.ToBoolean(Bestseller);
record.HotSale = Convert.ToBoolean(HotSale);
record.HotDeals = Convert.ToBoolean(HotDeals);
record.img = img;
csdl.ProdSales.Add(record);
csdl.SaveChanges();
return(RedirectToAction("ListProdSale", "ProdSale"));
}
static void Main(string[] args)
{
//string conn = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\dbLojaVirtual.mdf;Integrated Security=True;Connect Timeout=30"; //String de conexão
//IDbConnection con = new SqlConnection(conn);
//IDbCommand com = con.CreateCommand();
//com.CommandText = "select * from tbCliente";
//IDataReader read = com.ExecuteReader();
//while (read.Read()) {
// int Id = Convert.ToInt32(read["Id"]);
// string Name = Convert.ToString(read["Name"]);
//}
UserDAO dao = new UserDAO();
//ADD
//User Client = new User() { Name = "Malu", Pass = "******" };
//dao.Add(Client);
//Console.WriteLine( Properties.Resources.Saved );
//FIND
//User Client = dao.FindId(5);
//Console.WriteLine( Client.Name );
//REMOVE
//User Client = dao.FindId(2);
//dao.Remove(Client);
//Console.WriteLine( Properties.Resources.Removed );
//UPDATE
//User Client = dao.FindId(4);
//Client.Pass = "******";
//dao.Update();
//Console.WriteLine(Properties.Resources.Updated);
//NEW CONTEXTS - Category and Product
//EntitiesContext context = new EntitiesContext();
//Category cat = new Category() { Name = "Informática" };
//context.Categories.Add(cat);
//context.SaveChanges();
//Product prod = new Product() { Name = "Notebook Tijolo", Price = 20, Category = cat };
//context.Products.Add(prod);
//context.SaveChanges();
//Console.WriteLine( Properties.Resources.Register );
//Add only the Prod with an existing Category by they ID
//EntitiesContext context = new EntitiesContext();
//Product prod = new Product() { Name = "HD Externo 4TB USB 3.0", Price = 550, CategoryId = 1 };
//context.Products.Add(prod);
//context.SaveChanges();
//Console.WriteLine(Properties.Resources.Register);
//Search for a product or category (Prod this case) by they Id
//EntitiesContext context = new EntitiesContext();
//Product p = context.Products.FirstOrDefault(product => product.Id == 1);
//Console.WriteLine(p.Name);
//Search for a product and his category, show on the console the category only, by they Id
//EntitiesContext context = new EntitiesContext();
//Product p = context.Products.Include(product => product.Category).FirstOrDefault(product => product.Id == 1);
//Console.WriteLine(p.Category.Name);
//List of products in an category
//EntitiesContext context = new EntitiesContext();
//var category = context.Categories.Include(c => c.Products).FirstOrDefault(c => c.Id == 1);
//foreach (var p in category.Products) {
// Console.WriteLine(p.Name);
//}
//Avaliative Activity
//EntitiesContext context = new EntitiesContext();
//Category cat = new Category() { Name = "Papelaria" };
//context.Categories.Add(cat);
//context.SaveChanges();
//Product prod = new Product() { Name = "Lapis de Cor 60 cores", Price = 64, Category = cat };
//context.Products.Add(prod);
//context.SaveChanges();
//prod = new Product() { Name = "Caneta Hidrográfica", Price = 24, Category = cat };
//context.Products.Add(prod);
//context.SaveChanges();
//prod = new Product() { Name = "Cola Bastão", Price = 14, Category = cat };
//context.Products.Add(prod);
//context.SaveChanges();
//prod = new Product() { Name = "Lapiseira 0.7mm", Price = 7, Category = cat };
//context.Products.Add(prod);
//context.SavesChanges();
//prod = new Product() { Name = "Papel Sulfite A4", Price = 23, Category = cat };
//context.Products.Add(prod);
//context.SaveChanges();
//Console.WriteLine(Properties.Resources.Register);
//Using LINQ
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products select p;
//foreach (var prod in search) {
// Console.WriteLine(prod.Name);
//}
//The(funcking) same thing
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products select p;
//IList<Product> res = search.ToList();
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products orderby p.Name select p;
//IList<Product> res = search.ToList();
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products where (p.Price > 30) select p;
//IList<Product> res = search.ToList();
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products where (p.Price > 30) select p;
//IList<Product> res = search.ToList();
//foreach (var prod in res) {
// Console.WriteLine(prod.Name + "\t\t" + prod.Price);
//}
//EntitiesContext context = new EntitiesContext();
//decimal pMin = 20;
//var search = from p in context.Products where (p.Price > pMin) select p;
//IList<Product> res = search.ToList();
//foreach (var prod in res) {
// Console.WriteLine(prod.Name + "\t\tR$ " + prod.Price);
//}
//EntitiesContext context = new EntitiesContext();
//var search = from p in context.Products where (p.Category.Name == "Papelaria") select p;
//foreach (var prod in search) {
// Console.WriteLine(prod.Name + "\t\tR$ " + prod.Price);
//}
//EntitiesContext context = new EntitiesContext();
//decimal pMin = 20;
//var search = from p in context.Products where ((p.Category.Name == "Papelaria") && (p.Price > pMin)) select p;
//foreach (var prod in search) {
// Console.WriteLine(prod.Name + "\t\tR$ " + prod.Price);
//}
//Start the ProdDAO
EntitiesContext context = new EntitiesContext();
ProdDAO pdao = new ProdDAO(context);
//var res = pdao.SearchNPC(null, 0, null);
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//var res = pdao.SearchNPC("Cola Bastão", 0, null);
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//var res = pdao.SearchNPC(null, 24, null);
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
//var res = pdao.SearchNPC("Cola Bastão", 0, null);
//foreach (var prod in res) {
// Console.WriteLine(prod.Name);
//}
UserDAO udao = new UserDAO();
User users = udao.FindId(3);
Sale s = new Sale()
{
Client = users
};
Product p1 = context.Products.FirstOrDefault(prod => prod.Id == 1);
Product p2 = context.Products.FirstOrDefault(prod => prod.Id == 2);
//ProdSale ps1 = new ProdSale() {
// Sales = s,
// ProdID = p1.Id,
// Products = p1
//};
ProdSale ps2 = new ProdSale()
{
Sales = s,
ProdID = p2.Id,
Products = p2
};
//context.Sales.Add(s);
//context.ProdSales.Add(ps1);
context.ProdSales.Add(ps2);
context.SaveChanges();
Console.WriteLine("Foi!");
Console.ReadLine();
}
