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));
}
