public string editCalendar(string MainFunctionName)
{
sqlParameter = new SQLParameter();
sqlParameter.SetActionValue.Add("MainFunctionName", MainFunctionName);
calendarDB = new TB_Calendar_DB();
return(calendarDB.editData(sqlParameter));
}
public string deleteCalendar(string ID)
{
sqlParameter = new SQLParameter();
sqlParameter.WhereCondition.Add("ID", ID);
calendarDB = new TB_Calendar_DB();
return(calendarDB.deleteDate(sqlParameter));
}
public string addCalendar()
{
DateTime Now = DateTime.Now;
sqlParameter = new SQLParameter();
sqlParameter.SetActionValue.Add("EventName", this.EventName);
sqlParameter.SetActionValue.Add("Description", this.Description);
sqlParameter.SetActionValue.Add("EventTime", this.EventTime);
sqlParameter.SetActionValue.Add("CreateDate", Now);
calendarDB = new TB_Calendar_DB();
return(calendarDB.addData(sqlParameter));
}
public string getCalendar()
{
sqlParameter = new SQLParameter();
sqlParameter.OrderByValue = "EventTime Desc";
calendarDB = new TB_Calendar_DB();
DataTable dt = calendarDB.getData(sqlParameter);
if (CheckDataTableExist(dt) == false)
{
return("查無資料!");
}
CalendarList = new List <CalendarModel>();
CalendarList = (DataTableConvertToList.ToList <CalendarModel>(dt));
sqlParameter = null;
return(null);
}
