private void Supplier_Load(object sender, EventArgs e)
{
try
{
FirebaseResponse getResponse = firebase.Get();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
//MessageBox.Show(getResponse.JSONContent);
String jumlah = stuff.count;
id_sup = Convert.ToInt32(jumlah);
for (int i = 0; i < id_sup; i++)
{
FirebaseDB firebaseSuplier = firebaseDB.Node("S" + i);
FirebaseResponse customer = firebaseSuplier.Get();
dynamic stiff = JObject.Parse(customer.JSONContent);
if (stiff.nama == "")
{
continue;
}
vendorBindingSource.Add(new Vendor()
{
ID = stiff.id, Nama = stiff.nama, HP = stiff.hp, Produk = stiff.produk, Alamat = stiff.alamat, Email = stiff.email, Merek = stiff.merek
});
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void restock_Load(object sender, EventArgs e)
{
try
{
FirebaseDB firebaseDB = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Supplier");
FirebaseDB firebase = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Supplier_Status");
FirebaseResponse getResponse = firebase.Get();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
String jumlah = stuff.count;
id_supplier = Convert.ToInt32(jumlah);
for (int i = 0; i < id_supplier; i++)
{
FirebaseDB firebaseSup = firebaseDB.Node("S" + i);
FirebaseResponse customer = firebaseSup.Get();
dynamic stiff = JObject.Parse(customer.JSONContent);
if (stiff.nama == "")
{
continue;
}
nama_kalian.Add((string)stiff.nama);
alamat.Add((string)stiff.alamat);
no_hp.Add((string)stiff.hp);
comboBox1.Items.Add((string)stiff.nama);
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (nama_txt.Text == "" || alamat_txt.Text == "" || email_txt.Text == "" || hp_txt.Text == "" || vendor_txt.Text == "" || merek_txt.Text == "")
{
MessageBox.Show("Semua Wajib Diisi !", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
MainMenu form = new MainMenu();
form.Show(); Hide();
}
else
{
DataGridViewRow newRow = dataGridView1.Rows[selectedRow];
newRow.Cells[1].Value = nama_txt.Text;
newRow.Cells[5].Value = alamat_txt.Text;
newRow.Cells[4].Value = email_txt.Text;
newRow.Cells[2].Value = hp_txt.Text;
newRow.Cells[3].Value = vendor_txt.Text;
newRow.Cells[6].Value = merek_txt.Text;
FirebaseDB firebaseSupplier = firebaseDB.Node(newRow.Cells[0].Value.ToString());
FirebaseResponse coba = firebaseSupplier.Get();
dynamic stuff = JObject.Parse(coba.JSONContent);
var data = "";
data = @"{'id':'" + stuff.id + "','nama' : '" + nama_txt.Text + "','alamat' : '" + alamat_txt.Text + "','hp' : '" + hp_txt.Text + "','email' : '" + email_txt.Text + "','produk' : '" + vendor_txt.Text + "','merek' : '" + merek_txt.Text + "'}";
firebaseSupplier.Patch(data);
nama_txt.Text = "";
alamat_txt.Text = "";
hp_txt.Text = "";
email_txt.Text = "";
vendor_txt.Text = "";
merek_txt.Text = "";
}
}
private void button22_Click(object sender, EventArgs e)
{
String username = user_txt.Text;
String password = pass_txt.Text;
String nama = nama_txt.Text;
String email = email_txt.Text;
String hp = hp_txt.Text;
if (textBox1.Text == password)
{
FirebaseDB firebaseDB = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Employees");
FirebaseDB firebaseDBEmployees = firebaseDB.Node(username);
var data = @"{'username' : '" + username + "','password' : '" + password + "','nama' : '" + nama + "','email' : '" + email + "','hp' : '" + hp + "'}";
firebaseDBEmployees.Put(data);
MessageBox.Show("Data berhasil ditambahkan");
employeedataBindingSource.Add(new Employee_data()
{
Username = username, Password = password, Email = email, HP = hp, Nama = nama
});
}
else
{
MessageBox.Show("Password Doesn't Match !");
}
}
private void confirmation_Load(object sender, EventArgs e)
{
try
{
FirebaseDB firebase = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Customer_Status");
FirebaseResponse getResponse = firebase.Get();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
String jumlah = stuff.count;
int id_cust = Convert.ToInt32(jumlah);
for (int i = 0; i < id_cust; i++)
{
FirebaseDB firebaseDB = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Customers");
FirebaseDB firebaseCustomer = firebaseDB.Node("C" + i);
FirebaseResponse customer = firebaseCustomer.Get();
dynamic stiff = JObject.Parse(customer.JSONContent);
if (stiff.nama == "")
{
continue;
}
combo_customer.Items.Add((string)stiff.nama);
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
public IHttpActionResult authuser([FromBody] AuthModel c)
{
string url = c.email_Id;
string uu = url.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Users").NodePath(uu);
FirebaseResponse getResponse = firebaseDBTeams.Get();
if (Convert.ToString(getResponse.JSONContent) == "null")
{
System.Diagnostics.Debug.WriteLine("Doesn't exists");
return(null);
}
else
{
Customer c2 = JsonConvert.DeserializeObject <Customer>(getResponse.JSONContent);
if (c2.password == c.password)
{
System.Diagnostics.Debug.WriteLine(getResponse.JSONContent + "Login Succesfully");
return(Ok(c2));
}
else
{
return(null);
}
}
}
public IHttpActionResult create([FromBody] Customer c)
{
System.Diagnostics.Debug.WriteLine(JsonConvert.SerializeObject(c) + "jjjjjjj");
string url = c.email_Id;
string uu = url.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Users").NodePath(uu);
FirebaseResponse getResponse = firebaseDBTeams.Get();
if (Convert.ToString(getResponse.JSONContent) == "null")
{
System.Diagnostics.Debug.WriteLine("PUT Request");
FirebaseResponse putResponse = firebaseDBTeams.Put(JsonConvert.SerializeObject(c));
return(Ok("Resgistered Successfully"));
}
else
{
return(BadRequest("User Already Registered with this Email Id"));
}
}
private void Customer_Load(object sender, EventArgs e)
{
try
{
FirebaseResponse getResponse = firebase.Get();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
String jumlah = stuff.count;
id_cust = Convert.ToInt32(jumlah);
for (int i = 0; i < id_cust; i++)
{
FirebaseDB firebaseCustomer = firebaseDB.Node("C" + i);
FirebaseResponse customer = firebaseCustomer.Get();
dynamic stiff = JObject.Parse(customer.JSONContent);
if (stiff.nama == "")
{
continue;
}
personBindingSource.Add(new Person()
{
ID = stiff.id,
Nama = stiff.nama,
JenisKelamin = stiff.gender,
Alamat = stiff.alamat,
Email = stiff.email,
HP = stiff.hp
});
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
public IHttpActionResult respondedBylist(String id)
{
string url = id;
string uu = url.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("RespondsTo").NodePath(uu);
FirebaseResponse getResponse = firebaseDBTeams.Get();
if (Convert.ToString(getResponse.JSONContent) != "null")
{
var mList = JsonConvert.DeserializeObject <IDictionary <string, Request> >(getResponse.JSONContent);
List <Customer> newlist = new List <Customer>();
foreach (var v in mList)
{
FirebaseDB firebaseDBTeams2 = firebaseDB.Node("Users").NodePath(v.Key);
FirebaseResponse getResponse2 = firebaseDBTeams2.Get();
Customer c2 = JsonConvert.DeserializeObject <Customer>(getResponse2.JSONContent);
newlist.Add(c2);
}
return(Ok(newlist));
}
else
{
return(null);
}
}
public IHttpActionResult add([FromBody] Request request)
{
RequestDTO requestDTO = new RequestDTO();
string loginId = request.senderId.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Requests").NodePath(loginId).Node(request.destinationId.Replace(".", ","));
FirebaseDB firebaseDBTeams2 = firebaseDB.Node("Proposals").NodePath(request.destinationId.Replace(".", ",")).Node(loginId);
requestDTO.status = request.destinationId.Replace(".", ",");
dynamic foo = new ExpandoObject();
foo.status = request.status;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(foo);
FirebaseResponse getResponse = firebaseDBTeams.Get();
if (Convert.ToString(getResponse.JSONContent) == "null")
{
FirebaseResponse putResponse = firebaseDBTeams.Post(JsonConvert.SerializeObject(json));
FirebaseResponse putResponse2 = firebaseDBTeams2.Post(JsonConvert.SerializeObject(json));
return(Ok("Resgistered Successfully"));
}
else
{
System.Diagnostics.Debug.WriteLine("Already present");
return(BadRequest("User Already Registered with this Email Id"));
}
}
public IHttpActionResult list(String id)
{
string url = id;
string uu = url.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Users");
FirebaseResponse getResponse = firebaseDBTeams.Get();
Customer c = JsonConvert.DeserializeObject <Customer>(getResponse.JSONContent);
List <Customer> newlist = new List <Customer>();
var obj = JsonConvert.DeserializeObject <RootObject>(getResponse.JSONContent);
var mList = JsonConvert.DeserializeObject <IDictionary <string, Customer> >(getResponse.JSONContent);
foreach (var v in mList)
{
if (v.Value.Id != id)
{
newlist.Add(v.Value);
}
}
return(Ok(newlist));
}
public DataSubjectRegistrationController(IConfiguration Configuration)
{
_configuration = Configuration;
FirebaseDB firebaseDB = new FirebaseDB(_configuration["Firebase:url"]);
_firebaseDBRegistrations = firebaseDB.Node("data-subject-registrations");
}
public IHttpActionResult getImageModel(String id)
{
string uu = id.Replace(".", ",");
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Pictures").NodePath(uu);
FirebaseResponse getResponse = firebaseDBTeams.Get();
if (Convert.ToString(getResponse.JSONContent) == "null")
{
return(null);
}
else
{
ImageModel c2 = JsonConvert.DeserializeObject <ImageModel>(getResponse.JSONContent);
if (c2 != null)
{
return(Ok(c2));
}
else
{
return(null);
}
}
}
private void addNewUserToFirebase()
{
FirebaseDB firebaseDB = new FirebaseDB(pathFireBase);
FirebaseDB firebaseDBTeams = firebaseDB.Node("users");
firebaseDBTeams.NodePath("users");
for (int i = 1; i <= 4; i++)
{
var data = new UserViewModel
{
countofposts = "0",
data_display = "1",
name = "Jenny",
newmessages = "0",
password = "******",
score = "0",
typeOfCancer = "ALL",
usermail = "*****@*****.**"
};
string json = js.Serialize(data);
LuckyWithYouForum.Database.FirebaseResponse postResponse = firebaseDBTeams.Post(json);
}
}
public void fillUsersListFromFireBase()
{
FirebaseDB firebaseDB = new FirebaseDB(pathFireBase);
FirebaseDB firebaseDBTeams = firebaseDB.Node("users");
firebaseDBTeams.NodePath("users");
LuckyWithYouForum.Database.FirebaseResponse postResponse = firebaseDBTeams.Get();
try
{
List <UserViewModel> entryDict = JsonConvert.DeserializeObject <List <UserViewModel> >(postResponse.JSONContent.ToString());
if (entryDict != null)
{
users = entryDict;
}
else
{
users = new List <UserViewModel>();
}
}
catch (Exception e)
{
//dictionary type--> generated key for insered data
Dictionary <string, UserViewModel> entryDict = JsonConvert.DeserializeObject <Dictionary <string, UserViewModel> >(postResponse.JSONContent.ToString());
if (entryDict != null)
{
users = entryDict.Select(x => x.Value).ToList();
}
else
{
users = new List <UserViewModel>();
}
}
}
public IResponse Remove(int i_Id)
{
string key = i_Id.ToString();
FirebaseDB path = m_Fb.Node(key);
return(new FirebaseIResponseAdapter(path.Delete()));
}
private void update_btn_Click(object sender, EventArgs e)
{
if (nama_txt.Text == "" || email_txt.Text == "" || hp_txt.Text == "" || user_txt.Text == "" || pass_txt.Text == "" || textBox1.Text == "")
{
MessageBox.Show("Semua Wajib Diisi !", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
MainMenu form = new MainMenu();
form.Show(); Hide();
}
else
{
DataGridViewRow newRow = dataGridView1.Rows[selectedRow];
newRow.Cells[0].Value = nama_txt.Text;
newRow.Cells[2].Value = hp_txt.Text;
newRow.Cells[1].Value = user_txt.Text;
newRow.Cells[4].Value = email_txt.Text;
newRow.Cells[3].Value = pass_txt.Text;
FirebaseDB firebaseEmployee = firebaseDB.Node(newRow.Cells[0].Value.ToString());
FirebaseResponse coba = firebaseEmployee.Get();
dynamic stuff = JObject.Parse(coba.JSONContent);
var data = @"{'username' : '" + user_txt.Text + "','password' : '" + pass_txt.Text + "','nama' : '" + nama_txt.Text + "','email' : '" + email_txt.Text + "','hp' : '" + hp_txt.Text + "'}";
firebaseEmployee.Patch(data);
nama_txt.Text = "";
pass_txt.Text = "";
hp_txt.Text = "";
email_txt.Text = "";
user_txt.Text = "";
textBox1.Text = "";
}
}
private void Employee_Load(object sender, EventArgs e)
{
try
{
FirebaseDB firebase = new FirebaseDB("https://mobile-shoebox.firebaseio.com/Employees");
FirebaseResponse getResponse = firebase.Get();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
//MessageBox.Show(getResponse.JSONContent);
IEnumerable <JToken> name = stuff.SelectTokens("$.*");
foreach (JToken item in name)
{
dynamic stiff = JObject.Parse(item.ToString());
employeedataBindingSource.Add(new Employee_data()
{
Username = stiff.username,
Password = stiff.password,
Email = stiff.email,
Nama = stiff.nama,
HP = stiff.hp
});
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
public FirebaseRepository(IConfiguration configuration)
{
_configuration = configuration;
_firebase = new FirebaseDB(_configuration["FirebaseUrl"]);
// Referring to Node with name "Users" in Firebase
_firebaseDBTeams = _firebase.Node("Users");
}
private void button22_Click(object sender, EventArgs e)
{
FirebaseDB firebaseSupplier = firebaseDB.Node("S" + id_sup);
String tmp = "S" + id_sup;
var data = "";
if (nama_txt.Text == "" || alamat_txt.Text == "" || email_txt.Text == "" || hp_txt.Text == "" || vendor_txt.Text == "" || merek_txt.Text == "")
{
MessageBox.Show("Semua Wajib Diisi !", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
MainMenu form = new MainMenu();
form.Show(); Hide();
}
else
{
vendorBindingSource.Add(new Vendor()
{
ID = "S" + id_sup.ToString(), Nama = nama_txt.Text, HP = hp_txt.Text, Produk = vendor_txt.Text, Alamat = alamat_txt.Text, Email = email_txt.Text, Merek = merek_txt.Text
});
data = @"{'id':'" + tmp + "','nama' : '" + nama_txt.Text + "','alamat' : '" + alamat_txt.Text + "','hp' : '" + hp_txt.Text + "','email' : '" + email_txt.Text + "','produk' : '" + vendor_txt.Text + "','merek' : '" + merek_txt.Text + "'}";
firebaseSupplier.Put(data);
id_sup++;
}
nama_txt.Text = "";
alamat_txt.Text = "";
merek_txt.Text = "";
hp_txt.Text = "";
email_txt.Text = "";
vendor_txt.Text = "";
var count = "";
count = @"{'count':'" + id_sup + "'}";
firebase.Put(count);
}
public Customer Save(Customer model)
{
var firebaseDb = new FirebaseDB("https://archiewebshop-demo.firebaseio.com");
var firebaseTarget = firebaseDb.Node("customers");
var request = firebaseTarget.Post(model.SerializeJson());
return(model);
}
public List <Produto> ObterListaProdutos()
{
FirebaseDB firebaseDBTeams = firebaseDB.Node("Produto");
FirebaseResponse getResponse = firebaseDBTeams.Get();
//var result = JsonConvert.DeserializeObject<Produto>(getResponse.JSONContent);
return(_mapper.Map <List <Produto> >(getResponse.JSONContent));
}
private void init()
{
m_Firebase = new FirebaseDB(r_baseUrl);
m_WeatherRepository = new FirebaseRepository(m_Firebase.Node("Weather"));
m_StudentRepository = new FirebaseRepository(m_Firebase.Node("Students"));
m_JsonSerializer = new DbJsonSerializer();
m_WeatherCache = new EntityCache <WeatherForecast>(m_WeatherRepository, m_JsonSerializer, eCacheLoadingMode.Eager);
m_StudentCache = new EntityCache <Student>(m_StudentRepository, m_JsonSerializer, eCacheLoadingMode.Lazy);
}
private void login_btn_Click(object sender, EventArgs e)
{
FirebaseDB firebaseDB = new FirebaseDB("https://mobile-shoebox.firebaseio.com/orders_store");
FirebaseDB isi = firebaseDB.Node(order);
FirebaseResponse getResponse = isi.Get();
List <string> tmp = new List <string>();
dynamic stuff = JObject.Parse(getResponse.JSONContent);
tmp.Add((string)stuff.biaya);
tmp.Add((string)stuff.cabang);
tmp.Add((string)stuff.customer);
tmp.Add((string)stuff.diskon);
tmp.Add((string)stuff.merek_sepatu);
tmp.Add((string)stuff.orderid);
tmp.Add((string)stuff.pembayaran);
tmp.Add((string)stuff.service);
tmp.Add((string)stuff.subservice);
tmp.Add((string)stuff.tanggal_masuk);
var data = "";
data = @"{'customer':'" + tmp[2] + "','biaya':'" + tmp[0] + "','pembayaran' : '" + comboBox1.Text + "','cabang' : '" + tmp[1] + "','merek_sepatu' : '" + tmp[4] + "','orderid' : '" + tmp[5] + "','service' : '" + tmp[7] + "','subservice' : '" + tmp[8] + "','diskon' : '" + tmp[3] + "','tanggal_masuk' : '" + tmp[9] + "'}";
isi.Patch(data);
/*
* using (StreamWriter sw = new StreamWriter("D:/" + order + ".txt"))
* {
*
* sw.WriteLine("==========================================================================");
* sw.WriteLine("==================================SHOEBOX================================");
* sw.WriteLine("==========================================================================");
* sw.WriteLine("");
* sw.WriteLine("Nama Customer : " + tmp[2]);
* sw.WriteLine("Merek Sepatu : " + tmp[4]);
* sw.WriteLine(""); sw.WriteLine("");
* sw.WriteLine("--------------------------------------------------------------------------");
* sw.WriteLine("Service : " + stuff.service);
* sw.WriteLine("SubService : " + stuff.subservice);
* sw.WriteLine(""); sw.WriteLine("");
* sw.WriteLine("Diskon : " + stuff.diskon);
* sw.WriteLine("Biaya : " + stuff.biaya);
* sw.WriteLine("==========================================================================");
* sw.WriteLine("==========================================================================");
* sw.Flush();
* sw.Close();
* }*/
MainMenu balik = new MainMenu();
balik.Show(); Hide();
Invoices invoice = new Invoices();
invoice.Show();
}
public IList <Customer> GetAll()
{
var firebaseDb = new FirebaseDB("https://archiewebshop-demo.firebaseio.com");
var firebaseTarget = firebaseDb.Node("customers");
var response = firebaseTarget.Get();
var all = response.JSONContent.DeserializeJson <Dictionary <string, Customer> >();
return(all.Values.ToList());
}
public static void Put(FirebaseDB db, string data)
{
Console.WriteLine("PUT Request");
FirebaseResponse putResponse = db.Put(data);
Console.WriteLine(putResponse.Success);
Console.WriteLine();
Console.WriteLine("End of PUT Request");
Console.ReadLine();
}
public static void Delete(FirebaseDB db)
{
Console.WriteLine("DELETE Request");
FirebaseResponse deleteResponse = db.Delete();
Console.WriteLine(deleteResponse.Success);
Console.WriteLine();
Console.WriteLine("End of DELETE Request");
Console.ReadLine();
}
public IHttpActionResult searchuser([FromBody] SearchCriteria c)
{
FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/");
FirebaseDB firebaseDBTeams = firebaseDB.Node("Users");
FirebaseResponse getResponse = firebaseDBTeams.Get();
List <Customer> newlist = new List <Customer>();
var obj = JsonConvert.DeserializeObject <RootObject>(getResponse.JSONContent);
var mList = JsonConvert.DeserializeObject <IDictionary <string, Customer> >(getResponse.JSONContent);
int min, max;
if (c.age == "0")
{
min = 20;
max = 25;
}
else if (c.age == "1")
{
min = 25;
max = 30;
}
else if (c.age == "2")
{
min = 30;
max = 35;
}
else
{
min = 35;
max = 45;
}
foreach (var v in mList)
{
string[] splitString = v.Value.dob.Split('/');
int birthDay = int.Parse(splitString[0].Trim());
int birthMonth = int.Parse(splitString[1].Trim());
int birthYear = int.Parse(splitString[2].Trim());
double year;
DateTime birthDate = new DateTime(birthYear, birthMonth, birthDay);
DateTime currentDate = new DateTime();
currentDate = DateTime.Now;
TimeSpan age = new TimeSpan();
age = currentDate - birthDate;
year = age.Days / 365;
if (v.Value.address == c.address && v.Value.profession == c.occupation && v.Value.gender == c.gender && (year >= min && year <= max))
{
newlist.Add(v.Value);
}
}
return(Ok(newlist));
}
void Awake()
{
if (instance == null)
{
instance = this;
FirebaseDB.init();
}
else
{
Destroy(this.gameObject);
}
}
public string Get(string id)
{
FirebaseDB firebaseDBProd = firebaseDB.Node("Produto/" + id);
FirebaseResponse getResponse = firebaseDBProd.Get();
if (getResponse.Success)
{
return(getResponse.JSONContent);
}
Console.WriteLine(getResponse.JSONContent);
return(null);
}
