// GET: Modelis/Edit/5
public ActionResult Edit(int id)
{
Modelis2EditViewModel modelis = modeliuRepository.getModelis(id);
PopulateSelections(modelis);
return(View(modelis));
}
public Modelis2EditViewModel getModelis(int id)
{
Modelis2EditViewModel modelis = new Modelis2EditViewModel();
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"SELECT m.*
FROM " + Globals.dbPrefix + @"aktorystessutartis m WHERE m.asutartiesid=" + 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["asutartiesid"]);
modelis.pavadinimas = Convert.ToString(item["ashonoraras"]);
modelis.fk_marke = Convert.ToInt32(item["fk_KINOSTUDIJAkinostudijosid"]);
}
return(modelis);
}
// GET: Modelis/Create
public ActionResult Create()
{
Modelis2EditViewModel modelis = new Modelis2EditViewModel();
PopulateSelections(modelis);
return(View(modelis));
}
public bool addModelis(Modelis2EditViewModel modelis)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"INSERT INTO " + Globals.dbPrefix + "aktorystessutartis(asutartiesid,ashonoraras,fk_KINOSTUDIJAkinostudijosid)VALUES(?asutartiesid,?ashonoraras,?kinostudija)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?ashonoraras", MySqlDbType.VarChar).Value = modelis.pavadinimas;
mySqlCommand.Parameters.Add("?asutartiesid", 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(Modelis2EditViewModel 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, Modelis2EditViewModel 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(Modelis2EditViewModel 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)
{
Modelis2EditViewModel modelis = modeliuRepository.getModelis(id);
return(View(modelis));
}
