public static Mem_ApprovedCouncilMeeting GetMem_ApprovedCouncilMeetingByID(int id)
{
Mem_ApprovedCouncilMeeting mem_ApprovedCouncilMeeting = new Mem_ApprovedCouncilMeeting();
SqlMem_ApprovedCouncilMeetingProvider sqlMem_ApprovedCouncilMeetingProvider = new SqlMem_ApprovedCouncilMeetingProvider();
mem_ApprovedCouncilMeeting = sqlMem_ApprovedCouncilMeetingProvider.GetMem_ApprovedCouncilMeetingByID(id);
return(mem_ApprovedCouncilMeeting);
}
public bool UpdateMem_ApprovedCouncilMeeting(Mem_ApprovedCouncilMeeting mem_ApprovedCouncilMeeting)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateMem_ApprovedCouncilMeeting", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mem_ApprovedCouncilMeetingID", SqlDbType.Int).Value = mem_ApprovedCouncilMeeting.Mem_ApprovedCouncilMeetingID;
cmd.Parameters.Add("@Mem_ApprovedCouncilMeetingName", SqlDbType.NVarChar).Value = mem_ApprovedCouncilMeeting.Mem_ApprovedCouncilMeetingName;
cmd.Parameters.Add("@MeetingDate", SqlDbType.NVarChar).Value = mem_ApprovedCouncilMeeting.MeetingDate;
cmd.Parameters.Add("@Chairman", SqlDbType.NVarChar).Value = mem_ApprovedCouncilMeeting.Chairman;
cmd.Parameters.Add("@MembershipCommittee", SqlDbType.NVarChar).Value = mem_ApprovedCouncilMeeting.MembershipCommittee;
cmd.Parameters.Add("@MemberSecretary", SqlDbType.NVarChar).Value = mem_ApprovedCouncilMeeting.MemberSecretary;
cmd.Parameters.Add("@Details", SqlDbType.NText).Value = mem_ApprovedCouncilMeeting.Details;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Mem_ApprovedCouncilMeeting GetMem_ApprovedCouncilMeetingFromReader(IDataReader reader)
{
try
{
Mem_ApprovedCouncilMeeting mem_ApprovedCouncilMeeting = new Mem_ApprovedCouncilMeeting
(
(int)reader["Mem_ApprovedCouncilMeetingID"],
reader["Mem_ApprovedCouncilMeetingName"].ToString(),
(DateTime)reader["MeetingDate"],
reader["Chairman"].ToString(),
reader["MembershipCommittee"].ToString(),
reader["MemberSecretary"].ToString(),
reader["Details"].ToString()
);
return(mem_ApprovedCouncilMeeting);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateMem_ApprovedCouncilMeeting(Mem_ApprovedCouncilMeeting mem_ApprovedCouncilMeeting)
{
SqlMem_ApprovedCouncilMeetingProvider sqlMem_ApprovedCouncilMeetingProvider = new SqlMem_ApprovedCouncilMeetingProvider();
return(sqlMem_ApprovedCouncilMeetingProvider.UpdateMem_ApprovedCouncilMeeting(mem_ApprovedCouncilMeeting));
}
public static int InsertMem_ApprovedCouncilMeeting(Mem_ApprovedCouncilMeeting mem_ApprovedCouncilMeeting)
{
SqlMem_ApprovedCouncilMeetingProvider sqlMem_ApprovedCouncilMeetingProvider = new SqlMem_ApprovedCouncilMeetingProvider();
return(sqlMem_ApprovedCouncilMeetingProvider.InsertMem_ApprovedCouncilMeeting(mem_ApprovedCouncilMeeting));
}
