public List <Activity_ViewModel> SelectActivity_byActivity_no(DateTime Startdate, DateTime Enddate, string Type, string Group) { Activity_Model activity_Model = new Activity_Model(); List <Activity_Model> activity_models = activity_Model.SelectActivity_byActivity_no(Startdate, Enddate, Type, Group); List <Activity_ViewModel> activity_viewmodels = new List <Activity_ViewModel>(); foreach (var row in activity_models) { Activity_ViewModel activity_ViewModel = new Activity_ViewModel(); activity_ViewModel.Activity_no = row.Activity_no.ToString(); activity_ViewModel.Activity_name = row.Activity_name; activity_ViewModel.Activity_type = row.Activity_type; activity_ViewModel.Group = row.Group; activity_ViewModel.Activity_startdate = row.Activity_startdate; activity_ViewModel.Activity_enddate = row.Activity_enddate; activity_ViewModel.Undertake_unit = row.Undertake_unit; activity_ViewModel.Undertaker = row.Undertaker; activity_ViewModel.Undertake_phone = row.Undertake_phone; activity_ViewModel.Undertake_email = row.Undertake_email; activity_ViewModel.Member = row.Member; activity_ViewModel.Spare = row.Spare; activity_ViewModel.Place = row.Place; activity_ViewModel.Summary = row.Summary; activity_viewmodels.Add(activity_ViewModel); } return(activity_viewmodels); }
public List <BitmapImage> SelectActivity_byActivity_no(string activity_name, DateTime startdate) { Activity_Model activity_Model = new Activity_Model(); List <BitmapImage> Activity_model_photos = activity_Model.SelectActivity_byActivity_no(activity_name, startdate); Activity_no = activity_Model.Activity_no.ToString(); Activity_name = activity_Model.Activity_name; Activity_type = activity_Model.Activity_type; Group = activity_Model.Group; Activity_startdate = activity_Model.Activity_startdate; Activity_enddate = activity_Model.Activity_enddate; Undertake_unit = activity_Model.Undertake_unit; Undertaker = activity_Model.Undertaker; Undertake_phone = activity_Model.Undertake_phone; Undertake_email = activity_Model.Undertake_email; Lecturer = activity_Model.Lecturer; Member = activity_Model.Member; Spare = activity_Model.Spare; Place = activity_Model.Place; Summary = activity_Model.Summary; Home_image = activity_Model.Home_image; List <BitmapImage> Activity_photos = new List <BitmapImage>(); foreach (var row in Activity_model_photos) { Activity_photos.Add(row); } return(Activity_photos); }
private void AddSelectedDates() { Activity_Model activity_Model = new Activity_Model(); DateTime SrartDate = DateTime.Now.Date; DateTime EndDate = DateTime.Now.AddDays(31); List <DateTime> dateTimes = activity_Model.SelectActivity_bydatetime(SrartDate, EndDate); for (int i = 0; i < dateTimes.Count; i++) { Calendar1.SelectedDates.Add(dateTimes[i]); } }
public List <Activity_ViewModel> SelectVolunteer_ActivitybyVolunteerno(int Volunteer_no) { Activity_Model activity_Model = new Activity_Model(); List <Activity_ViewModel> activity_list = new List <Activity_ViewModel>(); List <Activity_Model> activity_model_list = activity_Model.SelectVolunteer_ActivitybyVolunteerno(Volunteer_no); foreach (var row in activity_model_list) { Activity_ViewModel activity_ViewModel = new Activity_ViewModel(); activity_ViewModel.Activity_no = row.Activity_no.ToString(); activity_ViewModel.Activity_name = row.Activity_name; activity_ViewModel.Undertaker = row.Undertaker; activity_list.Add(activity_ViewModel); } return(activity_list); }
public HttpResponseMessage UpdateActivity(Activity_Model _act) { try { int id = obj.Save_Update_Delete_Activity(_act); if (id > 0) { return(Request.CreateResponse(HttpStatusCode.OK, id)); } else { return(Request.CreateResponse(HttpStatusCode.MultipleChoices, "Activity already exists")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage DeleteActivity(Activity_Model _act) { try { int id = obj.Save_Update_Delete_Activity(_act); if (id > 0) { return(Request.CreateResponse(HttpStatusCode.OK, id)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Activity not found.")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int Save_Update_Delete_Activity(Activity_Model _act) { int id = 0; try { cmd = new SqlCommand("Activity", cmd.Connection); cmd.Connection = DbConnect.CreateConnection(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ActivityId", _act.ActivityId); cmd.Parameters.AddWithValue("@Activity", _act.Activity); cmd.Parameters.AddWithValue("@Action", _act.Action); cmd.Connection.Open(); id = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Connection.Close(); return(id); } catch (Exception ex) { return(id); } }
private void AddLabel() //加入行事曆細項(未來7天) { this.ActivityPanel.Children.Clear(); VolunteerEntities dbContext = new VolunteerEntities(); DateTime dt1 = DateTime.Now.Date.AddDays(7); var q = from a in dbContext.Activities where (a.Activity_startdate <= dt1 && a.Activity_startdate >= DateTime.Now) || (a.Activity_enddate <= dt1 && a.Activity_enddate >= DateTime.Now) select a; int WeekActivity = q.Count(); //7天內活動數 Activity_Model activity_Model = new Activity_Model(); foreach (var a in q) { ActivityPanel.Children.Add(new Label { Content = a.Activity_startdate?.ToShortDateString() + "—" + a.Activity_enddate?.ToShortDateString() + " " + a.Activity_name }); } }
public int Save_Update_Delete_Activity(Activity_Model _act) { return(obj.Save_Update_Delete_Activity(_act)); }