public bool insertAndUpdate(ShowTimeCreate ShowTimeViewModel)
{
List <RodymoLaikas> items = SelectRepertory();
for (int i = 0; i < ShowTimeViewModel.fk_Filmasid_Filmas.Length; i++)
{
bool notInsert = false;
for (int j = 0; j < items.Count - 1; j++)
{
string data = items[j].laikas.ToString("yyyy-MM-dd");
if (ShowTimeViewModel.filmo_prad_laik[i] == items[j].filmo_prad_laik &&
ShowTimeViewModel.laikas[i] == data &&
ShowTimeViewModel.fk_Kino_saleid_Kino_sale[0] == items[j].kinoSale_id &&
ShowTimeViewModel.fk_Filmasid_Filmas[i] != 0)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"UPDATE `rodymo_laikas` SET `fk_Filmasid_Filmas` = ?fk_Filmasid_Filmas WHERE laikas=?laikas AND fk_Kino_saleid_Kino_sale= ?fk_Kino_saleid_Kino_sale AND filmo_prad_laik = ?filmo_prad_laik";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?laikas", MySqlDbType.Date).Value = ShowTimeViewModel.laikas[i];
mySqlCommand.Parameters.Add("?fk_Filmasid_Filmas", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Filmasid_Filmas[i];
mySqlCommand.Parameters.Add("?fk_Kino_saleid_Kino_sale", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Kino_saleid_Kino_sale[0];
mySqlCommand.Parameters.Add("?filmo_prad_laik", MySqlDbType.Int32).Value = ShowTimeViewModel.filmo_prad_laik[i];
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
notInsert = true;
}
}
if (!notInsert)
{
if (ShowTimeViewModel.fk_Filmasid_Filmas[i] != 0)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"INSERT INTO `rodymo_laikas`
(
`laikas`,
`fk_Filmasid_Filmas`,
`fk_Kino_saleid_Kino_sale`,
`filmo_prad_laik`)
VALUES (
?laikas,
?fk_Filmasid_Filmas,
?fk_Kino_saleid_Kino_sale,
?filmo_prad_laik)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?laikas", MySqlDbType.Date).Value = ShowTimeViewModel.laikas[i];
mySqlCommand.Parameters.Add("?fk_Filmasid_Filmas", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Filmasid_Filmas[i];
mySqlCommand.Parameters.Add("?fk_Kino_saleid_Kino_sale", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Kino_saleid_Kino_sale[0];
mySqlCommand.Parameters.Add("?filmo_prad_laik", MySqlDbType.Int32).Value = ShowTimeViewModel.filmo_prad_laik[i];
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
}
}
return(true);
}
public bool Insert(ShowTimeCreate ShowTimeViewModel)
{
for (int i = 0; i < ShowTimeViewModel.fk_Filmasid_Filmas.Length; i++)
{
if (ShowTimeViewModel.fk_Filmasid_Filmas[i] != 0)
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"INSERT INTO `rodymo_laikas`
(
`laikas`,
`fk_Filmasid_Filmas`,
`fk_Kino_saleid_Kino_sale`,
`filmo_prad_laik`)
VALUES (
?laikas,
?fk_Filmasid_Filmas,
?fk_Kino_saleid_Kino_sale,
?filmo_prad_laik)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?laikas", MySqlDbType.Date).Value = ShowTimeViewModel.laikas[i];
mySqlCommand.Parameters.Add("?fk_Filmasid_Filmas", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Filmasid_Filmas[i];
mySqlCommand.Parameters.Add("?fk_Kino_saleid_Kino_sale", MySqlDbType.Int32).Value = ShowTimeViewModel.fk_Kino_saleid_Kino_sale[0];
mySqlCommand.Parameters.Add("?filmo_prad_laik", MySqlDbType.Int32).Value = ShowTimeViewModel.filmo_prad_laik[i];
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
}
return(true);
}
public ActionResult EditShowTime()
{
ShowTimeCreate ShowTimeCreateViewModel = new ShowTimeCreate();
//Užpildomi pasirinkimų sąrašai duomenimis iš duomenų saugyklų
PopulateSelections(ShowTimeCreateViewModel);
return(View(ShowTimeCreateViewModel));
}
public ActionResult RepertoryPage()
{
ShowTimeCreate ShowTimeCreateViewModel = new ShowTimeCreate();
//Užpildomi pasirinkimų sąrašai duomenimis iš duomenų saugyklų
PopulateSelections(ShowTimeCreateViewModel);
ViewBag.MyList = ShowTimeCreateViewModel.Filmo_Prad_List;
ModelState.Clear();
return(View(showTimeRepo.SelectRepertory()));
}
public ActionResult EditShowTime(ShowTimeCreate collection)
{
try
{
//Pridedamas naujas automobilis
showTimeRepo.insertAndUpdate(collection);
return(RedirectToAction("SelectHalls"));
}
catch
{
PopulateSelections(collection);
return(View(collection));
}
}
public void PopulateSelections(ShowTimeCreate SaleCreateViewModel)
{
var filmuPradLaikai = filmuPradLaikRepo.getFilmoPradLaikai();
var sales = saleRepo.getSales();
var filmai = filmRepo.getMovie();
List <SelectListItem> selectListFilmuPradLaik = new List <SelectListItem>();
List <SelectListItem> selectListSales = new List <SelectListItem>();
List <SelectListItem> selectListFilmai = new List <SelectListItem>();
//užpildomas kebulų sąrašas iš duomenų bazės
foreach (var item in filmuPradLaikai)
{
selectListFilmuPradLaik.Add(new SelectListItem()
{
Value = Convert.ToString(item.id), Text = item.name
});
}
foreach (var item in sales)
{
selectListSales.Add(new SelectListItem()
{
Value = Convert.ToString(item.id), Text = item.pavadinimas
});
}
foreach (var item in filmai)
{
selectListFilmai.Add(new SelectListItem()
{
Value = Convert.ToString(item.id), Text = item.pavadinimas
});
}
//Sarašai priskiriami vaizdo objektui
SaleCreateViewModel.Filmo_Prad_List = selectListFilmuPradLaik;
SaleCreateViewModel.Sale_List = selectListSales;
SaleCreateViewModel.Filmai_List = selectListFilmai;
}
public bool Update(ShowTimeCreate ShowTimeViewModel)
{
return(true);
}
