public SkrydzioBilietasEditViewModel getBilietas(int id)
{
SkrydzioBilietasEditViewModel bilietas = new SkrydzioBilietasEditViewModel();
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"SELECT m.*
FROM " + @"skrydzio_bilietai m WHERE m.skrydzio_bilietai_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)
{
bilietas.id = Convert.ToInt32(item["skrydzio_bilietai_id"]);
bilietas.fk_bilietas = Convert.ToInt32(item["fk_bilietaibilieto_id"]);
bilietas.fk_skrydis = Convert.ToInt32(item["fk_skrydziaiskrydzio_id"]);
}
return(bilietas);
}
public ActionResult Edit(int id)
{
SkrydzioBilietasEditViewModel bilietas = skrydzioBilietasRepository.getBilietas(id);
PopulateSelections(bilietas);
return(View(bilietas));
}
public ActionResult Create()
{
SkrydzioBilietasEditViewModel bilietas = new SkrydzioBilietasEditViewModel();
PopulateSelections(bilietas);
return(View(bilietas));
}
public void PopulateSelections(SkrydzioBilietasEditViewModel bilietas)
{
var bilietai = bilietaiRepository.getBilietai();
var skrydziai = skrydziaiRepository.getSkrydziai();
List <SelectListItem> selectListBilietai = new List <SelectListItem>();
List <SelectListItem> selectListSkrydziai = new List <SelectListItem>();
foreach (var item in bilietai)
{
selectListBilietai.Add(new SelectListItem()
{
Value = Convert.ToString(item.id), Text = Convert.ToString(item.id)
});
}
foreach (var item in skrydziai)
{
selectListSkrydziai.Add(new SelectListItem()
{
Value = Convert.ToString(item.id), Text = Convert.ToString(item.id)
});
}
bilietas.BilietasList = selectListBilietai;
bilietas.SkrydisList = selectListSkrydziai;
}
public bool updateBilietas(SkrydzioBilietasEditViewModel bilietas)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"UPDATE " + "skrydzio_bilietai a SET a.fk_bilietaibilieto_id=?bilietas, a.fk_skrydziaiskrydzio_id=?skrydis WHERE a.skrydzio_bilietai_id=?id";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value = bilietas.id;
mySqlCommand.Parameters.Add("?bilietas", MySqlDbType.Int32).Value = bilietas.fk_bilietas;
mySqlCommand.Parameters.Add("?skrydis", MySqlDbType.Int32).Value = bilietas.fk_skrydis;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
public bool addBilietas(SkrydzioBilietasEditViewModel bilietas)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"INSERT INTO " + "skrydzio_bilietai(skrydzio_bilietai_id,fk_bilietaibilieto_id,fk_skrydziaiskrydzio_id)VALUES(?id,?bilietas,?skrydis)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?id", MySqlDbType.Int32).Value = bilietas.id;
mySqlCommand.Parameters.Add("?bilietas", MySqlDbType.Int32).Value = bilietas.fk_bilietas;
mySqlCommand.Parameters.Add("?skrydis", MySqlDbType.VarChar).Value = bilietas.fk_skrydis;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
SkrydzioBilietasEditViewModel bilietas = skrydzioBilietasRepository.getBilietas(id);
skrydzioBilietasRepository.deleteBilietas(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, SkrydzioBilietasEditViewModel collection)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
skrydzioBilietasRepository.updateBilietas(collection);
}
return(RedirectToAction("Index"));
}
catch
{
PopulateSelections(collection);
return(View(collection));
}
}
public ActionResult Create(SkrydzioBilietasEditViewModel collection)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
collection.id = skrydzioBilietasRepository.getNewId();
skrydzioBilietasRepository.addBilietas(collection);
}
return(RedirectToAction("Index"));
}
catch
{
PopulateSelections(collection);
return(View(collection));
}
}
public ActionResult Delete(int id)
{
SkrydzioBilietasEditViewModel bilietas = skrydzioBilietasRepository.getBilietas(id);
return(View(bilietas));
}
