public List <Abnormal_event_ViewModel> SelectAbnormal_Event_byStage(string stage, string category, string application_unit, DateTime startdate, DateTime enddate) { Abnormal_event_Model abnormal_Event_Model = new Abnormal_event_Model(); List <Abnormal_event_Model> abnormal_Event_Models = abnormal_Event_Model.SelectAbnormal_event_byStage(stage, category, application_unit, startdate, enddate); List <Abnormal_event_ViewModel> abnormal_Event_ViewModels = new List <Abnormal_event_ViewModel>(); foreach (var row in abnormal_Event_Models) { Abnormal_event_ViewModel abnormal_Event_ViewModel = new Abnormal_event_ViewModel(); abnormal_Event_ViewModel.Abnormal_event_no = row.Abnormal_event_no; abnormal_Event_ViewModel.Abnormal_event_ID = row.Abnormal_event_ID; abnormal_Event_ViewModel.Abnormal_event = row.Abnormal_event; abnormal_Event_ViewModel.Volunteer_name = row.Volunteer_name; abnormal_Event_ViewModel.Application_unit = row.Application_unit; abnormal_Event_ViewModel.event_category = row.event_category; abnormal_Event_ViewModel.Stage = row.Stage; abnormal_Event_ViewModel.Notification_date = row.Notification_date; abnormal_Event_ViewModel.Closing_date = row.Closing_date; abnormal_Event_ViewModel.Supervisor = row.Supervisor; abnormal_Event_ViewModel.Unit_descrition = row.Unit_descrition; abnormal_Event_ViewModel.Volunteer_description = row.Volunteer_description; abnormal_Event_ViewModel.Supervisor_description = row.Supervisor_description; abnormal_Event_ViewModel.Result = row.Result; abnormal_Event_ViewModel.Volunteer_leader = row.Volunteer_leader; abnormal_Event_ViewModel.Supervisor_heads = row.Supervisor_heads; abnormal_Event_ViewModels.Add(abnormal_Event_ViewModel); } return(abnormal_Event_ViewModels); }
public List <string> Selectevent_category() { List <string> event_categorys = new List <string>(); Abnormal_event_ViewModel abnormal_Event_ViewModel = new Abnormal_event_ViewModel(); foreach (var row in abnormal_Event_ViewModel.Selectevent_category()) { event_categorys.Add(row); } return(event_categorys); }