public List <Activity_Model> SelectVolunteer_ActivitybyVolunteerno(int Volunteer_no) { VolunteerEntities dbContext = new VolunteerEntities(); var q = from n1 in dbContext.Volunteer join n2 in dbContext.Activity1 on n1.Volunteer_no equals n2.Volunteer_no join n3 in dbContext.Activities on n2.Activity_no equals n3.Activity_no join n4 in dbContext.Volunteer_supervision on n3.Undertaker equals n4.supervision_ID where n1.Volunteer_no == Volunteer_no select new { Activity_no = n3.Activity_no, Activity_name = n3.Activity_name, Undertaker = n4.supervision_Name }; List <Activity_Model> activity_list = new List <Activity_Model>(); foreach (var row in q) { Activity_Model activity_Model = new Activity_Model(); activity_Model.Activity_no = row.Activity_no; activity_Model.Activity_name = row.Activity_name.ToString(); activity_Model.Undertaker = row.Undertaker.ToString(); activity_list.Add(activity_Model); } return(activity_list); }
public List <Activity_Model> SelectActivity_byActivity_no(DateTime Startdate, DateTime Enddate, string Type, string Group) { VolunteerEntities dbContext = new VolunteerEntities(); var q = from n1 in dbContext.Activities join n2 in dbContext.Volunteer_supervision on n1.Undertaker equals n2.supervision_ID join n3 in dbContext.Activity_type on n1.Activity_type_ID equals n3.Activity_type_ID join n4 in dbContext.Service_group on n1.Group_no equals n4.Group_no where ((Startdate == DateTime.MinValue) ? true : n1.Activity_startdate >= Startdate) && ((Enddate == DateTime.MinValue) ? true : n1.Activity_enddate <= Enddate) && ((Type == "") ? true : n3.Activity_type1 == Type) && ((Group == "") ? true : n4.Group_name == Group) select new { Activity_no = n1.Activity_no, Activity_name = n1.Activity_name, Activity_type = n3.Activity_type1, Group = n4.Group_name, Activity_startdate = n1.Activity_startdate, Activity_enddate = n1.Activity_enddate, Undertake_unit = n1.Undertake_unit, Undertaker = n2.supervision_Name, Undertake_phone = n1.Undertake_phone, Undertake_email = n1.Undertake_email, Member = n1.Member, Spare = n1.Spare, Place = n1.Place, Summary = n1.Summary }; List <Activity_Model> activity_models = new List <Activity_Model>(); foreach (var row in q) { Activity_Model activity_Model = new Activity_Model(); activity_Model.Activity_no = row.Activity_no; activity_Model.Activity_name = row.Activity_name.ToString(); activity_Model.Activity_type = row.Activity_type.ToString(); activity_Model.Group = row.Group.ToString(); activity_Model.Activity_startdate = row.Activity_startdate.ToString(); activity_Model.Activity_enddate = row.Activity_enddate.ToString(); activity_Model.Undertake_unit = row.Undertake_unit.ToString(); activity_Model.Undertaker = row.Undertaker.ToString(); activity_Model.Undertake_phone = row.Undertake_phone.ToString(); activity_Model.Undertake_email = row.Undertake_email.ToString(); activity_Model.Member = row.Member.ToString(); activity_Model.Spare = row.Spare.ToString(); activity_Model.Place = row.Place.ToString(); activity_Model.Summary = row.Summary.ToString(); activity_models.Add(activity_Model); } return(activity_models); }