public ActionResult TeacherRegistr(TeacherRegModel model) { if (ModelState.IsValid) { var schoolList = new List<SelectListItem>(); var schoolType = model.StudyType.Where(s => s.Value == model.SelectedStudyTypeId.ToString()).Select(t => t.Text).FirstOrDefault(); var school = string.Empty; var placeType = string.Empty; var schoolChosen = "Yes"; if (model.SelectedStudyTypeId == 1) { schoolList = RawSchoolList(); school = schoolList.Where(s => s.Text == model.SpecialSchool).Select(t => t.Text).FirstOrDefault(); } else if (model.SelectedStudyTypeId == 2) { schoolList = RawOtherList(); school = schoolList.Where(s => s.Text == model.SpecialSchool).Select(t => t.Text).FirstOrDefault(); } if (string.IsNullOrEmpty(school)) { school = model.SpecialSchool; schoolChosen = "No"; } var placeReq = model.PlaceRequired; if (placeReq != "Nē") { placeType = model.PlaceRequiredType; } using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataSourceConnectionString"].ConnectionString)) { con.Open(); string command = @"INSERT INTO Registration (Created, RegType, RegCode, Vards, Uzvards, Pilseta, Telefons, Email, SkolasTips, SkolasNosaukums, Kopnite, KopnitesTips, IrIzveletaSkola) VALUES ('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' ,N'" + model.RegType.ToString() + "', N'" + SpecialCode() + "',N'" + model.Name + "', N'" + model.Surname + "', N'" + model.City + "', N'" + model.Phone + "', N'" + model.Email + "', N'" + schoolType + "', N'" + school + "', N'" + placeReq + "', N'" + placeType + "', N'" + schoolChosen + "')"; using (SqlCommand query = new SqlCommand(command, con)) { query.ExecuteNonQuery(); } } return View("SuccessRegistr"); } else { model.Sequrity = false; model.PlaceRequired = "Nē"; return View(model); } }
public ActionResult TeacherRegistr() { if (SiteConfiguration.EnableRegistration()) { var model = new TeacherRegModel(); model.School = RawSchoolList(); return View(model); } else { return RedirectToAction("Index", "Home"); } }