public IActionResult Preferences() { TutorModel tutorModel = base.TutorModel; if (tutorModel != null) { if (Request.QueryString != null && Request.QueryString.HasValue) { long userId = Request.Query["user"].Equals(string.Empty) ? 0 : long.Parse(Request.Query["user"]); long tutorId = Request.Query["tutor"].Equals(string.Empty) ? 0 : long.Parse(Request.Query["tutor"]); if (userId > 0 && tutorId > 0) { bool isTeacher = bool.Parse(Request.Query["alreadyTeacher"]); TutorPreferences pref = new TutorPreferences { TutorId = tutorId, IsTeacher = isTeacher, TeachingInstitute = isTeacher ? Request.Query["school"].ToString() : null, HasCertification = isTeacher && Request.Query["hasCert"].Equals(string.Empty) ? false : bool.Parse(Request.Query["hasCert"]), YearsOfExperience = isTeacher ? Request.Query["yearsOfExperience"].Equals(string.Empty) ? 0 : int.Parse(Request.Query["yearsOfExperience"]) : 0, TutoringTypes = Request.Query["typeOfStudents"], LessonTypes = Request.Query["lessonTypes"], RewardingPoints = Request.Query["rewardings"], HasCar = bool.Parse(Request.Query["alreadyTeacher"]), IsInterested = bool.Parse(Request.Query["onlineTutoringInterest"]), OutsideTutoringWeekHrs = Request.Query["hrsOutsideINTO"].Equals(string.Empty) ? 0 : int.Parse(Request.Query["hrsOutsideINTO"]), Language = int.Parse(Request.Query["lang"]), StepId = int.Parse(Request.Query["step"]), EntityType = (EntityType)byte.Parse(Request.Query["entityType"]) }; int rows = TutorDB.SavePreferences(pref, userId, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); if (rows > 0) { RegistrationStep step = StepsDB.NextRegStep(userId, pref.StepId, (byte)pref.EntityType, pref.Language, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); if (step != null) { return(RedirectToAction(step.UIName, "Tutor")); } } } } try { tutorModel.Resources = LookUpDB.GetTranslation("Pages.Preferences", 1, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); tutorModel.Globals = LookUpDB.GetTranslation("Global", 1, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); tutorModel.TutoringTypes = LookUpDB.GetLookupDetails(15, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); tutorModel.LessonTypes = LookUpDB.GetLookupDetails(16, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); tutorModel.RewardingPoints = LookUpDB.GetLookupDetails(17, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION)); } catch (Exception ex) { /*GetLogger().Log(LogLevel.Error, ex.Message);*/ } return(View(tutorModel)); } return(base.AssureLogin(this.CurrentController, this.CurrentAction)); }
public static int SavePreferences(TutorPreferences tprf = null, long? userId = null, string connection = "") { using (SqlConnection con = new SqlConnection(connection)) { SqlCommand cmd = new SqlCommand("sp_ManageTutor", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter() { ParameterName = "@Mode", Value = "SavePreferences" }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@UId", Value = userId }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@ObjEntityId", Value = tprf.TutorId }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@RegistrationStepId", Value = 1 }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@StepStatus", Value = 1 }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@IsTeacher", Value = tprf.IsTeacher }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@TeachingInstitute", Value = tprf.TeachingInstitute }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@YearsOfExperience", Value = tprf.YearsOfExperience }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@TutoringTypes", Value = tprf.TutoringTypes }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@LessonTypes", Value = tprf.LessonTypes }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@RewardingPoints", Value = tprf.RewardingPoints }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@HasCar", Value = tprf.HasCar }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@OutsideTutoringWeekHrs", Value = tprf.OutsideTutoringWeekHrs }); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@Id", Value = tprf.TutorId }); con.Open(); cmd.ExecuteNonQuery(); return 1; } }