public bool UpdateDvd(Dvd dvd)
{
try
{
using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString))
{
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
SqlCommand cmd = new SqlCommand("DvdUpdate", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DvdId", SqlDbType.Int).Value = dvd.DvdId;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = dvd.Title;
cmd.Parameters.Add("@ReleaseYear", SqlDbType.Int).Value = dvd.ReleaseYear;
cmd.Parameters.Add("@DirectorId", SqlDbType.Int).Value = dvd.DirectorId;
cmd.Parameters.Add("@RatingId", SqlDbType.Int).Value = dvd.RatingId;
cmd.Parameters.Add("@Note", SqlDbType.NVarChar).Value = dvd.Note;
if (cnn.State != ConnectionState.Open)
{
cnn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
public bool UpdateDvd(Dvd dvd)
{
dvdList.RemoveAll(d => d.DvdId == dvd.DvdId);
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
dvdList.Add(dvd);
return(true);
}
public int InsertDvd(Dvd dvd)
{
dvd.DvdId = dvdList.Count + 1;
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
dvdList.Add(dvd);
return(dvd.DvdId);
}
private void lsEquities_SelectedIndexChanged(object sender, System.EventArgs e)
{
int i = lsEquities.SelectedIndex;
EquitiesAbstract eq = (EquitiesAbstract)lsEquities.Items[i];
mchoice = DirectorFactory.GetBuilder(eq);
this.Controls.Remove(pnl);
pnl = mchoice.GetPanelResult();
setPanel();
}
public List <Dvd> GetDvdList()
{
List <Dvd> result = new List <Dvd>();
try
{
using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString))
{
DataSet dataSet = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter("DvdSelect", cnn);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
if (cnn.State != ConnectionState.Open)
{
cnn.Open();
}
adapter.Fill(dataSet);
if (dataSet.Tables.Count > 0)
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
DataRow r = dataSet.Tables[0].Rows[i];
Rating rate = RatingFactory.Create().GetRatingbyId((int)r["RatingId"]);
Director director = DirectorFactory.Create().GetDirectorbyId((int)r["DirectorId"]);
result.Add(new Dvd
{
DvdId = (int)r["DvdId"],
Title = r["Title"].ToString(),
ReleaseYear = (int)r["ReleaseYear"],
DirectorId = (int)r["DirectorId"],
RatingId = (int)r["RatingId"],
Note = r["Note"].ToString(),
Rating = rate,
Director = director
});
}
}
}
return(result);
}catch (Exception e)
{
return(null);
}
}
public bool UpdateDvd(Dvd dvd)
{
try
{
using (var ctx = new DvdContext())
{
//dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId);
//dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId);
ctx.Entry(dvd).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
public int InsertDvd(Dvd dvd)
{
try
{
using (var ctx = new DvdContext())
{
//dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId);
//dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId);
ctx.Dvd.Add(dvd);
ctx.SaveChanges();
//dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId);
//dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId);
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
return(ctx.Dvd.Max(d => d.DvdId));
}
}
catch (Exception e)
{
return(-1);
}
}
public int InsertDvd(Dvd dvd)
{
try
{
using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString))
{
dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId);
dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId);
SqlCommand cmd = new SqlCommand("DvdInsert", cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter dvdIDParam = new SqlParameter("@DvdId", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(dvdIDParam);
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = dvd.Title;
cmd.Parameters.Add("@ReleaseYear", SqlDbType.Int).Value = dvd.ReleaseYear;
cmd.Parameters.Add("@DirectorId", SqlDbType.Int).Value = dvd.DirectorId;
cmd.Parameters.Add("@RatingId", SqlDbType.Int).Value = dvd.RatingId;
cmd.Parameters.Add("@Note", SqlDbType.NVarChar).Value = dvd.Note;
if (cnn.State != ConnectionState.Open)
{
cnn.Open();
}
cmd.ExecuteNonQuery();
dvd.DvdId = (int)dvdIDParam.Value;
return(dvd.DvdId);
}
}
catch (Exception e)
{
return(-1);
}
}
