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)); }