private void CustomersByDate_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var db = new AMDDataContext();
var query = from p in db.Customers
where p.CustomerID != null
select p;
dgvCustomers.ItemsSource = query;
var query2 = from p in db.Customers
where p.CustomerID != null
select p;
//var Filterquery = query2.Where(o => o.DateBought.ToString().StartsWith(CustomersByDate.Text));
//CustomersByID.ItemsSource = Filterquery.Select(x => x.DateBought).Distinct().ToList();
//CustomersByID.DisplayMemberPath = "CustomerID";
//CustomersByID.SelectedValuePath = "Id";
var customerid = from p in db.Customers
select p;
//var FilterCustomer = customerid.Where(o => o.DateBought.ToString().StartsWith(CustomersByDate.Text));
//dgvCustomers.ItemsSource = FilterCustomer;
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
var db = new AMDDataContext();
var query = from p in db.Items
select p;
ItemsToPrint.ItemsSource = query.ToList();
ItemsToPrint.DisplayMemberPath = "ItemName";
ItemsToPrint.SelectedValuePath = "Id";
//if (ItemsToPrint.SelectedIndex == -1)
//{
// ItemsNumber.Items.Clear();
//}
//else
//{
//for (int i = 1; i <= 100; i++)
//{
// ItemsNumber.Items.Add(i);
//}
//}
txtCash.Visibility = Visibility.Collapsed;
txtTransfer.Visibility = Visibility.Collapsed;
Bank.Visibility = Visibility.Collapsed;
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
var db = new AMDDataContext();
var query = from p in db.Items
select p;
dgvItems.ItemsSource = query;
}
private void CustomersByID_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var db = new AMDDataContext();
var customerid = from p in db.Customers
select p;
//var FilterCustomer = customerid.Where(o => o.CustomerID.ToString().StartsWith(CustomersByID.Text));
//dgvCustomers.ItemsSource = FilterCustomer;
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
db.Visibility = Visibility.Visible;
it.Visibility = Visibility.Hidden;
cm.Visibility = Visibility.Hidden;
//rc.Visibility = Visibility.Hidden;
ac.Visibility = Visibility.Hidden;
AMDDataContext db1 = new AMDDataContext();
var query = from p in db1.Items
select p;
dgvItems.ItemsSource = query;
}
private void SaveItem_Click(object sender, RoutedEventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(txtFullName.Text) || string.IsNullOrWhiteSpace(txtUserName.Text) ||
string.IsNullOrWhiteSpace(txtPassword.Text))
{
MessageBox.Show("These Fields cannot be empty!");
}
var db = new AMDDataContext();
var Users = from p in db.Users
where p.Username == txtUserName.Text
select p;
if (Users.Count() != 0)
{
MessageBox.Show("User already exists!");
}
else
{
//var NewUser = new users with { FullName = txtFullName.Text, Username = txtUserName.Text, Password = txtPassword, Role = txtRole}
var NewUser = new User();
NewUser.FullName = txtFullName.Text;
NewUser.Username = txtUserName.Text;
NewUser.Password = txtPassword.Text;
if (rdbAdminRole.IsChecked == true)
{
NewUser.Role = "Admin";
db.Users.InsertOnSubmit(NewUser);
db.SubmitChanges();
MessageBox.Show("User successfully added as Admin!");
}
else
{
NewUser.Role = "User";
db.Users.InsertOnSubmit(NewUser);
db.SubmitChanges();
MessageBox.Show("User successfully added as User!");
}
}
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
private void RemoveCustomer_Click(object sender, RoutedEventArgs e)
{
DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Are you sure you want delete this Customer?", "Delete Customer", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
AMDDataContext db = new AMDDataContext();
var DeleteCustomer = from p in db.Customers
where p.CustomerID == txtCustomerID.Text
select p;
foreach (var customer in DeleteCustomer)
{
db.Customers.DeleteOnSubmit(DeleteCustomer.FirstOrDefault());
db.SubmitChanges();
}
System.Windows.Forms.MessageBox.Show("Customer deleted successfully!", "AMD Enterprise", MessageBoxButtons.OK);
txtCustomerFullName.Text = string.Empty;
txtCustomerID.Text = string.Empty;
var customerid = from p in db.Customers
select p;
var FilterCustomer = customerid.Where(o => o.CustomerID.StartsWith(txtCustomerID.Text));
dgvItems.ItemsSource = null;
}
catch (Exception a)
{
System.Windows.Forms.MessageBox.Show(a.Message);
}
}
else
{
return;
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
var db = new AMDDataContext();
var query = from p in db.Customers
select p;
dgvCustomers.ItemsSource = query;
var query1 = from p in db.Customers
where p.DateBought.Value != null
select p;
//CustomersByDate.ItemsSource = query1.ToList();
//CustomersByDate.DisplayMemberPath = "DateBought";
//CustomersByDate.SelectedValuePath = "Id";
CustomersSelectionType.Items.Add("Daily");
CustomersSelectionType.Items.Add("Weekly");
CustomersSelectionType.Items.Add("Monthly");
CustomersSelectionType.Items.Add("Yearly");
}
private void Login_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(UserName.Text) || string.IsNullOrWhiteSpace(Password.Password))
{
MessageBox.Show("Fields cannot be empty!");
return;
}
else
{
Prog.Visibility = Visibility.Visible;
UserName.IsEnabled = false;
Password.IsEnabled = false;
Login.IsEnabled = false;
try
{
Task.Run(() =>
{
Thread.Sleep(1500);
var db = new AMDDataContext();
var CheckUsers = from p in db.Users
where p.Username == UserName.Text && p.Password == Password.Password
select p;
this.Dispatcher.Invoke(() =>
{
if (CheckUsers.Count() == 0)
{
UserName.IsEnabled = true;
Password.IsEnabled = true;
Login.IsEnabled = true;
Prog.Visibility = Visibility.Collapsed;
//await this.ShowMessageAsync("","");
MessageBox.Show("This User does not exist!, Please try again");
}
else
{
var navigation = NavigationServiceEx.Instance;
UserName.IsEnabled = true;
Password.IsEnabled = true;
Login.IsEnabled = true;
Prog.Visibility = Visibility.Collapsed;
//navigation.Navigate(typeof(MainPage));
foreach (var user in CheckUsers)
{
switch (user.Role)
{
case "Admin":
navigation.Navigate(typeof(MainPage));
var nc = new NewCustomerPage();
nc.txtCollector.Text = user.FullName;
break;
case "User":
navigation.Navigate(typeof(UserPage));
break;
default:
break;
}
}
}
}
);
}
);
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
}
private void SaveItems_Click(object sender, RoutedEventArgs e)
{
//foreach (var row in dgvItems1.rows)
//{
//}
AMDDataContext db = new AMDDataContext();
Customer SaveItem = new Customer();
if (PrintButtonClicked == true)
{
SaveItem.CustomerID = txtCustomerID.Text;
SaveItem.CustomerName = txtCustomerFullName.Text;
SaveItem.DateBought = DateTime.Now;
SaveItem.PaymentType = PaymentType.Text;
SaveItem.Cash = txtCash.Text;
SaveItem.Transfer = txtTransfer.Text;
SaveItem.Bank = Bank.Text;
SaveItem.Comment = txtCustomerComment.Text;
PrintButtonClicked = false;
Reciept = false;
}
else
{
SaveItem.CustomerID = txtCustomerID.Text;
SaveItem.ItemName = ItemsToPrint.Text;
SaveItem.DateBought = DateTime.Now;
SaveItem.Price = Convert.ToDouble(txtPiecesShopPrice.Text);
SaveItem.Quantity = Convert.ToInt32(ItemsNumber.Text);
SaveItem.Total = (SaveItem.Price * SaveItem.Quantity);
SaveItem.ReducedPrice = Convert.ToDouble(txtReducedPrice.Text);
System.Windows.Forms.MessageBox.Show("Customer successfully saved!");
double PiecesPrice = Convert.ToDouble(txtPiecesShopPrice.Text);
int itemsNo = Convert.ToInt32(ItemsNumber.Text);
double TotalPayment = (PiecesPrice * itemsNo);
Payment += TotalPayment;
txtTotal.Text = Payment.ToString();
txtCustomerDetailsName.Text = txtCustomerFullName.Text;
txtPaymenttype.Text = PaymentType.Text;
}
if (Bank.SelectedIndex == -1)
{
txtBank.Text = "No Bank";
}
else
{
txtBank.Text = Bank.Text;
}
db.Customers.InsertOnSubmit(SaveItem);
db.SubmitChanges();
var customerid = from p in db.Customers
select p;
var FilterCustomer = customerid.Where(o => o.CustomerID.StartsWith(txtCustomerID.Text));
dgvItems.ItemsSource = FilterCustomer;
//ICollectionView linqview = CollectionViewSource.GetDefaultView(customerid);
//linqview.Filter = new Predicate<object>(o =>
//((Customer)o).CustomerID.StartsWith(txtCustomerID.Text));
}
private void SaveItem_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(ItemName.Text) || string.IsNullOrWhiteSpace(BaleQuantity.Text) ||
string.IsNullOrWhiteSpace(BaleActualPrice.Text) || string.IsNullOrWhiteSpace(BaleShopPrice.Text) ||
string.IsNullOrWhiteSpace(PiecesPerBale.Text) || string.IsNullOrWhiteSpace(ItemComment.Text))
{
MessageBox.Show("All Fields are required please!");
return;
}
if (!int.TryParse(BaleQuantity.Text, out a))
{
MessageBox.Show("Bale Quantity must be in Number please!");
return;
}
if (!int.TryParse(BaleActualPrice.Text, out a))
{
MessageBox.Show("Bale Actual Price must be in Number please!");
return;
}
if (!int.TryParse(BaleShopPrice.Text, out a))
{
MessageBox.Show("Bale Shop price must be in Number please!");
return;
}
if (!int.TryParse(PiecesPerBale.Text, out a))
{
MessageBox.Show("pieces Per Bale must be in Number please!");
return;
}
var db = new AMDDataContext();
var Items = from p in db.Items
where p.ItemName == ItemName.Text
select p;
if (Items.Count() != 0)
{
MessageBox.Show("Item already exists!");
}
else
{
var NewItem = new Item();
NewItem.ItemName = ItemName.Text;
NewItem.DateArrived = DateTime.Now;
NewItem.BaleQuantity = Convert.ToInt32(BaleQuantity.Text);
NewItem.BaleActualPrice = Convert.ToInt32(BaleActualPrice.Text);
NewItem.BaleShopPrice = Convert.ToInt32(BaleShopPrice.Text);
NewItem.PiecesPerBale = Convert.ToInt32(PiecesPerBale.Text);
NewItem.ItemComment = ItemComment.Text;
NewItem.TotalPieces = (Convert.ToInt32(BaleQuantity.Text) * Convert.ToInt32(PiecesPerBale.Text));
NewItem.PiecesActualPrice = (Convert.ToInt32(BaleActualPrice.Text) / Convert.ToInt32(PiecesPerBale.Text));
NewItem.PiecesShopPrice = (Convert.ToInt32(BaleShopPrice.Text) / Convert.ToInt32(PiecesPerBale.Text));
NewItem.PiecesActualPriceTotal = (Convert.ToInt32(PiecesPerBale.Text) * (Convert.ToInt32(BaleActualPrice.Text) / Convert.ToInt32(PiecesPerBale.Text)));
NewItem.PiecesPerBaleTotal = (Convert.ToInt32(BaleQuantity.Text) * Convert.ToInt32(PiecesPerBale.Text));
NewItem.PiecesShopPriceTotal = (Convert.ToInt32(PiecesPerBale.Text) * (Convert.ToInt32(BaleShopPrice.Text) / Convert.ToInt32(PiecesPerBale.Text)));
NewItem.BaleActualPriceTotal = (Convert.ToInt32(BaleActualPrice.Text) * Convert.ToInt32(BaleQuantity.Text));
NewItem.BaleShopPriceTotal = (Convert.ToInt32(BaleShopPrice.Text) * Convert.ToInt32(BaleQuantity.Text));
db.Items.InsertOnSubmit(NewItem);
db.SubmitChanges();
MessageBox.Show("Item successfully added!");
}
}
