public EditDocumentForm(Document doc)
{
InitializeComponent();
this.documentId = doc.ID;
using (var db = new WereDesktopEntities())
{
editDocumentSourceLookUpEdit.Properties.DataSource = db.Contragent.ToList();
editDocumentSourceLookUpEdit.EditValue = doc.SourceID;
editDocumentDestinationLookUpEdit.Properties.DataSource = db.Contragent.ToList();
editDocumentDestinationLookUpEdit.EditValue = doc.DestinationID;
editDocumentNumberTE.Text = doc.DocumentNumber.ToString();
editDocumentDateTE.Text = doc.Date.ToString();
var documents = db.Document.Where(d => d.ID == documentId).ToList();
foreach (Document d in documents)
{
document = d;
}
}
//CheckUserInput();
}
public XtraReportDocument(Document document, List <DocumentRowCart> list)
{
InitializeComponent();
xrSourceContragentName.Text = document.Contragent.Name;
xrSourceContragentBulstat.Text = document.Contragent.Bulstat;
xrSourceContragentVATNumber.Text = document.Contragent.VatNumber;
xrSourceContragentAddress.Text = document.Contragent.Address;
xrSourceContragentCity.Text = document.Contragent.City;
xrSourceContragentMrp.Text = document.Contragent.Mrp;
xrSourceContragentPhoneNumber.Text = document.Contragent.PhoneNumber;
xrDestinationContragentName.Text = document.Contragent1.Name;
xrDestinationContragentBulstat.Text = document.Contragent1.Bulstat;
xrDestinationContragentVATNumber.Text = document.Contragent1.VatNumber;
xrDestinationContragentAddress.Text = document.Contragent1.Address;
xrDestinationContragentCity.Text = document.Contragent1.City;
xrDestinationContragentMrp.Text = document.Contragent1.Mrp;
xrDestinationContragentPhoneNumber.Text = document.Contragent1.PhoneNumber;
using (var db = new WereDesktopEntities())
{
objectDataSource3.DataSource = list;
}
foreach (DocumentRowCart dr in list)
{
sum += dr.Sum;
}
sumWithoutDDS.Text = sum.ToString();
sumWithDDS.Text = (decimal.ToDouble(sum) * 1.2).ToString();
}
private void ValidateForm()
{
bool bValidName = ValidateProductName();
bool bValidPrice = ValidateProductPrice();
bool bValidNumber = ValidateProductNumber();
if (bValidName && bValidPrice && bValidNumber)
{
var name = productNameET.Text;
var price = Convert.ToDecimal(productPriceET.Text);
var productNumber = productNumberET.Text;
using (var db = new WereDesktopEntities())
{
Product prod = new Product();
Guid id = Guid.NewGuid();
prod.ID = id.ToString();
prod.Name = name;
prod.ProductNumber = productNumber;
prod.Price = price;
prod.Quantity = 0;
db.Product.AddOrUpdate(prod);
db.SaveChanges();
this.Close();
}
}
}
private void ValidateForm()
{
bool bValidBarcode = ValidateBarcode();
if (bValidBarcode)
{
if (Barcode.ID != null)
{
var barcodeNumber = barcodeNumberET.Text;
using (var db = new WereDesktopEntities())
{
Barcode barcode = new Barcode();
barcode.ID = Barcode.ID;
barcode.ProductID = Barcode.ProductID;
barcode.BarcodeNumber = barcodeNumber;
db.Barcode.AddOrUpdate(barcode);
db.SaveChanges();
this.Close();
}
}
}
}
private void deleteBarcode()
{
var deleteBarcode = SelectedBarcode;
DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избрания баркод?", "Потвърждение", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
//delete row from database or datagridview...
using (var db = new WereDesktopEntities())
{
if (deleteBarcode != null)
{
db.Barcode.Attach(deleteBarcode);
db.Barcode.Remove(deleteBarcode);
db.SaveChanges();
updateScreen(db);
}
}
}
else if (dr == DialogResult.No)
{
//Nothing to do
}
}
private void deleteLot()
{
var deleteLot = SelectedLot;
DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избраната партида?", "Потвърждение", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
//delete row from database or datagridview...
using (var db = new WereDesktopEntities())
{
if (deleteLot != null)
{
foreach (var docRow in db.DocumentRow.Where(row => row.LotID == deleteLot.ID))
{
db.DocumentRow.Remove(docRow);
}
db.SaveChanges();
deleteLot.DocumentRow = null;
db.Lot.Attach(deleteLot);
db.Lot.Remove(deleteLot);
db.SaveChanges();
updateScreen(db);
}
}
}
else if (dr == DialogResult.No)
{
//Nothing to do
}
}
private void AddDocumentRowButton_Click(object sender, EventArgs e)
{
double quantity = double.Parse(quantityET.Text);
var productID = productTreeListLookUpEdit.EditValue.ToString();
var lotID = lotTreeListLookUpEdit.EditValue.ToString();
using (var db = new WereDesktopEntities())
{
var lots = db.Lot.Where(l => l.ID == lotID).ToList();
foreach (Lot lot in lots)
{
DocumentRow dr = new DocumentRow();
Guid id = Guid.NewGuid();
dr.ID = id.ToString();
dr.ProductID = productID;
dr.LotID = lotID;
dr.Quantity = quantity;
dr.Sum = Convert.ToDecimal(quantity) * lot.Product.Price;
dr.DocumentID = DocumentID;
lot.Quantity = lot.Quantity - quantity;
db.DocumentRow.AddOrUpdate(dr);
db.Lot.AddOrUpdate(lot);
db.SaveChanges();
this.Close();
}
}
}
private void deleteRowTab4()
{
var deleteRow = SelectedRowTab1;
DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избраната партида?", "Потвърждение", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
//delete row from database or datagridview...
if (deleteRow != null)
{
var lotID = deleteRow.LotID;
using (var db = new WereDesktopEntities())
{
var lots = db.Lot.Where(l => l.ID == lotID).ToList();
foreach (Lot lot in lots)
{
lot.Quantity = lot.Quantity + deleteRow.Quantity;
db.Lot.AddOrUpdate(lot);
db.SaveChanges();
}
}
tab4DocumentRowsList.Remove(deleteRow);
changeLabelValues();
documentRowCartBindingSource3.DataSource = tab4DocumentRowsList;
documentRowsTab4GridControl.RefreshDataSource();
}
}
else if (dr == DialogResult.No)
{
//Nothing to do
}
}
private void deleteDocument()
{
var documentToDelete = SelectedDocument;
if (documentToDelete != null)
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete selected entry?", "Warning", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var db = new WereDesktopEntities())
{
var rowsToDelete = db.DocumentRow.Where(r => r.DocumentID == documentToDelete.ID).ToList();
var paymentsToDelete = db.DocumentPayment.Where(p => p.DocumentId == documentToDelete.ID).ToList();
foreach (DocumentPayment p in paymentsToDelete)
{
db.DocumentPayment.Attach(p);
db.DocumentPayment.Remove(p);
db.SaveChanges();
}
foreach (DocumentRow r in rowsToDelete)
{
using (var dbForLotUpdate = new WereDesktopEntities())
{
Lot lotToUpdate = new Lot();
var lots = dbForLotUpdate.Lot.Where(l => l.ID == r.LotID).ToList();
foreach (Lot lot in lots)
{
lotToUpdate = lot;
}
lotToUpdate.Quantity += r.Quantity;
dbForLotUpdate.Lot.AddOrUpdate(lotToUpdate);
dbForLotUpdate.SaveChanges();
db.DocumentRow.Attach(r);
db.DocumentRow.Remove(r);
db.SaveChanges();
}
}
using (var bd = new WereDesktopEntities())
{
var docs = bd.Document.Where(d => d.ID == documentToDelete.ID).ToList();
foreach (Document d in docs)
{
bd.Document.Attach(d);
bd.Document.Remove(d);
bd.SaveChanges();
}
}
}
using (var db = new WereDesktopEntities())
{
updateScreen(db);
}
}
}
}
public SelectContragentForm()
{
InitializeComponent();
using (var db = new WereDesktopEntities())
{
contragentTreeListLookUpEdit.Properties.DataSource = db.Contragent.ToList();
}
}
private void updateScreen(WereDesktopEntities db)
{
contragentBindingSource.DataSource = db.Contragent.ToList();
var selected = SelectedContragent;
contragentBindingSource.DataSource = db.Contragent.ToList();
}
public XtraUserControlDocuments()
{
InitializeComponent();
using (var db = new WereDesktopEntities())
{
documentBindingSource.DataSource = db.Document.Include(d => d.Contragent).Include(d => d.Contragent1).ToList();
}
}
private void addDocumentButton_Click(object sender, EventArgs e)
{
try
{
decimal input = decimal.Parse(inCashET.Text);
if (input >= sum)
{
using (var db = new WereDesktopEntities())
{
Document document = new Document();
Guid id = Guid.NewGuid();
document.ID = id.ToString();
document.SourceID = SelectedContragent.SourceContragentID;
document.DestinationID = SelectedContragent.contragent.ID;
document.DocumentNumber = GenerateDocumentNumber.generateDocumentNumber();
document.Date = DateTime.Now;
db.Document.AddOrUpdate(document);
db.SaveChanges();
foreach (DocumentRowCart dr in documentRowsList)
{
DocumentRow docRow = new DocumentRow();
docRow.ID = dr.ID;
docRow.ProductID = dr.ProductID;
docRow.LotID = dr.LotID;
docRow.Quantity = dr.Quantity;
docRow.Sum = dr.Sum;
docRow.DocumentID = document.ID;
db.DocumentRow.Add(docRow);
db.SaveChanges();
}
DocumentPayment dp = new DocumentPayment();
id = Guid.NewGuid();
dp.ID = id.ToString();
dp.DocumentId = document.ID;
dp.MethodOfPayment = "cash";
dp.Price = sum;
db.DocumentPayment.Add(dp);
db.SaveChanges();
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public XtraUserControlContragents()
{
InitializeComponent();
using (var db = new WereDesktopEntities())
{
contragentBindingSource.DataSource = db.Contragent.ToList();
}
}
private void updateScreen(WereDesktopEntities db)
{
productBindingSource.DataSource = db.Product.ToList();
var selected = SelectedProduct;
lotBindingSource1.DataSource = db.Lot.Where(l => l.ProductID == selected.ID).ToList();
barcodeBindingSource.DataSource = db.Barcode.Where(b => b.ProductID == selected.ID).ToList();
}
private void updateScreen(WereDesktopEntities db)
{
documentBindingSource.DataSource = db.Document.Include(d => d.Contragent).Include(d => d.Contragent1).ToList();
var selected = SelectedDocument;
documentRowBindingSource.DataSource = db.DocumentRow.Where(dr => dr.DocumentID == selected.ID).ToList();
documentPaymentBindingSource.DataSource = db.DocumentPayment.Where(dp => dp.DocumentId == selected.ID).ToList();
}
private void productGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
var selected = SelectedProduct;
using (var db = new WereDesktopEntities())
{
lotBindingSource1.DataSource = db.Lot.Where(l => l.ProductID == selected.ID).ToList();
barcodeBindingSource.DataSource = db.Barcode.Where(b => b.ProductID == selected.ID).ToList();
}
}
public AddProductToDocumentRowForm(List <Classes.DocumentRowCart> list)
{
this.documentRowsList = list;
InitializeComponent();
using (var db = new WereDesktopEntities())
{
productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList();
}
CheckUserInput();
}
private void documentGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
var selected = SelectedDocument;
using (var db = new WereDesktopEntities())
{
documentRowBindingSource.DataSource = db.DocumentRow.Include(dr => dr.Product).Include(dr => dr.Lot).Where(dr => dr.DocumentID == selected.ID).ToList();
documentPaymentBindingSource.DataSource = db.DocumentPayment.Where(dp => dp.DocumentId == selected.ID).ToList();
}
}
public XtraUserControlCreateDocument()
{
InitializeComponent();
using (var db = new WereDesktopEntities())
{
//db.Lot.Load();
productBindingSource.DataSource = db.Product.Include(p => p.Lot).ToList();
}
changeLabelValues();
}
private void deleteContragent()
{
using (var db = new WereDesktopEntities())
{
var contragentToDelete = SelectedContragent;
DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete selected entry?", "Warning", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (contragentToDelete != null)
{
foreach (var doc in db.Document.Where(d => d.SourceID == contragentToDelete.ID || d.DestinationID == contragentToDelete.ID))
{
foreach (var payment in db.DocumentPayment.Where(p => p.DocumentId == doc.ID).ToList())
{
db.DocumentPayment.Remove(payment);
}
foreach (var row in db.DocumentRow.Where(r => r.DocumentID == doc.ID).ToList())
{
using (var dbForLotUpdate = new WereDesktopEntities())
{
Lot lotToUpdate = new Lot();
var lots = dbForLotUpdate.Lot.Where(l => l.ID == row.LotID).ToList();
foreach (Lot lot in lots)
{
lotToUpdate = lot;
}
lotToUpdate.Quantity += row.Quantity;
dbForLotUpdate.Lot.AddOrUpdate(lotToUpdate);
dbForLotUpdate.SaveChanges();
}
db.DocumentRow.Remove(row);
}
doc.DocumentPayment = null;
doc.DocumentRow = null;
db.Document.Remove(doc);
}
db.SaveChanges();
contragentToDelete.Document = null;
contragentToDelete.Document1 = null;
db.Contragent.Attach(contragentToDelete);
db.Contragent.Remove(contragentToDelete);
db.SaveChanges();
updateScreen(db);
}
}
}
}
private void editDocumentBtn_Click(object sender, EventArgs e)
{
document.DestinationID = editDocumentDestinationLookUpEdit.EditValue.ToString();
document.SourceID = editDocumentSourceLookUpEdit.EditValue.ToString();
using (var db = new WereDesktopEntities())
{
db.Document.AddOrUpdate(document);
db.SaveChanges();
}
}
private void productTreeListLookUpEdit_Properties_EditValueChanged(object sender, EventArgs e)
{
if (productTreeListLookUpEdit.EditValue != null)
{
var productID = productTreeListLookUpEdit.EditValue.ToString();
using (var db = new WereDesktopEntities())
{
productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList();
lotTreeListLookUpEdit.Properties.DataSource = db.Lot.Where(l => l.ProductID == productID).ToList();
}
}
}
private void addContragent()
{
addForm = new AddContragentForm();
addForm.MaximizeBox = false;
addForm.MinimizeBox = false;
addForm.ShowDialog();
using (var db = new WereDesktopEntities())
{
contragentBindingSource.DataSource = db.Contragent.ToList();
}
}
private void addProduct()
{
addProductForm = new AddProductForm();
addProductForm.MaximizeBox = false;
addProductForm.MinimizeBox = false;
addProductForm.ShowDialog();
using (var db = new WereDesktopEntities())
{
productBindingSource.DataSource = db.Product.ToList();
}
}
public AddDocumentRowForm(string id)
{
InitializeComponent();
this.DocumentID = id;
using (var db = new WereDesktopEntities())
{
productTreeListLookUpEdit.Properties.DataSource = db.Product.ToList();
lotTreeListLookUpEdit.Properties.DataSource = db.Lot.ToList();
}
CheckUserInput();
}
private void editDocumentRowProductTreeListLookUpEdit_EditValueChanged(object sender, EventArgs e)
{
if (editDocumentRowProductTreeListLookUpEdit.EditValue != null)
{
var productID = editDocumentRowProductTreeListLookUpEdit.EditValue.ToString();
using (var db = new WereDesktopEntities())
{
editDocumentRowProductTreeListLookUpEdit.Properties.DataSource = db.Product.ToList();
editDocumentRowLotTreeListLookUpEdit.Properties.DataSource = db.Lot.Where(l => l.ProductID == productID).ToList();
}
}
CheckUserInput();
}
private void editDocumentRow()
{
editDocumentRowForm = new EditDocumentRowForm(SelectedDocumentRow);
editDocumentRowForm.MaximizeBox = false;
editDocumentRowForm.MinimizeBox = false;
if (editDocumentRowForm.ShowDialog() == DialogResult.OK)
{
using (var db = new WereDesktopEntities())
{
updateScreen(db);
}
}
}
private void documentsGridControl_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{
deleteDocument();
}
else if (e.KeyCode == Keys.F5)
{
using (var db = new WereDesktopEntities())
{
updateScreen(db);
}
}
}
private void deleteProduct()
{
var deleteProduct = SelectedProduct;
DialogResult dr = MessageBox.Show("Сигурни ли сте, че искате да изтриете избрания продукт", "Потвърждение", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
//delete row from database or datagridview...
using (var db = new WereDesktopEntities())
{
if (deleteProduct != null)
{
foreach (var docRow in db.DocumentRow.Where(row => row.ProductID == deleteProduct.ID))
{
db.DocumentRow.Remove(docRow);
}
db.SaveChanges();
foreach (var lot in db.Lot.Where(l => l.ProductID == deleteProduct.ID).ToList())
{
db.Lot.Remove(lot);
}
db.SaveChanges();
foreach (var barcode in db.Barcode.Where(b => b.ProductID == deleteProduct.ID).ToList())
{
db.Barcode.Remove(barcode);
}
db.SaveChanges();
deleteProduct.DocumentRow = null;
deleteProduct.Lot = null;
deleteProduct.Barcode = null;
db.Product.Attach(deleteProduct);
db.Product.Remove(deleteProduct);
db.SaveChanges();
updateScreen(db);
}
}
}
else if (dr == DialogResult.No)
{
//Nothing to do
}
}
