public static void ChangeStatus(IMorningMeetingImage MorningMeetingImage)
{
SqlParameter[] _parameters = new SqlParameter[]
{
new SqlParameter("@Id", MorningMeetingImage.Id),
new SqlParameter("@Status", MorningMeetingImage.Status),
new SqlParameter("@SysModifier", MorningMeetingImage.SysModifier)
};
SqlHelper.ExecuteNonQuery(Configuration.ConnectionString, "sp_MorningMeetingImages_ChangeStatusById", _parameters);
}
public static int Insert(IMorningMeetingImage MorningMeetingImage)
{
SqlParameter[] _parameters = new SqlParameter[]
{
new SqlParameter("@Department", MorningMeetingImage.Department),
new SqlParameter("@Caption", MorningMeetingImage.Caption),
new SqlParameter("@ImageName", MorningMeetingImage.ImageName),
new SqlParameter("@Photo", MorningMeetingImage.Photo),
new SqlParameter("@Status", MorningMeetingImage.Status),
new SqlParameter("@SysCreator", MorningMeetingImage.SysCreator)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(Configuration.ConnectionString, "sp_MorningMeetingImages_InsertImage", _parameters)));
}
public static void Update(IMorningMeetingImage MorningMeetingImage)
{
SqlParameter[] _parameters = new SqlParameter[]
{
new SqlParameter("@Id", MorningMeetingImage.Id),
new SqlParameter("@Department", MorningMeetingImage.Department),
new SqlParameter("@Caption", MorningMeetingImage.Caption),
new SqlParameter("@ImageName", MorningMeetingImage.ImageName),
new SqlParameter("@Photo", MorningMeetingImage.Photo),
new SqlParameter("@Status", MorningMeetingImage.Status),
new SqlParameter("@SysModifier", MorningMeetingImage.SysModifier)
};
SqlHelper.ExecuteNonQuery(Configuration.ConnectionString, "sp_MorningMeetingImages_UpdateById", _parameters);
}
public static DataSet Retrieve(IMorningMeetingImage MorningMeetingImage)
{
SqlParameter[] _parameters = new SqlParameter[]
{
new SqlParameter("@Department", MorningMeetingImage.Department),
new SqlParameter("@Caption", MorningMeetingImage.Caption),
new SqlParameter("@Status", MorningMeetingImage.Status),
new SqlParameter("@SysCreator", MorningMeetingImage.SysCreator),
new SqlParameter("@SysCreatedFrom", MorningMeetingImage.SysCreated),
new SqlParameter("@SysCreatedTo", MorningMeetingImage.SysCreated2),
new SqlParameter("@SysModifier", MorningMeetingImage.SysModifier),
new SqlParameter("@SysModifiedFrom", MorningMeetingImage.SysModified),
new SqlParameter("@SysModifiedTo", MorningMeetingImage.SysModified2)
};
return(SqlHelper.ExecuteDataset(Configuration.ConnectionString, "sp_MorningMeetingImages_SearchMorningMeetingImages", _parameters));
}
