public static List <ContactDetails> GetCustomerNumbers(int id)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", id }
};
string query = "SELECT Id, CustomerId, ContactTypeId, ContactInfo " +
"FROM CustomerContactDetails " +
"WHERE CustomerId = @Id";
con.Open();
return(DBActions.ExecReaderListQR <ContactDetails>(con, query, p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
public static int UpdateCustomer(Customer c)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", c.Id },
{ "@FirstName", c.FirstName },
{ "@LastName", c.LastName },
{ "@DateOfBirth", c.DateOfBirth },
{ "@CompanyId", c.CompanyId }
};
con.Open();
return(DBActions.ExecNonReaderSP(con, "updateCustomerByID", p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(-1);
}
finally
{
con.Close();
}
}
}
public static List <AddressVM> GetCustomerAddressList(int id)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", id }
};
string query = "SELECT Id, Road, Number, City, Region, State, PostalCode, Country " +
"FROM CustomerAddress " +
"WHERE CustomerId = @Id";
con.Open();
return(DBActions.ExecReaderListQR <AddressVM>(con, query, p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
public static int AddCustomerNumber(ContactDetails number)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
int retVal = -1;
Dictionary <string, object> inParams = new Dictionary <string, object>
{
{ "@CustomerId", number.CustomerId },
{ "@ContactTypeId", number.ContactTypeId },
{ "@ContactInfo", number.ContactInfo }
};
Dictionary <string, object> outParams = new Dictionary <string, object>
{
{ "@NewId", -1 }
};
con.Open();
retVal = (int)DBActions.ExecNonReaderWithReturnSP(con, "addCustomerNumber", inParams, outParams);
return(retVal);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(-1);
}
finally
{
con.Close();
}
}
}
private async void ButtonRemove(object s, EventArgs args)
{
if (clicked)
{
return;
}
if (admin != null)
{
clicked = true;
var b = await App.Send("Meddelande",
"Vill du också radera alla tillhörande produkter?", "Ja", "Nej", ManagePage.page);
await DBActions.FullyRemoveAdmin(admin);
if (b)
{
var a = DBActions._a(admin);
foreach (Products p in a)
{
await DBActions.FullyRemoveProduct(p);
}
}
search.Text = null;
App.Send("Info", "Kontot med ID: " + admin.ID + " har raderats!", "Ok", ManagePage.page);
stack.IsVisible = false;
clicked = false;
}
}
public DBActions InsertOrUpdate(Person newPerson)
{
DBActions action = DBActions.None;
using (var dao = new PersonLINQDao())
{
var thePerson = dao.Persons.Find(newPerson.Id);
action = thePerson != null ? DBActions.Update : DBActions.Insert;
switch (action)
{
case DBActions.Insert:
//newPerson.Id = 0;
newPerson.Intime = DateTime.Now;
newPerson.Utime = DateTime.Now;
newPerson.Id = Convert.ToInt32(dao.InsertWithIdentity(newPerson));
break;
case DBActions.Update:
newPerson.Intime = thePerson.Intime;
newPerson.Utime = DateTime.Now;
dao.Update(newPerson);
break;
}
}
return(action);
}
public static int AddCustomer(Customer c)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
int retVal = -1;
Dictionary <string, object> inParams = new Dictionary <string, object>
{
{ "@FirstName", c.FirstName },
{ "@LastName", c.LastName },
{ "@DateOfBirth", c.DateOfBirth },
{ "@CompanyId", c.CompanyId },
};
Dictionary <string, object> outParams = new Dictionary <string, object>
{
{ "@NewId", -1 }
};
con.Open();
retVal = (int)DBActions.ExecNonReaderWithReturnSP(con, "createNewCustomer", inParams, outParams);
return(retVal);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(-1);
}
finally
{
con.Close();
}
}
}
private void OnSearch()
{
var text = search.Text;
if (text != null)
{
var ad = DBActions.GetAdminById(text);
if (ad != null)
{
if (ad.ID == App.ACCOUNT_NAME)
{
return;
}
admin = ad;
stack.IsVisible = true;
}
else
{
stack.IsVisible = false;
App.Send("Fel", "Kunde inte hitta kontot med ID: " + text + "!", "Avbryt", ManagePage.page);
}
}
else
{
App.Send("Fel", "Ange admin id!", "Avbryt", ManagePage.page);
}
}
public static int DeleteCustomerAddresses(int id)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", id }
};
string cmdText = "DELETE " +
"FROM CustomerAddress " +
"WHERE CustomerId = @Id";
con.Open();
return(DBActions.ExecNonReaderQR(con, cmdText, p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(-1);
}
finally
{
con.Close();
}
}
}
private async void LoadContent()
{
ImageSource src = null;
ImageSource src1 = null;
AdminIcon ai = await DBActions.LoadAdminIcon(DBActions._p(binary.PRODUCT));
Images img = await DBActions.LoadProductImage(binary.PRODUCT);
if (ai != null)
{
src = App.ByteToImage(ai.Image);
}
else
{
src = App.GetSource("icon-blank.png");
}
if (img != null)
{
src1 = App.ByteToImage(img.Image);
}
else
{
src1 = App.GetSource("noproduct.jpg");
}
icon.SetSRC(src);
product_image.SetSRC(src1);
content_loading.IsVisible = false;
animation.Pause();
LOADING = false;
}
private void Login_Cliked(object sender, EventArgs e)
{
string u = e_name.Text;
string p = e_pass.Text;
if (u != null && p != null)
{
Accounts a = DBActions.GetAccountByName(u);
if (a != null && a.DPassword == p)
{
if (a.DUType == 0)
{
Navigation.PushAsync(new Startsidan());
App.Current.Properties["LoggedUser"] = a.DUsername;
App.Current.SavePropertiesAsync();
}
else
{
//TODO
//Restaurant Page
}
}
else
{
DisplayAlert("Misslyckad Inloggning", "Ogiltigt användernamn eller lösenord!", "Avbryt");
}
}
else
{
DisplayAlert("Misslyckad Inloggning", "Mata in ditt användernamn och lösenord", "Okej");
}
}
public static Company GetCompany(int?id)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
if (id is null)
{
return(null);
}
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", id }
};
string query = "SELECT Id, Name, Title, Country " +
"FROM Companies " +
"WHERE Id = @Id";
con.Open();
return(DBActions.ExecReaderQR <Company>(con, query, p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
private async void ShowProduct(object s, EventArgs a)
{
if (await DBActions.Check(MapPage._g as Admins, MapPage.mapPage))
{
return;
}
MapPage.mapPage.OpenProduct(binary);
}
private async void RCommand1()
{
await DBActions.LoadProducts();
await DBActions.LoadUsers();
events.rel_admin(search1.Text);
refr1.IsRefreshing = false;
}
protected override void AddItem()
{
DBActions.Add <Storage>(new Storage
{
Name = "Новый элемент" + ListCurrentData.Count
});
ListCurrentData = DBActions.Get <Storage>();
OnPropertyChanged("ListCurrentData");
SelectedDataItem = ListCurrentData[ListCurrentData.Count - 1];
}
protected override void AddItem()
{
DBActions.Add <Provider>(new Provider
{
FullName = "Поставщик новый " + ListCurrentData.Count
});
ListCurrentData = DBActions.Get <Provider>();
OnPropertyChanged("ListCurrentData");
SelectedDataItem = ListCurrentData[ListCurrentData.Count - 1];
}
protected override void AddItem()
{
DBActions.Add <Client>(new Client
{
FullName = "Поставщик клиент " + ListCurrentData.Count
});
ListCurrentData = DBActions.Get <Client>();
OnPropertyChanged("ListCurrentData");
SelectedDataItem = ListCurrentData[ListCurrentData.Count - 1];
}
private async void RCommand()
{
await DBActions.LoadAdmins();
await DBActions.LoadProducts();
await DBActions.LoadUsers();
events.rel(TXT());
refr.IsRefreshing = false;
}
private async void ButtonClicked(object s, EventArgs a)
{
if (loading)
{
return;
}
var x = loc.Text; var x1 = name.Text; var x2 = email.Text; var x3 = phone.Text;
loading = true;
if (file == null)
{
DisplayAlert("Fel", "Välj en ikon!", "Avbryt");
loading = false;
return;
}
if (x != null && x1 != null && x2 != null && x3 != null)
{
an.IsVisible = true;
an.Play();
var list = await App.GetPositions(x);
if (list.Count == 1)
{
_a.Address = await App.GetAddress(list[0]);
_a.SName = x1; _a.Email = x2; _a.Phone = x3; _a.Login = true;
await DBActions.EditAdmin(_a);
var aicon = new AdminIcon {
ID = _a.ID, Image = App.ImageToByte(file)
};
if (hadAdminIcon)
{
await DBActions.EditAdminIcon(aicon);
}
else
{
await DBActions.AddAdminIcon(aicon);
}
await App.ReloadPins();
an.IsVisible = false;
an.Pause();
Navigation.PushAsync(new MapPage(_a));
App.RemovePage(this);
return;
}
}
an.IsVisible = false;
an.Pause();
loading = false;
await DisplayAlert("Fel", "Ange en giltig adress!", "Avbryt");
}
public CardDefault(Binary b)
{
this.b = b;
InitializeComponent();
Account acc = MapPage._g;
if (acc is Guests)
{
Guests g = acc as Guests;
if (!DBActions.hasBooked(g, b.PRODUCT))
{
btn.Text = "RESERVERA";
}
}
lbl.Text = b.PRODUCT.Description;
btn.Clicked += async(s, e) => {
if (loading)
{
return;
}
if (MapPage._g is Admins)
{
if (await DBActions.Check(MapPage._g as Admins, MapPage.mapPage))
{
return;
}
}
loading = true;
await DBActions.LoadProducts();
await DBActions.LoadUsers();
var prds = DBActions.GetProductById(b.PRODUCT.ID);
if (prds != null && prds.Quantity > 0 &&
DBActions.GetAdminById(prds.AdminID) != null)
{
MapPage.mapPage.OpenProduct(b);
}
else
{
App.Send("Info", "Produkten finns inte längre!", "Ok");
if (DBActions.GetAdminById(prds.AdminID) == null)
{
await DBActions.CheckProducts();
}
MapPage.mapPage.ReloadAll();
}
loading = false;
};
}
private async void SetIcon()
{
var v = await DBActions.LoadAdminIcon(_a);
if (v != null)
{
hadAdminIcon = true;
icon.Source = App.ByteToImage(v.Image);
}
else
{
icon.Source = App.GetSource("icon.png");
}
}
private async void Ask()
{
var l = await CrossPermissions.Current.CheckPermissionStatusAsync(Permission.LocationWhenInUse);
if (l != PermissionStatus.Granted)
{
var results = await CrossPermissions.Current.RequestPermissionsAsync(new[] { Permission.LocationWhenInUse });
if (results.ContainsKey(Permission.LocationWhenInUse))
{
l = results[Permission.LocationWhenInUse];
}
}
if (l == PermissionStatus.Granted)
{
// Load Database
if (App.Current.Properties.ContainsKey("LoggedUser") &&
DBActions.GetAccountByName(App.Current.Properties["LoggedUser"] as string) != null)
{
Accounts acc = DBActions.GetAccountByName(App.Current.Properties["LoggedUser"] as string);
if (acc.DUType == 0)
{
Navigation.PushAsync(new Startsidan());
}
else
{
// Restaurant Page
//Navigation.PushAsync();
}
}
else
{
//Navigation.PushAsync(new RestaurantPage());
Navigation.PushAsync(new MenuDisplayPage());
//Navigation.PushAsync(new MenusPage());
//Navigation.PushAsync(new Startsidan());
//Navigation.PushAsync(new WelcomePage());
//Navigation.PushAsync(new PaymentPage());
}
}
else
{
//var x = await DisplayAlert("Error", "You must allow location access!", "Retry", "Cancel");
//if (x)
//{
Ask();
//}
}
}
private async void Load()
{
Images images = await DBActions.LoadProductImage(b.PRODUCT);
if (images != null)
{
img.Source = App.ByteToImage(images.Image);
}
else
{
img.Source = App.GetSource("noimage.png");
}
image_loading.Pause();
image_an_layout.IsVisible = false;
}
private async void UnbookClicked(object s, EventArgs a)
{
if (loading)
{
return;
}
if (await App.SendSure())
{
loading = true;
await DBActions.Unbook(binary.OWNER, binary.PRODUCT, true);
MapPage.mapPage.ReloadAll();
loading = false;
}
}
private async void ButtonUnRetrieved(object s, EventArgs args)
{
if (loading)
{
return;
}
if (await DBActions.Check(MapPage._g as Admins, MapPage.mapPage))
{
return;
}
loading = true;
await DBActions.Unbook(binary.OWNER, binary.PRODUCT, true);
MapPage.mapPage.ReloadAll();
loading = false;
}
protected override void EditItem()
{
System.Windows.MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show(
"Вы уверены, что хотите внести изменения?",
"Предупреждение",
System.Windows.MessageBoxButton.YesNo,
System.Windows.MessageBoxImage.Warning
);
if (messageBoxResult == System.Windows.MessageBoxResult.No)
{
return;
}
DBActions.Update <Provider>(TempItem);
ListCurrentData[ListCurrentData.IndexOf(SelectedDataItem)] = TempItem;
}
public void rel_admin(string f)
{
la_2.cardType = "user";
vis_admin.Clear();
List <Products> list = DBActions._a((Admins)MapPage._g);
if (f != null && f != "")
{
f = f.ToLower();
foreach (Guests g in DBActions.guests)
{
if (g.Name.ToLower().StartsWith(f))
{
var l1 = DBActions.GetProducts(g);
foreach (Products p in l1)
{
if (list.Contains(p))
{
vis_admin.Add(new Binary {
OWNER = g, PRODUCT = p,
QUANTITY = DBActions.GetQuantity(g, p)
});
}
}
}
}
}
else
{
foreach (Guests g in DBActions.guests)
{
var l1 = DBActions.GetProducts(g);
foreach (Products p in l1)
{
if (list.Contains(p))
{
vis_admin.Add(new Binary {
OWNER = g, PRODUCT = p,
QUANTITY = DBActions.GetQuantity(g, p)
});
}
}
}
}
la_2.visible = vis_admin;
la_2.OpenPage(1, FilterState.BOOKERS);
}
private async void ButtonReset(object s, EventArgs args)
{
if (clicked)
{
return;
}
clicked = true;
if (admin != null)
{
admin.Login = false;
await DBActions.FullyEditAdmin(admin);
search.Text = null;
App.Send("Info", "Kontot med ID: " + admin.ID + " har återställts!", "Ok", ManagePage.page);
stack.IsVisible = false;
clicked = false;
}
}
protected override void RemoveItem()
{
System.Windows.MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show(
"Вы уверены, что хотите удалить выбранный элемент?",
"Предупреждение",
System.Windows.MessageBoxButton.YesNo,
System.Windows.MessageBoxImage.Warning
);
if (messageBoxResult == System.Windows.MessageBoxResult.No)
{
return;
}
DBActions.Delete <Provider>(SelectedDataItem);
ListCurrentData.Remove(SelectedDataItem);
OnPropertyChanged("ListCurrentData");
SelectedDataItem = ListCurrentData[ListCurrentData.Count - 1];
}
public static string CurrentUser()
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
return(DBActions.CurrentUser(con));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
public string ObjectTypeName; //This is the name of the DB Table.
#endregion Fields
#region Constructors
public RepositoryEventsArgs(object obj, string objectTypeName, DBActions action)
{
Obj = obj;
ObjectTypeName = objectTypeName;
DBActionType = action;
}
