/// <summary> /// Adds a purchase to the database. /// </summary> /// <param name="purchase">The PurchaseModel entity instance to add.</param> /// <returns>A fully populated PurchaseModel entity instance.</returns> public PurchaseModel Add(PurchaseModel purchase) { try { using (Context context = new Context()) { AbstractBookModel book = context.AbstractBooks.Find(purchase.AbstractBookId); purchase.TotalPrice = (book.DiscountPercentage / 100) * book.Price; context.Purchases.Add(purchase); context.SaveChanges(); return(context.Purchases.Include(p => p.AbstractBook).Include(p => p.Customer).Include(p => p.Employee).FirstOrDefault(p => p.Id == purchase.Id)); } } catch (Exception e) { logsRepository.Add(e.Message); } return(null); }
private void btn_Save_Click(object sender, RoutedEventArgs e) { List <StockModel> newStocks = new List <StockModel>(); List <PurchaseStockModel> Stocks = lstPurchase.Items.Cast <PurchaseStockModel>().Select(x => x).ToList(); if (Stocks.Any(x => x.ProductCode > 0 && x.Quantity > 0)) { decimal? nullval = null; DateTime?nulldate = null; dynamic row = new PurchaseModel(_purchaseData.PurchaseId, _purchaseData.PurchaseDate, string.IsNullOrEmpty(supplier_name.Text) ? null : _supplierCode, string.IsNullOrEmpty(purchase_cashdiscount.Text) ? nullval : Convert.ToDecimal(purchase_cashdiscount.Text), string.IsNullOrEmpty(purchase_cashdiscountDoller.Text) ? nullval : Convert.ToDecimal(purchase_cashdiscountDoller.Text), string.IsNullOrEmpty(purchase_deliveryDate.Text) ? nulldate : CommonFunctions.ParseDateToFinclave(purchase_deliveryDate.Text), string.IsNullOrEmpty(purchase_expiryDate.Text) ? nulldate : CommonFunctions.ParseDateToFinclave(purchase_expiryDate.Text) , string.IsNullOrEmpty(purchase_cashSubChargeAmo.Text) ? nullval : Convert.ToDecimal(purchase_cashSubChargeAmo.Text) , string.IsNullOrEmpty(_taxValue) ? nullval : Convert.ToDecimal(_taxValue), _purchaseData.CreatedBy, _purchaseData.CreatedDate, _purchaseData.CompanyCode, _purchaseData.BranchCode, _purchaseData.SuplierName); var result = purchaseController.SaveUpdateDirectPurchase(row); newStocks.AddRange(Stocks.Where(z => z.ProductCode > 0 && z.Quantity > 0).Select(x => { return(new StockModel(x.StockId == null ? 0 : x.StockId, _purchaseData.PurchaseId.Value, x.Quantity, x.CostPrice, x.SellingPrice, x.MRP, x.Discount, x.BatchNo, x.ProductCode, null)); // newStocks.Add(stock); }).ToList()); purchaseController.UpdateStocks(newStocks, _deletestocks); // ConfirmationPopup form = new ConfirmationPopup((string)myResourceDictionary["purchase_updated"], header, false); // form.ShowDialog(); Common.Notification((string)Application.Current.Resources["purchase_updated"], header, false); ClearData(); DirectPurchase form1 = new DirectPurchase(); NavigationService.Navigate(form1); } else { ConfirmationPopup form = new ConfirmationPopup((string)Application.Current.Resources["purchase_requiredFields"], header, false); form.ShowDialog(); // Common.ErrorNotification((string)myResourceDictionary["purchase_requiredFields"], header, false); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.PreviousPage != null) { try { Label label = new Label { Text = "Your purchase is successful, the total price is" + Request.Form["LiteralTotal"] }; Panel1.Controls.Add(label); var cart = Session[User.Identity.GetUserId()] as List <Purchase>; PurchaseModel model = new PurchaseModel(); model.MarkOrdersAsPaid(cart); Session[User.Identity.GetUserId()] = null; } catch (Exception ex) { Literal1.Text = ex.ToString(); } } }
private async Task <Purchase> ModelToPurchase(PurchaseModel model) { logger.Debug("StorageService: converting purchase storage model to purchase"); if (model == null) { return(null); } return(new Purchase { Id = (int)model.Id, Date = new DateTime(model.Timestamp), Name = model.ProductName, ItemCost = model.ItemCost, TotalCost = model.TotalCost, ItemsNumber = model.ItemsNumber, PurchaseComment = model.Comment, StoreComment = model.StoreComment, PurchaseRate = model.Rate, StoreName = model.StoreName, IsMonthly = model.IsMonthly, Type = await ResolveProductType(model.TypeId), SubType = await ResolveProductSubType(model.SubTypeId) }); }
private void lbAutoInvoice_SelectionChanged(object sender, SelectionChangedEventArgs e) { lbAutoSupplierName.Visibility = Visibility.Collapsed; if (lbAutoInvoiceNo.SelectedIndex != -1) { if (purchaseType == (int)CommonEnum.PurchaseTypes.PO) { PurchaseOrderModel purchaseOrder = new PurchaseOrderModel(); purchaseOrder = _purchaseOrder.FirstOrDefault(x => x.PurchaseId == Convert.ToInt32(lbAutoInvoiceNo.SelectedItem)); GetTotalAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem)); } else { PurchaseModel purchase = new PurchaseModel(); purchase = _directPurchase.FirstOrDefault(x => x.PurchaseId == Convert.ToInt32(lbAutoInvoiceNo.SelectedItem)); GetTotalAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem)); } GetPaidAmount(Convert.ToInt32(lbAutoInvoiceNo.SelectedItem), purchaseType); invoiceNo_.Text = Convert.ToString(lbAutoInvoiceNo.SelectedItem); totalAmount_.Text = Convert.ToString(TotalCostPrice); paidAmount_.Text = Convert.ToString(PaidAmount); pendingAmount_.Text = Convert.ToString(TotalCostPrice - PaidAmount); } }
public ActionResult ProcessDonation(PurchaseModel purchaseModel) { try { var contact = _contactService.Find(purchaseModel.ContactId); _donationService.CreateDonation(new Donation { Currency = purchaseModel.Currency, Customer = purchaseModel.CustomerName, CustomerEmail = purchaseModel.CustomerEmailAddress, DonationDescription = purchaseModel.Description, DonatedOn = DateTime.Now, DonationAmount = purchaseModel.Amount }, contact); return(Json(new { success = true })); } catch (Exception ex) { _logger.Error($"SupportController => ProcessDonation => Error: {ex.GetFullErrorMessage()}"); return(Json(new { success = false, error = ex.Message })); } }
public PurchaseModel GetById(int Id) { PurchaseModel purchaseModel = (from a in _serverContext.Purchases select new { a.Id, a.SubsidiaryLedgerAccountId, a.PurchaseReferenceNo, a.PurchaseDate, a.PurchaseDueDate, a.Description, a.PurchaseModeOfPayment, a.ChartOfAccountId }).ToList() .Where(x => x.Id == Id) .Select(x => new PurchaseModel { Id = x.Id, Vendor = new Vendor { Value = x.SubsidiaryLedgerAccountId }, Date = x.PurchaseDate, DueDate = x.PurchaseDueDate, Description = x.Description, ReferenceNo = x.PurchaseReferenceNo, ModeOfPayment = x.PurchaseModeOfPayment, ChartOfAccounts = new ChartOfAccounts { Value = x.ChartOfAccountId }, Items = (from a in _serverContext.PurchaseDetails join b in _serverContext.TaxRates on a.PurchaseTaxRateId equals b.Id select new { Id = a.Id, PurchaseId = a.PurchaseId, InventoryItem = new InventoryItem { Value = a.PurchaseInventoryId }, ChartOfAccountItem = new ChartOfAccountItem { Value = a.ChartOfAccountId }, Description = a.PurchaseDetailDescription, Quantity = a.PurchaseQuantity, UnitPrice = a.PurchaseUnitPrice, TaxRateItem = new PurchaseTaxRate { Value = a.PurchaseTaxRateId, Rate = b.Rate } }).ToList() .Where(x => x.PurchaseId == Id) .Select(x => new PurchaseItemModel { Id = x.Id, InventoryItem = x.InventoryItem, ChartOfAccountItem = x.ChartOfAccountItem, Description = x.Description, Quantity = x.Quantity, UnitPrice = x.UnitPrice, TaxRateItem = x.TaxRateItem, Amount = Math.Round((x.Quantity * x.UnitPrice), 2).ToString("#,##0.00") }).ToList() }).FirstOrDefault(); return(purchaseModel); }
protected void Page_Load(object sender, EventArgs e) { string Userid = Context.User.Identity.GetUserId(); Session["Userid"] = Userid; PurchaseModel model = new PurchaseModel(); ProductModel productmodel = new ProductModel(); if (Userid != null) { if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) { int id = Convert.ToInt32(Request.QueryString["id"]); int value = 1; int quan = 0; if (!string.IsNullOrWhiteSpace(Request.QueryString["quan"])) { value = Convert.ToInt32(Request.QueryString["quan"]); } if (!string.IsNullOrWhiteSpace(Request.QueryString["quantity"])) { quan = Convert.ToInt32(Request.QueryString["quantity"]); } Purchase cart = new Purchase { Quantity = value, UsersID = Userid, DateTime = Convert.ToString(DateTime.Now), ProductID = id }; int purchaseid = model.check_order_product(Userid, id); int purchasequantity = model.check_order_quantity(Userid, id); int purchaseproductid = model.check_order_productid(Userid, id); available_quantity = productmodel.available_quantity_product(id); //Session["avail_quantity"] = available_quantity; if (value > available_quantity && available_quantity == 0 || quan > available_quantity && available_quantity == 0) { //MessageBox.Show("Sorry Product is Out of Stock"); string script = "alert('Sorry Product is Out of Stock');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); string site = String.Format("product_detail.aspx?id={0}", id); Response.Redirect(site); } else if (purchaseid == 0) { model.insert_purchase(cart); } else if (quan != 0) { if (quan > available_quantity) { string script = "alert('Quantity selected is more than Available Quantity');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } else { update_quantity(purchaseid, quan); } } else if (purchasequantity == available_quantity) { string script = "alert('Product Quantity is already equal to Available Quantity');"; ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); } else { update_quantity(purchaseid, purchasequantity + 1); } } else if (!string.IsNullOrWhiteSpace(Request.QueryString["del"])) { int id = Convert.ToInt32(Request.QueryString["del"]); model.delete_purchase(id); Response.Redirect("cart.aspx"); } //else if (!string.IsNullOrWhiteSpace(Request.QueryString["pur_id"])) //{ // int id = Convert.ToInt32(Request.QueryString["pur_id"]); // int value = Convert.ToInt32(Request.QueryString["quan"]); // string userId = Convert.ToString(HttpContext.Current.Session["Userid"]); // if (value > available_quantity) // { // System.Windows.Forms.MessageBox.Show("Quantity selected is more than Available Quantity"); // } // else // { // } //} } else { Response.Redirect("loginPage.aspx"); } }
public ActionResult PurchaseFoodMenu(PurchaseModel purchaseModel, string Cancel) { purchaseModel.SupplierList = _iDropDownService.GetSupplierList(); purchaseModel.StoreList = _iDropDownService.GetStoreList(); purchaseModel.EmployeeList = _iDropDownService.GetEmployeeList(); string purchaseMessage = string.Empty; if (!ModelState.IsValid) { string errorString = this.ValidationPurchase(purchaseModel); if (!string.IsNullOrEmpty(errorString)) { return(Json(new { error = true, message = errorString, status = 201 })); } } if (purchaseModel.PurchaseDetails != null) { if (purchaseModel.PurchaseDetails.Count > 0) { purchaseModel.InventoryType = 1; if (purchaseModel.Id > 0) { int result = _iPurchaseService.UpdatePurchaseFoodMenu(purchaseModel); if (result > 0) { purchaseMessage = _locService.GetLocalizedHtmlString("EditSuccss"); ClientModel clientModel = new ClientModel(); clientModel = _iPurchaseService.GetClientDetail(); _iEmailService.SendEmailToForFoodMenuPurchase(Convert.ToInt32(purchaseModel.Id), clientModel); // if (purchaseModel.IsSendEmail) // { // if (!string.IsNullOrEmpty(purchaseModel.SupplierEmail)) // { // _iEmailService.SendEmailToForFoodMenuPurchase(purchaseModel, purchaseModel.SupplierEmail); // } // } } } else { //purchaseModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset); purchaseModel.ReferenceNo = _iPurchaseService.ReferenceNumberFoodMenu().ToString(); string result = _iPurchaseService.InsertPurchaseFoodMenu(purchaseModel); if (result != "") { int purchaseId = 0; purchaseMessage = _locService.GetLocalizedHtmlString("SaveSuccess") + " Reference No is: " + result.ToString(); ClientModel clientModel = new ClientModel(); clientModel = _iPurchaseService.GetClientDetail(); purchaseId = _iPurchaseService.GetPurchaseIdByReferenceNo(result); _iEmailService.SendEmailToForFoodMenuPurchase(purchaseId, clientModel); //if (purchaseModel.IsSendEmail) //{ // if (!string.IsNullOrEmpty(purchaseModel.SupplierEmail)) // { // _iEmailService.SendEmailToForFoodMenuPurchase(purchaseModel, clientModel); // } //} } } } else { purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails"); return(Json(new { error = true, message = purchaseMessage, status = 201 })); } } else { purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails"); return(Json(new { error = true, message = purchaseMessage, status = 201 })); } // return View(purchaseModel); return(Json(new { error = false, message = purchaseMessage, status = 200 })); //return View(); }
public DataTable FillShippingAddress(PurchaseModel ObjPurchaseModel) { DataTable dtShippingAddress = objPurchaseDA.FillShippingAddress(ObjPurchaseModel); return(dtShippingAddress); }
public DataSet FillItemPurchaseRate(PurchaseModel ObjPurchaseModel) { DataSet ItemList = objPurchaseDA.FillItemPurchaseRate(ObjPurchaseModel); return(ItemList); }
public DataTable FillGistnNo(PurchaseModel ObjPurchaseModel) { DataTable IncomeHeadList = objPurchaseDA.FillGistnNo(ObjPurchaseModel); return(IncomeHeadList); }
internal DataTable SavePurchase(PurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPurchaseVoucherChange"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjPurchaseModel.EntryType); ClsCon.cmd.Parameters.AddWithValue("@User", ObjPurchaseModel.User); ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPurchaseModel.IP); ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjPurchaseModel.ByCashSale); ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjPurchaseModel.PartyName); ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjPurchaseModel.PartyGSTIN); ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjPurchaseModel.PartyAddress); ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjPurchaseModel.WareHouseID); ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjPurchaseModel.PONo); ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", ObjPurchaseModel.PurchaseBillNo); ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", ObjPurchaseModel.PurchaseBillDate); ClsCon.cmd.Parameters.AddWithValue("@GRNNo", ObjPurchaseModel.GRNNo); ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjPurchaseModel.VoucherDate); ClsCon.cmd.Parameters.AddWithValue("@CCCode", ObjPurchaseModel.CCCode); ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", ObjPurchaseModel.IDARefNo);//ida Ref No. ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", ObjPurchaseModel.BrokerageID); ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", ObjPurchaseModel.BrokerageRate); ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", ObjPurchaseModel.BrokerageGSTIN); ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", ObjPurchaseModel.BrokerageAmount); ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", ObjPurchaseModel.DtPurchase); ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", ObjPurchaseModel.DtItems); ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", ObjPurchaseModel.DtSundries); ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjPurchaseModel.DtAdjAdvance); ClsCon.cmd.Parameters.AddWithValue("@DeptID", ObjPurchaseModel.DeptID); ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", ObjPurchaseModel.SubDeptID); ClsCon.cmd.Parameters.AddWithValue("@IsFinal", ObjPurchaseModel.IsFinal); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPurchase = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPurchase); dtPurchase.TableName = "success"; } catch (Exception) { dtPurchase = new DataTable(); dtPurchase.TableName = "error"; return(dtPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPurchase); }
private void AddPurchaseStock(SqlTransaction trans, PurchaseModel model, string modifyStockAction) { this.UpdatePurchaseplanStockDataSource(); DataTable dataTable = this.ViewState["resource"] as DataTable; if (modifyStockAction == "add") { DataRow[] array = dataTable.Select("pscode=" + model.pcode); for (int i = 0; i < array.Length; i++) { DataRow dataRow = array[i]; ModifyStockModel modifyStockModel = new ModifyStockModel(); modifyStockModel.Id = Guid.NewGuid().ToString(); modifyStockModel.ModifyId = this.hfldModifyId.Value.Trim(); if (!string.IsNullOrEmpty(dataRow["psid"].ToString())) { modifyStockModel.PurchaseId = dataRow["psid"].ToString(); } else { modifyStockModel.PurchaseId = Guid.NewGuid().ToString(); } modifyStockModel.Scode = dataRow["ResourceCode"].ToString(); modifyStockModel.Pscode = dataRow["pscode"].ToString(); modifyStockModel.Quantity = Convert.ToDecimal(dataRow["number"]); modifyStockModel.Sprice = Convert.ToDecimal(dataRow["sprice"]); modifyStockModel.Corp = dataRow["corp"].ToString(); if (dataRow["ArrivalDate"] != DBNull.Value) { modifyStockModel.ArrivalDate = new DateTime?(Convert.ToDateTime(dataRow["ArrivalDate"])); } else { modifyStockModel.ArrivalDate = null; } this.modifyStock.Add(trans, modifyStockModel); } return; } if (modifyStockAction == "edit") { DataRow[] array2 = dataTable.Select("pscode=" + model.pcode + "and ModifyStockId<>''"); for (int j = 0; j < array2.Length; j++) { DataRow dataRow2 = array2[j]; ModifyStockModel modifyStockModel2 = new ModifyStockModel(); modifyStockModel2.Id = dataRow2["ModifyStockId"].ToString(); modifyStockModel2.ModifyId = this.hfldModifyId.Value.Trim(); modifyStockModel2.PurchaseId = dataRow2["psid"].ToString(); modifyStockModel2.Pscode = dataRow2["pscode"].ToString(); modifyStockModel2.Quantity = Convert.ToDecimal(dataRow2["number"]); modifyStockModel2.Sprice = Convert.ToDecimal(dataRow2["sprice"]); modifyStockModel2.Corp = dataRow2["corp"].ToString(); this.modifyStock.Update(trans, modifyStockModel2); } if (this.ViewState["modifyStockIds"] != null) { List <string> ids = (List <string>) this.ViewState["modifyStockIds"]; this.modifyStock.Delete(trans, ids); } DataRow[] array3 = dataTable.Select("pscode=" + model.pcode); for (int k = 0; k < array3.Length; k++) { DataRow dataRow3 = array3[k]; if (string.IsNullOrEmpty(dataRow3["ModifyStockId"].ToString())) { ModifyStockModel modifyStockModel3 = new ModifyStockModel(); modifyStockModel3.Id = Guid.NewGuid().ToString(); modifyStockModel3.ModifyId = this.hfldModifyId.Value.Trim(); modifyStockModel3.PurchaseId = Guid.NewGuid().ToString(); modifyStockModel3.Scode = dataRow3["ResourceCode"].ToString(); modifyStockModel3.Pscode = dataRow3["pscode"].ToString(); modifyStockModel3.Quantity = Convert.ToDecimal(dataRow3["number"]); modifyStockModel3.Sprice = Convert.ToDecimal(dataRow3["sprice"]); modifyStockModel3.Corp = dataRow3["corp"].ToString(); if (dataRow3["ArrivalDate"] != DBNull.Value) { modifyStockModel3.ArrivalDate = new DateTime?(Convert.ToDateTime(dataRow3["ArrivalDate"])); } else { modifyStockModel3.ArrivalDate = null; } this.modifyStock.Add(trans, modifyStockModel3); } } } }
private void btnSubmit_Click(object sender, EventArgs e) { try { Logger.Info("Payment information save start."); Dictionary <string, string> salesInfo = new Dictionary <string, string>(); int purchaseBillingID = 0; if (toggleBilling.Checked) { Logger.Info("Save purchase information start."); PurchaseModel purchaseModel = new PurchaseModel(); purchaseModel.SupplierID = Convert.ToInt32((cmbFirmName.SelectedItem as DropDown).Value); purchaseModel.ExiseDuty = 0; purchaseModel.GrandTotal = !String.IsNullOrEmpty(txtGrandTotal.Text) ? Convert.ToDouble(txtGrandTotal.Text) : 0; purchaseModel.InvoiceNumber = Convert.ToInt32(txtInvoiceNo.Text); purchaseModel.OnCredit = !String.IsNullOrEmpty(txtCreditAmount.Text) ? Convert.ToDouble(txtCreditAmount.Text) : 0; purchaseModel.Paid = String.IsNullOrEmpty(txtPayAmount.Text) ? 0 : Convert.ToDouble(txtPayAmount.Text); purchaseModel.SubTotal = !String.IsNullOrEmpty(txtAmount.Text) ? Convert.ToDouble(txtAmount.Text) : 0; purchaseModel.Tax = !String.IsNullOrEmpty(txtGst.Text) ? Convert.ToDouble(txtGst.Text) : 0; purchaseModel.Trans_Date = dtpBillingDate.Value; purchaseBillingID = purchaseReciever.SavePurchaseInvoice(purchaseModel); Logger.Info("Save purchase information success."); Logger.Info("Save purchase items information start."); foreach (BillingItemModel item in ovlItems.Objects) { PurchaseItemModel purchaseItemModel = new PurchaseItemModel(); purchaseItemModel.InvoiceNumber = Convert.ToInt32(txtInvoiceNo.Text); purchaseItemModel.Price = item.Rate; purchaseItemModel.Quantity = item.Quantity; purchaseItemModel.PurchaseID = purchaseBillingID; purchaseItemModel.SubItemID = Convert.ToInt32(item.ProductValue); purchaseItemModel.Total = item.Total; purchaseReciever.SavePurchaseItemDetails(purchaseItemModel); } Logger.Info("Save purchase items information success."); } else { Logger.Info("Save sales information start."); // Save sales details SalesModel sales = new SalesModel(); sales.CustomerID = Convert.ToInt32((cmbFirmName.SelectedItem as DropDown).Value); sales.TransactionDate = dtpBillingDate.Value; sales.Amount = !String.IsNullOrEmpty(txtAmount.Text) ? Convert.ToDouble(txtAmount.Text) : 0; sales.Carton = 0; sales.Discount = String.IsNullOrEmpty(txtRound.Text) ? 0 : Convert.ToDouble(txtRound.Text); sales.GrandTotal = !String.IsNullOrEmpty(txtGrandTotal.Text) ? Convert.ToDouble(txtGrandTotal.Text) : 0; sales.GST = !String.IsNullOrEmpty(txtGst.Text) ? Convert.ToDouble(txtGst.Text) : 0; sales.OnCredit = !String.IsNullOrEmpty(txtCreditAmount.Text) ? Convert.ToDouble(txtCreditAmount.Text) : 0; sales.Paid = String.IsNullOrEmpty(txtPayAmount.Text) ? 0 : Convert.ToDouble(txtPayAmount.Text); sales.TransportationID = transportationModel != null ? transportationModel.TransportationID : 0; salesInfo = salesReciever.SaveSales(sales); Logger.Info("Save sales information success."); Logger.Info("Save sales items information start."); // Add sales Items details foreach (BillingItemModel item in ovlItems.Objects) { SalesItemDetailsModel salesDetails = new SalesItemDetailsModel(); salesDetails.InvoiceNumber = Convert.ToInt32(salesInfo.ElementAt(1).Value); salesDetails.SalesID = Convert.ToInt32(salesInfo.ElementAt(0).Value); salesDetails.SubItemID = Convert.ToInt32(item.ProductValue); salesDetails.Quantity = item.Quantity; salesDetails.Rate = item.Rate; salesDetails.Total = item.Total; salesReciever.SaveSalesDetails(salesDetails); Logger.Info(string.Format("Sales item {0} added and amount is {1}.", salesDetails.SubItemID, salesDetails.Total)); } Logger.Info("Save sales items information success."); if (transportationModel != null) { if (!String.IsNullOrEmpty(transportationModel.TEmployeeName) && !String.IsNullOrEmpty(transportationModel.TVehicleNumber)) { Logger.Info("Save tranportation information start."); transportationModel.SalesID = Convert.ToInt32(salesInfo.ElementAt(0).Value); salesReciever.SaveTransportDetails(transportationModel); Logger.Info("Save tranportation information success."); } } } if (paymentTransactionModel != null) { var sales = toggleBilling.Checked ? false : true; if (paymentTransactionModel.AccountID > 0 && paymentTransactionModel.PaymentModeID > 0) { Logger.Info("Payment information save start."); SalesPayment salesPayment = new SalesPayment(); salesPayment.PaymentModeID = paymentTransactionModel.PaymentModeID; salesPayment.TransactionDetailNo = paymentTransactionModel.TransactionNumber; salesPayment.BillingID = sales ? Convert.ToInt32(salesInfo.ElementAt(0).Value) : purchaseBillingID; salesPayment.ToAcc = paymentTransactionModel.AccountID.ToString(); salesPayment.TransactionDate = dtpBillingDate.Value; salesPayment.Description = paymentTransactionModel.Description; salesPayment.InvoieType = sales ? "S" : "P"; salesReciever.SavePaymentDetails(salesPayment); Logger.Info("Payment information save success."); } } ResetItem(); ResetBillingInformation(); ResetItemList(); ResetTransportationDetails(); ResetPaymentMode(); MessageBox.Show("Billing invoice saved successfully.", "Success", MessageBoxButtons.OK); } catch (Exception ex) { Logger.Error("Error in billing invoice submit.", ex); } }
public DataTable FillLocation(PurchaseModel ObjPurchaseModel) { DataTable dtFillLocation = objPurchaseDA.Filllocation(ObjPurchaseModel); return(dtFillLocation); }
public DataTable FillHeadName(PurchaseModel ObjPurchaseModel) { DataTable dtFillHeadName = objPurchaseDA.FillHeadName(ObjPurchaseModel); return(dtFillHeadName); }
public DataTable SavePurchase(PurchaseModel ObjPurchaseModel) { DataTable dtShippingAddress = objPurchaseDA.SavePurchase(ObjPurchaseModel); return(dtShippingAddress); }
public DataSet FillGistnNoWithDetail(PurchaseModel ObjPurchaseModel) { DataSet dsFillGistnNoWithDetail = objPurchaseDA.FillGistnNoWithDetail(ObjPurchaseModel); return(dsFillGistnNoWithDetail); }
public DataTable LastVoucherNo(PurchaseModel ObjPurchaseModel) { DataTable AccHeadList = objPurchaseDA.LastVoucherNo(ObjPurchaseModel); return(AccHeadList); }
public DataTable LoadNarration(PurchaseModel ObjPurchaseModel) { DataTable NarrationList = objPurchaseDA.LoadNarration(ObjPurchaseModel); return(NarrationList); }
public DataSet BindAll(PurchaseModel ObjPurchaseModel) { DataSet dsBindAll = objPurchaseDA.BindAll(ObjPurchaseModel); return(dsBindAll); }
public JsonResult CancelBill(PurchaseModel purchasemodel) { var result = purchaseService.cancelbill(purchasemodel); return(Json(result, JsonRequestBehavior.AllowGet)); }
public DataSet CheckGSTIN_Number(PurchaseModel ObjPurchaseModel) { DataSet GSTINList = objPurchaseDA.CheckGSTIN_Number(ObjPurchaseModel); return(GSTINList); }
public void ClearView() { Purchase = new PurchaseModel(); }
public DataTable CheckBudgetHead(PurchaseModel ObjPurchaseModel) { DataTable AccHeadList = objPurchaseDA.CheckBudgetHead(ObjPurchaseModel); return(AccHeadList); }
public void Spawn(PurchaseModel purchaseModel, GameObject sectionGameObject, ProductClickHandlerScript productClickHandlerScript) { WarshipPowerPointsProductModel model = purchaseModel.productModel; int increment = model.Increment; InGameCurrencyCostModel costModel = ZeroFormatterSerializer.Deserialize <InGameCurrencyCostModel>(purchaseModel.productModel.CostModel .SerializedCostModel); //Создать объект на сцене GameObject wppPrefab = Resources.Load <GameObject>("Prefabs/LobbyShop/Image_WarshipPowerPointsItem"); GameObject wppGo = Object.Instantiate(wppPrefab, sectionGameObject.transform, false); //Установить название обьекта wppGo.name += " " + increment; //Заполнить картинку Image itemPreview = wppGo.transform.Find("Image_WarshipPreview") .GetComponentInChildren <Image>(); itemPreview.sprite = Resources.Load <Sprite>("SkinPreview/" + purchaseModel.productModel.PreviewImagePath); //Заполнить текущий показатель силы Text currentPowerValue = wppGo.transform.Find("Empty_PowerValueRoot/Text").GetComponent <Text>(); currentPowerValue.text = $"{model.SupportClientModel.StartValue}/{model.SupportClientModel.MaxValueForLevel}"; //Установить значение слайдера Slider slider = wppGo.transform.Find("Empty_PowerValueRoot/Slider").GetComponent <Slider>(); slider.value = 1f * model.SupportClientModel.StartValue / model.SupportClientModel.MaxValueForLevel; //Заполнить прибавку к очкам силы Text incrementText = wppGo.transform.Find("Text").GetComponent <Text>(); // log.Debug($"increment = "+increment); incrementText.text = $"+{increment}"; //Заполнить цену Text itemCost = wppGo.transform.Find("Image_Cost/Text_Amount").GetComponent <Text>(); itemCost.text = costModel.Cost.ToString(CultureInfo.InvariantCulture); var darkLayer = wppGo.transform.Find("Image_Disabled").gameObject; darkLayer.SetActive(purchaseModel.productModel.IsDisabled); var boughtText = wppGo.transform.Find("Image_Cost/Text_Bought").gameObject; boughtText.SetActive(purchaseModel.productModel.IsDisabled); var costText = wppGo.transform.Find("Image_Cost/Text_Amount").gameObject; costText.SetActive(!purchaseModel.productModel.IsDisabled); if (dictionary.ContainsKey(purchaseModel.productModel.Id)) { dictionary.Remove(purchaseModel.productModel.Id); } dictionary.Add(purchaseModel.productModel.Id, new StubWppUi() { boughtText = boughtText, costText = costText, darkLayer = darkLayer }); //Установить обработчик нажатия Button itemButton = wppGo.GetComponent <Button>(); itemButton.onClick.RemoveAllListeners(); itemButton.onClick.AddListener(() => { productClickHandlerScript.Product_OnClick(purchaseModel); }); }
public DataTable ExpenseHead(PurchaseModel ObjPurchaseModel) { DataTable IncomeHeadList = objPurchaseDA.LoadExpenseHead(ObjPurchaseModel); return(IncomeHeadList); }
int UpdatePurchase(PurchaseModel purchaseModel, bool addMode) { Purchase purchase = null; if (addMode) { purchase = new Purchase { SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value, PurchaseModeOfPayment = purchaseModel.ModeOfPayment, ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null, PurchaseReferenceNo = purchaseModel.ReferenceNo, PurchaseAmount = purchaseModel.Amount, PurchaseDate = purchaseModel.Date, PurchaseDueDate = purchaseModel.DueDate, Description = purchaseModel.Description, PurchaseCreatedDate = DateTime.Now }; _serverContext.Purchases.Add(purchase); _serverContext.SaveChanges(); } else { purchase = _serverContext.Purchases.Find(purchaseModel.Id); purchase.SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value; purchase.PurchaseModeOfPayment = purchaseModel.ModeOfPayment; purchase.ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null; purchase.PurchaseAmount = purchaseModel.Amount; purchase.PurchaseReferenceNo = purchaseModel.ReferenceNo; purchase.Description = purchaseModel.Description; purchase.PurchaseDate = purchaseModel.Date; purchase.PurchaseDueDate = purchaseModel.DueDate; _serverContext.SaveChanges(); } if (!addMode) { foreach (var item in _serverContext.PurchaseDetails.Where(x => x.PurchaseId == purchaseModel.Id).ToList()) { PurchaseDetail purchaseDetail = new PurchaseDetail(); purchaseDetail = _serverContext.PurchaseDetails.Find(item.Id); if (purchaseDetail != null) { _serverContext.PurchaseDetails.Remove(purchaseDetail); _serverContext.SaveChanges(); } } } foreach (PurchaseItemModel item in purchaseModel.Items) { PurchaseDetail purchaseDetail = new PurchaseDetail(); purchaseDetail.PurchaseId = purchase.Id; if (item.InventoryItem != null) { purchaseDetail.PurchaseInventoryId = item.InventoryItem.Value; } purchaseDetail.ChartOfAccountId = item.ChartOfAccountItem.Value; purchaseDetail.PurchaseTaxRateId = item.TaxRateItem.Value; purchaseDetail.PurchaseDetailDescription = item.Description; purchaseDetail.PurchaseQuantity = item.Quantity; purchaseDetail.PurchaseUnitPrice = item.UnitPrice; _serverContext.PurchaseDetails.Add(purchaseDetail); _serverContext.SaveChanges(); } if (!addMode) { var tempGl = _serverContext.GeneralLedgers.Where(x => x.PurchaseId == purchaseModel.Id).SingleOrDefault(); _serverContext.GeneralLedgers.Remove(tempGl); } return(purchase.Id); }
public DataTable PurchaseFrom(PurchaseModel ObjPurchaseModel) { DataTable dtSalesTo = objPurchaseDA.PurchaseFrom(ObjPurchaseModel); return(dtSalesTo); }