private void btnSave_Click(object sender, EventArgs e)
{
try
{
var cart = _context.Anu_Purchase_Cart.Include(bb => bb.prdouct).ToList();
int id = 0;
foreach (var item in cart)
{
var IsHave = _context.Anu_Stocks.Where(a => a.Anu_Product_Id.Contains(item.Anu_Product_Id)).SingleOrDefault();
if (IsHave != null)
{
if (InvoiceNo != null)
{
IsHave.Anu_Stock_Qty = IsHave.Anu_Stock_Qty + item.Qty;
_context.SaveChanges();
}
else
{
IsHave.Anu_Stock_Qty = IsHave.Anu_Stock_Qty + Convert.ToInt32(txtQty.Text.Trim());
_context.SaveChanges();
}
var st = _context.Anu_Stock_Detail.Where(a => a.Anu_Stock_Detail_Id == IsHave.Anu_StockId).SingleOrDefault();
st.ModifiedBy = SessionMgr.UserId;
st.ModifiedDate = DateTime.Now;
}
else
{
Anu_Stock stock = new Anu_Stock();
stock.Anu_Product_Id = item.Anu_Product_Id;
stock.Anu_Stock_Product_Code = item.prdouct.Anu_Product_Code;
stock.Anu_Stock_Qty = item.Qty;
stock.Anu_Stock_Type = item.Anu_Cart_type;
_context.Anu_Stocks.Add(stock);
_context.SaveChanges();
id = stock.Anu_StockId;
Anu_Stock_Detail details = new Anu_Stock_Detail();
details.Anu_StockId = id;
details.CreatedBy = SessionMgr.UserId;
details.CreatedDate = DateTime.Now;
_context.Anu_Stock_Detail.Add(details);
_context.SaveChanges();
Anu_Purchase_Cart crt = _context.Anu_Purchase_Cart.Find(item.Anu_CartId);
_context.Anu_Purchase_Cart.Remove(crt);
_context.SaveChanges();
}
}
Init();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblvenId.Text) && string.IsNullOrEmpty(lblvenMob.Text))
{
errorProvider1.SetError(vendCombo, "Please Select Vedor Name");
}
else
{
try
{
Anu_Purchase pur = new Anu_Purchase();
pur.Anu_Purchase_Id = PurchseNo;
pur.Anu_Purchase_InvoiceNo = lblInvoice.Text.Trim();
pur.Anu_Purchase_Invoice_Date = dateTimePicker1.Value.Date;
pur.Anu_Vendor_Id = vendCombo.SelectedValue.ToString();
pur.Anu_Purchase_Amount = TotalAmount;
pur.Status = Status.UnPaid;
pur.Anu_Purchase_IsActive = true;
pur.Anu_Purchase_CreatedBy = SessionMgr.UserId;
pur.Anu_Purchase_CreatedDate = DateTime.Now;
_context.Anu_Purchases.Add(pur);
_context.SaveChanges();
var crt = _context.Anu_Purchase_Cart.ToList();
foreach (var item in crt)
{
var detid = "";
long urn = 1;
var MaxURN = (from a in _context.Anu_Purchase_Details select a).AsEnumerable().Max(p => p.Anu_Purchase_Detail_Id.Split('-')[1]);
if (MaxURN != null)
{
urn = Convert.ToInt64(MaxURN) + 1;
}
detid = "AGPPURDET" + "-" + urn.ToString("0000");
Anu_Purchase_Detail pd = new Anu_Purchase_Detail();
pd.Anu_Purchase_Detail_Id = detid;
pd.Anu_Purchase_Id = pur.Anu_Purchase_Id;
pd.Anu_Product_Id = item.Anu_Product_Id;
pd.Anu_Purchase_Detail_Qty = item.Qty.ToString();
pd.Anu_Purchase_Detail_Rate = item.Rate;
pd.Anu_Purchase_Detail_type = item.Anu_Cart_type;
_context.Anu_Purchase_Details.Add(pd);
_context.SaveChanges();
}
foreach (var items in crt)
{
if (items != null)
{
Anu_Purchase_Cart ct = _context.Anu_Purchase_Cart.Find(items.Anu_CartId);
_context.Anu_Purchase_Cart.Remove(ct);
_context.SaveChanges();
}
}
var grd = from a in _context.Anu_Purchase_Cart.Include(b => b.prdouct)
select new
{
Product_Name = a.prdouct.Anu_Product_Name,
Quantity = a.Qty + " " + a.Anu_Cart_type.ToString(),
Amount = a.Rate
};
cartGrd.DataSource = grd.ToList();
lblitem.Text = "0";
lblamount.Text = "0.00";
lblQty.Text = "0";
lblvenGst.Text = "";
lblvenId.Text = "";
lblvenMob.Text = "";
vendCombo.SelectedIndex = 0;
txtsrc.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtQty.Text.Trim()) && string.IsNullOrEmpty(txtAmt.Text.Trim()))
{
if (string.IsNullOrEmpty(txtQty.Text.Trim()))
{
errorProvider1.SetError(txtQty, "Quantity is Empty");
txtQty.Focus();
}
if (string.IsNullOrEmpty(txtAmt.Text.Trim()))
{
errorProvider1.SetError(txtAmt, "Quantity is Empty");
txtAmt.Focus();
}
}
else
{
var IsHave = _context.Anu_Purchase_Cart.Where(a => a.Anu_Product_Id.Contains(ProductId)).SingleOrDefault();
if (IsHave != null)
{
IsHave.Qty = IsHave.Qty + Convert.ToInt32(txtQty.Text.Trim());
IsHave.Rate = IsHave.Rate + Convert.ToInt32(txtAmt.Text.Trim());
_context.SaveChanges();
}
else
{
Anu_Purchase_Cart cart = new Anu_Purchase_Cart();
cart.Anu_Product_Id = ProductId;
cart.Qty = Convert.ToInt32(txtQty.Text.Trim());
cart.Rate = Convert.ToInt32(txtAmt.Text.Trim());
if (TypeCombo.SelectedValue.ToString() == "0")
{
cart.Anu_Cart_type = Model.Type.SP;
}
else if (TypeCombo.SelectedValue.ToString() == "1")
{
cart.Anu_Cart_type = Model.Type.GM;
}
else if (TypeCombo.SelectedValue.ToString() == "2")
{
cart.Anu_Cart_type = Model.Type.KG;
}
else
{
cart.Anu_Cart_type = Model.Type.LR;
}
_context.Anu_Purchase_Cart.Add(cart);
_context.SaveChanges();
}
var grd = from a in _context.Anu_Purchase_Cart.Include(b => b.prdouct)
select new
{
Product_Name = a.prdouct.Anu_Product_Name,
Quantity = a.Qty + " " + a.Anu_Cart_type.ToString(),
Amount = a.Rate
};
cartGrd.DataSource = grd.ToList();
txtQty.Text = "";
txtAmt.Text = "";
lblPrdName.Text = "";
lblcat.Text = "";
TypeCombo.SelectedIndex = 0;
txtsrc.Focus();
int itemCount = _context.Anu_Purchase_Cart.Count();
decimal total = _context.Anu_Purchase_Cart.Sum(a => a.Rate);
TotalAmount = total;
lblitem.Text = itemCount.ToString();
lblamount.Text = total.ToString();
lblQty.Text = _context.Anu_Purchase_Cart.Sum(a => a.Qty).ToString() + " " + Model.Type.KG.ToString();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
prdgrid.Visible = true;
if (InvoiceNo != "")
{
var grd = from a in _context.Anu_Purchase_Details.Include(ab => ab.anuPurchase).Include(dd => dd.product)
where (a.Anu_Purchase_Id.Contains(InvoiceNo))
select new
{
Id = a.Anu_Purchase_Detail_Id,
ProductId = a.Anu_Product_Id,
Product = a.product.Anu_Product_Name,
Quantity = a.Anu_Purchase_Detail_Qty,
Type = a.Anu_Purchase_Detail_type.ToString(),
Rate = a.Anu_Purchase_Detail_Rate
};
prdgrid.DataSource = grd.OrderBy(a => a.Product).ToList();
var lstitem = grd.ToList();
prdgrid.Columns[0].Visible = false;
prdgrid.Columns[1].Visible = false;
foreach (var item in lstitem)
{
var IsHave = _context.Anu_Purchase_Cart.Where(a => a.Anu_Product_Id.Contains(item.ProductId)).SingleOrDefault();
if (IsHave != null)
{
IsHave.Qty = IsHave.Qty + Convert.ToInt32(item.Quantity);
_context.SaveChanges();
}
else
{
Anu_Purchase_Cart crt = new Anu_Purchase_Cart();
crt.Anu_Product_Id = item.ProductId;
crt.Qty = Convert.ToInt32(item.Quantity);
if (TypeCombo.SelectedValue.ToString() == "0")
{
crt.Anu_Cart_type = Model.Type.SP;
}
else if (TypeCombo.SelectedValue.ToString() == "1")
{
crt.Anu_Cart_type = Model.Type.GM;
}
else if (TypeCombo.SelectedValue.ToString() == "2")
{
crt.Anu_Cart_type = Model.Type.KG;
}
else
{
crt.Anu_Cart_type = Model.Type.LR;
}
crt.Rate = Convert.ToDecimal("0.00");
_context.Anu_Purchase_Cart.Add(crt);
_context.SaveChanges();
}
}
}
else
{
var IsHave = _context.Anu_Purchase_Cart.Where(a => a.Anu_Product_Id.Contains(ProductId)).SingleOrDefault();
if (IsHave != null)
{
IsHave.Qty = IsHave.Qty + Convert.ToInt32(txtQty.Text.Trim());
_context.SaveChanges();
}
else
{
Anu_Purchase_Cart crt = new Anu_Purchase_Cart();
crt.Anu_Product_Id = ProductId;
crt.Qty = Convert.ToInt32(txtQty.Text.Trim());
crt.Anu_Cart_type = Model.Type.KG;
crt.Rate = Convert.ToDecimal("0.00");
_context.Anu_Purchase_Cart.Add(crt);
_context.SaveChanges();
}
var grd = from a in _context.Anu_Purchase_Cart.Include(b => b.prdouct)
select new
{
Id = a.Anu_CartId,
Product = a.prdouct.Anu_Product_Name,
Quantity = a.Qty + " " + a.Anu_Cart_type.ToString(),
Rate = a.Rate
};
prdgrid.DataSource = grd.OrderBy(a => a.Product).ToList();
prdgrid.Columns[0].Visible = false;
txtQty.Text = "";
listCombo.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
