User-1701663573 posted
Hi I am developing an app using xamarin and asp.net .net framework for API but I am getting an exception the operation was cancelled
This is the code behind
public partial class AddLiving : ContentPage
{
Response res = new Response();
// private SQLiteAsyncConnection conn;
public AddLiving()
{
InitializeComponent();
// conn = DependencyService.Get<ISqliteDb>().GetConnection();
}
private async void Button_Clicked(object sender, EventArgs e)
{
try
{
var app = new Living()
{
fans = fan.Text,
lights = light.Text
};
// await DisplayAlert("Hi",fan.Text,light.Text,"ok");
string url = "https://192.168.1.5:80/api/Living/AddUser";
HttpClient client = new HttpClient();
string jsonData = JsonConvert.SerializeObject(app);
StringContent content = new StringContent(jsonData, Encoding.UTF8, "application/json");
HttpResponseMessage response = await client.PostAsync(url, content);
string result = await response.Content.ReadAsStringAsync();
res = JsonConvert.DeserializeObject<Response>(result);
if (res.responsestatus==true)
{
await Navigation.PopToRootAsync();
}
else
{
// await DisplayAlert("Hmm..", "failed insert to in livingroom", "ok");
}
}
catch(Exception ex)
{
ex.ToString();
}
}
}
}
This is the controller
public class LivingController : ApiController
{
SqlConnection conn;
void Connection()
{
string constring = ConfigurationManager.ConnectionStrings["getConnection"].ToString();
conn = new SqlConnection(constring);
}
public Response AddUser(Living living)
{
Response response = new Response();
try
{
if (string.IsNullOrEmpty(living.fans) || string.IsNullOrEmpty(living.lights))
{
response.Message = "The Field Cannot be empty";
response.Responsestatus = false;
}
else
{
Connection();
SqlCommand cmd = new SqlCommand("spAddUsers", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@fans", living.fans);
cmd.Parameters.AddWithValue("@lights", living.lights);
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
if (i >= 0)
{
response.Message = "Inserted succesfully";
response.Responsestatus = true;
}
else
{
response.Message = "failed to insert ";
response.Responsestatus = false;
}
}
}
catch(Exception e)
{
response.Message = e.Message;
}
return response;
}
}
}
