public static Mem_Recomendation GetMem_RecomendationByID(int id) { Mem_Recomendation mem_Recomendation = new Mem_Recomendation(); SqlMem_RecomendationProvider sqlMem_RecomendationProvider = new SqlMem_RecomendationProvider(); mem_Recomendation = sqlMem_RecomendationProvider.GetMem_RecomendationByID(id); return(mem_Recomendation); }
public int InsertMem_Recomendation(Mem_Recomendation mem_Recomendation) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("IEB_InsertMem_Recomendation", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Mem_RecomendationID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@RecomendationDate", SqlDbType.DateTime).Value = mem_Recomendation.RecomendationDate; cmd.Parameters.Add("@Mem_MemberID", SqlDbType.Int).Value = mem_Recomendation.Mem_MemberID; cmd.Parameters.Add("@Comn_RowSatusID", SqlDbType.Int).Value = mem_Recomendation.Comn_RowSatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@Mem_RecomendationID"].Value); } }
public Mem_Recomendation GetMem_RecomendationFromReader(IDataReader reader) { try { Mem_Recomendation mem_Recomendation = new Mem_Recomendation ( (int)reader["Mem_RecomendationID"], (DateTime)reader["RecomendationDate"], (int)reader["Mem_MemberID"], (int)reader["Comn_RowSatusID"] ); return(mem_Recomendation); } catch (Exception ex) { return(null); } }
public static bool UpdateMem_Recomendation(Mem_Recomendation mem_Recomendation) { SqlMem_RecomendationProvider sqlMem_RecomendationProvider = new SqlMem_RecomendationProvider(); return(sqlMem_RecomendationProvider.UpdateMem_Recomendation(mem_Recomendation)); }
public static int InsertMem_Recomendation(Mem_Recomendation mem_Recomendation) { SqlMem_RecomendationProvider sqlMem_RecomendationProvider = new SqlMem_RecomendationProvider(); return(sqlMem_RecomendationProvider.InsertMem_Recomendation(mem_Recomendation)); }