public bool BuyProduct(PurchaseDetails purchase) { var products = _productRepo.GetAllProducts().ToList(); var customers = _customerRepo.GetAllCustomers().ToList(); if (!_purchaseservice.IsProductExists(products, purchase)) { return(false); // return "Selected Product not existed"; } else if (!_purchaseservice.IsCustomerExists(customers, purchase)) { return(false); // return "Selected CUstomer not existed"; } else if (!_purchaseservice.IsProductQuantityAvilable(products, purchase)) { return(false); // return "Selected producted already sold out"; } _purchaseservice.CalculatePrice(customers, products, purchase); _purchaseRepo.Addpurchase(purchase); var product = products.Find(p => p.Id == purchase.ProductId); product.Quantity = product.Quantity - purchase.Quantity; _productRepo.Update(product); return(true); }
public ActionResult EditPurchaseDetails(PurchaseDetailsViewModel purchaseDetailsViewModel) { string message = ""; PurchaseDetails purchaseDetails = Mapper.Map <PurchaseDetails>(purchaseDetailsViewModel); purchaseDetailsViewModel.CategorySelectListItems = _categoryManager .GetAll() .Select(c => new SelectListItem() { Value = c.Id.ToString(), Text = c.Name }).ToList(); ViewBag.CategoryId = purchaseDetailsViewModel.CategorySelectListItems; if (_purchaseManager.Update(purchaseDetails)) { message = "Updated Successfully.."; } else { message = "No Change Your Update Information"; } purchaseDetailsViewModel.PurchaseDetails = _purchaseManager.GetAll().Where(c => c.Id == purchaseDetailsViewModel.Id).ToList(); ViewBag.Message = message; return(View(purchaseDetailsViewModel)); }
public List <PurchaseDetails> GetAllPurchaseDetails(string Invoice) { var _PurchaseDetailsList = new List <PurchaseDetails>(); string query = ("Select *from PurchaseDetails where Invoice='" + Invoice + "' "); var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString()); if (reader.HasRows) { while (reader.Read()) { var _PurchaseDetails = new PurchaseDetails(); _PurchaseDetails.Id = Convert.ToInt32(reader["Id"].ToString()); _PurchaseDetails.ProductCode = reader["ProductCode"].ToString(); _PurchaseDetails.ManufacturedDate = (reader["ManufacturedDate"].ToString()); _PurchaseDetails.ExpireDate = (reader["ExpireDate"].ToString()); _PurchaseDetails.Qty = Convert.ToDecimal(reader["Qty"].ToString()); _PurchaseDetails.UnitPrice = Convert.ToDecimal(reader["UnitPrice"].ToString()); _PurchaseDetails.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); _PurchaseDetails.NewMrp = Convert.ToDecimal(reader["NewMrp"].ToString()); _PurchaseDetailsList.Add(_PurchaseDetails); } } reader.Close(); return(_PurchaseDetailsList); }
protected void AddButton_Click(object sender, EventArgs e) { try { PurchaseDetails _PurchaseDetails = new PurchaseDetails(); _PurchaseDetails.ProductCode = txtCode.Text; _PurchaseDetails.ManufacturedDate = Convert.ToDateTime(txtManufacturedDate.Text).ToShortDateString(); _PurchaseDetails.ExpireDate = Convert.ToDateTime(txtExpireDate.Text).ToShortDateString(); _PurchaseDetails.Qty = Convert.ToDecimal(txtQty.Text); _PurchaseDetails.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text); _PurchaseDetails.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text); _PurchaseDetails.NewMrp = Convert.ToDecimal(txtMrp.Text); _PurchaseDetails.Invoice = txtInvoice.Text; int successAdd = _PurchaseRepository.Add(_PurchaseDetails); if (successAdd > 0) { LoadPurchaseDetails(); } else { } } catch { } }
public bool UniquePurchaseCode(PurchaseDetails purchaseDetails) { bool exists = false; //Connection using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { //Command string commandString = @"SELECT InvoiceNo FROM PurchaseDetails WHERE InvoiceNo = '" + purchaseDetails.InvoiceNo + "' "; SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); //showDataGridView.DataSource = dataTable; //Close sqlConnection.Close(); if (dataTable.Rows.Count > 0) { exists = true; } sqlConnection.Close(); } return(exists); }
public List <PurchaseDetails> Read() { var data = new List <Purchase>(); try { data = _context.Purchases.ToList(); } catch (Exception ex) { throw new Exception($"{ex.Message}"); } var rData = new List <PurchaseDetails>(); foreach (var rec in data) { var purchaseDetail = new PurchaseDetails() { ID = rec.ID, Email = _context.Customers.FirstOrDefault(a => rec.UserID == a.ID).Email, ProductName = _context.Products.FirstOrDefault(a => rec.ProductID == a.ID).Name }; rData.Add(purchaseDetail); } return(rData); }
public virtual void AddPurchaseDetails(Item item, long qty, decimal rate, decimal salesRate) { var amount = qty * rate; PurchaseDetails.Add(new PurchaseDetail(this, item, qty, rate, salesRate)); Calculate(amount); }
public IActionResult Add(purchasesummaryviewmodel allpurchase) { PurchaseSummary sum = new PurchaseSummary(); sum.sup_id = allpurchase.sup_id; sum.total = allpurchase.total_amount; sum.discount = allpurchase.discount; sum.vat = allpurchase.vat; sum.net_total = allpurchase.netamount; _context.Add(sum); _context.SaveChanges(); foreach(var purchasedetail in allpurchase.purchase_details) { PurchaseDetails details = new PurchaseDetails(); details.pch_id = sum.pch_id; details.product_id = purchasedetail.product_id; details.qty = purchasedetail.qty; details.price = purchasedetail.price; details.total = purchasedetail.total; _context.Add(details); Product Prdt = _context.products.Find(details.product_id); Prdt.qty = Prdt.qty + details.qty; _context.products.Update(Prdt); _context.SaveChanges(); } return Json(new { id = sum.pch_id }); }
public List <PurchaseDetails> RetrievePurchaseDetailsByUser(int id) { var purchaseList = new List <PurchaseDetails>(); try { var purchases = MarketEntryAccessor.RetrievePurchasesByUser(id); foreach (Purchase e in purchases) { var marketEntry = MarketEntryAccessor.RetrieveMarketEntryById(e.MarketEntryID); var marketEntryDetail = new MarketEntryDetails() { MarketEntry = marketEntry, User = UserAccessor.RetrieveUserByMarketEntryID(marketEntry.MarketEntryID), CollectionEntry = CollectionAccessor.RetrieveCollectionEntryByID(marketEntry.CollectionEntryID) }; var purhcase = new PurchaseDetails() { MarketEntryDetails = marketEntryDetail, User = UserAccessor.RetrieveUserById(e.UserID) }; purchaseList.Add(purhcase); } } catch (Exception) { throw; } return(purchaseList); }
public List <PurchaseDetails> PurchasesDetailsRecord(int purchaseId) { List <PurchaseDetails> purchaseDetails = new List <PurchaseDetails>(); connection = new Connection(); string query = @"Select * From PurchaseDetailsRecord where PurchaseID='" + purchaseId + "'"; sqlCommand = new SqlCommand(query, connection.GetConnection()); reader = sqlCommand.ExecuteReader(); while (reader.Read()) { PurchaseDetails purchaseDetail = new PurchaseDetails(); //purchaseDetail.PurchaseID = Convert.ToInt32(reader["ID"]); purchaseDetail.ProductName = reader["Name"].ToString(); purchaseDetail.ProductCode = reader["Code"].ToString(); purchaseDetail.ManufactureDate = Convert.ToDateTime(reader["ManufactureDate"].ToString()); purchaseDetail.ExpireDate = Convert.ToDateTime(reader["ExpireDate"].ToString()); purchaseDetail.Quantity = Convert.ToDouble(reader["Quantity"]); purchaseDetail.UnitPrice = Convert.ToDouble(reader["UnitPrice"]); purchaseDetail.TotalPrice = Convert.ToDouble(reader["TotalPrice"]); purchaseDetail.MRP = Convert.ToDouble(reader["MRP"]); purchaseDetail.Remark = reader["Remark"].ToString(); purchaseDetails.Add(purchaseDetail); } connection.GetClose(); return(purchaseDetails); }
public bool AddPurchaseDetails(PurchaseDetails purchaseDetails) { bool isAdded = false; using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { //open connection sqlConnection.Open(); //string queryString = @"INSERT INTO Purchases VALUES('" + purchase.Date + "','" + purchase.InvoiceNo + "'," + purchase.SupplierId + "," + purchase.ProductId + ",'" + purchase.Code + "','" + purchase.ManufacturedDate + "','" + purchase.ExpireDate + "'," + purchase.Quantity + "," + purchase.UnitPrice + "," + purchase.TotalPrice + "," + purchase.MRP + ",'" + purchase.Remarks + "');"; string queryString = @"INSERT INTO PurchaseDetails VALUES('" + purchaseDetails.Date + "','" + purchaseDetails.InvoiceNo + "','" + purchaseDetails.Code + "'," + purchaseDetails.SupplierId + ")"; SqlCommand sqlCommand = new SqlCommand(queryString, sqlConnection); int isExecuted = sqlCommand.ExecuteNonQuery(); if (isExecuted > 0) { isAdded = true; } //close connection sqlConnection.Close(); } return(isAdded); }
private void AddButton_Click(object sender, EventArgs e) { int status = 1; var purchaseDetails = new PurchaseDetails(); foreach (var p in _purchasesDetails) { if (p.ProductCode.Contains(codeTextBox.Text)) { MessageBox.Show("Product already in list"); status = 0; } } purchaseDetails.ProductID = Convert.ToInt32(productComboBox.SelectedValue); purchaseDetails.CategoryID = Convert.ToInt32(categoryComboBox.SelectedValue); purchaseDetails.ProductCode = codeTextBox.Text; purchaseDetails.ManufactureDate = Convert.ToDateTime(manufactureDateTimePicker.Text); purchaseDetails.ExpireDate = Convert.ToDateTime(expiredDateTimePicker.Text); purchaseDetails.Quantity = Convert.ToDouble(quantityTextBox.Text); purchaseDetails.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text); purchaseDetails.MRP = Convert.ToDouble(MRPTextBox.Text); purchaseDetails.Remark = remarkTextBox.Text; purchaseDetails.TotalPrice = Convert.ToDouble(totalPriceTextBox.Text); if (status == 1) { _purchasesDetails.Add(purchaseDetails); displayDataGridView.Rows.Clear(); ShowList(_purchasesDetails); } }
public List <PurchaseDetails> GetAllPurchaseDetails(string id) { var _PurchaseDetaillist = new List <PurchaseDetails>(); string query = ("Select *From PurchaseDetails Where PurchaseId='" + id + "'"); var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString()); if (reader.HasRows) { while (reader.Read()) { var _PurchaseDetails = new PurchaseDetails(); _PurchaseDetails.PurchaseId = reader["PurchaseId"].ToString(); _PurchaseDetails.Item = reader["Item"].ToString(); _PurchaseDetails.Batch = Convert.ToInt32(reader["Batch"].ToString()); _PurchaseDetails.Qty = Convert.ToDecimal(reader["Qty"].ToString()); _PurchaseDetails.CostPrice = Convert.ToDecimal(reader["CostPrice"].ToString()); _PurchaseDetails.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); _PurchaseDetails.SellingPrice = Convert.ToDecimal(reader["SellingPrice"].ToString()); _PurchaseDetails.Expire = reader["Expire"].ToString(); _PurchaseDetaillist.Add(_PurchaseDetails); } } reader.Close(); return(_PurchaseDetaillist); }
public ActionResult PurchaseAdd(PurchaseDetails purchaseDetails) { //string message = ""; //message += "Date: " + purchaseDetails.Date; //message += "BillInvoice: " + purchaseDetails.BillInvoice; //message += "SupplierName: " + purchaseDetails.SupplierName; //message += "Category: " + purchaseDetails.Category; //message += "Products: " + purchaseDetails.Products; //message += "Code: " + purchaseDetails.Code; //message += "AvailableQuantity: " + purchaseDetails.AvailableQuantity; //message += "ManufacturedDate: " + purchaseDetails.ManufacturedDate; //message += "ExpireDate: " + purchaseDetails.ExpireDate; //message += "Remarks: " + purchaseDetails.Remarks; //message += "Quantity: " + purchaseDetails.Quantity; //message += "UnitPrice: " + purchaseDetails.UnitPrice; //message += "TotalPrice: " + purchaseDetails.TotalPrice; //message += "PreviousUnitPrice: " + purchaseDetails.PreviousUnitPrice; //message += "PreviousMrp: " + purchaseDetails.PreviousMRP; //message += "MRP: " + purchaseDetails.MRP; //return message; //if (_purchaseManager.SaveInfo(purchaseDetails)) //{ // string message += "Saved!"; //} //else //{ // string message += "Not Saved!"; //} _purchaseManager.SaveInfo(purchaseDetails); return(View()); }
private ReturnMethod validateReturn(PurchaseDetails purchaseDetail) { //Stored Procedure to validate ReturnMethod returnMethod = Repository.Instance.ValidateReturn(purchaseDetail, _context.Database.GetDbConnection().ConnectionString); return(returnMethod); }
public List <PurchaseDetails> GetPdfPurchaseDetails(string id) { var _PurchaseDetaillist = new List <PurchaseDetails>(); string query = ("Select Item,Batch,Qty,CostPrice,TotalPrice,Expire from PurchaseDetails where PurchaseId='" + id + "'"); var reader = _pharmaDb.Reader(query, _pharmaDb.ConnectionStrings()); if (reader.HasRows) { while (reader.Read()) { var _PurchaseDetails = new PurchaseDetails(); _PurchaseDetails.Item = reader["Item"].ToString(); _PurchaseDetails.Batch = Convert.ToInt32(reader["Batch"].ToString()); _PurchaseDetails.Qty = Convert.ToDecimal(reader["Qty"].ToString()); _PurchaseDetails.CostPrice = Convert.ToDecimal(reader["CostPrice"].ToString()); _PurchaseDetails.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); _PurchaseDetails.Expire = reader["Expire"].ToString(); _PurchaseDetaillist.Add(_PurchaseDetails); } } reader.Close(); return(_PurchaseDetaillist); }
private JsonTransactionResponse _GetUrl(PurchaseDetails pd) { // Fill in the JSON parameters (use the corresponding documents to determine the parameters needed for your unique payment page). var jsonTransactionRequest = new JsonTransactionDetails() { terminal = "0962210", user = "******", password = "******", GoodURL = CommonHelper.GetBaseUrl() + Url.Action("ResFromPlecard"), ErrorURL = CommonHelper.GetBaseUrl() + Url.Action("ResFromPlecard"), FeedbackDataTransferMethod = "POST", CssURL = CommonHelper.GetBaseUrl() + "/TemplatesContent/bootstrap/css/customPele.css", UserKey = Guid.NewGuid().ToString(), Total = ((int)(pd.Cost * 100)).ToString(), UserData = new UserData() { UserData1 = string.Format("שם לקוח:{0}", pd.Customer.UserName), UserData2 = string.Format("מזהה לקוח:{0}", pd.Customer.Id), UserData3 = string.Format("שם יצירה:{0}", pd.Music.HebrewName), UserData4 = string.Format("שימוש:{0}", string.Join(",", pd.PermissionValueNames.ToArray())), UserData5 = pd.Music.HebrewName, UserData6 = string.Join(",", pd.PermissionValueNames.ToArray()), UserData7 = pd.Music.ID.ToString(), UserData8 = pd.Permission.ID.ToString() } }; return(PostJson <JsonTransactionDetails, JsonTransactionResponse>(jsonTransactionRequest, "https://gateway20.pelecard.biz/PaymentGW/Init")); }
internal static void RaiseOnSuccess(PurchaseDetails purchaseDetails) { if (OnSuccess != null) { OnSuccess (purchaseDetails); } }
internal static void RaiseOnRestore(PurchaseDetails purchaseDetails) { if (OnRestore != null) { OnRestore (purchaseDetails); } }
protected void gvPurchasing_RowDeleting(object sender, GridViewDeleteEventArgs e) { PurchaseDetails _objdcd = new PurchaseDetails(); purchaseDid = Convert.ToInt32(((Label)gvPurchasing.Rows[e.RowIndex].FindControl("lblpdetailid")).Text); try { if (purchaseDid != 0) { _objdcd.PurchaseDetailId = purchaseDid; _objdcd.IsActive = false; _objdcd.Isdeleted = true; _objdcd.Amount = 0; _objdcd.Rate = 0; _objdcd.Discount = 0; _objdcd.Quantity = Convert.ToInt32(((TextBox)gvPurchasing.Rows[e.RowIndex].FindControl("lblQuantity")).Text); _objdcd.UpdatedBy = Session["UserName"].ToString(); _objdcd.Delete(); } DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["tempdata"]; dt1.Rows[e.RowIndex].Delete(); gvPurchasing.DataSource = dt1; gvPurchasing.DataBind(); Session["tempdata"] = dt1; } catch { } }
public List <PurchaseDetails> GetAllPurchaseDetails() { List <PurchaseDetails> purchaseDetails = new List <PurchaseDetails>(); using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { string queryString = @"SELECT p.Id,p.SupplierId,p.[Date],p.InvoiceNo,p.Code, s.Name As Supplier FROM PurchaseDetails AS p LEFT JOIN Suppliers AS s ON s.Id=p.SupplierId ORDER BY p.Id DESC"; SqlCommand sqlCmd = new SqlCommand(queryString, sqlConnection); //open connection sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCmd.ExecuteReader(); while (sqlDataReader.Read()) { PurchaseDetails purchaseDetail = new PurchaseDetails(); purchaseDetail.Id = Convert.ToInt32(sqlDataReader["Id"]); purchaseDetail.Date = sqlDataReader["Date"].ToString(); purchaseDetail.InvoiceNo = sqlDataReader["InvoiceNo"].ToString(); purchaseDetail.Code = sqlDataReader["Code"].ToString(); purchaseDetail.SupplierId = Convert.ToInt32(sqlDataReader["SupplierId"]); purchaseDetail.Supplier = sqlDataReader["Supplier"].ToString(); purchaseDetails.Add(purchaseDetail); } //close connection sqlConnection.Close(); return(purchaseDetails); } }
public void CanAddPurchase() { var purchase = new PurchaseDetails(); purchase.Name = "Andrew Galvin"; purchase.Email = "*****@*****.**"; purchase.Street1 = "20 Stable Court"; purchase.City = "Wilmington"; purchase.State = "DE"; purchase.ZipCode = "19803"; purchase.PurchasePrice = 17995; purchase.PurchaseType = "Cash"; purchase.UserID = "00000000-0000-0000-0000-000000000000"; var repo = new VehicleRepositoryADO(); int id = 3; repo.Purchase(purchase, id); Assert.AreEqual(2, purchase.PurchaseID); var vehicle = repo.GetDetails(id); Assert.AreEqual(2, vehicle.PurchaseID); }
public void SaveDetails(int DocNo) { try { if (Session["UserName"] != null) { PurchaseDetails pd = new PurchaseDetails(); pd.PurchaseMasterID = DocNo; pd.CreatedBy = Session["UserName"].ToString(); foreach (GridViewRow gv in gvPurchasing.Rows) { pd.IsActive = Convert.ToBoolean(true); pd.PurchaseDetailId = Convert.ToInt32(((Label)gv.FindControl("lblpdetailid")).Text); pd.Code = ((Label)gv.FindControl("lblCode")).Text; pd.Description = ((Label)gv.FindControl("lblName")).Text; pd.Quantity = Convert.ToInt32(((TextBox)gv.FindControl("lblQuantity")).Text); pd.Rate = Convert.ToDecimal(((TextBox)gv.FindControl("lblRate")).Text); pd.Per = ((Label)gv.FindControl("lblRemarksave")).Text; pd.Standard = ((Label)gv.FindControl("lblstandard")).Text; pd.Discount = Convert.ToDecimal(((TextBox)gv.FindControl("lblDisc")).Text); pd.Amount = Convert.ToDecimal(((Label)gv.FindControl("lblAmount")).Text); pd.OriQuantity = Convert.ToInt32(((Label)gv.FindControl("lblqtyactual")).Text); pd.UpdatedBy = strFY.ToString(); pd.Save(1); } } } catch { } }
private void BtnInsertUpdatePurchase_Click(object sender, EventArgs e) { try { string ResultMessage = ValidateHeaderControlles(); if (!string.IsNullOrEmpty(ResultMessage)) { messageShow.singlemsgtext(ResultMessage); return; } var purchase_details = new PurchaseDetails { PurchaseId = 0, PurchaseInvoiceNo = TxtInvoiceNo.Text.ToString(), SupplierCode = Convert.ToInt32(((KeyValuePair <string, string>)DropDownSupplierMobNo.SelectedItem).Key.ToString()), NetAmount = Convert.ToDouble(TxtNetAmountPurchase.Text.ToString()), PaymentType = Convert.ToInt32(((KeyValuePair <string, string>)DropDownPaymentType.SelectedItem).Key.ToString()), PaidAmount = Convert.ToDouble(TxtPaidAmount.Text.ToString()), DuesAmount = Convert.ToDouble(TxtDuesAmount.Text.ToString()), DtPurchaseDetails = DataGridViewToDataTable(), OperationType = 1 }; int id = _PurchaseRepository.InsertUpdatePurchaseDetails(purchase_details); if (id > 0) { messageShow.singlemsgtext("Sccessfully purchased the product."); EmptyDataGridAndHeader(); } } catch (Exception _exception) { CmC.InsertException(_exception); messageShow.singlemsgtext(CmC.ExceptionErrorMessage); } }
public async Task <ActionResult <PurchaseDetails> > PostPurchaseDetails(PurchaseDetails purchaseDetails) { _context.Purchase_Details.Add(purchaseDetails); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPurchaseDetails", new { id = purchaseDetails.ID }, purchaseDetails)); }
public async Task <IActionResult> PutPurchaseDetails(int id, PurchaseDetails purchaseDetails) { if (id != purchaseDetails.ID) { return(BadRequest()); } _context.Entry(purchaseDetails).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PurchaseDetailsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public frmCompletePurchase(CollectionManager colMgr, MarketEntryManager marketEMgr, User user, PurchaseDetails purchaseDetails) { this._collectionManager = colMgr; this._marketEntryManager = marketEMgr; this._user = user; this._purchaseDetails = purchaseDetails; InitializeComponent(); }
public ActionResult DeleteConfirmed(int id) { PurchaseDetails purchaseDetails = db.PurchaseDetail.Find(id); db.PurchaseDetail.Remove(purchaseDetails); db.SaveChanges(); return(RedirectToAction("Index")); }
// retrieve values from database private void LoadFromID() { PurchaseData dao = new PurchaseData(ConnStr); PurchaseDetails details = dao.RetrieveDetails(Id); UserId = details.UserId; ProductId = details.ProductId; }
public static void UpdatePurchase(PurchaseDetails purchaseDetail) { if (PurchaseDetails.Exists(pd => pd.Id == purchaseDetail.Id)) { var indix = PurchaseDetails.FindIndex(pd => pd.Id == purchaseDetail.Id); PurchaseDetails[indix] = purchaseDetail; } }
/// <summary> /// Insert and update the purchase details.. /// </summary> /// <param name="users"></param> /// <returns></returns> public int InsertUpdatePurchaseDetails(PurchaseDetails purchase_details) { int LastId = 0; var DbManager = new DBManager("DBConnection"); DbManager.Insert(_StoredProcedures.InsertUpdatePurchaseDetails_SP, CommandType.StoredProcedure, _PurchaseIRepository.AddParmsPurchaseDetails(purchase_details), out LastId); return(LastId); }
public static Response NewPurchase(NewPurchaseView view, string userName) { using (var transaction = db.Database.BeginTransaction()) { try { var user = db.Users.Where(u => u.UserName == userName).FirstOrDefault(); var purchase = new Purchase { CompanyId = user.CompanyId, ProviderId = view.ProviderId, Date = view.Date, Remarks = view.Remarks, StateId = DBHelper.GetState("Criado", db), WareHouseId = view.ProviderId }; db.Purchase.Add(purchase); db.SaveChanges(); var details = db.PurchaseDetailTmps.Where(odt => odt.UserName == userName).ToList(); foreach (var detail in details) { var purchaseDetail = new PurchaseDetails { Description = detail.Description, PurchaseId = purchase.PurchaseId, Price = detail.Price, ProductId = detail.ProductId, Quantity = detail.Quantity, TaxRate = detail.TaxRate }; db.PurchaseDetails.Add(purchaseDetail); db.PurchaseDetailTmps.Remove(detail); } db.SaveChanges(); transaction.Commit(); return(new Response { Succeeded = true }); } catch (Exception ex) { transaction.Rollback(); return(new Response { Message = ex.Message, Succeeded = false }); throw; } } }