public ActionResult Delete(int id, FormCollection collection)
{
try
{
PriceEditViewModel priceEditViewModel = pricesRepository.getPrice(id);
bool used = false;
/*if(pricesRepository.getPriceCount(id)>0)
* {
* used = true;
* ViewBag.used = "Negalima pašalinti akcijos, kuri yra naudojama kitose lentelėse.";
*
* }*/
if (!used)
{
pricesRepository.deletePrice(id);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public PriceEditViewModel getPrice(int id)
{
PriceEditViewModel PriceEditViewModel = new PriceEditViewModel();
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"select p.* from " + Globals.dbPrefix + @"prices p WHERE p.id=" + id; // ' '
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlConnection.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(mySqlCommand);
DataTable dt = new DataTable();
mda.Fill(dt);
mySqlConnection.Close();
foreach (DataRow item in dt.Rows)
{
PriceEditViewModel.from_date = Convert.ToDateTime(item["from_date"]);
PriceEditViewModel.value = Convert.ToDecimal(item["value"]);
PriceEditViewModel.to_date = Convert.ToDateTime(item["to_date"]);
PriceEditViewModel.id = Convert.ToInt32(item["id"]);
PriceEditViewModel.fk_Security = Convert.ToString(item["fk_Security"]);
}
return(PriceEditViewModel);
}
// GET: Prices/Edit/5
public ActionResult Edit(int id)
{
PriceEditViewModel priceEditViewModel = pricesRepository.getPrice(id);
PopulateSelections(priceEditViewModel);
return(View(priceEditViewModel));
}
// GET: Prices/Create
public ActionResult Create()
{
PriceEditViewModel priceEditViewModel = new PriceEditViewModel();
PopulateSelections(priceEditViewModel);
return(View(priceEditViewModel));
}
public void PopulateSelections(PriceEditViewModel priceEditViewModel)
{
var securities = securitiesRepository.getSecurities();
List <SelectListItem> selectListSecurities = new List <SelectListItem>();
foreach (var item in securities)
{
selectListSecurities.Add(new SelectListItem()
{
Value = Convert.ToString(item.ticker), Text = item.ticker
});
}
priceEditViewModel.SecuritiesList = selectListSecurities;
}
public ActionResult Edit(int id, PriceEditViewModel collection)
{
try
{
if (ModelState.IsValid)
{
pricesRepository.updatePrice(collection);
}
return(RedirectToAction("Index"));
}
catch
{
PopulateSelections(collection);
return(View(collection));
}
}
public bool addPrice(PriceEditViewModel PriceEditViewModel)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"INSERT INTO " + Globals.dbPrefix +
"prices(from_date, value, to_date, id, fk_Security)" +
"VALUES(?from_date, ?value, ?to_date, ?id, ?fk_Security)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?from_date", MySqlDbType.DateTime).Value = PriceEditViewModel.from_date;
mySqlCommand.Parameters.Add("?value", MySqlDbType.Decimal).Value = PriceEditViewModel.value;
mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value = PriceEditViewModel.id;
mySqlCommand.Parameters.Add("?to_date", MySqlDbType.DateTime).Value = PriceEditViewModel.to_date;
mySqlCommand.Parameters.Add("?fk_Security", MySqlDbType.VarChar).Value = PriceEditViewModel.fk_Security;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Price price = db.Prices.Find(id);
if (price == null)
{
return(HttpNotFound());
}
var user = db.Employees.Find(User.Identity.GetUserId());
if (User.IsInRole(nameof(RoleEnum.CompanyManager)))
{
if (price.Station.CompanyId != user.CompanyId)
{
return(HttpNotFound());
}
}
else
{
if (price.Station.Id != user.StationId)
{
return(HttpNotFound());
}
}
ViewBag.PriceStationId = price.StationId;
PriceEditViewModel priceVM = new PriceEditViewModel()
{
Id = price.Id, StationName = price.Station.ComercialName,
Time = price.Time, CostNormal = price.CostNormal.ToString(), CostUltra = price.CostUltra.ToString()
};
return(View(priceVM));
}
public ActionResult Edit([Bind(Include = "Id,StationName,CostNormal,CostUltra")] PriceEditViewModel price)
{
var myPrice = db.Prices.Find(price.Id);
if (Double.TryParse(price.CostNormal, out double normal) && Double.TryParse(price.CostUltra, out double ultra))
{
myPrice.CostUltra = ultra;
myPrice.CostNormal = normal;
}
else
{
TempData["msg"] = "Formato de custo errado (deve ser: 1,33)";
return(View(price));
}
if (ModelState.IsValid)
{
db.Entry(myPrice).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(price));
}
public bool updatePrice(PriceEditViewModel PriceEditViewModel)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"UPDATE prices p SET
p.from_date = ?from_date,
p.value = ?value,
p.to_date = ?to_date,
p.fk_Security = ?fk_Security
WHERE p.id=?id";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?from_date", MySqlDbType.DateTime).Value = PriceEditViewModel.from_date;
mySqlCommand.Parameters.Add("?value", MySqlDbType.Decimal).Value = PriceEditViewModel.value;
mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value = PriceEditViewModel.id;
mySqlCommand.Parameters.Add("?to_date", MySqlDbType.DateTime).Value = PriceEditViewModel.to_date;
mySqlCommand.Parameters.Add("?fk_Security", MySqlDbType.VarChar).Value = PriceEditViewModel.fk_Security;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
// GET: Prices/Delete/5
public ActionResult Delete(int id)
{
PriceEditViewModel priceEditViewModel = pricesRepository.getPrice(id);
return(View(priceEditViewModel));
}
