public IList<AssociationEvent> GetAssociationEventListData()
{
StringBuilder sql = new StringBuilder();
AssociationEvent obj = new AssociationEvent();
sql = SqlBuilder.Query(obj);
DataTable table = ConnectDBToGetData(sql);
return DataTableToList<AssociationEvent>(table);
}
public void CreateAssociationEvent_B(AssociationEvent obj)
{
StringBuilder sql = new StringBuilder();
sql = SqlBuilder.Insert(obj);
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@AssociationEvent_Title", Value= obj.AssociationEvent_Title},
new SqlParameter() {ParameterName = "@AssociationEvent_Detail", Value = obj.AssociationEvent_Detail},
new SqlParameter() {ParameterName = "@AssociationEvent_Date", Value = obj.AssociationEvent_Date},
new SqlParameter() {ParameterName = "@AssociationEvent_Picture", Value = obj.AssociationEvent_Picture},
new SqlParameter() {ParameterName = "@AssociationEvent_Modifier", Value = obj.AssociationEvent_Modifier},
new SqlParameter() {ParameterName = "@AssociationEvent_Modificationdatetime", Value = obj.AssociationEvent_Modificationdatetime}
};
ConnectDBToSendData(sql, parameter);
}
public object UpdateAssociationEventdata_B(AssociationEvent objPara)
{
BAEModel.UpdateAssociationEvent_B(objPara);
object objData = true;
return objData;
}