public bool addVietos(SaleCreate saleCreateViewModel, int SaleId) { for (int i = 0; i < saleCreateViewModel.eiles_nr.Length; i++) { string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"INSERT INTO `vieta` ( `eiles_nr`, `vietos_nr`, `vietos_tipas`, `kaina`, `fk_Kino_saleid_Kino_sale`) VALUES ( ?eil, ?vt, ?tipas, ?kaina, ?salesId)"; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlCommand.Parameters.Add("?eil", MySqlDbType.Int32).Value = saleCreateViewModel.eiles_nr[i]; mySqlCommand.Parameters.Add("?vt", MySqlDbType.Int32).Value = saleCreateViewModel.vietos_nr[i]; mySqlCommand.Parameters.Add("?tipas", MySqlDbType.Int32).Value = saleCreateViewModel.vietos_tipas[i]; mySqlCommand.Parameters.Add("?kaina", MySqlDbType.Float).Value = saleCreateViewModel.kaina[i]; mySqlCommand.Parameters.Add("?salesId", MySqlDbType.Int32).Value = SaleId; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); } return(true); }
public ActionResult Create(SaleCreate model) { var service = CreateSaleService(); //var companyService = new CompanyService(); //Need to limit to CompanyID of the User. ViewBag.CompanyID = new SelectList(service.GetUserCompanyList(), "CompanyID", "CompanyName"); if (!ModelState.IsValid) { return(View(model)); } if (service.CreateSale(model)) { TempData["SaveResult"] = "Your sale was created."; return(RedirectToAction("Index")); } ; ModelState.AddModelError("", "Sale could not be created."); return(View(model)); }
public ActionResult Create() { SaleCreate SaleCreateViewModel = new SaleCreate(); //Užpildomi pasirinkimų sąrašai duomenimis iš duomenų saugyklų PopulateSelections(SaleCreateViewModel); return(View(SaleCreateViewModel)); }
// CREATE public bool CreateSale(SaleCreate model) { Sale entity = new Sale { DayOfTheWeek = model.DayOfTheWeek, SalePrice = model.SalePrice, BreweryId = model.BreweryId, Brewery = model.Brewery }; _context.Sales.Add(entity); return(_context.SaveChanges() == 1); }
public ActionResult Create(SaleCreate collection) { try { //Pridedamas naujas automobilis saleRepo.addSale(collection); int a = saleRepo.getSaleId(); vietuRepo.addVietos(collection, saleRepo.getSaleId()); return(RedirectToAction("Index")); } catch { PopulateSelections(collection); return(View(collection)); } }
public bool addSale(SaleCreate saleCreateViewModel) { string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"INSERT INTO `kino_sale` ( `pavadinimas`) VALUES ( ?pav)"; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlCommand.Parameters.Add("?pav", MySqlDbType.VarChar).Value = saleCreateViewModel.pavadinimas; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); return(true); }
public ActionResult Create(SaleCreate model) { if (!ModelState.IsValid) { return(View(model)); } if (_service.CreateSale(model)) { TempData["SaveResult"] = "Sale was added."; return(RedirectToAction("Index")); } ; ModelState.AddModelError("", "Sale could not be created."); return(View(model)); }
public void PopulateSelections(SaleCreate SaleCreateViewModel) { var vt = vietuTipai.getVietuTipas(); List <SelectListItem> selectListVietuTipai = new List <SelectListItem>(); //užpildomas kebulų sąrašas iš duomenų bazės foreach (var item in vt) { selectListVietuTipai.Add(new SelectListItem() { Value = Convert.ToString(item.id), Text = item.pav }); } //Sarašai priskiriami vaizdo objektui SaleCreateViewModel.vietos_tipasList = selectListVietuTipai; }
public async Task <ActionResult> Create(SaleCreate model) { if (!ModelState.IsValid) { return(View(model)); } var service = CreateSaleService(); if (await service.CreateSale(model)) { TempData["SaveResult"] = "The Sale was successfully completed."; return(RedirectToAction("Index")); } ModelState.AddModelError("", "The Sale could not be completed, please try again."); return(View(model)); }
public ActionResult CreateFromArt(SaleCreate model) { if (!ModelState.IsValid) { return(View(model)); } var service = CreateSaleService(); if (service.CreateSale(model)) { TempData["SaveResult"] = "Your Sale was added."; return(RedirectToAction("Index")); } ; ModelState.AddModelError("", "Sale could not be added."); return(View(model)); }
public async Task <bool> CreateSale(SaleCreate model) { var entity = new Sale() { OwnerID = _userId, AcctID = model.AcctID, Symbol = (Sale.CryptoSymbolEnum)model.Symbol, Quantity = model.Quantity, Price = model.Price, Total = model.Total, SaleDate = DateTimeOffset.Now }; using (var ctx = new ApplicationDbContext()) { ctx.Sales.Add(entity); return(await ctx.SaveChangesAsync() == 1); } }
public bool CreateSale(SaleCreate model) { var entity = new Sale() { OwnerID = _userId, Address = model.Address, SalePrice = model.SalePrice, SquareFootage = model.SquareFootage, Buyer1 = model.Buyer1, Seller1 = model.Seller1, CompanyID = model.CompanyID, CreatedUtc = DateTimeOffset.Now }; using (var ctx = new ApplicationDbContext()) { ctx.Sales.Add(entity); return(ctx.SaveChanges() == 1); } }
public bool CreateSale(SaleCreate model) { var entity = new Sale() { OwnerID = _userId, ArtID = model.ArtID, ClientID = model.ClientID, Price = model.Price, Location = model.Location, SellingPrice = model.SellingPrice, VenderCommission = model.VenderCommission, DateOfTransaction = model.DateOfTransaction, }; using (var ctx = new ApplicationDbContext()) { ctx.Sales.Add(entity); var id = entity.ArtID; SoldArtTrue(id); return(ctx.SaveChanges() == 1); } }