private void gridView1_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Delete)// && e.Modifiers == Keys.Control)
{
if (MessageBox.Show("حذف ?", "تأكيد الحذف", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
DataAccess.PurchaseInvoice currentRow = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
if (currentRow.Flag == 1)
{
MessageBox.Show("You can not delete closed invoice", "Delete Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
db.PurchaseInvoices.Remove(currentRow);
if (db.SaveChanges() > 0)
{
////MainScreen parent = (MainScreen)this.Parent.Parent.Parent.Parent;
////parent.ShowMessageInStatusBar("Item Deleted", 9000);
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
private void bindingSource1_AddingNew(object sender, AddingNewEventArgs e)
{
DataAccess.PurchaseInvoice newRow = db.PurchaseInvoices.Create();
newRow.UserID = Convert.ToInt32(UserData.Default.UserID);
newRow.BranchID = Convert.ToInt32(UserData.Default.BranchID);
db.PurchaseInvoices.Add(newRow);
e.NewObject = newRow;
//DataAccess.PurchaseInvoice obj = (DataAccess.PurchaseInvoice)e.NewObject;
//obj.Flag = 0;//New Invoice
}
private void gridView1_EditFormShowing(object sender, EditFormShowingEventArgs e)
{
if (gridView1.IsDataRow(e.RowHandle))
{
DataAccess.PurchaseInvoice currentRow = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
if (currentRow.Flag == 1) //Clased Invoice
{
e.Allow = false;
MessageBox.Show("You can not update closed invoice", "Closed Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
private void gridView1_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Delete)// && e.Modifiers == Keys.Control)
{
DataAccess.PurchaseInvoice currentRow = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
//if (currentRow.Flag == 1)
{
MessageBox.Show("You can not delete closed invoice", "Delete Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("الفاتورة تحتوي علي " + currentRow.PurchaseInvoiceDetails.Count + "\n\n\n هل انت متأكد من حذف الفاتورة؟ ", "تأكيد الحذف", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
//for (int i = 0; i < currentRow.PurchaseInvoiceDetails.Count; i++)
//{
// currentRow.PurchaseInvoiceDetails.re
//}
foreach (var item in currentRow.PurchaseInvoiceDetails.ToList())
{
db.PurchaseInvoiceDetails.Remove(item);
}
db.PurchaseInvoices.Remove(currentRow);
if (db.SaveChanges() > 0)
{
////MainScreen parent = (MainScreen)this.Parent.Parent.Parent.Parent;
////parent.ShowMessageInStatusBar("Item Deleted", 9000);
}
GetInvoices();
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
try
{
//Add or update items
if (e.ClickedItem == invoiceDetailsToolStripMenuItem)
{
DataAccess.PurchaseInvoice invoice = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
//if (invoice.Flag == 1) //Clased Invoice
//{
// MessageBox.Show("You can not update closed invoice", "Update Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
// return;
//}
new PurchaseInvoiceForm(invoice, false).Show();
}
//Close invoice
if (e.ClickedItem == closeToolStripMenuItem)
{
DataAccess.PurchaseInvoice currentRow = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
if (currentRow.Flag == 1)
{
MessageBox.Show("Invoice already closed", "Closed Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (currentRow.PurchaseInvoiceDetails.Count == 0)
{
MessageBox.Show("You can not close invoice has no items", "Closed Invoice", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("Close invoice ?", "Close invoice", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
currentRow.Flag = 1;
if (db.SaveChanges() > 0)
{
ShowMessageInStatusBar("Invoice closed", 9000);
if (MessageBox.Show("تحويل الفاتورة الي بقية الفروع?", "تحويل الفاتورة ", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
new TransferForm(currentRow, db).ShowDialog();
}
}
}
}
if (e.ClickedItem == transferToolStripMenuItem)
{
DataAccess.PurchaseInvoice currentRow = (DataAccess.PurchaseInvoice)gridView1.GetFocusedRow();
if (currentRow.Flag == 0)
{
MessageBox.Show("يجب عليك قفل الفاتورة قبل عملية التحويل", "الفاتورة غير مقفلة", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("تحويل الفاتورة الي بقية الفروع?", "تحويل الفاتورة ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
new TransferForm(currentRow, db).ShowDialog();
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
////public PurchaseInvoiceForm()
////{
//// InitializeComponent();
////}
public PurchaseInvoiceForm(DataAccess.PurchaseInvoice invoice, bool isNew, bool quickInsert = false)
{
InitializeComponent();
_quickInsert = quickInsert;
if (isNew)
{
this.invoice = db.PurchaseInvoices.Create();
this.invoice.UserID = Convert.ToInt32(UserData.Default.UserID);
this.invoice.BranchID = Convert.ToInt32(UserData.Default.BranchID);
this.invoice.Flag = 0;
this.invoice.Date = DateTime.Now;
this.invoice.Total = 0;
this.invoice.Discount = 0;
db.PurchaseInvoices.Add(this.invoice);
}
else
{
this.invoice = invoice;
}
this.bindingSource1.DataSource = this.invoice;
db.PurchaseInvoiceDetails.Where(s => s.PurchaseInvoiceID == invoice.ID).Load();
purchaseDetails = db.PurchaseInvoiceDetails.Local.ToBindingList();
this.bindingSource2.DataSource = purchaseDetails;
if (quickInsert)
{
//Only quick items
this.invoice.Number = "فاتورة سريعه" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + "-" + UserData.Default.BranchID;
var list = db.Items.Where(s => s.CategoryID == 2014).ToList();
this.itemBindingSource.DataSource = list;
itemBindingSource1.DataSource = list;
txtItemSearch.Enabled = false;
}
else
{
db.ItemBarcodes.Load();
this.itemBindingSource.DataSource = db.Items.ToList();
}
this.txtUser.Text = this.invoice.User.UserName;
//if invoice was closed
if (this.invoice.Flag == 1)
{
btnSave.Enabled = false;
btnAddItem.Enabled = false;
cmbItem.Enabled = false;
txtItemDiscount.Enabled = false;
txtPurchasePrice.Enabled = false;
txtSalePrice.Enabled = false;
txtDiscount.Enabled = false;
txtQunatity.Enabled = false;
cmpDate.Enabled = false;
txtTotal.Enabled = false;
txtUser.Enabled = false;
checkEditAutoPrint.Enabled = false;
checkEditAutoSave.Enabled = false;
txtNumber.Enabled = false;
gridView1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
//gridView1.OptionsBehavior.Editable = false;
colDiscountPrice.OptionsColumn.AllowEdit = false;
colItemID.OptionsColumn.AllowEdit = false;
colQuantity.OptionsColumn.AllowEdit = false;
colSalePrice.OptionsColumn.AllowEdit = false;
colPurchasePrice.OptionsColumn.AllowEdit = false;
repositoryItemButtonEdit1.Buttons[3].Visible = false;
this.Text = "Invoice Number: " + this.invoice.Number + " Closed";
}
else if (this.invoice.Flag == 0)
{
this.Text = "Invoice Number: " + this.invoice.Number + " Open";
}
BarcodePrinter = db.Companies.Take(1).SingleOrDefault().BarcodePrinter;
}
