private void dataGridView_DoubleClick(object sender, EventArgs e)
{
if (dataGridView.CurrentRow != null)
{
var id = Convert.ToInt32(dataGridView.CurrentRow.Cells["Id"].Value);
var updateObj = db.CustomerAndSuppliers.FirstOrDefault(c => c.Id == id);
customerAndSupplier = updateObj;
if (updateObj != null)
{
txtPartyName.Text = updateObj.Name;
txtPartyCode.Text = updateObj.Code;
txtContactNo.Text = updateObj.ContactNo;
txtEmail.Text = updateObj.Email;
txtAddress.Text = updateObj.Address;
if (updateObj.Type == "CustomerSupplier")
{
chkCustomer.Checked = true;
chkSupplier.Checked = true;
}
else if (updateObj.Type == "Customer")
{
chkCustomer.Checked = true;
}
else if (updateObj.Type == "Supplier")
{
chkSupplier.Checked = true;
}
}
SetFormUpdateMode();
}
}
private void btnSave_Click_1(object sender, EventArgs e)
{
try
{
Sale sales = new Sale();
sales.InvoiceNo = GetInvoiceNo().ToString();
sales.listOfItem = listOfSalesItem;
sales.SubTotal = Convert.ToDecimal(txtSubTotal.Text);
sales.Vat = Convert.ToDecimal(lblVat.Text);
sales.SalesDate = dtpSales.Value;
sales.Remarks = txtRemarks.Text;
sales.Discount = Convert.ToDecimal(txtDiscount.Text);
sales.TotalAmount = sales.SubTotal + sales.Vat;
sales.OutletId = (int)cmbOutlet.SelectedValue;
sales.EmployeeId = (int)cmbEmployee.SelectedValue;
if (lblCustomerId.Text == "")
{
CustomerAndSupplier cus = new CustomerAndSupplier();
cus.ContactNo = txtContactNo.Text;
cus.Name = txtCustomerName.Text;
cus.Code = "Party" + "-" + cus.SetInvioceNo();
cus.Type = "Customer";
using (ManagerContext db = new ManagerContext())
{
bool customerIdExist = db.CustomerAndSuppliers.Count(a => a.ContactNo == cus.ContactNo) > 0;
if (customerIdExist)
{
MessageBox.Show("This number is Exist");
}
else
{
db.CustomerAndSuppliers.Add(cus);
db.SaveChanges();
sales.CustomerId = db.CustomerAndSuppliers.Count();
}
}
}
else
{
sales.CustomerId = Convert.ToInt32(lblCustomerId.Text);
}
using (ManagerContext db = new ManagerContext())
{
db.Sales.Add(sales);
int count = db.SaveChanges();
//Update Stock Quantity In Database Method
StockQuantityChange();
if (count > 0)
{
MessageBox.Show("Sales Saved Success");
}
else
{
MessageBox.Show("Operation Failed");
}
}
ClearAllBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
