private void btnAdd_Click(object sender, EventArgs e)
{
model.ItemName = txtName.Text.Trim();
model.ItemDescription = txtDescription.Text.Trim();
decimal value;
if (decimal.TryParse(txtStockPrice.Text, NumberStyles.Currency, new CultureInfo("si-LK").NumberFormat, out value))
{
model.ItemStockPrice = value;
}
if (decimal.TryParse(txtSellingPrice.Text, NumberStyles.Currency, new CultureInfo("si-LK").NumberFormat, out value))
{
model.ItemSellingPrice = value;
}
model.ItemAvailableQuantity = Convert.ToInt32(txtQuantity.Value);
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
if (model.ItemID == 0)
{
db.Items.Add(model);
}
else
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
Clear();
Populate();
lblStatus.Text = "Item Added";
}
private void btnAdd_Click(object sender, EventArgs e)
{
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
if (lblItemID.Text != "")
{
discountModel.ItemID = itemModel.ItemID;
discountModel.DiscountValue = nudDiscount.Value;
discountModel.DiscountStartDate = dtpStartDate.Value;
discountModel.DiscountEndDate = dtpEndDate.Value;
MessageBox.Show(dtpStartDate.Value.ToString());
db.Discounts.Add(discountModel);
db.SaveChanges();
itemModel.ItemDiscount = nudDiscount.Value;
db.Entry(itemModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
lblStatus.Text = "Discount added.";
Reset();
Populate(itemModel.ItemID);
}
else
{
lblStatus.BackColor.Equals(Color.Red);
lblStatus.Text = "Item not selected";
}
Reset();
Populate(0);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
if (lblItemID.Text != "")
{
inventoryModel.ItemID = itemModel.ItemID;
inventoryModel.StockPrice = Decimal.Parse(txtStockPrice.Text);
inventoryModel.SellingPrice = Decimal.Parse(txtSellingPrice.Text);
inventoryModel.Quantity = Convert.ToInt32(txtQuantity.Value);
inventoryModel.Remarks = txtRemarks.Text.Trim();
db.Inventories.Add(inventoryModel);
db.SaveChanges();
itemModel.ItemAvailableQuantity = itemModel.ItemAvailableQuantity + inventoryModel.Quantity;
itemModel.ItemStockPrice = inventoryModel.StockPrice;
itemModel.ItemSellingPrice = inventoryModel.SellingPrice;
db.Entry(itemModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
lblStatus.Text = "Stock added.";
Reset();
Populate(itemModel.ItemID);
}
else
{
lblStatus.BackColor.Equals(Color.Red);
lblStatus.Text = "Item not selected";
}
Reset();
Populate(0);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Delete " + model.ItemName + "?", "Delete Item", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
var entry = db.Entry(model);
if (entry.State == EntityState.Detached)
{
db.Items.Attach(model);
}
db.Items.Remove(model);
db.SaveChanges();
Clear();
Populate();
lblStatus.Text = "Item Deleted";
}
}
}