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;
}
}