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