public List <Sala> getListSALAS()
{
using (var db = new Cinema_Model())
{
return(db.Sala.ToList());
}
}
private void btn_Update_Click(object sender, EventArgs e)
{
cinema_Model = new Cinema_Model();
if (PerformValidation(groupBox1))
{
ATB();
bool DialogDel = MessageBox.Show("Are you sure to EDIT this Data", "EDIT", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes;
if (DialogDel)
{
CinemaCRUD = new Cinema_CRUD_Service();
if (CinemaCRUD.Update(cinema_Model))
{
MessageBox.Show("Data UPDATED !!");
this.Close();
}
else
{
MessageBox.Show("Data FAILED UPDATED !!");
this.Close();
}
}
else
{
}
((FrmEditCinema)f).displaydatagrid();
}
}
public List <Tipo_sala> getlistTipo_Sala()
{
using (var db = new Cinema_Model())
{
return(db.Tipo_sala.ToList());
}
}
/*Método para obtener los id de sala*/
public List <Sala> getSala()//método para obtener todos los datos del asiento
{
using (var db = new Cinema_Model())
{
return(db.Sala.ToList());
}
}
public List <Asiento> GetAsiento()//método para obtener todos los datos del asiento
{
using (var db = new Cinema_Model())
{
return(db.Asiento.ToList());
}
}
public bool Update(Cinema_Model cinema_Model)
{
bool result = false;
try
{
DBCon = new DBConnection();
query = string.Format(@"UPDATE `cinemas`
SET
`cinema_name` = '{0}',
`movie_name` = '{1}',
`theather` = '{2}',
`time` = '{3}',
`class` = '{4}'
WHERE `cinema_id` = '{5}';",
cinema_Model.Cinema_Name,
cinema_Model.Movie_name,
cinema_Model.Theather,
cinema_Model.Time,
cinema_Model.Class,
cinema_Model.Cinema_Id);
DBCon.ConnectionOpen();
cmd = new MySqlCommand(query, DBCon.Connection);
result = cmd.ExecuteNonQuery() == 1;
DBCon.ConnectionClose();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(result);
}
public bool Insert(Cinema_Model cinema_Model)
{
bool result = false;
query = "INSERT INTO `cinemas`(`cinema_name`,`movie_name`,`theather`,`time`,`class`)" +
"VALUES(@cinema_name,@movie_name,@theather,@time,@class)";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add("@cinema_name", cinema_Model.Cinema_Name);
cmd.Parameters.Add("@movie_name", cinema_Model.Movie_name);
cmd.Parameters.Add("@theather", cinema_Model.Theather);
cmd.Parameters.Add("@time", cinema_Model.Time);
cmd.Parameters.Add("@class", cinema_Model.Class);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(result = true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(result);
}
}
}
public void LoadForm()
{
cinema_Model = new Cinema_Model();
txt_CinemaName.Text = ((FrmEditCinema)f).txt_CinemaName.Text;
txt_MovieName.Text = ((FrmEditCinema)f).txt_MovieName.Text;
txt_Theather.Text = ((FrmEditCinema)f).txt_Theather.Text;
txt_Time.Text = ((FrmEditCinema)f).txt_Time.Text;
txt_Class.Text = ((FrmEditCinema)f).txt_Class.Text;
}
public void ATB()
{
cinema_Model = new Cinema_Model();
cinema_Model.Cinema_Name = txt_CinemaName.Text;
cinema_Model.Movie_name = txt_MovieName.Text;
cinema_Model.Theather = txt_Theather.Text;
cinema_Model.Time = txt_Time.Text;
cinema_Model.Class = txt_Class.Text;
}
public void AgregarSala(Sala item)
{
try
{
using (var db = new Cinema_Model())
{
db.Sala.Add(item);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception("Verifica los datos a Insertar");//es un error que yo creo
}
}
public List <vSala> Sala_c_tipo()
{
List <vSala> obj = new List <vSala>();
using (var db = new Cinema_Model())
{
obj = (from x in db.Sala
select new vSala
{
Cod_sala = x.Cod_sala,
Num_sala = x.Num_sala,
cod_tipo = x.cod_tipo,
NombreSala_tipo = x.Tipo_sala.Nombre_sala
}).ToList();
return(obj);
}
}
public List <vAsiento> AsientoComplete()
{
List <vAsiento> obj = new List <vAsiento>();
using (var db = new Cinema_Model())
{
obj = (from x in db.Asiento
select new vAsiento
{
id_siento = x.id_siento,
fila = x.fila,
columna = x.columna,
Cod_sala = x.Cod_sala,
Num_sala = x.Sala.Cod_sala
}).ToList();
return(obj);
}
}
public List <Sala> getListSala(Hashtable datos)
{
try
{
using (var db = new Cinema_Model())
{
string query = @"SELECT VALUE SALA FROM Cinema_Model.Sala As Sala";
StringBuilder wheereis = new StringBuilder();
List <ObjectParameter> parameters = new List <ObjectParameter>();
if (datos.Contains("NUM_SALA"))
{
if (wheereis.Length > 0)
{
wheereis.Append(" AND ");
}
wheereis.Append("Sala.NUM_SALA=@NUM_SALA");
parameters.Add(new ObjectParameter("NUM_SALA", datos["NUM_SALA"]));
}
if (wheereis.Length > 0)
{
query += " WHERE " + wheereis.ToString();
}
ObjectContext oc;
oc = ((IObjectContextAdapter)db).ObjectContext;
var q = new ObjectQuery <Sala>(query, oc);
if (wheereis.Length > 0)
{
foreach (ObjectParameter parametro in parameters)
{
q.Parameters.Add(parametro);
}
}
return(q.ToList());
}
}
catch (Exception e)
{
throw new Exception("Verifica los datos a buscar");
}
}
public void BorrarSala(Sala item)
{
try
{
using (var db = new Cinema_Model())
{
Sala obj = db.Sala.Where(x => x.Num_sala == item.Num_sala).FirstOrDefault();
if (obj != null)
{
MessageBox.Show("si entro");
db.Sala.Remove(obj);
db.SaveChanges();
}
}
}
catch (Exception e)
{
throw new Exception("Verifica los datos a Eliminar");//es un error que yo creo
}
}
public void ModificarSala(Sala item)
{
try
{
using (var db = new Cinema_Model())
{
Sala obj = db.Sala.Where(x => x.Cod_sala == item.Cod_sala).FirstOrDefault();
if (obj != null)
{
obj.Num_sala = item.Num_sala;
obj.cod_tipo = item.cod_tipo;
db.SaveChanges();
}
}
}
catch (Exception e)
{
throw new Exception("Verifica los datos a Actualizar");//es un error que yo creo
}
}
