public void DeleteExhibition_B(Exhibition obj)
{
StringBuilder sql = new StringBuilder();
sql = SqlBuilder.Delete(obj);
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@Exhibition_ID", Value= obj.Exhibition_ID}
};
ConnectDBToSendData(sql, parameter);
}
public void CreateExhibition_B(Exhibition obj)
{
StringBuilder sql = new StringBuilder();
sql = SqlBuilder.Insert(obj);
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@Exhibition_Detail", Value= obj.Exhibition_Detail},
new SqlParameter() {ParameterName = "@Exhibition_Enddatetime", Value = obj.Exhibition_Enddatetime},
new SqlParameter() {ParameterName = "@Exhibition_Otherpeople", Value = obj.Exhibition_Otherpeople},
new SqlParameter() {ParameterName = "@Exhibition_Picture", Value = obj.Exhibition_Picture},
new SqlParameter() {ParameterName = "@Exhibition_Place", Value = obj.Exhibition_Place},
new SqlParameter() {ParameterName = "@Exhibition_Startdatetime", Value = obj.Exhibition_Startdatetime},
new SqlParameter() {ParameterName = "@Exhibition_Title", Value = obj.Exhibition_Title}
};
ConnectDBToSendData(sql, parameter);
}
public object UpdateExhibitiondata_B(Exhibition objPara)
{
BEXModel.UpdateExhibition_B(objPara);
object objData = true;
return objData;
}
