void RefreshData()
{
UserSource.DataSource = BusinessAccessLayer.GetEntity().User_tbl;
DBSource.DataSource = BusinessAccessLayer.GetEntity().DB_tbl;
SubPrivSource.DataSource = BusinessAccessLayer.GetEntity().Sub_Priv_tbl;
PrivelegeSource.DataSource = BusinessAccessLayer.GetEntity().Privilege_tbl;
}
private void btnSave_Click(object sender, EventArgs e)
{
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
AsyncHelper.TaskAwaiter(() =>
{
var user = (User_tbl)UserSource.Current;
var priv = user.Privilege_tbl.Where(x => x.DbID == selectDB);
if (priv.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
}
BusinessAccessLayer.GetEntity().SaveChanges();
return(true);
});
}
private void btnSave_Click(object sender, EventArgs e)
{
BusinessAccessLayer.GetEntity().SaveChanges();
modRefreshData("");
Close();
Dispose();
}
private void button3_Click(object sender, EventArgs e)
{
if (txtGrandtotal.Text.Trim() == "")
{
return;
}
var result = MessageBox.Show(
"You must save the transaction before you cant generate Invoice\nDo you want to save transaction?",
"Saving transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
_order.CustomerID = int.Parse(cmbBillto.SelectedValue.ToString() ?? "0");
_order.IsPaid = false;
_order.OrderDate = DateTime.Now;
_order.BillingDate = dtpTransDate.Value.AddDays(30);
_order.DeliveryAddress = txtAddress.Text;
_order.DeliveryDate = dtpTransDate.Value;
_order.Term = 30;
foreach (var orderDetail in OrderDetailSource.OfType <Order_Detail>())
{
_order.Order_Details.Add(orderDetail);
}
BusinessAccessLayer.GetEntity().Orders.AddObject(_order);
BusinessAccessLayer.GetEntity().SaveChanges();
GenerateInvoice();
Close();
}
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
entity.CreateDatabaseScript();
SupplierSource.DataSource = entity.Suppliers;
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
var products = BusinessAccessLayer.GetEntity().Products.Where(x => x.ProductName.Contains(textBox1.Text.Trim()));
if (products.Count() <= 0)
{
MessageBox.Show("Product Barcode not available", "invalid", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
_orderDetails = new Order_Detail();
_orderDetails.Quantity = 1;
_orderDetails.UnitPrice = products.First().UnitPrice;
_orderDetails.ProductID = products.First().ProductID;
_orderDetails.IsVoid = false;
_orderDetails.IsReturn = false;
OrderDetailSource.Add(_orderDetails);
CalculateSumAmount();
textBox11.Clear();
textBox11.Focus();
}
}
public frmTransactionBilling()
{
InitializeComponent();
_order = new Order();
OrderSource.DataSource = BusinessAccessLayer.GetEntity().Orders;
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
}
public frmTransactionDelivery()
{
InitializeComponent();
_order = new Order();
OrderSource.DataSource = BusinessAccessLayer.GetEntity().Orders;
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
textBox11.Focus();
}
private frmCustomerDataEntry(int id = 0)
{
InitializeComponent();
if (id <= 0)
{
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Products;
}
else
{
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers.Where(e => e.ID == id);
}
}
private frmProductDataEntry(int id = 0)
{
InitializeComponent();
bindingSupplier.DataSource = BusinessAccessLayer.GetEntity().Suppliers;
if (id <= 0)
{
bindingProduct.DataSource = BusinessAccessLayer.GetEntity().Products;
}
else
{
bindingProduct.DataSource = BusinessAccessLayer.GetEntity().Products.Where(e => e.ProductID == id);
}
}
private frmSupplierDataEntry(int id = 0)
{
InitializeComponent();
if (id <= 0)
{
SupplierSource.DataSource = BusinessAccessLayer.GetEntity().Suppliers;
}
else
{
SupplierSource.DataSource = BusinessAccessLayer.GetEntity().Suppliers.Where(e => e.SupplierID == id);
}
}
private void OnChangeDataSelect()
{
var user = (User_tbl)UserSource.Current;
var Dbtbl = (DB_tbl)DBSource.Current;
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
var dataAwaiter = AsyncHelper.TaskAwaiter(() =>
{
var privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
if (privList.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
BusinessAccessLayer.GetEntity().SaveChanges();
privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
}
return(privList);
});
dataAwaiter.OnCompleted(() =>
{
var privList = dataAwaiter.GetResult();
if (privList.Count() > 0)
{
SubPrivSource.DataSource = privList.First().Sub_Priv_tbl;
}
});
}
public frmRemittance(int id = 0)
{
InitializeComponent();
UserSource.DataSource = BusinessAccessLayer.GetEntity().User_tbl;
var ordersPaid =
BusinessAccessLayer.GetEntity().Orders.ToList().Where(
e => (e.OrderDate >= DateTime.Now.AddHours(-8) && e.OrderDate <= DateTime.Now) ||
(e.DeliveryDate >= DateTime.Now.AddHours(-8) && e.DeliveryDate <= DateTime.Now));
decimal?totalRemit = null;
totalRemit = ordersPaid.Sum(e => e.Payments.Sum(x => x.AmountPaid));
label3.Text = (totalRemit ?? 0).ToString("#,###.00");
}
//Use to validate user login entry
private void sValidate()
{
var user =
BusinessAccessLayer.GetEntity().User_tbl.Where(
e => e.UserID == txtUsername.Text && e.Password == txtPassword.Text);
if (user.Count() > 0)
{
isvalid = true;
User = txtUsername.Text;
Close();
return;
}
MessageBox.Show("Invalid username or password", "invalid", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public frmManageUser()
{
InitializeComponent();
var userCount = BusinessAccessLayer.GetEntity().User_tbl.Count();
if (userCount <= 0)
{
var user = new User_tbl();
user.UserID = "Admin";
user.Password = "******";
BusinessAccessLayer.GetEntity().User_tbl.AddObject(user);
BusinessAccessLayer.GetEntity().SaveChanges();
}
RefreshData();
comboBox1.SelectedValueChanged += comboBox1_SelectedValueChanged;
}
private void btnSave_Click(object sender, EventArgs e)
{
var remitttance = new Remittance();
remitttance.DateRemit = DateTime.Now;
remitttance.UserID = int.Parse(comboBox1.SelectedValue.ToString());
foreach (var remittanceDetail in RemitDetailSource.OfType <RemittanceDetail>())
{
remitttance.RemittanceDetails.Add(remittanceDetail);
}
BusinessAccessLayer.GetEntity().Remittances.AddObject(remitttance);
BusinessAccessLayer.GetEntity().SaveChanges();
Close();
Dispose();
}
public frmTransactionBilling(int id)
{
InitializeComponent();
_order = new Order();
if (BusinessAccessLayer.GetEntity().Orders.Where(e => e.OrderID == id).Count() <= 0)
{
MessageBox.Show("Order Transaction doesnt exist", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
_order = BusinessAccessLayer.GetEntity().Orders.Where(e => e.OrderID == id).First();
OrderSource.DataSource = _order;
CustomerSource.DataSource = _order.Customer;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
OrderDetailSource.DataSource = _order.Order_Details;
CalculateSumAmount();
}
private void btnCash_Click(object sender, EventArgs e)
{
if (txtGrandtotal.Text.Trim() == "")
{
return;
}
var paymentEntry = new frmPaymentEntry();
paymentEntry.AmountToPay = double.Parse(txtGrandtotal.Text);
paymentEntry.ShowDialog();
if (!paymentEntry.IsSubmit)
{
return;
}
var payment = new Payment();
payment.AmountPaid = (decimal)paymentEntry.Cash;
payment.Balance = (decimal)(paymentEntry.Cash - double.Parse(txtGrandtotal.Text));
_order.CustomerID = int.Parse(cmbBillto.SelectedValue.ToString() ?? "0");
_order.IsPaid = (payment.Balance == 0);
_order.OrderDate = dtpTransDate.Value;
_order.BillingDate = dtpTransDate.Value;
_order.Term = 30;
_order.Payments.Add(payment);
foreach (var orderDetail in OrderDetailSource.OfType <Order_Detail>())
{
_order.Order_Details.Add(orderDetail);
}
BusinessAccessLayer.GetEntity().Orders.AddObject(_order);
BusinessAccessLayer.GetEntity().SaveChanges();
MessageBox.Show("transaction saved", "transaction", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
//---------------------------------------------//
//Constructor
public frmMain()
{
var data = BusinessAccessLayer.GetEntity();
InitializeComponent();
}
private void showSelected(string msg)
{
if (msg.Contains("Walk"))
{
new frmTransactionWalkin().ShowDialog();
}
else if (msg.Contains("Purchase Order"))
{
new frmTransactionOrder().ShowDialog();
}
else if (msg.Contains("Delivery"))
{
new frmTransactionDelivery().ShowDialog();
}
else if (msg == "Order List")
{
showOrderList();
}
else if (msg.Contains("Remit"))
{
new frmRemittance().ShowDialog();
showRemmitanceList();
}
else if (msg == "Item List")
{
showManageProduct();
}
else if (msg.Contains("Details"))
{
showManageProductDetails();
}
else if (msg.Contains("Buying Report"))
{
var rptRange = new frmDateRangeReport();
rptRange.Title = "Buying Report Range";
rptRange.ShowDialog();
if (!rptRange.IsShow)
{
return;
}
var f = new frmProductInventoryReport();
f.ProductBindingSource.DataSource = BusinessAccessLayer.GetEntity().Products;
f.ShowDialog();
}
else if (msg.Contains("Open P/O Report"))
{
var rptRange = new frmDateRangeReport();
rptRange.Title = "Open P/O Report Range";
rptRange.ShowDialog();
if (!rptRange.IsShow)
{
return;
}
var f = new frmOpenPOReport();
f.GetOrderList_ResultBindingSource.DataSource = BusinessAccessLayer.GetEntity().GetOrderList();
//.Where(e=> e.DeliveryDate >= rptRange.dtFrom.Value && e.DeliveryDate <= rptRange.dtFrom.Value);
f.ShowDialog();
}
else if (msg.Contains("AR Cash Report"))
{
}
else if (msg.Contains("Account Recievable"))
{
showARList();
}
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
OrderSource.DataSource = entity.GetOrderList();
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
OrderSource.DataSource = entity.GetAccountReceivable();
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
BillingSource.DataSource = entity.RemittanceDetails;
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
CustomerSource.DataSource = entity.Customers;
}