public static Web_Event GetWeb_EventByID(int id)
{
Web_Event web_Event = new Web_Event();
SqlWeb_EventProvider sqlWeb_EventProvider = new SqlWeb_EventProvider();
web_Event = sqlWeb_EventProvider.GetWeb_EventByID(id);
return(web_Event);
}
public Web_Event GetWeb_EventFromReader(IDataReader reader)
{
try
{
Web_Event web_Event = new Web_Event
(
(int)reader["Web_EventID"],
reader["EventTitle"].ToString(),
reader["EventBoardMessage"].ToString(),
reader["BreakingNews"].ToString(),
reader["NoticeBoardMessage"].ToString(),
reader["EventDetails"].ToString(),
(DateTime)reader["EventDate"],
(DateTime)reader["NoticeStartDate"],
(DateTime)reader["NoticeEndDate"],
reader["SmallPictureURL"].ToString(),
reader["DetailsPictureURL"].ToString(),
(int)reader["Web_EventTypeID"],
(bool)reader["TopMarque"],
(bool)reader["NoticeBoard"],
(bool)reader["EventBoard"],
(bool)reader["EventArcrive"],
(bool)reader["EventArcriveFrontPage"],
(decimal)reader["Ordering"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
return(web_Event);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateWeb_Event(Web_Event web_Event)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateWeb_Event", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Web_EventID", SqlDbType.Int).Value = web_Event.Web_EventID;
cmd.Parameters.Add("@EventTitle", SqlDbType.NVarChar).Value = web_Event.EventTitle;
cmd.Parameters.Add("@EventBoardMessage", SqlDbType.NVarChar).Value = web_Event.EventBoardMessage;
cmd.Parameters.Add("@BreakingNews", SqlDbType.NVarChar).Value = web_Event.BreakingNews;
cmd.Parameters.Add("@NoticeBoardMessage", SqlDbType.NVarChar).Value = web_Event.NoticeBoardMessage;
cmd.Parameters.Add("@EventDetails", SqlDbType.NVarChar).Value = web_Event.EventDetails;
cmd.Parameters.Add("@EventDate", SqlDbType.DateTime).Value = web_Event.EventDate;
cmd.Parameters.Add("@NoticeStartDate", SqlDbType.DateTime).Value = web_Event.NoticeStartDate;
cmd.Parameters.Add("@NoticeEndDate", SqlDbType.DateTime).Value = web_Event.NoticeEndDate;
cmd.Parameters.Add("@SmallPictureURL", SqlDbType.NVarChar).Value = web_Event.SmallPictureURL;
cmd.Parameters.Add("@DetailsPictureURL", SqlDbType.NVarChar).Value = web_Event.DetailsPictureURL;
cmd.Parameters.Add("@Web_EventTypeID", SqlDbType.Int).Value = web_Event.Web_EventTypeID;
cmd.Parameters.Add("@TopMarque", SqlDbType.Bit).Value = web_Event.TopMarque;
cmd.Parameters.Add("@NoticeBoard", SqlDbType.Bit).Value = web_Event.NoticeBoard;
cmd.Parameters.Add("@EventBoard", SqlDbType.Bit).Value = web_Event.EventBoard;
cmd.Parameters.Add("@EventArcrive", SqlDbType.Bit).Value = web_Event.EventArcrive;
cmd.Parameters.Add("@EventArcriveFrontPage", SqlDbType.Bit).Value = web_Event.EventArcriveFrontPage;
cmd.Parameters.Add("@Ordering", SqlDbType.Decimal).Value = web_Event.Ordering;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = web_Event.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = web_Event.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = web_Event.ExtraField3;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = web_Event.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = web_Event.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = web_Event.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = web_Event.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = web_Event.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static bool UpdateWeb_Event(Web_Event web_Event)
{
SqlWeb_EventProvider sqlWeb_EventProvider = new SqlWeb_EventProvider();
return(sqlWeb_EventProvider.UpdateWeb_Event(web_Event));
}
public static int InsertWeb_Event(Web_Event web_Event)
{
SqlWeb_EventProvider sqlWeb_EventProvider = new SqlWeb_EventProvider();
return(sqlWeb_EventProvider.InsertWeb_Event(web_Event));
}
