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"; } } }