private void pctCuenta_Click(object sender, EventArgs e)
{
Sign_up objLlamarRegistrarse = new Sign_up();
objLlamarRegistrarse.Show();
this.Hide();
}
public void Inertgroup_andexpertise(List <int> AD)
{
var Sign_up_list = (from n in Myentity.Sign_up
select n).ToList();
var Sign_up_expertise_list = (from n in Myentity.Sign_up_expertise
select n).ToList();
var Sign_up_Service_period_list = (from n in Myentity.Sign_up_Service_period select n).ToList();
var account_list = (from n in Myentity.accounts select n).ToList();
var stage_id = (from n in Myentity.Stages where n.Stage1 == "未排班" && n.Stage_type == "排班意願" select n.Stage_ID).First();
foreach (var row in AD)
{
Sign_up sign_Up = Sign_up_list.Where(p => p.Sign_up_no == row).First();
var q = (from n in Myentity.Volunteer
where n.Chinese_name == sign_Up.Chinese_name &&
n.Join_date == sign_Up.Sign_up_date
select n).First();
Service_Group1 service_Group1 = new Service_Group1();
service_Group1.Volunteer_no = q.Volunteer_no;
service_Group1.Group_no = 1;
Myentity.Service_Group1.Add(service_Group1);
var expertise_list = Sign_up_expertise_list.Where(p => p.Sign_up_no == row).ToList();
foreach (var expertise in expertise_list)
{
Expertise2 expertise2 = new Expertise2();
expertise2.Volunteer_no = q.Volunteer_no;
expertise2.Expertise_no = (int)expertise.Expertise;
Myentity.Expertise2.Add(expertise2);
}
var Service_period_list = Sign_up_Service_period_list.Where(p => p.Sign_up_no == row).ToList();
foreach (var _period in Service_period_list)
{
Service_period2 service_Period2 = new Service_period2();
service_Period2.Volunteer_no = q.Volunteer_no;
service_Period2.Service_period_no = _period.Service_period_no;
service_Period2.Stage = stage_id;
service_Period2.Wish_order = _period.Wish_order;
Myentity.Service_period2.Add(service_Period2);
}
var account = account_list.Select(p => p.Account_number).Max().Trim();
account _account = new account();
_account.Account_number = (int.Parse(account) + 1).ToString();
_account.Password = (int.Parse(account) + 1).ToString();
_account.User_ID = q.Volunteer_no;
_account.Permission = "Volunteer";
Myentity.accounts.Add(_account);
ThreadStart TS = new ThreadStart(
delegate()
{
sending_email(sign_Up.Email, sign_Up.Chinese_name + sign_Up.English_name, Issend_pass, _account.Account_number); //寄送郵件
System.Windows.Forms.Application.DoEvents();
});
send_mail = new Thread(TS);
send_mail.IsBackground = true;
send_mail.Start();
break;
}
this.Myentity.SaveChanges();
}
//存入個人資料
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"));
}
