public Web_EventFile GetWeb_EventFileFromReader(IDataReader reader)
{
try
{
Web_EventFile web_EventFile = new Web_EventFile
(
(int)reader["Web_EventFileID"],
(int)reader["Web_EventID"],
reader["EventFileName"].ToString(),
(bool)reader["Visibility"],
(decimal)reader["Ordering"],
(int)reader["RowStatusID"],
reader["AlterTag"].ToString(),
reader["Details"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString()
);
return(web_EventFile);
}
catch (Exception ex)
{
return(null);
}
}
public static Web_EventFile GetWeb_EventFileByID(int id)
{
Web_EventFile web_EventFile = new Web_EventFile();
SqlWeb_EventFileProvider sqlWeb_EventFileProvider = new SqlWeb_EventFileProvider();
web_EventFile = sqlWeb_EventFileProvider.GetWeb_EventFileByID(id);
return(web_EventFile);
}
public bool UpdateWeb_EventFile(Web_EventFile web_EventFile)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateWeb_EventFile", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Web_EventFileID", SqlDbType.Int).Value = web_EventFile.Web_EventFileID;
cmd.Parameters.Add("@Web_EventID", SqlDbType.Int).Value = web_EventFile.Web_EventID;
cmd.Parameters.Add("@EventFileName", SqlDbType.NVarChar).Value = web_EventFile.EventFileName;
cmd.Parameters.Add("@Visibility", SqlDbType.Bit).Value = web_EventFile.Visibility;
cmd.Parameters.Add("@Ordering", SqlDbType.Decimal).Value = web_EventFile.Ordering;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = web_EventFile.RowStatusID;
cmd.Parameters.Add("@AlterTag", SqlDbType.NVarChar).Value = web_EventFile.AlterTag;
cmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = web_EventFile.Details;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = web_EventFile.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = web_EventFile.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = web_EventFile.ExtraField3;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static bool UpdateWeb_EventFile(Web_EventFile web_EventFile)
{
SqlWeb_EventFileProvider sqlWeb_EventFileProvider = new SqlWeb_EventFileProvider();
return(sqlWeb_EventFileProvider.UpdateWeb_EventFile(web_EventFile));
}
public static int InsertWeb_EventFile(Web_EventFile web_EventFile)
{
SqlWeb_EventFileProvider sqlWeb_EventFileProvider = new SqlWeb_EventFileProvider();
return(sqlWeb_EventFileProvider.InsertWeb_EventFile(web_EventFile));
}
