//存入個人資料 public ActionResult InsertSign_up() { //session轉VM Sign_up_session sign_Up_Session = Session["Sign_up_session"] as Sign_up_session; Student_questionnaireVM Student_question = Session["Question"] as Student_questionnaireVM; //轉dbset並存檔 //存個人資料 日期沒輸入的預設為1800/1/1 Sign_up sign = new Sign_up(); sign.Chinese_name = sign_Up_Session.Chinese_name; sign.Identity_card = sign_Up_Session.Identity_card; sign.Sex = sign_Up_Session.Sex; sign.Birthday = sign_Up_Session.Birthday; sign.Phone = sign_Up_Session.Phone; sign.Mobile = sign_Up_Session.Mobile; sign.Email = sign_Up_Session.Email; sign.Address = sign_Up_Session.Address; sign.Education = sign_Up_Session.Education; sign.Job = sign_Up_Session.Job; sign.Stage = 1; sign.Sign_up_type = sign_Up_Session.Sign_up_type; //日期預設 sign.Sign_up_date = Convert.ToDateTime("1800-01-01 00:00:00"); sign.Approval_date = Convert.ToDateTime("1800-01-01 00:00:00"); dbContext.Entry(sign).State = System.Data.Entity.EntityState.Added; dbContext.SaveChanges(); //找出此新志工的暫時ID int Number = dbContext.Sign_up.Where(p => p.Identity_card == sign.Identity_card).First().Sign_up_no; //存專長資料 foreach (var exp in sign_Up_Session.Expertises) { Sign_up_expertise se = new Sign_up_expertise(); se.Sign_up_no = Number; se.Expertise = Convert.ToInt32(Regex.Replace(exp, "[^0-9]", "")); dbContext.Entry(se).State = System.Data.Entity.EntityState.Added; } //存表單資料 //存Q9 是否參加訓練 { Sign_up_questionnaire q9 = new Sign_up_questionnaire(); q9.Sign_up_no = Number; q9.Question_no = 9; q9.Other_result1 = Student_question.training.ToString(); dbContext.Entry(q9).State = System.Data.Entity.EntityState.Added; } //存Q10 家長是否知道 { Sign_up_questionnaire q10 = new Sign_up_questionnaire(); q10.Sign_up_no = Number; q10.Question_no = 10; q10.Other_result1 = Student_question.knowing.ToString(); dbContext.Entry(q10).State = System.Data.Entity.EntityState.Added; } //存Q11 緊急連絡人名 { Sign_up_questionnaire q11 = new Sign_up_questionnaire(); q11.Sign_up_no = Number; q11.Question_no = 11; q11.Other_result1 = Student_question.Emergency_Name.ToString(); dbContext.Entry(q11).State = System.Data.Entity.EntityState.Added; } //存Q12 緊急連絡人電話 { Sign_up_questionnaire q12 = new Sign_up_questionnaire(); q12.Sign_up_no = Number; q12.Question_no = 12; q12.Other_result1 = Student_question.Emergency_Phone.ToString(); dbContext.Entry(q12).State = System.Data.Entity.EntityState.Added; } //存Q13 學校名稱 { Sign_up_questionnaire q13 = new Sign_up_questionnaire(); q13.Sign_up_no = Number; q13.Question_no = 13; q13.Other_result1 = Student_question.School_Name.ToString(); dbContext.Entry(q13).State = System.Data.Entity.EntityState.Added; } //存Q14 學校規定 { Sign_up_questionnaire q14 = new Sign_up_questionnaire(); q14.Sign_up_no = Number; q14.Question_no = 14; q14.Other_result1 = Student_question.School_Regulation.ToString(); dbContext.Entry(q14).State = System.Data.Entity.EntityState.Added; } //存學生服務時間 var service_period_vm = Session["Service_period"] as Service_period_VM; int[] wish1 = service_period_vm.wish1; foreach (var i in wish1) { Sign_up_Service_period service_period = new Sign_up_Service_period(); service_period.Sign_up_no = Number; service_period.Wish_order = 1; service_period.Service_period_no = i; dbContext.Entry(service_period).State = System.Data.Entity.EntityState.Added; } dbContext.SaveChanges(); return(Redirect("~/Student/NewVolunteer/6")); }
//存入個人資料 public ActionResult InsertSign_up() { //session轉VM Sign_up_session sign_Up_Session = Session["Sign_up_session"] as Sign_up_session; Sign_up_questionnaireVM Sign_up_question = Session["Question"] as Sign_up_questionnaireVM; //轉dbset並存檔 //存個人資料 日期沒輸入的預設為1800/1/1 Sign_up sign = new Sign_up(); sign.Chinese_name = sign_Up_Session.Chinese_name; sign.Identity_card = sign_Up_Session.Identity_card; sign.Sex = sign_Up_Session.Sex; sign.Birthday = sign_Up_Session.Birthday; sign.Phone = sign_Up_Session.Phone; sign.Mobile = sign_Up_Session.Mobile; sign.Email = sign_Up_Session.Email; sign.Address = sign_Up_Session.Address; sign.Education = sign_Up_Session.Education; sign.Job = sign_Up_Session.Job; sign.Stage = 1; sign.Sign_up_type = sign_Up_Session.Sign_up_type; //日期預設 sign.Sign_up_date = Convert.ToDateTime("1800-01-01 00:00:00"); sign.Approval_date = Convert.ToDateTime("1800-01-01 00:00:00"); dbContext.Entry(sign).State = System.Data.Entity.EntityState.Added; dbContext.SaveChanges(); //找出此新志工的暫時ID int Number = dbContext.Sign_up.Where(p => p.Identity_card == sign.Identity_card).First().Sign_up_no; //存專長資料 foreach (var exp in sign_Up_Session.Expertises) { Sign_up_expertise se = new Sign_up_expertise(); se.Sign_up_no = Number; se.Expertise = Convert.ToInt32(Regex.Replace(exp, "[^0-9]", "")); dbContext.Entry(se).State = System.Data.Entity.EntityState.Added; } //存表單資料 //存Q1 foreach (var q1 in Sign_up_question.Q1) { // var q1num = ; Sign_up_questionnaire sq = new Sign_up_questionnaire(); sq.Sign_up_no = Number; sq.Question_no = 1; sq.Answer_num = Convert.ToInt32(Regex.Replace(q1, "[^0-9]", "")); //選到其他,則加入其他的值 if (Regex.Replace(q1, "[^0-9]", "") == "06") { sq.Other_result1 = Sign_up_question.Q1else; } dbContext.Entry(sq).State = System.Data.Entity.EntityState.Added; } //存Q2 foreach (var q2 in Sign_up_question.Q2) { var q2num = Regex.Replace(q2, "[^0-9]", ""); Sign_up_questionnaire sq = new Sign_up_questionnaire(); sq.Sign_up_no = Number; sq.Question_no = 2; sq.Answer_num = Convert.ToInt32(q2num); //選到其他,則加入其他的值 if (q2num == "08") { sq.Other_result1 = Sign_up_question.Q2else; } dbContext.Entry(sq).State = System.Data.Entity.EntityState.Added; } //存Q3 foreach (var q3 in Sign_up_question.Q3) { var q3num = Regex.Replace(q3, "[^0-9]", ""); Sign_up_questionnaire sq = new Sign_up_questionnaire(); sq.Sign_up_no = Number; sq.Question_no = 3; sq.Answer_num = Convert.ToInt32(q3num); //選到其他,則加入其他的值 if (q3num == "09") { sq.Other_result1 = Sign_up_question.Q3doc; } dbContext.Entry(sq).State = System.Data.Entity.EntityState.Added; } //存Q4 foreach (var q4 in Sign_up_question.Q4) { var q4num = Regex.Replace(q4, "[^0-9]", ""); Sign_up_questionnaire sq = new Sign_up_questionnaire(); sq.Sign_up_no = Number; sq.Question_no = 4; sq.Answer_num = Convert.ToInt32(q4num); //選到其他,則加入其他的值 if (q4num == "08") { sq.Other_result1 = Sign_up_question.Q4else; } dbContext.Entry(sq).State = System.Data.Entity.EntityState.Added; } //Q5 Sign_up_questionnaire q5 = new Sign_up_questionnaire(); q5.Sign_up_no = Number; q5.Question_no = 5; q5.Answer_num = 1; q5.Other_result1 = Sign_up_question.Q5unit; q5.Other_result2 = Sign_up_question.Q5years; q5.Other_result3 = Sign_up_question.Q5content; dbContext.Entry(q5).State = System.Data.Entity.EntityState.Added; //Q6 Sign_up_questionnaire q6jobs = new Sign_up_questionnaire(); q6jobs.Sign_up_no = Number; q6jobs.Question_no = 6; q6jobs.Other_result1 = Sign_up_question.Q6jobs; dbContext.Entry(q6jobs).State = System.Data.Entity.EntityState.Added; //Q7 Sign_up_questionnaire q7 = new Sign_up_questionnaire(); q7.Sign_up_no = Number; q7.Question_no = 7; q7.Other_result1 = Sign_up_question.Q7; dbContext.Entry(q7).State = System.Data.Entity.EntityState.Added; //Q8 foreach (var q8 in Sign_up_question.Q8) { var q8num = Regex.Replace(q8, "[^0-9]", ""); Sign_up_questionnaire sq = new Sign_up_questionnaire(); sq.Sign_up_no = Number; sq.Question_no = 8; sq.Answer_num = Convert.ToInt32(q8num); dbContext.Entry(sq).State = System.Data.Entity.EntityState.Added; } //存服務時間 var service_period_vm = Session["Service_period"] as Service_period_VM; int[] wish1 = service_period_vm.wish1; int[] wish2 = service_period_vm.wish2; int[] wish3 = service_period_vm.wish3; foreach (var i in wish1) { Sign_up_Service_period service_period = new Sign_up_Service_period(); service_period.Sign_up_no = Number; service_period.Wish_order = 1; service_period.Service_period_no = i; dbContext.Entry(service_period).State = System.Data.Entity.EntityState.Added; } if (wish2 != null) { foreach (var i in wish2) { Sign_up_Service_period service_period = new Sign_up_Service_period(); service_period.Sign_up_no = Number; service_period.Wish_order = 2; service_period.Service_period_no = i; dbContext.Entry(service_period).State = System.Data.Entity.EntityState.Added; } } if (wish3 != null) { foreach (var i in wish3) { Sign_up_Service_period service_period = new Sign_up_Service_period(); service_period.Sign_up_no = Number; service_period.Wish_order = 3; service_period.Service_period_no = i; dbContext.Entry(service_period).State = System.Data.Entity.EntityState.Added; } } //存可面試時間 var interview_period_vm = Session["Interview_period"] as Interview_period_VM; int[] interview_wish = interview_period_vm.wish1; foreach (var i in interview_wish) { Sign_up_interview_period interview_period = new Sign_up_interview_period(); interview_period.Sign_up_no = Number; interview_period.interview_period_no = i; dbContext.Entry(interview_period).State = System.Data.Entity.EntityState.Added; } dbContext.SaveChanges(); return(Redirect("~/Home/NewVolunteer/7")); }