public ActionResult DeleteConfirmed(int id)
{
MyFirstTable myFirstTable = db.MyFirstTable.Find(id);
db.MyFirstTable.Remove(myFirstTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void insertIntoMyFirstTable(MyFirstTable mfTable)
{
var res = myCn.Query <TablesClass.MyFirstTable>("Select * from MyFirstTable where name ='" + mfTable.name + "'");
if (res.Count() == 0)
{
myCn.Insert(mfTable);
}
}
public ActionResult Edit([Bind(Include = "ID,Name,Age")] MyFirstTable myFirstTable)
{
if (ModelState.IsValid)
{
db.Entry(myFirstTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(myFirstTable));
}
public ActionResult Create([Bind(Include = "ID,Name,Age")] MyFirstTable myFirstTable)
{
if (ModelState.IsValid)
{
db.MyFirstTable.Add(myFirstTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(myFirstTable));
}
// GET: MyFirstTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MyFirstTable myFirstTable = db.MyFirstTable.Find(id);
if (myFirstTable == null)
{
return(HttpNotFound());
}
return(View(myFirstTable));
}
public static async Task <HttpResponseMessage> RunGetByIdAsync([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestMessage req, ILogger log)
{
string content = await req.Content.ReadAsStringAsync();
log.LogInformation($"Received following payload: {content}");
GetIDEntity GetContent = JsonConvert.DeserializeObject <GetIDEntity>(content);
try
{
log.LogInformation("Checking Database for Id");
MyFirstTable tableItem = await Database.GetMyFirstTableItemByID(GetContent.Id, log);
return(req.CreateResponse(HttpStatusCode.OK, $"Found item Id:{tableItem.Id} Name:{tableItem.Name} Surname:{tableItem.Surname}"));
}
catch (Exception ex)
{
log.LogError(ex.Message);
return(req.CreateResponse(HttpStatusCode.InternalServerError, $"Error Message:{ex.Message}"));
}
}
private async void ImageTapped(object sender, EventArgs e)
{
MyFirstTable myTable = new MyFirstTable();
myTable.cource = "Xamarin";
myTable.name = "Nitin";
DBClass.insertIntoMyFirstTable(myTable);
var Data = DBClass.getFirstTableData();
DBClass.UpdateName("Nagarjun");
Data = DBClass.getFirstTableData();
DBClass.DeleteRecord("Nagarjun");
Data = DBClass.getFirstTableData();
NavigationPage.SetHasNavigationBar(this, true);
if (!CrossMedia.Current.IsCameraAvailable || !CrossMedia.Current.IsTakePhotoSupported)
{
await DisplayAlert("No Camera", ":( No camera available.", "OK");
return;
}
var file = await CrossMedia.Current.TakePhotoAsync(new Plugin.Media.Abstractions.StoreCameraMediaOptions
{
Directory = "Sample",
Name = "test.jpg"
});
if (file == null)
{
return;
}
await DisplayAlert("File Location", file.Path, "OK");
var stream = file.GetStream();
file.Dispose();
}
internal static async Task <bool> CreateMyFirstTable(MyFirstTable myFirstTable, ILogger log, int retryCount = 5, int delay = 500)
{
if (retryCount <= 0)
{
throw new ArgumentException("Provide a retry count greater than zero.");
}
if (delay <= 0)
{
throw new ArgumentException("Provide a delay greater than zero.");
}
log.LogInformation($"Creating MyFirstTable information for ID:{myFirstTable.Id}");
log.LogInformation("Retrieve Connection string");
string sqlConnectionString = Utilities.GetConnectionString("SQLConnectionString");
log.LogInformation("Retrieve Access Token");
string accessToken = await GetSQLAccessToken(log);
log.LogInformation("Got Access Token");
bool successful = false;
int retryAfterInterval = 0;
int retryAttempts = 0;
int backoffInterval = delay;
while (retryAttempts < retryCount)
{
try
{
using (SqlConnection conn = new SqlConnection(sqlConnectionString))
{
string statement = $"INSERT INTO MyFirstTable VALUES(@Id, @Name, @Surname)";
using (SqlCommand cmd = new SqlCommand(statement, conn))
{
cmd.Parameters.AddWithValue("Id", myFirstTable.Id);
cmd.Parameters.AddWithValue("Name", myFirstTable.Name);
cmd.Parameters.AddWithValue("Surname", myFirstTable.Surname);
conn.AccessToken = accessToken;
await conn.OpenAsync();
log.LogInformation("Executing SQL Query");
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
successful = true;
}
}
}
break;
}
catch (SqlException sqlex)
{
if (TransientErrorNumbers.Contains(sqlex.Number) == true)
{
log.LogWarning($"{sqlex.Number}: transient occurred.");
retryAfterInterval = backoffInterval;
await Task.Delay(retryAfterInterval);
retryAttempts++;
backoffInterval *= 2;
}
else
{
log.LogError(sqlex.Message);
throw sqlex;
}
}
catch (Exception ex)
{
log.LogError(ex.Message);
throw ex;
}
}//End of While retry loop
return(successful);
}
internal static async Task <MyFirstTable> GetMyFirstTableItemByID(Guid id, ILogger log, int retryCount = 5, int delay = 500)
{
if (retryCount <= 0)
{
throw new ArgumentException("Provide a retry count greater than zero.");
}
if (delay <= 0)
{
throw new ArgumentException("Provide a delay greater than zero.");
}
log.LogInformation($"Obtain MyFirstTable information for ID:{id}");
log.LogInformation("Retrieve Connection string");
string sqlConnectionString = Utilities.GetConnectionString("SQLConnectionString");
log.LogInformation("Retrieve Access Token");
string accessToken = await GetSQLAccessToken(log);
MyFirstTable myFirstTable = null;
int retryAfterInterval = 0;
int retryAttempts = 0;
int backoffInterval = delay;
while (retryAttempts < retryCount)
{
using (SqlConnection conn = new SqlConnection(sqlConnectionString))
{
string statement = $"Select * from MyFirstTable Where Id=@id";
try
{
using (SqlCommand cmd = new SqlCommand(statement, conn))
{
cmd.Parameters.AddWithValue("Id", id);
conn.AccessToken = accessToken;
log.LogInformation("Connect to SQL");
await conn.OpenAsync();
log.LogInformation("Executing SQL Query");
using (SqlDataReader reader = await cmd.ExecuteReaderAsync())
{
if (reader.HasRows)
{
while (reader.Read())
{
myFirstTable = new MyFirstTable()
{
Id = reader.GetGuid(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
Surname = reader.GetString(reader.GetOrdinal("Surname"))
};
break;
}
}
}
}
break;
}
catch (SqlException sqlex)
{
if (TransientErrorNumbers.Contains(sqlex.Number) == true)
{
log.LogWarning($"{sqlex.Number}: transient occurred.");
retryAfterInterval = backoffInterval;
await Task.Delay(retryAfterInterval);
retryAttempts++;
backoffInterval *= 2;
}
else
{
log.LogError(sqlex.Message);
throw sqlex;
}
}
catch (Exception ex)
{
log.LogError(ex.Message);
throw ex;
}
}
}//End of While retry loop
return(myFirstTable);
}
