public async Task <ActionResult> Index(Account acc)
{
await initialDB();
if (acc.password == acc.confirmPassword)
{
Query query = db.Collection("users")
.WhereEqualTo("username", acc.username);
QuerySnapshot snapshots = await query.GetSnapshotAsync();
foreach (DocumentSnapshot doc in snapshots)
{
//User Exists
ViewBag.error = "User Exists. Try again!";
return(View("Index"));
}
CollectionReference collection = db.Collection("users");
Dictionary <string, object> data = new Dictionary <string, object>()
{
{ "id", DateTime.Now.ToBinary().ToString() },
{ "username", acc.username },
{ "password", acc.password },
};
await collection.AddAsync(data);
return(RedirectToAction("Index", "Home"));
}
else
{
//Not Compare
ViewBag.error = "Don't match";
return(View("Index"));
}
}
public async Task <Cobranca> Add(Cobranca cobranca)
{
CollectionReference colRef = fireStoreDb.Collection(collectionName);
await colRef.AddAsync(cobranca);
return(cobranca);
}
public async Task <IActionResult> Post([FromBody] PostMessage request)
{
// Unpack the message from Pubsub.
string sourceText;
try
{
byte[] data = Convert.FromBase64String(request.message.data);
sourceText = Encoding.UTF8.GetString(data);
}
catch (Exception e)
{
_logger.LogError(1, e, "Bad request");
return(BadRequest());
}
// Translate the source text.
_logger.LogDebug(2, "Translating {0} to Spanish.", sourceText);
var result = await _translator.TranslateTextAsync(sourceText, "es");
// Store the result in Firestore.
Translation translation = new Translation()
{
TimeStamp = DateTime.UtcNow,
SourceText = sourceText,
TranslatedText = result.TranslatedText
};
_logger.LogDebug(3, "Saving translation {0} to {1}.",
translation.TranslatedText, _translations.Path);
await _translations.AddAsync(translation);
// Return a success code.
return(NoContent());
}
public async void UploadRepair(
string serviceName,
AddRepairBindingModel repair)
{
FirestoreDb db = connection.GetFirestoreDb();
CollectionReference repairsColRef = db
.Collection("service-repairs");
DateTime endOfWarranty = new DateTime(
repair.BoughtAt.Year + repair.WarrantyPeriod / 12,
repair.BoughtAt.Month, repair.BoughtAt.Day);
repair.InWarranty =
DateTime.UtcNow >= repair.BoughtAt &&
DateTime.UtcNow <= endOfWarranty ? true : false;
Repair repairModel = new Repair(repair);
await repairsColRef.AddAsync(repairModel);
//await db.RunTransactionAsync(async transaction => {
// UpdateRepairId(serviceName, repair.RepairId);
//
//});
}
/*
* Firestore'a doküman olarak yeni bir oyuncu ekleyen fonksiyonumuz
*/
public async void NewPlayer(Player player)
{
// players koleksiyonuna ait referansı al
CollectionReference collRef = db.Collection("players");
// awaitable AddAsync metodu ile ekle
await collRef.AddAsync(player);
}
public async Task PostRoutesToFirestore([FromBody] RouteViewModel routeData)
{
if (routeData != null)
{
CollectionReference collectionReference = db.Collection("RouteList");
string routeDataFromFrontEnd = routeData.RouteDescription;
string zone = "N/A";
client = new FireSharp.FirebaseClient(config);
StringReader reader = new StringReader(routeDataFromFrontEnd);
while ((routeDataFromFrontEnd = reader.ReadLine()) != null)
{
string[] cxLine = routeDataFromFrontEnd.Split("\t");
zone = cxLine[2] == null || cxLine[2] == "" ? zone : cxLine[2].ToString();
RouteModel routeModel = new RouteModel();
routeModel.Dsp = cxLine[0];
routeModel.Zone = zone;
routeModel.Status = "waiting".ToUpper();
routeModel.Cx = cxLine[3];
routeModel.Name = NameParser(cxLine[4]);
routeModel.Wave = Int32.Parse(routeData.Wave);
try
{
await collectionReference.AddAsync(routeModel);
}
catch (Exception e)
{
string s = e.ToString();
}
}
;
}
}
//public async Task<List<string>> GetDatabases()
//{
// var client = new MongoClient(_config.AtlasMongoConnection);
// List<string> databases = new List<string>();
// using (var cursor = await client.ListDatabasesAsync())
// {
// await cursor.ForEachAsync(d => databases.Add(d.ToString()));
// }
// return databases;
//}
//public async Task<List<string>> GetCollections(string database)
//{
// var client = new MongoClient(_config.AtlasMongoConnection);
// List<string> collections = new List<string>();
// using (var cursor = await client.GetDatabase(database).ListCollectionsAsync())
// {
// await cursor.ForEachAsync(d => collections.Add( new JObject(new JProperty("name",d["name"].ToString())).ToString()));
// }
// return collections;
//}
public async Task <Repository> Create(string repository, string collection, Repository repoObject)
{
if (repoObject.validate)
{
ValidateInnerDataAgainstSchema(repoObject.schemaUri, repoObject.data);
}
GoogleCredential serviceAcct = GoogleCredential.FromJson(GetServiceAccountKey()); //hardcoded
Channel channel = new Channel(
FirestoreClient.DefaultEndpoint.Host, FirestoreClient.DefaultEndpoint.Port,
serviceAcct.ToChannelCredentials());
FirestoreClient client = FirestoreClient.Create(channel);
FirestoreDb db = FirestoreDb.Create("repositorynookproject", client);
CollectionReference c = GetCollection(db, collection);
//convert times to UTC
repoObject.createdDate = DateTime.SpecifyKind(repoObject.createdDate, DateTimeKind.Utc);
repoObject.modifiedDate = DateTime.SpecifyKind(repoObject.modifiedDate, DateTimeKind.Utc);
DocumentReference document = await c.AddAsync(repoObject);
return(repoObject);
}
public ActionResult Create(SuperUser superuser)
{
string Path = AppDomain.CurrentDomain.BaseDirectory + @"greenpaperdev-firebase-adminsdk-8k2y5-fb46e63414.json";
Environment.SetEnvironmentVariable("GOOGLE_APPLICATION_CREDENTIALS", Path);
FirestoreDb db = FirestoreDb.Create("greenpaperdev");
try
{
CollectionReference col1 = db.Collection("SuperUsers");
Dictionary <string, object> data1 = new Dictionary <string, object>
{
{ "UserId", superuser.UserId },
{ "UserName", superuser.UserName },
{ "Password", superuser.Password }
};
col1.AddAsync(data1);
// TODO: Add insert logic here
//var result = await fireBaseClient.Child("Students").PostAsync(std);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task UploadLog(RepairLog log)
{
FirestoreDb db =
connection.GetFirestoreDb();
CollectionReference colRef = db
.Collection("activity-log");
DocumentReference docRef = null;
Dictionary <string, object> repairIdDoc =
new Dictionary <string, object>()
{
{ "RepairId", log.RepairId }
};
await db.RunTransactionAsync(async t => {
docRef = await colRef.AddAsync(repairIdDoc);
});
CollectionReference subDocRef =
docRef.Collection("logs");
await db.RunTransactionAsync(async t => {
await subDocRef.AddAsync(log);
});
}
public async Task <Cliente> Add(Cliente cliente)
{
CollectionReference colRef = fireStoreDb.Collection(collectionName);
await colRef.AddAsync(cliente);
return(cliente);
}
private async Task <int> updateVendorDb(string vendorName)
{
CollectionReference coll = db.Collection("vendor");
Query query = coll.WhereEqualTo("vendor_name", vendorName);
Query query2 = coll.OrderByDescending("vendor_id").Limit(1);
QuerySnapshot snap = await query.GetSnapshotAsync();
QuerySnapshot snap2 = await query2.GetSnapshotAsync();
int id = snap2.Documents[0].ConvertTo <Vendor>().vendor_id;
if (snap.Documents.Count == 0)
{
id = id + 1;
Dictionary <string, object> data = new Dictionary <string, object>()
{
{ "vendor_id", id },
{ "vendor_name", vendorName }
};
await coll.AddAsync(data);
return(id);
}
Vendor vendor = snap.Documents[0].ConvertTo <Vendor>();
return(vendor.vendor_id);
}
private static async Task <bool> ValidateConnectionToFirestore(ServerProperties properties)
{
string collectionName = "Test_firestore_collection";
string docName = "Test_firestore_document";
CredentialList credentialList = FindCredentialsAsset();
FirestoreDb db = FirestoreDb.Create(GetProjectId(properties, credentialList));
// Create a document with a random ID in the "Test_firestore_collection" collection.
CollectionReference collection = db.Collection(collectionName);
DocumentReference document =
await collection.AddAsync(new { Name = docName });
// A DocumentReference doesn't contain the data - it's just a path.
// Let's fetch the current document.
DocumentSnapshot snapshot = await document.GetSnapshotAsync();
string receivedDocName = snapshot.GetValue <string>("Name");
if (receivedDocName != docName)
{
await document.DeleteAsync();
Debug.LogError($"Could not write a test document to firebase");
return(false);
}
await document.DeleteAsync();
return(true);
}
public T Add <T>(T record) where T : Base
{
CollectionReference colRef = fireStoreDb.Collection(collectionName);
DocumentReference doc = colRef.AddAsync(record).GetAwaiter().GetResult();
record.Id = doc.Id;
return(record);
}
public async System.Threading.Tasks.Task EnviarAlaNubeAsync(MessageQueue cola, FirestoreDb db)
{
CollectionReference collection = db.Collection("Archivos");
String archivo = Recibir(cola);
DocumentReference document = await collection.AddAsync(new { Archivo = archivo });
DocumentSnapshot snapshot = await document.GetSnapshotAsync();
}
public async Task CreateAsync(Book book)
{
// Firestore expects all times to be UTC.
book.PublishedDate = book.PublishedDate?.ToUniversalTime();
DocumentReference docRef = await _books.AddAsync(book);
book.Id = docRef.Id;
}
/// <inheritdoc/>
public async Task <Bookmark> AddBookmarkAsync(Bookmark bookmark)
{
DocumentReference bookmarkDocument = await _bookmarksCollection.AddAsync(bookmark);
bookmark.AddDocumentReference(bookmarkDocument);
return(bookmark);
}
private async void FirebaseSave()
{
//MessageBox.Show(db.ToString());
// Create a document with a ramdom ID in the "Product" collection
// A DocumentReference doen't contain the data -it's just a path
// let fetch the current document
//DocumentSnapshot snapshot = await document.GetSnapshotAsync();
//txtName.Text = snapshot.GetValue<string>("Name");
//txtDetail.Text = snapshot.GetValue<string>("Detail");
//txtPath.Text = snapshot.GetValue<string>("PathImage");
//pictureBox1.ImageLocation = txtPath.Text;
/*
* new
* {
* Name = txtName.Text.ToUpper().Trim(),
* Detail = txtDetail.Text.Trim(),
* PathImage = txtPath.Text.Trim(),
* Image = FSBHelper.ConvertImageToBase64(ImageBox.Image)
* }
*
* ProductRecord p = new ProductRecord
* {
* Id = _document,
* Name = txtName.Text.Trim(),
* Detail = txtDetail.Text.Trim(),
* PathImage = txtPath.Text.Trim(),
* Image = FSBHelper.ConvertImageToBase64(ImageBox.Image)
* };
*/
// test upload file
//UploadImageToFireStore();
CollectionReference collectionReference = db.Collection("Product");
if (_mode == ActionMode.Add)
{
DocumentReference document = await collectionReference.AddAsync(p);
}
else if (_mode == ActionMode.Edit)
{
Dictionary <FieldPath, object> updates = new Dictionary <FieldPath, object>
{
{ new FieldPath("Name"), p.Name },
{ new FieldPath("Detail"), p.Detail },
{ new FieldPath("PathImage"), p.PathImage },
{ new FieldPath("Image"), p.Image }
};
await collectionReference.Document(_document).UpdateAsync(updates);
//DocumentReference docRef =
//db.Collection("Product").Document(_document);
//await docRef.SetAsync(p);
}
}
RunTransaction(
WarehousePart newPart,
CollectionReference colRef)
{
await colRef.Database
.RunTransactionAsync(async transaction => {
await colRef.AddAsync(newPart);
});
}
async Task addDataToFirestore()
{
CollectionReference collection = db.Collection("cars");
Dictionary <string, object> data = new Dictionary <string, object>()
{
{ "id", "1234" },
};
await collection.AddAsync(data);
}
public async void UploadRepair(
string serviceName,
AddRepairBindingModel repair)
{
FirestoreDb db = connection.GetFirestoreDb();
CollectionReference repairsColRef = db
.Collection("service-repairs");
Repair repairModel = new Repair(repair);
if (repairModel.BoughtAt.Day == 29 &&
repairModel.BoughtAt.Month == 2)
{
int warrantyInYears = repairModel.WarrantyPeriod / 12;
if (warrantyInYears % 4 == 0)
{
repairModel.WarrantyExpiresOn =
repairModel.BoughtAt.AddYears(warrantyInYears);
}
else
{
repairModel.WarrantyExpiresOn =
repairModel.BoughtAt.AddYears(warrantyInYears)
.AddDays(1);
}
}
else
{
int warrantyInYears = repairModel.WarrantyPeriod / 12;
repairModel.WarrantyExpiresOn =
repairModel.BoughtAt.AddYears(warrantyInYears);
}
await db
.RunTransactionAsync(async transaction => {
UpdateRepairId(serviceName,
repairModel.RepairId);
await repairsColRef.AddAsync(repairModel);
});
RepairLog log = new RepairLog()
{
TimeOfEvent = DateTime.UtcNow,
RepairId = repairModel.RepairId,
TypeOfEvent = "create",
Status = repairModel.RepairStatus,
Description = $"Add repair with id {repairModel.RepairId}"
};
UploadLog(log);
}
public async Task <BlogPost> AddBlogPost(BlogPost blogPost)
{
// add document to collection to get a ref
var blogPostRef = await _blogPostsCollection.AddAsync(blogPost);
// get a snapshot of the ref
var snapshot = await blogPostRef.GetSnapshotAsync();
// convert to model
return(snapshot.ConvertTo <BlogPost>());
}
private async Task Insert()
{
FirestoreDb db = FirestoreDb.Create(ProjectID);
CollectionReference policlinics = db.Collection("policlinics");
var clinics = await Clinics.GetPoliclinicsAsync();
clinics.ForEach(async clinic =>
{
await policlinics.AddAsync(clinic);
});
}
public async void AddTodoTask(TodoTask task)
{
CollectionReference collection =
firestoreDb.Collection("tasks");
task.CreatedAt = DateTime.SpecifyKind(
DateTime.Now,
DateTimeKind.Utc
);
DocumentReference dr = await collection.AddAsync(task);
}
public async void AddEmployee(Employee employee)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("employees");
await colRef.AddAsync(employee);
}
catch
{
throw;
}
}
public async void AddContact(ContactUs contact)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("contact-us");
await colRef.AddAsync(contact);
}
catch
{
throw;
}
}
public async void AddMedic(Medic Medic)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("Medics");
await colRef.AddAsync(Medic);
}
catch
{
throw;
}
}
public async void AddUser(Users user)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("users");
await colRef.AddAsync(user);
}
catch
{
throw;
}
}
public async Task UploadLog(RepairLog log)
{
FirestoreDb db =
connection.GetFirestoreDb();
CollectionReference colRef = db
.Collection("activity-log");
await db.RunTransactionAsync(async t => {
await colRef.AddAsync(log);
});
}
public async void AddCareer(Career career)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("career");
await colRef.AddAsync(career);
}
catch
{
throw;
}
}
public async void AddRewards(Rewards obj)
{
try
{
CollectionReference colRef = fireStoreDb.Collection("rewards");
await colRef.AddAsync(obj);
}
catch
{
throw;
}
}
