//資料總表顯示 public ActionResult Alldata_check() { Sign_up_session sign_Up_Session = Session["Sign_up_session"] as Sign_up_session ?? new Sign_up_session(); Student_questionnaireVM student_question = Session["Question"] as Student_questionnaireVM ?? new Student_questionnaireVM(); Sign_up_Alldata_VM sign_Up_Alldata_VM = new Sign_up_Alldata_VM(); sign_Up_Alldata_VM.SetSign_up_Alldata(sign_Up_Session, student_question); return(PartialView(sign_Up_Alldata_VM)); }
public ActionResult Questionnaire() { ViewBag.Partilview = "Questionnaire"; Student_questionnaireVM session; if (Session["Question"] == null) { session = new Student_questionnaireVM(); } else { session = Session["Question"] as Student_questionnaireVM; } ViewData.Model = session; return(PartialView()); }
//存入個人資料 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 Questionnaire(Student_questionnaireVM SQ) { ViewBag.Partilview = "Questionnaire"; Session["Question"] = SQ; return(Redirect("~/Student/NewVolunteer/4")); }