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);
}
}
void Populate()
{
dgvItem.AutoGenerateColumns = false;
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
dgvItem.DataSource = db.Items.ToList();
}
}
private void txtSearchName_TextChanged(object sender, EventArgs e)
{
dgvItem.AutoGenerateColumns = false;
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
dgvItem.DataSource = db.Items.Where(i => i.ItemName.Contains(txtSearchName.Text)).ToList();
}
}
void Search()
{
Clear();
dgvItem.AutoGenerateColumns = false;
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
dgvItem.DataSource = db.Items.Where(i => i.ItemName.Contains(txtSearch.Text)).ToList();
}
}
private void dgvItem_DoubleClick(object sender, EventArgs e)
{
if (dgvItem.CurrentRow.Index != -1)
{
itemModel.ItemID = Convert.ToInt32(dgvItem.CurrentRow.Cells[0].Value);
lblStatus.Text = itemModel.ItemID.ToString();
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
itemModel = db.Items.Where(x => x.ItemID == itemModel.ItemID).FirstOrDefault();
lblItemID.Text = itemModel.ItemName;
}
}
}
void Populate(int ItemID)
{
dgvItem.AutoGenerateColumns = false;
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
if (ItemID > 0)
{
dgvItem.DataSource = db.Items.Where(i => i.ItemID.Equals(ItemID)).ToList();
}
else
{
dgvItem.DataSource = db.Items.ToList();
}
}
}
private void dgvItem_DoubleClick(object sender, EventArgs e)
{
if (dgvItem.CurrentRow.Index != -1)
{
model.ItemID = Convert.ToInt32(dgvItem.CurrentRow.Cells[0].Value);
using (HarithmaSalesEntities db = new HarithmaSalesEntities())
{
model = db.Items.Where(x => x.ItemID == model.ItemID).FirstOrDefault();
txtName.Text = model.ItemName;
txtDescription.Text = model.ItemDescription;
txtStockPrice.Text = model.ItemStockPrice.ToString();
txtSellingPrice.Text = model.ItemSellingPrice.ToString();
txtQuantity.Value = model.ItemAvailableQuantity;
btnAdd.Text = "Edit";
btnDelete.Enabled = true;
}
}
}
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";
}
}
}