public ActionResult StudentRegistr(StudentRegModel 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 schoolClass = 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(); schoolClass = model.SelectedKlass; } else { schoolList = RawOtherList(); school = schoolList.Where(s => s.Text == model.SpecialSchool).Select(t => t.Text).FirstOrDefault(); schoolClass = model.SelectedKurss; } 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, Skolotajs, SkolasTips, SkolasNosaukums, SkolasKlase, 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'" + model.Advicer + "', N'" + schoolType + "', N'" + school + "', N'" + schoolClass + "', 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); } }
// // GET: /Registr/ public ActionResult StudentRegistr() { if (SiteConfiguration.EnableRegistration()) { var model = new StudentRegModel(); model.School = RawSchoolList(); return View(model); } else { return RedirectToAction("Index", "Home"); } }