private void frmPurchaseNew_Load(object sender, EventArgs e)
{
//loading ComboBox
DAL.Ledger ld = new DAL.Ledger();
DAL.Employee em = new DAL.Employee();
DAL.Product p = new DAL.Product();
DAL.Purchase pr = new DAL.Purchase();
cmbLedger.DataSource = ld.select().Tables[0];
cmbLedger.DisplayMember = "name";
cmbLedger.ValueMember = "id";
cmbLedger.SelectedValue = -1;
cmbEmployee.DataSource = em.select().Tables[0];
cmbEmployee.DisplayMember = "name";
cmbEmployee.ValueMember = "id";
cmbEmployee.SelectedValue = -1;
//product
colProduct.DataSource = p.select().Tables[0];
colProduct.DisplayMember = "name";
colProduct.ValueMember = "id";
this.MaximumSize = this.Size;
this.MinimumSize = this.Size;
}
public static Purchase GetFromEntity(DAL.Purchase data)
{
return(new Purchase()
{
AreaDescription = data.AreaDescription,
Date = data.Date,
EventDate = data.EventDate,
EventDescription = data.EventDescription,
EventName = data.EventName,
Id = data.Id,
SeatNumber = data.SeatNumber,
SeatRow = data.SeatRow,
UserId = data.UserId
});
}
private void btnSearch_Click(object sender, EventArgs e)
{
DAL.Purchase purchase = new DAL.Purchase();
dgvPurchase.DataSource = purchase.Select().Tables[0];
}
private void btnSave_Click(object sender, EventArgs e)
{
int er = 0;
if (txtNumber.Text == "")
{
er++;
ep.SetError(txtNumber, "Required");
}
if (cmbLedger.SelectedValue == null || cmbLedger.SelectedValue.ToString() == "")
{
er++;
ep.SetError(cmbLedger, "Required");
}
if (cmbEmployee.SelectedValue == null || cmbEmployee.SelectedValue.ToString() == "")
{
er++;
ep.SetError(cmbEmployee, "Required");
}
if (dtpDate.Value.ToString() == "")
{
er++;
ep.SetError(dtpDate, "Required");
}
//if(dataGridView1.Rows.Count < 2)
//{
// er++;
// ep.SetError(dataGridView1, "Enter some items");
//}
if (er > 0)
{
return;
}
DAL.Purchase prs = new DAL.Purchase();
prs.Discount = Convert.ToDouble(txtDiscount.Text);
prs.EmployeeId = Convert.ToInt32(cmbEmployee.SelectedValue);
prs.LedgerId = Convert.ToInt32(cmbLedger.SelectedValue);
prs.Number = txtNumber.Text;
prs.Total = Convert.ToDouble(txtTotal.Text);
prs.Vat = Convert.ToDouble(txtVat.Text);
if (prs.insert())
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
DAL.PurchaseDetails pd = new DAL.PurchaseDetails();
pd.PurchaseId = prs.lastId;
pd.ProductId = Convert.ToInt32(dataGridView1.Rows[i].Cells["colProduct"].Value);
pd.Qty = Convert.ToInt32(dataGridView1.Rows[i].Cells["colQty"].Value);
pd.Rate = Convert.ToDouble(dataGridView1.Rows[i].Cells["colRate"].Value);
pd.insert();
}
MessageBox.Show("Purchased Saved");
dataGridView1.Rows.Clear();
}
else
{
MessageBox.Show(prs.Error);
}
}
