public void AddLocationItem(LocationsItem itemLocation)
 {
     using (var connection = new SqlConnection(constr))
     {
         connection.Open();
         connection.InsertAsync(itemLocation);
     }
 }
 public void UpdateLocationItem(LocationsItem itemLocation)
 {
     using (var connection = new SqlConnection(constr))
     {
         connection.Open();
         connection.UpdateAsync(itemLocation);
     }
 }