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);
}
}
