public IHttpActionResult PostBillDetail(BillDetailTable billdetailmodel) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BillDetailTables.Add(billdetailmodel); db.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest()); } }
public IHttpActionResult DeleteBillDtailsTable(int id) { BillDetailTable billdetailtable = db.BillDetailTables.Find(id); try { if (billdetailtable == null) { return(NotFound()); } db.BillDetailTables.Remove(billdetailtable); db.SaveChanges(); return(Ok(billdetailtable)); } catch (Exception) { throw; } }
public IHttpActionResult PutQutationDetailsTable(int id, BillDetailTable billDetailTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != billDetailTable.BillDetailId) { return(BadRequest()); } db.Entry(billDetailTable).State = EntityState.Modified; try { db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); } catch (Exception ex) { throw ex; } }
public JsonResult Proceeds(int Id, string Status) { MvcPurchaseModel PurchaseModel = new MvcPurchaseModel(); List <MvcPurchaseViewModel> _PurcchaseDetailList = new List <MvcPurchaseViewModel>(); InvoiceTable InvoiceTable = new InvoiceTable(); MVCInvoiceModel mvcInvoiceModel = new MVCInvoiceModel(); PurchaseOrderTable purchasemodel = new PurchaseOrderTable(); try { PurchaseModel = GetPurchasae(Id); _PurcchaseDetailList = GetPurchaseDetail(Id); if (PurchaseModel != null) { BillTable billtable = new BillTable(); billtable.CompanyId = PurchaseModel.CompanyId; billtable.UserId = Convert.ToInt32(Session["LoginUserID"]); billtable.Bill_ID = PurchaseModel.PurchaseID.ToString(); billtable.PurchaseId = PurchaseModel.PurchaseOrderID; billtable.VenderId = PurchaseModel.VenderId; billtable.RefNumber = PurchaseModel.PurchaseRefNumber; billtable.BillDate = Convert.ToDateTime(PurchaseModel.PurchaseDate); billtable.BillDueDate = Convert.ToDateTime(PurchaseModel.PurchaseDueDate); billtable.SubTotal = PurchaseModel.PurchaseSubTotal; billtable.DiscountAmount = PurchaseModel.PurchaseTotoalAmount; billtable.TotalAmount = PurchaseModel.PurchaseTotoalAmount; billtable.CustomerNote = PurchaseModel.PurchaseVenderNote; billtable.TotalVat6 = PurchaseModel.Vat6; billtable.TotalVat21 = PurchaseModel.Vat21; billtable.Status = "accepted"; billtable.Type = StatusEnum.Goods.ToString(); // bill Api HttpResponseMessage response = GlobalVeriables.WebApiClient.PostAsJsonAsync("AddBill", billtable).Result; BillTable billviewmodel = response.Content.ReadAsAsync <BillTable>().Result; if (response.StatusCode == System.Net.HttpStatusCode.OK) { if (_PurcchaseDetailList != null) { foreach (var item in _PurcchaseDetailList) { BillDetailTable billdetailtable = new BillDetailTable(); billdetailtable.BillID = billviewmodel.BilID; billdetailtable.ItemId = item.PurchaseItemId; billdetailtable.Description = item.PurchaseDescription; billdetailtable.Quantity = item.PurchaseQuantity; billdetailtable.Rate = item.PurchaseItemRate; billdetailtable.Total = item.PurchaseTotal; billdetailtable.Type = item.Type; billdetailtable.RowSubTotal = Convert.ToDouble(item.RowSubTotal); billdetailtable.Vat = item.PurchaseVatPercentage; billdetailtable.ServiceDate = item.ServiceDate; // APIBill HttpResponseMessage responsses = GlobalVeriables.WebApiClient.PostAsJsonAsync("AddBillDetail", billdetailtable).Result; if (responsses.StatusCode != System.Net.HttpStatusCode.OK) { return(new JsonResult { Data = new { Status = "Fail", Message = "Fail to Proceed" } }); } } if (UpdateQuatationStation(Id)) { return(new JsonResult { Data = new { Status = "Success", Message = "Proceed successfullly" } }); } } } } } catch (Exception) { throw; } return(new JsonResult { Data = new { Status = "Success", Message = "Proceed successfullly" } }); }