QkoSad
81 lines
2.6 KiB
C#
81 lines
2.6 KiB
C#
using System.Net;
|
|
using MySql.Data.MySqlClient;
|
|
|
|
namespace Server;
|
|
|
|
public class CreateProfile : SecuredRoute
|
|
{
|
|
public static void HandleRequest(HttpListenerRequest request, HttpListenerResponse response)
|
|
{
|
|
try
|
|
{
|
|
List<string> bodyParamNames =
|
|
[
|
|
"f_name",
|
|
"l_name",
|
|
"company",
|
|
"website",
|
|
"location",
|
|
"github",
|
|
"status",
|
|
"bio",
|
|
"skills",
|
|
"twitter",
|
|
"facebook",
|
|
"youtube",
|
|
"linkedin",
|
|
"instagram",
|
|
];
|
|
string user_id = ExtractUserId(request);
|
|
var bodyParamValues = ExtractBody(request, bodyParamNames);
|
|
ValidateParams(bodyParamValues);
|
|
|
|
bodyParamNames.Add("user_id");
|
|
bodyParamValues["user_id"] = user_id;
|
|
|
|
MySqlCommand cmd = new(CreateInsertQuery("profile", bodyParamNames));
|
|
|
|
cmd = AddValuesToCmd(bodyParamValues, cmd);
|
|
|
|
using MySqlConnection conn = new(connectionString);
|
|
conn.Open();
|
|
cmd.Connection = conn;
|
|
cmd.ExecuteNonQuery();
|
|
|
|
SendSuccess(response);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
SendError(response, ex);
|
|
}
|
|
}
|
|
|
|
private static void ValidateParams(Dictionary<string, string> paramsToValidate)
|
|
{
|
|
if (
|
|
paramsToValidate["f_name"].Length > 30
|
|
|| string.IsNullOrEmpty(paramsToValidate["f_name"])
|
|
|| paramsToValidate["l_name"].Length > 30
|
|
|| string.IsNullOrEmpty(paramsToValidate["l_name"])
|
|
|| paramsToValidate["company"].Length > 70
|
|
|| string.IsNullOrEmpty(paramsToValidate["company"])
|
|
|| paramsToValidate["website"].Length > 120
|
|
|| paramsToValidate["location"].Length > 100
|
|
|| string.IsNullOrEmpty(paramsToValidate["location"])
|
|
|| paramsToValidate["skills"].Length > 300
|
|
|| paramsToValidate["github"].Length > 120
|
|
|| paramsToValidate["status"].Length > 20
|
|
|| string.IsNullOrEmpty(paramsToValidate["status"])
|
|
|| paramsToValidate["bio"].Length > 1000
|
|
|| paramsToValidate["twitter"].Length > 100
|
|
|| paramsToValidate["facebook"].Length > 100
|
|
|| paramsToValidate["youtube"].Length > 100
|
|
|| paramsToValidate["linkedin"].Length > 100
|
|
|| paramsToValidate["instagram"].Length > 100
|
|
)
|
|
{
|
|
throw new Exception("Wrong parameters");
|
|
}
|
|
}
|
|
}
|