public static string Start(RequestType request, out bool HasResponse)
{
string result = "";
try
{
switch (request.FuncName)
{
case "Register":
Register_Params Rpar =
(Register_Params)JsonConvert.DeserializeObject(request.Params.ToString(), typeof(Register_Params));
result = Register(Rpar);
break;
case "UpdateUserInformation":
UpdateUserInformation_Params UUIpar =
(UpdateUserInformation_Params)JsonConvert.DeserializeObject(request.Params.ToString(),
typeof(UpdateUserInformation_Params));
result = UpdateUserInformation(UUIpar);
break;
default:
break;
}
}
catch
{
result = "error in parameter format";
}
HasResponse = true;
return(result);
}
private static string Register(Register_Params rp)
{
string result = "";
ResponseType rt = new ResponseType();
//DataContext db = new DataContext(Properties.Settings.Default.__connection);
SqlConnection cnn = new SqlConnection(Properties.Settings.Default.__connection);
SqlCommand cmm = new SqlCommand();
cmm.Connection = cnn;
try
{
cmm.CommandText = "INSERT INTO UserIdentifier (Latitude,Longitude) output inserted.id" +
" Values (" +
"@Latitude,@Longitude)";
cmm.Parameters.AddWithValue("Latitude", rp.Latitude);
cmm.Parameters.AddWithValue("Longitude", rp.Longitude);
try
{
if (cnn.State != ConnectionState.Open)
{
cnn.Open();
}
}
catch { }
object insertedId = cmm.ExecuteScalar();
try
{
if (cnn.State != ConnectionState.Closed)
{
cnn.Close();
}
}
catch { }
rt.state = true;
rt.retVal = insertedId.ToString();
}
catch (Exception e)
{
rt.state = false;
rt.retVal = e.Message;
}
try
{
result = JsonConvert.SerializeObject(rt, typeof(ResponseType), new JsonSerializerSettings());
}
catch (Exception e)
{
result = "error : " + e.Message;
}
return(result);
}