public string postTransaction(Transaction transaction)
{
try
{
if (transaction.accountId == null)
{
return("Account id can`t be null. Transference failed");
}
IFirebaseClient client = new FirebaseClient(config);
transaction.account = getAccountById(transaction.accountId);
if (transaction.account == null)
{
return("Account not found. Transference failed");
}
PushResponse response = client.Push("transactions", transaction);
Transaction result = response.ResultAs <Transaction>();
return("Transaction successfully recorded.");
}
catch (Exception ex)
{
throw ex;
}
}
static private void Push()
{
var data = new Data
{
ID = "1",
Name = "AUSTIN"
};
PushResponse response = firebaseClient.Push("Customer/1", data);
Data result = response.ResultAs <Data>();
Console.WriteLine("Data pushed " + data.ID);
}
public string postAccount(Account account)
{
try
{
IFirebaseClient client = new FirebaseClient(config);
PushResponse response = client.Push("accounts", account);
Account result = response.ResultAs <Account>(); //The response will contain the data written
return("Account successfully recorded.");
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddCustomer(Customer c)
{
try
{
FirebaseResponse res = firebaseClient.Get($"Customer/{c.Id}");
var res2 = res.ResultAs <Customer>();
}
catch (NullReferenceException n)
{
PushResponse response = firebaseClient.Push($"Customer/{c.Id}", c);
Customer result = response.ResultAs <Customer>();
return(true);
}
return(false);
}
private async void add_btn_Click(object sender, EventArgs e)
{
if (name_editText.Text != "" && name_editText.Text != null)
{
if (mobileNo_editText.Text.Count() == 11)
{
try
{
vendor = new Vendor_class
{
name = name_editText.Text,
mobileNo = mobileNo_editText.Text
};
PushResponse response = await client.PushTaskAsync("vendors", vendor);
Vendor_class result = response.ResultAs <Vendor_class>();
MessageBox.Show("Vendor Added Successfully!");
this.Hide();
New_Purchase np = new New_Purchase();
np.Show();
}
catch (Exception)
{
//inserted = false;
MessageBox.Show("Failed to add vendor. Check your internet connectivity.");
}
}
else
{
MessageBox.Show("Mobile Number invalid!");
}
}
else
{
MessageBox.Show("Name invalid!");
}
}
public bool AddOrder(Order o)
{
try
{
FirebaseResponse res = firebaseClient.Get($"Order/{o.Id}");
var res2 = res.ResultAs <Order>();
}
catch (NullReferenceException n)
{
Console.WriteLine(n.Message);
return(false);
}
PushResponse response = firebaseClient.Push("Order/4", o);
Order result = response.ResultAs <Order>();
if (result != null)
{
return(true);
}
return(false);
}
public T Push <T>(string url, object data)
{
PushResponse response = client.Push(url, data);
return(response.ResultAs <T>());
}
public async Task <ActionResult> UploadAsync([FromForm] FormProduct formData)
{
string output = "";
LoadFirebase();
try {
bool checkFile = true;
if ("Create".Equals(formData.Button))
{
if (formData.File == null)
{
return(new UnsupportedMediaTypeResult());
}
}
else if ("Update".Equals(formData.Button))
{
if (formData.File == null)
{
checkFile = false;
}
}
PushResponse response = null;
if (checkFile)
{
string filename = formData.File.FileName;
#region algorithm to check file exists. if true, rename file
if (System.IO.File.Exists(fileUploadPath + filename))
{
while (System.IO.File.Exists(fileUploadPath + filename))
{
int lastIndex = filename.LastIndexOf(".");
string input = filename.Substring(lastIndex - 3, 3);
if (Regex.IsMatch(input, "^\\(\\d+\\)$"))
{
string number = filename.Substring(lastIndex - 2, 1);
int num = Int32.Parse(number);
num++;
filename = filename.Replace("(" + number + ")", "(" + num + ")");
}
else
{
filename = filename.Insert(lastIndex, "(1)");
}
}
string oldPath = Path.Combine(fileUploadPath, formData.File.FileName);
string newPath = Path.Combine(fileUploadPath, filename);
System.IO.File.Move(oldPath, newPath);
}
#endregion
#region save file to path project
var fileExtension = MimeTypeMap.GetExtension(formData.File.ContentType);
using var stream = System.IO.File.Create(Path.Combine(fileUploadPath, formData.File.FileName));
formData.File.CopyToAsync(stream).Wait();
stream.Close();
#endregion
#region upload file on Firebase - Realtime Database
string base64 = GetBase64StringForImage(GetFilePath(filename, fileUploadPath));
output = base64;
var data = new ImageModel {
Img = base64
};
response = await client.PushTaskAsync("Image/", data);
ImageModel result = response.ResultAs <ImageModel>();
#endregion
}
TempForm tempForm = new TempForm();
if ("Create".Equals(formData.Button))
{
tempForm.ImageLocation = response.Result.Name;
}
else if ("Update".Equals(formData.Button))
{
tempForm.ProductId = formData.ProductId;
if (formData.File != null)
{
tempForm.ImageLocation = response.Result.Name;
}
}
tempForm.ProductName = formData.ProductName;
tempForm.Quantity = formData.Quantity;
tempForm.Price = formData.Price;
tempForm.CategoryId = formData.CategoryId;
string serialize = System.Text.Json.JsonSerializer.Serialize <TempForm>(tempForm);
HttpContext.Session.SetString("tempForm", serialize);
return(Redirect("Product/addProduct"));
} catch (Exception) {
throw;
}
return(BadRequest());
}
public Payload SendNotification(Payload payload)
{
PushResponse response = _firebaseClient.Push("/users/" + payload.ToUserId, payload);
return(response.ResultAs <Payload>());
}
private async void add_btn_Click(object sender, EventArgs e)
{
if (name_editText.Text != "" && password_editText.Text != "")
{
int temp = role_list.SelectedIndex;
string role;
//cashier is selected
if (temp == 0)
{
role = "Cashier";
}
else
{
role = "Admin";
}
Pos_Users user = new Pos_Users()
{
name = name_editText.Text,
password = password_editText.Text,
role = role
};
try
{
PushResponse response = await client.PushTaskAsync("posUsers", user);
Pos_Users result = response.ResultAs <Pos_Users>();
usersList.Add(user);
FirebaseResponse resp = await client.GetTaskAsync("posUsers/");
Dictionary <string, Pos_Users> dict = resp.ResultAs <Dictionary <string, Pos_Users> >();
//Adding new key to keys array
foreach (KeyValuePair <string, Pos_Users> ele1 in dict)
{
if (!keys.Contains(ele1.Key))
{
keys.Add(ele1.Key);
break;
}
}
//adding new row to DT
DataRow row = dt.NewRow();
row["Name"] = user.name;
row["Password"] = user.password;
row["Role"] = user.role;
dt.Rows.Add(row);
}
catch (Exception)
{
MessageBox.Show("Failed to connect to database. Check your internet connection and try again.");
}
}
else
{
MessageBox.Show("Please fill the fields first.");
}
}
private async void createOrder_btn_Click(object sender, EventArgs e)
{
if (products_grid.Rows[0].Cells[0].Value == null)
{
MessageBox.Show("Please select a product first");
}
else
{
try
{
Vendor_class v = vendorList[vendor_list.SelectedIndex];
List <Products_class> newList = new List <Products_class>();
newList = selectedProductsList.Concat(newProductList).ToList();
PurchaseOrder_class po = new PurchaseOrder_class
{
vendor = v,
orderNo = orderNo_editText.Text,
orderDate = orderDate_editText.Text,
totalBill = totalBill_label.Text,
productList = newList,
punchedBy = Form1.loggedInUser.name
};
try
{
PushResponse response = await client.PushTaskAsync("purchases", po);
PurchaseOrder_class p2 = response.ResultAs <PurchaseOrder_class>();
for (int i = 0; i < newProductList.Count; i++)
{
PushResponse res = await client.PushTaskAsync("products", newProductList[i]);
Products_class pp = res.ResultAs <Products_class>();
}
for (int i = 0; i < selectedProductsListUPDATE.Count; i++)
{
FirebaseResponse response2 = await client.UpdateTaskAsync("products/" + keysUPDATE[i], selectedProductsListUPDATE[i]);
Products_class product = response2.ResultAs <Products_class>();
}
}
catch (Exception)
{
MessageBox.Show("Error connecting to FIREBASE. Please check your internet connection!");
}
MessageBox.Show("Order added successfully");
this.Hide();
Purchasing p = new Purchasing();
p.Show();
}
catch (Exception)
{
MessageBox.Show("Please Select a vendor first!");
}
}
}