public IHttpActionResult UpdateUserSettings([FromBody] ExtendedUserProfileModel UserSettings)
{
SchedulingLayer schedulingLayer = new SchedulingLayer();
schedulingLayer.UpdateSchedulingUserSettings(UserSettings.userId, UserSettings.userName, UserSettings.hoursPerWeek, UserSettings.daysPerWeek, UserSettings.prefStartHour);
return(Ok());
}
/// <summary>
/// GetUserSettingsRealization method
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public dynamic GetSchedulingUserSettings(string userName)
{
List <ExtendedUserProfileModel> userStettings = new List <ExtendedUserProfileModel>();
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
SqlCommand sqlComm = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "GetUserProfile"
};
sqlComm.Parameters.AddWithValue("@userName", userName);
sqlComm.Connection = sqlCon;
try
{
sqlCon.Open();
SqlDataReader reader = sqlComm.ExecuteReader();
while (reader.Read())
{
try
{
ExtendedUserProfileModel extendedUserProfileModel = new ExtendedUserProfileModel
{
userId = int.Parse(reader.GetValue(reader.GetOrdinal("userId")).ToString()),
userName = reader.GetValue(reader.GetOrdinal("userName")).ToString(),
hoursPerWeek = int.Parse(reader.GetValue(reader.GetOrdinal("hoursWeek")).ToString()),
daysPerWeek = int.Parse(reader.GetValue(reader.GetOrdinal("daysWeek")).ToString()),
prefStartHour = int.Parse(reader.GetValue(reader.GetOrdinal("prefStartHour")).ToString())
};
userStettings.Add(extendedUserProfileModel);
}
catch (Exception ex)
{
throw ex;
}
}
return(userStettings);
}
catch (Exception ex)
{
throw ex;
}
}
}
