public List <Unit_service_period_Model> SelectUnit_service_period_byApplication_unit_no(int Application_unit_no) { VolunteerEntities dbContext = new VolunteerEntities(); var q = from n1 in dbContext.Service_period join n2 in dbContext.Service_period1 on n1.Service_period_no equals n2.Service_period_no where n1.Application_unit_no == Application_unit_no select new { Service_period = n2.Service_period, Volunteer_number = n1.Volunteer_number }; List <Unit_service_period_Model> Unit_service_periods = new List <Unit_service_period_Model>(); foreach (var row in q) { Unit_service_period_Model unit_Service_Period_Model = new Unit_service_period_Model(); unit_Service_Period_Model.Service_period = row.Service_period; unit_Service_Period_Model.Volunteer_number = row.Volunteer_number.ToString(); Unit_service_periods.Add(unit_Service_Period_Model); } return(Unit_service_periods); }
public void InsertUnit_service_period(int unit_no, List <Unit_service_period_Model> unit_Service_Period_Models) { List <Unit_service_period_Model> Service_Period_nos = new List <Unit_service_period_Model>(); VolunteerEntities dbContext = new VolunteerEntities(); foreach (var row in unit_Service_Period_Models) { var q1 = from n in dbContext.Service_period1 where n.Service_period == row.Service_period select n; foreach (var row1 in q1) { Unit_service_period_Model unit_Service_Period_Model = new Unit_service_period_Model(); unit_Service_Period_Model.Volunteer_number = row.Volunteer_number; unit_Service_Period_Model.Service_period = row1.Service_period_no.ToString(); Service_Period_nos.Add(unit_Service_Period_Model); } } var q = from n in dbContext.Service_period where n.Application_unit_no == unit_no select n; foreach (var row1 in q) { foreach (var row2 in Service_Period_nos) { if (row1.Service_period_no.ToString() == row2.Service_period) { row1.Volunteer_number = int.Parse(row2.Volunteer_number); } } } dbContext.SaveChanges(); }