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