public static int UpdateFestivalDetail(FestivalDetail fe)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("update FestivalDetail set PoinPenilaian=@poinPenilaian,UpdatedDate=@UpdatedDate,UpdatedBy=@UpdatedBy where FestivalID=@festivalID and PoinID=@poinID ", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
cmd.Parameters.AddWithValue("@festivalID", fe.festivalID);
cmd.Parameters.AddWithValue("@poinID", fe.poinID);
cmd.Parameters.AddWithValue("@poinPenilaian", fe.poinPenilaian);
cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", fe.UpdatedBy);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public static IEnumerable <FestivalDetail> getFestivalDetailList(string festid)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select * from FestivalDetail where FestivalID=@festivalID and deleted=0", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
cmd.Parameters.AddWithValue("@festivalID", festid);
List <FestivalDetail> newFestival = new List <FestivalDetail>();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
FestivalDetail fes = new FestivalDetail(rd.GetString(0), rd.GetInt32(1), rd.GetString(2));
newFestival.Add(fes);
}
return(newFestival);
}
public static int InsertFestivalDetail(FestivalDetail fe)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("insert into FestivalDetail (festivalID,poinID,poinPenilaian,CreatedDate,CreatedBy,UpdatedDate,UpdatedBy) values (@festivalID,@poinID,@poinPenilaian,@CreatedDate,@CreatedBy,@UpdatedDate,@UpdatedBy)", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
cmd.Parameters.AddWithValue("@festivalID", fe.festivalID);
cmd.Parameters.AddWithValue("@poinID", fe.poinID);
cmd.Parameters.AddWithValue("@poinPenilaian", fe.poinPenilaian);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@CreatedBy", fe.UpdatedBy);
cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", fe.UpdatedBy);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public static int DeleteFestivalDetail(FestivalDetail fe)
{
SqlConnection con = new SqlConnection(cs);
//SqlCommand cmd = new SqlCommand("delete from FestivalDetail where FestivalID='" + fe.festivalID + "' and PoinID='" + fe.poinID + "'", con);
SqlCommand cmd = new SqlCommand("update FestivalDetail set deleted=1, UpdatedDate=@UpdatedDate,UpdatedBy=@UpdatedBy where FestivalID=@festivalID and PoinID=@poinID and deleted=0", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
cmd.Parameters.AddWithValue("@festivalID", fe.festivalID);
cmd.Parameters.AddWithValue("@poinID", fe.poinID);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@CreatedBy", fe.UpdatedBy);
cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", fe.UpdatedBy);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public static int UpdateFestivalDetail(FestivalDetail fe)
{
return(FestivalModel.UpdateFestivalDetail(fe));
}
public static int InsertFestivalDetail(FestivalDetail fe)
{
return(FestivalModel.InsertFestivalDetail(fe));
}
public static int DeleteFestivalDetail(FestivalDetail fe)
{
return(FestivalModel.DeleteFestivalDetail(fe));
}