// GET: Modelis/Edit/5 public ActionResult Edit(int id) { Modelis1EditViewModel modelis = modeliuRepository.getModelis(id); PopulateSelections(modelis); return(View(modelis)); }
public Modelis1EditViewModel getModelis(int id) { Modelis1EditViewModel modelis = new Modelis1EditViewModel(); string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"SELECT m.* FROM " + Globals.dbPrefix + @"darbosutartis m WHERE m.dsutartiesid=" + 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) { modelis.id = Convert.ToInt32(item["dsutartiesid"]); modelis.pavadinimas = Convert.ToString(item["dshonoraras"]); modelis.fk_marke = Convert.ToInt32(item["fk_KINOSTUDIJAkinostudijosid"]); } return(modelis); }
// GET: Modelis/Create public ActionResult Create() { Modelis1EditViewModel modelis = new Modelis1EditViewModel(); PopulateSelections(modelis); return(View(modelis)); }
public bool addModelis(Modelis1EditViewModel modelis) { string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"INSERT INTO " + Globals.dbPrefix + "darbosutartis(dsutartiesid,dshonoraras,fk_KINOSTUDIJAkinostudijosid)VALUES(?dsutartiesid,?dshonoraras,?kinostudija)"; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlCommand.Parameters.Add("?dshonoraras", MySqlDbType.VarChar).Value = modelis.pavadinimas; mySqlCommand.Parameters.Add("?dsutartiesid", MySqlDbType.VarChar).Value = modelis.id; mySqlCommand.Parameters.Add("?kinostudija", MySqlDbType.VarChar).Value = modelis.fk_marke; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); return(true); }
public void PopulateSelections(Modelis1EditViewModel modelis) { var markes = markeRepository.getMarkes(); List <SelectListItem> selectListmarkes = new List <SelectListItem>(); foreach (var item in markes) { selectListmarkes.Add(new SelectListItem() { Value = Convert.ToString(item.id), Text = item.pavadinimas }); } modelis.MarkesList = selectListmarkes; }
public ActionResult Edit(int id, Modelis1EditViewModel collection) { try { // TODO: Add update logic here if (ModelState.IsValid) { modeliuRepository.updateModelis(collection); } return(RedirectToAction("Index")); } catch { PopulateSelections(collection); return(View(collection)); } }
public ActionResult Create(Modelis1EditViewModel collection) { try { // TODO: Add insert logic here if (ModelState.IsValid) { modeliuRepository.addModelis(collection); } return(RedirectToAction("Index")); } catch { PopulateSelections(collection); return(View(collection)); } }
// GET: Modelis/Delete/5 public ActionResult Delete(int id) { Modelis1EditViewModel modelis = modeliuRepository.getModelis(id); return(View(modelis)); }