public IHttpActionResult PuttblPurchase(int id, tblPurchase tblPurchase)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblPurchase.purchaseId)
{
return(BadRequest());
}
db.Entry(tblPurchase).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblPurchaseExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void btnAddCart_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["ID"]))
{
string custID = Context.User.Identity.GetUserId();
if (custID != null)
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
int Quantity = Convert.ToInt32(ddlQuantity.SelectedValue);
tblPurchase cart = new tblPurchase
{
LP_price = Quantity,
cust_ID = custID,
LP_date = DateTime.Now,
in_Cart = true,
LP_ID = ID
};
PurchaseModel m = new PurchaseModel();
lblAction.Text = m.InsertPurchase(cart);
}
else
{
lblAction.Text = "Please Signin to order Laptop!";
}
}
}
public PurchaseViewModel GettblPurchases(string ordno)
{
db.Configuration.ProxyCreationEnabled = true;
tblPurchase porder = db.tblPurchases.Where(x => x.purchaseOrderNo == ordno).FirstOrDefault();
PurchaseViewModel pmodel = new PurchaseViewModel();
if (porder == null)
{
}
else
{
pmodel.purchaseId = porder.purchaseId;
pmodel.purchaseOrderNo = porder.purchaseOrderNo;
pmodel.purchaseAssetName = porder.purchaseAssetName;
pmodel.purchaseAssetNamestr = porder.tblAssetDefinition.assetName;
pmodel.purchaseAssetType = porder.purchaseAssetType;
pmodel.purchaseAssetTypestr = porder.tblAssetType.assetTypeName;
pmodel.quantity = Convert.ToDecimal(porder.quantity);
pmodel.purchaseVendorName = porder.purchaseVendorName;
pmodel.purchaseVendorNamestr = porder.tblVendor.vendorName;
pmodel.purchaseDatestr = porder.purchaseDatestr;
pmodel.purchaseDelivDatestr = porder.purchaseDelivDatestr;
pmodel.purchaseStatus = porder.purchaseStatus;
}
return(pmodel);
}
public IHttpActionResult PosttblVendor(tblPurchase tblPurchase)
{
tblPurchase.purchaseDate = DateTime.Now;
db.tblPurchases.Add(tblPurchase);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblPurchase.purchaseId }, tblPurchase));
}
public IHttpActionResult PuttblPurchase(int id, tblPurchase tblPurchase)
{
count = Convert.ToDecimal(tblPurchase.quantity);
db.Entry(tblPurchase).State = EntityState.Modified;
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
public void UpdateQ(int id, int quantity)
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
tblPurchase p = db.tblPurchases.Find(id);
p.LP_price = quantity;
db.SaveChanges();
}
public IHttpActionResult PosttblPurchase(tblPurchase tblPurchase)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblPurchases.Add(tblPurchase);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblPurchase.purchaseId }, tblPurchase));
}
public IHttpActionResult DeletetblPurchase(int id)
{
tblPurchase tblPurchase = db.tblPurchases.Find(id);
if (tblPurchase == null)
{
return(NotFound());
}
db.tblPurchases.Remove(tblPurchase);
db.SaveChanges();
return(Ok(tblPurchase));
}
public string InsertPurchase(tblPurchase product)
{
try
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
db.tblPurchases.Add(product);
db.SaveChanges();
return(product.LP_date + "-Succesfully Add");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public void MOAPaid(List <tblPurchase> carts)
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
if (carts != null)
{
foreach (tblPurchase cart in carts)
{
tblPurchase oldCart = db.tblPurchases.Find(cart.ID);
oldCart.LP_date = DateTime.Now;
oldCart.in_Cart = false;
}
db.SaveChanges();
}
}
public string DeletePurchase(int id)
{
try
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
tblPurchase product = db.tblPurchases.Find(id);
db.tblPurchases.Attach(product);
db.tblPurchases.Remove(product);
db.SaveChanges();
return(product.LP_date + "-Succesfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public PurchaseViewModel GetPurchase(int iid)
{
db.Configuration.ProxyCreationEnabled = true;
tblPurchase porder = db.tblPurchases.Where(x => x.purchaseId == iid).FirstOrDefault();
PurchaseViewModel pomodel = new PurchaseViewModel();
pomodel.purchaseId = porder.purchaseId;
pomodel.purchaseOrderNo = porder.purchaseOrderNo;
pomodel.assetName = porder.tblAssetDefinition.assetName;
pomodel.assetType = porder.tblAssetType.assetTypeName;
pomodel.purchaseAssetName = porder.purchaseAssetName;
pomodel.purchaseAssetType = porder.purchaseAssetType;
pomodel.purchaseVendorName = porder.purchaseVendorName;
pomodel.quantity = Convert.ToDecimal(porder.quantity);
pomodel.vendorName = porder.tblVendor.vendorName;
pomodel.purchaseDateStr = porder.purchaseDateStr;
pomodel.purchaseDelivDateStr = porder.purchaseDelivDateStr;
pomodel.purchaseStatus = porder.purchaseStatus;
return(pomodel);
}
public string UpdatePurchase(int id, tblPurchase product)
{
try
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
//ge the table from db
tblPurchase pro = db.tblPurchases.Find(id);
pro.cust_ID = product.cust_ID;
pro.LP_ID = product.LP_ID;
pro.LP_price = product.LP_price;
pro.LP_date = product.LP_date;
pro.in_Cart = product.in_Cart;
db.SaveChanges();
return(product.LP_date + "-Succesfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
tblPurchaseInvoice tb = new tblPurchaseInvoice();
tb.InvoiceNo = txtInvoiceNo.Text;
tb.InvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
tb.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
tb.VendorId = vendorid;
db.tblPurchaseInvoices.Add(tb);
db.SaveChanges();
var tbv = db.tblVendorPayments.OrderByDescending(a => a.VendorPaymentId).Select(x => new { VendorId = x.VendorId, VendorName = x.tblVendor.Name, PaymentDate = x.PaymentDate, TotalAmount = x.TotalAmount, PaymentAmount = x.PaymentAmount, RemainingAmount = x.RemainingAmount }).Where(b => b.VendorId == vendorid).Take(1).FirstOrDefault();
tblVendorPayment tbvenpay = new tblVendorPayment();
if (tbv != null)
{
tbvenpay.VendorId = vendorid;
tbvenpay.PaymentDate = Convert.ToDateTime(txtInvoiceDate.Text);
tbvenpay.TotalAmount = Convert.ToDecimal(txtGrandTotal.Text) + Convert.ToDecimal(tbv.RemainingAmount);
tbvenpay.PaymentAmount = Convert.ToDecimal(txtPaidAmount.Text);
tbvenpay.RemainingAmount = (Convert.ToDecimal(txtGrandTotal.Text) + Convert.ToDecimal(tbv.RemainingAmount)) - Convert.ToDecimal(txtPaidAmount.Text);
}
else
{
tbvenpay.VendorId = vendorid;
tbvenpay.PaymentDate = Convert.ToDateTime(txtInvoiceDate.Text);
tbvenpay.TotalAmount = Convert.ToDecimal(txtGrandTotal.Text);
tbvenpay.PaymentAmount = Convert.ToDecimal(txtPaidAmount.Text);
tbvenpay.RemainingAmount = Convert.ToDecimal(txtRemainingAmount.Text);
tbvenpay.PaymentMode = rbdCash.Checked ? "Cash" : "Cheque";
}
db.tblVendorPayments.Add(tbvenpay);
if (db.SaveChanges() > 0)
{
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
tblPurchase pur = new tblPurchase();
pur.PurchaseInvoiceId = tb.PurchaseInvoiceId;
pur.ProductId = Convert.ToInt32(dr.Cells["colProductId"].Value);
pur.Quantity = Convert.ToInt32(dr.Cells["colQuantity"].Value);
pur.UnitPrice = Convert.ToDecimal(dr.Cells["colUnitPrice"].Value);
pur.Total = Convert.ToDecimal(dr.Cells["colTotal"].Value);
pur.PurchaseDate = Convert.ToDateTime(txtInvoiceDate.Text);
pur.Tax = Convert.ToDecimal(dr.Cells["colTax"].Value);
db.tblPurchases.Add(pur);
if (db.SaveChanges() > 0)
{
tblStock tbst = db.tblStocks.Where(p => p.ProductId == pur.ProductId).FirstOrDefault();
if (tbst != null)
{
int puranoquantity = Convert.ToInt32(tbst.Quantity);
tbst.Quantity = puranoquantity + Convert.ToInt32(dr.Cells["colQuantity"].Value);
db.SaveChanges();
}
else
{
tblStock tbstock = new tblStock();
tbstock.ProductId = Convert.ToInt32(dr.Cells["colProductId"].Value);
tbstock.Quantity = Convert.ToInt32(dr.Cells["colQuantity"].Value);
db.tblStocks.Add(tbstock);
db.SaveChanges();
}
}
}
}
MessageBox.Show("Purchase Done");
}
