public Message AddOrEdit(PricingDetail pricingDetail) { var message = new Message(); var ID = pricingDetail.PricingDetailID; int result = _iPricingDetailRepository.AddOrEdit(pricingDetail); try { if (result > 0) { if (Convert.ToInt32(ID) > 0) { message = Message.SetMessages.SetSuccessMessage("Submission Updated Successfully!"); } else { message = Message.SetMessages.SetSuccessMessage("Submission Successful!"); } } else { message = Message.SetMessages.SetErrorMessage("Could not be submitted!"); } } catch (Exception e) { message = Message.SetMessages.SetWarningMessage(e.Message.ToString()); } return(message); }
public ActionResult AddOrEdit(int id = 0) { PricingDetail pricingDetail = new PricingDetail(); if (id != 0) { pricingDetail = _iPricingDetailManager.GetAPricingDetail(id); } return(View(pricingDetail)); }
public async static Task <IDTO> AddUpdate(PricingDetail pricingDetail) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (pricingDetail.ID.HasValue) { oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ID ?? DBNull.Value); SPName = PricingDetailsSpName.SP_UPADTE_PRICING_DETAIL; message = "Updated Successfully"; } else { oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = PricingDetailsSpName.SP_INSERT_PRICING_DETAIL; message = "Inserted Successfully"; } oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.CreatedBy ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.CreationDate ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.ModifiedBy ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ModificationDate ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.Status ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.StatusDate ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.EffectiveDate ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ExpiryDate ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductID ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductDetailID ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.LineOfBusiness ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.SubLineOfBusiness ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_IS_FACTOR, OracleDbType.Int16, ParameterDirection.Input, (object)pricingDetail.IsFactor ?? DBNull.Value); oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_PRIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.PricingID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.message = "Operation Success"; } else { complate.message = "Operation Failed"; } return(complate); }
public async static Task <IDTO> DeletePricingDetail(PricingDetail pricingDetail) { OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); var dyParam = new OracleDynamicParameters(); dyParam.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(PricingDetailsSpName.SP_DELETE_PRICING_DETAIL, dyParam) == -1) { complate.message = "Operation Successed"; } else { complate.message = "Operation Failed"; } return(complate); }
public int AddOrEdit(PricingDetail pricingDetail) { if (pricingDetail.PricingDetailID == 0) { pricingDetail.CreatedDate = DateTime.Now; pricingDetail.UpdatedDate = DateTime.Now; pricingDetail.CreatedBy = 1; pricingDetail.UpdatedBy = 1; _dbContext.PricingDetails.Add(pricingDetail); } else { pricingDetail.UpdatedBy = 1; pricingDetail.UpdatedDate = DateTime.Now; _dbContext.Entry(pricingDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public ActionResult AddOrEdit(PricingDetail pricingDetail) { var data = _iPricingDetailManager.AddOrEdit(pricingDetail); return(Json(new { messageType = data.MessageType, message = data.ReturnMessage, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", _iPricingDetailManager.GetAllPricingDetail()) }, JsonRequestBehavior.AllowGet)); }
public PricingDetail GetPricingDetails(OrderDetailInformation OrderDetails, NorthwindConfig config) { PricingDetail result = new PricingDetail(); string customerID; int productId; List <int> productIds = new List <int>(); int recordCount; if (!OrderDetails.Currency.Equals(config.CurrencyCode, StringComparison.InvariantCultureIgnoreCase)) { result.Result = false; result.ErrorMessage = Resources.ErrorMessages_CurrencyNotSupported; return(result); } if (!OrderDetails.PricingListId.Equals(Constants.DefaultValues.PriceList.ID, StringComparison.InvariantCultureIgnoreCase)) { result.Result = false; result.ErrorMessage = Resources.ErrorMessages_PriceListNotSupported; return(result); } if (OrderDetails.AccountId == null) { result.Result = false; result.ErrorMessage = Resources.ErrorMessages_AccountNotFound; return(result); } customerID = OrderDetails.AccountId; if (!(customerID.StartsWith(Constants.CustomerIdPrefix, StringComparison.InvariantCultureIgnoreCase))) { result.Result = false; result.ErrorMessage = Resources.ErrorMessages_OnlyCustomersSupported; return(result); } customerID = customerID.Substring(Constants.CustomerIdPrefix.Length); DataSet dataSet = new DataSet(); OleDbDataAdapter dataAdapter; string sqlQuery = "Select * from Customers where CustomerID = '" + customerID + "'"; using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { dataAdapter = new OleDbDataAdapter(sqlQuery, connection); if (dataAdapter.Fill(dataSet, "Customers") == 0) { result.Result = false; result.ErrorMessage = Resources.ErrorMessages_AccountNotFound; return(result); } } result.Result = true; result.ErrorMessage = ""; result.PricingListId = Constants.DefaultValues.PriceList.ID; DataSets.Product product = new DataSets.Product(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; recordCount = tableAdapter.Fill(product.Products); } result.PricingDetailLineItems = new PricingDetailLineItem[OrderDetails.LineItemDetails.Length]; DataSets.Product.ProductsRow row; decimal totalPrice = 0; decimal totalLineItemDiscount = 0; result.ErrorMessage = ""; for (int index = 0; index < OrderDetails.LineItemDetails.Length; index++) { result.PricingDetailLineItems[index] = new PricingDetailLineItem(); result.PricingDetailLineItems[index].Description = OrderDetails.LineItemDetails[index].Description; result.PricingDetailLineItems[index].LineItemId = OrderDetails.LineItemDetails[index].LineItemId; result.PricingDetailLineItems[index].LineType = OrderDetails.LineItemDetails[index].LineType; result.PricingDetailLineItems[index].SynchMessage = ""; try { productId = Convert.ToInt32(OrderDetails.LineItemDetails[index].ProductId); } catch (Exception) { result.PricingDetailLineItems[index].SynchMessage = String.Format(Resources.ErrorMessages_ProductIdWrongFormat, OrderDetails.LineItemDetails[index].ProductId.ToString()); result.ErrorMessage += result.PricingDetailLineItems[index].SynchMessage + "\r\n"; result.Result = false; continue; } if (productIds.Contains(productId)) { result.PricingDetailLineItems[index].SynchMessage = String.Format(Resources.ErrorMessages_OrderWithProductTwice, productId); //result.ErrorMessage += result.PricingDetailLineItems[index].SynchMessage + "\r\n"; //result.Result = false; //continue; } productIds.Add(productId); row = product.Products.FindByProductID(productId); if (row == null) { result.PricingDetailLineItems[index].SynchMessage = String.Format(Resources.ErrorMessages_ProductIdNotFound, productId); result.ErrorMessage += result.PricingDetailLineItems[index].SynchMessage + "\r\n"; result.Result = false; continue; } //result.PricingDetailLineItems[index].RepricingStatus = ??; //result.PricingDetailLineItems[index].StockQuantity = row.IsUnitsInStockNull() ? 0 : (int)row.UnitsInStock; result.PricingDetailLineItems[index].ListPrice = row.IsUnitPriceNull() ? (decimal)0 : row.UnitPrice; result.PricingDetailLineItems[index].Tax = 0; //result.PricingDetailLineItems[index].TaxRate = "no Tax"; result.PricingDetailLineItems[index].TaxRate = "0"; result.PricingDetailLineItems[index].DiscountRate = 0; result.PricingDetailLineItems[index].Discount = 0; if (OrderDetails.LineItemDetails[index].Quantity >= 10) { result.PricingDetailLineItems[index].DiscountRate = 10; result.PricingDetailLineItems[index].Discount = 10; } result.PricingDetailLineItems[index].DiscountSum = ((result.PricingDetailLineItems[index].DiscountRate / 100)) * result.PricingDetailLineItems[index].ListPrice; result.PricingDetailLineItems[index].QuotedPrice = result.PricingDetailLineItems[index].ListPrice * (1 - (result.PricingDetailLineItems[index].DiscountRate / 100)); result.PricingDetailLineItems[index].QuotedPriceTotal = OrderDetails.LineItemDetails[index].Quantity * result.PricingDetailLineItems[index].QuotedPrice; totalPrice += result.PricingDetailLineItems[index].QuotedPriceTotal; totalLineItemDiscount += OrderDetails.LineItemDetails[index].Quantity * result.PricingDetailLineItems[index].DiscountSum; } result.DiscountAmt = 0; result.DiscountPC = 0; result.DiscountType = ""; result.GrossAmt = totalPrice; result.LineItemDisc = totalLineItemDiscount; result.NetAmt = totalPrice; //result.NoDiscAmt = 0; //???? result.PricingListId = OrderDetails.PricingListId; result.OrderQuoteId = OrderDetails.OrderQuoteId; //result.Reference = ""; result.Tax = 0; return(result); }
public int Insert(Repo.Models.Flights.Flight model, string origin, string destionation, string departureDate, string returnDate = null, string currency = Default.CURRENCY, int adults = Default.ADULTS) { if (model == null || String.IsNullOrEmpty(origin) || String.IsNullOrEmpty(destionation) || String.IsNullOrEmpty(departureDate)) { throw new ArgumentNullException(); } if (model.Data == null || model.Dictionaries == null || model.Meta == null) { throw new NullReferenceException(); } if (model.Dictionaries.Currencies != null) { foreach (var item in model.Dictionaries.Currencies) { if (unitOfWork.Currencies.FindByCode(item.Key) == null) { unitOfWork.Currencies.Insert(item); } } } if (model.Dictionaries.Aircraft != null) { foreach (var item in model.Dictionaries.Aircraft) { if (unitOfWork.Aircrafts.FindByCode(item.Key) == null) { unitOfWork.Aircrafts.Insert(item); } } } if (model.Dictionaries.Carriers != null) { foreach (var item in model.Dictionaries.Carriers) { if (unitOfWork.Carriers.FindByCode(item.Key) == null) { unitOfWork.Carriers.Insert(item); } } } if (model.Dictionaries.Locations != null) { foreach (var item in model.Dictionaries.Locations) { if (unitOfWork.Locations.FindByCode(item.Key) == null) { unitOfWork.Locations.Insert(new KeyValuePair <string, string>(item.Key, item.Value.detailedName)); } } } Flight flight = new Flight() { Adults = adults, CurrencyId = unitOfWork.Currencies.FindByCode(model.Meta.Currency).CurrencyId, Origin = origin, Destination = destionation, DepartureDate = DateTime.Parse(departureDate), ReturnDate = DateTime.Parse(returnDate ?? DateTime.MinValue.ToString()), Link = model.Meta.Links.Self, }; flight.FlightId = unitOfWork.Flights.Insert(flight); try { foreach (var item in model.Data) { FlightOffer flightOffer = new FlightOffer { Id = item.Id, Type = item.Type, FlightId = flight.FlightId, }; var flightOfferId = unitOfWork.FlightOffers.Insert(flightOffer); foreach (var offer in item.OfferItems) { OfferItem offerItem = new OfferItem(); offerItem.FlightOfferId = flightOfferId; Price price = new Price { Total = offer.Price.Total, TotalTaxes = offer.Price.TotalTaxes, }; offerItem.PriceId = unitOfWork.Prices.Insert(price); if (offer.PricePerAdult != null) { Price adult = new Price { Total = offer.PricePerAdult.Total, TotalTaxes = offer.PricePerAdult.TotalTaxes, }; offerItem.PricePerAdultId = unitOfWork.Prices.Insert(adult); } if (offer.PricePerChild != null) { Price child = new Price { Total = offer.PricePerChild.Total, TotalTaxes = offer.PricePerChild.TotalTaxes, }; offerItem.PricePerChildId = unitOfWork.Prices.Insert(child); } if (offer.PricePerInfant != null) { Price infant = new Price { Total = offer.PricePerInfant.Total, TotalTaxes = offer.PricePerInfant.TotalTaxes, }; offerItem.PricePerInfantId = unitOfWork.Prices.Insert(infant); } if (offer.PricePerSenior != null) { Price senior = new Price { Total = offer.PricePerSenior.Total, TotalTaxes = offer.PricePerSenior.TotalTaxes, }; offerItem.PricePerSeniorId = unitOfWork.Prices.Insert(senior); } var offerItemId = unitOfWork.OfferItems.Insert(offerItem); foreach (var ser in offer.Services) { Data.Flights.Service service = new Data.Flights.Service(); service.OfferItemId = offerItemId; var serviceId = unitOfWork.Services.Insert(service); if (ser.Segments != null) { foreach (var seg in ser.Segments) { Segment segment = new Segment(); segment.ServiceId = serviceId; FlightSegment flightSegment = new FlightSegment(); flightSegment.AircraftId = unitOfWork.Aircrafts.FindByCode(seg.FlightSegment.Aircraft.Code).AircraftId; FlightEndPoint arrival = new FlightEndPoint { At = seg.FlightSegment.Arrival.At, LocationId = unitOfWork.Locations.FindByCode(seg.FlightSegment.Arrival.IataCode).LocationId, Terminal = seg.FlightSegment.Arrival.Terminal, }; flightSegment.ArrivalId = unitOfWork.FlightEndPoints.Insert(arrival); flightSegment.CarrierId = unitOfWork.Carriers.FindByCode(seg.FlightSegment.CarrierCode).CarrierId; FlightEndPoint departure = new FlightEndPoint { At = seg.FlightSegment.Departure.At, LocationId = unitOfWork.Locations.FindByCode(seg.FlightSegment.Departure.IataCode).LocationId, Terminal = seg.FlightSegment.Departure.Terminal, }; flightSegment.DepartureId = unitOfWork.FlightEndPoints.Insert(departure); flightSegment.Duration = seg.FlightSegment.Duration; flightSegment.Number = seg.FlightSegment.Number; Operation operation = new Operation { CarrierId = unitOfWork.Carriers.FindByCode(seg.FlightSegment.Operating.CarrierCode).CarrierId, Number = seg.FlightSegment.Operating.Number, }; flightSegment.OperationId = unitOfWork.Operations.Insert(operation); segment.FlightSegmentId = unitOfWork.FlightSegments.Insert(flightSegment); if (seg.FlightSegment.Stops != null) { foreach (var stop in seg.FlightSegment.Stops) { FlightStop flightStop = new FlightStop { AircraftId = unitOfWork.Aircrafts.FindByCode(stop.NewAircraft.Code).AircraftId, ArrivalAt = stop.ArrivalAt, CarrierId = unitOfWork.Carriers.FindByCode(stop.IataCode).CarrierId, DepartureAt = stop.DepartureAt, Duration = stop.Duration, FlightSegmentId = segment.FlightSegmentId, }; unitOfWork.FlightStops.Insert(flightStop); } } if (seg.PricingDetailPerAdult != null) { PricingDetail adult = new PricingDetail { Availability = seg.PricingDetailPerAdult.Availability, FareBasis = seg.PricingDetailPerAdult.FareBasis, FareClass = seg.PricingDetailPerAdult.FareClass, TravelClass = seg.PricingDetailPerAdult.TravelClass, }; segment.PricingDetailPerAdultId = unitOfWork.PricingDetails.Insert(adult); } if (seg.PricingDetailPerChild != null) { PricingDetail child = new PricingDetail { Availability = seg.PricingDetailPerChild.Availability, FareBasis = seg.PricingDetailPerChild.FareBasis, FareClass = seg.PricingDetailPerChild.FareClass, TravelClass = seg.PricingDetailPerChild.TravelClass, }; segment.PricingDetailPerChildId = unitOfWork.PricingDetails.Insert(child); } if (seg.PricingDetailPerInfant != null) { PricingDetail infant = new PricingDetail { Availability = seg.PricingDetailPerInfant.Availability, FareBasis = seg.PricingDetailPerInfant.FareBasis, FareClass = seg.PricingDetailPerInfant.FareClass, TravelClass = seg.PricingDetailPerInfant.TravelClass, }; segment.PricingDetailPerInfantId = unitOfWork.PricingDetails.Insert(infant); } if (seg.PricingDetailPerSenior != null) { PricingDetail senior = new PricingDetail { Availability = seg.PricingDetailPerSenior.Availability, FareBasis = seg.PricingDetailPerSenior.FareBasis, FareClass = seg.PricingDetailPerSenior.FareClass, TravelClass = seg.PricingDetailPerSenior.TravelClass, }; segment.PricingDetailPerSeniorId = unitOfWork.PricingDetails.Insert(senior); } var segmentId = unitOfWork.Segments.Insert(segment); } } } } } } catch (Exception e) { throw new Exception(e.Message); } return(flight.FlightId); }