public int InsertFilm(dtoFilms film)
{
int count = 0;
try
{
string sql = "INSERT [dbo].[Film] ([FilmName], [ReleaseDate], [StopDate], [Duration], [GenreID]) VALUES (@Name, @ReleaseDate, @StopDate, @Duration, @GenreID)";
SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.NVarChar);
parameterName.Value = film.FilmName;
SqlParameter parameterReleaseDate = new SqlParameter("@ReleaseDate", SqlDbType.DateTime);
parameterReleaseDate.Value = film.ReleaseDate;
SqlParameter parameterStopDate = new SqlParameter("@StopDate", SqlDbType.DateTime);
parameterStopDate.Value = film.StopDate;
SqlParameter parameterDuration = new SqlParameter("@Duration", SqlDbType.Time);
parameterDuration.Value = film.Duration;
SqlParameter parameterGenreID = new SqlParameter("@GenreID", SqlDbType.Int);
parameterGenreID.Value = film.GenreID;
count = InsertUpdateDeleteData(sql, new[] { parameterName, parameterReleaseDate, parameterStopDate, parameterDuration, parameterGenreID });
}
finally
{
CloseConnection();
}
return(count);
}
public int UpdateFilmFromID(dtoFilms film)
{
int count = 0;
try
{
string sql = "UPDATE [dbo].[Film] SET [FilmName] = @Name, [ReleaseDate] = @ReleaseDate, [StopDate] = @StopDate, [Duration] = @Duration, [GenreID] = @GenreID WHERE [FilmID] = @FilmID";
SqlParameter parameterID = new SqlParameter("@FilmID", SqlDbType.Int);
parameterID.Value = film.FilmID;
SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.NVarChar);
parameterName.Value = film.FilmName;
SqlParameter parameterReleaseDate = new SqlParameter("@ReleaseDate", SqlDbType.DateTime);
parameterReleaseDate.Value = film.ReleaseDate;
SqlParameter parameterStopDate = new SqlParameter("@StopDate", SqlDbType.DateTime);
parameterStopDate.Value = film.StopDate;
SqlParameter parameterDuration = new SqlParameter("@Duration", SqlDbType.Time);
parameterDuration.Value = film.Duration;
SqlParameter parameterGenreID = new SqlParameter("@GenreID", SqlDbType.Int);
parameterGenreID.Value = film.GenreID;
count = InsertUpdateDeleteData(sql, new[] { parameterName, parameterReleaseDate, parameterStopDate, parameterDuration, parameterGenreID });
}
finally
{
CloseConnection();
}
return(count);
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtFilmName.Text == "" || txtGenre.Text == "" || dteReleaseDate.Text == "" || dteStopDate.Text == "" || tseDuration.Text == "")
{
throw new Exception("Vui lòng nhập đầy đủ thông tin!");
}
else
{
dtoFilms dtoFilms = new dtoFilms();
dtoFilms.FilmName = txtFilmName.Text;
dtoFilms.GenreID = Convert.ToInt32(txtGenre.Text);
dtoFilms.Duration = tseDuration.TimeSpan;
dtoFilms.ReleaseDate = dteReleaseDate.DateTime;
dtoFilms.StopDate = dteStopDate.DateTime;
int count = balFilm.Insert(dtoFilms);
txtFilmName.Text = "";
txtGenre.Text = "";
dteReleaseDate.Text = "";
dteStopDate.Text = "";
tseDuration.Text = "";
BindingData();
string mess = "Thông tin phim đã được thêm thành công!" + "\nSố hàng đã được thêm: " + count.ToString();
XtraMessageBox.Show(mess, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int Insert(dtoFilms dtoFilms)
{
dalFilm film = new dalFilm();
int count = film.InsertFilm(dtoFilms);
return(count);
}
public int Update(dtoFilms viewFilm)
{
dalFilm Film = new dalFilm();
int count = Film.UpdateFilmFromID(viewFilm);
return(count);
}
public List <dtoFilms> GetFilms()
{
dalFilm dalFilm = new dalFilm();
List <dtoFilms> listEmp = new List <dtoFilms>();
DataTable Films = dalFilm.GetFilms();
for (int i = 0; i < Films.Rows.Count; i++)
{
dtoFilms Film = new dtoFilms();
DataRow row = Films.Rows[i];
Film.FilmID = Convert.ToInt32(row[0]);
Film.FilmName = row[1].ToString();
Film.ReleaseDate = Convert.ToDateTime(row[2]);
Film.StopDate = Convert.ToDateTime(row[3]);
Film.Duration = (TimeSpan)row[4];
Film.GenreID = Convert.ToInt32(row[5]);
listEmp.Add(Film);
}
return(listEmp);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
dtoFilms dtoFilms = new dtoFilms();
dtoFilms = dgvViewFilm.GetFocusedRow() as dtoFilms;
if (dtoFilms.FilmName == "" || dtoFilms.Duration.ToString() == "" || dtoFilms.ReleaseDate.ToString() == "" || dtoFilms.StopDate.ToString() == "" || dtoFilms.GenreID.ToString() == "")
{
throw new Exception("Vui lòng không để trống thông tin!");
}
else
{
int count = balFilm.Update(dtoFilms);
XtraMessageBox.Show("Cập nhập thông tin movie thành công! \nSố hàng đã được cập nhập: " + count.ToString(), "Succesful", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
