Example #1
0
        public ActionMessage createQuote(QuoteInfo _Quote, string _userI)
        {
            ActionMessage        ret           = new ActionMessage();
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                /* try
                 * {
                 *   var ProposalInfo = ProposalDataLayer.GetInstance().getProposalDetail2(connection, _Quote.ProposalCode);
                 *   if (ProposalInfo != null)
                 *   {
                 *       _Quote.ProposalID = ProposalInfo.ProposalID;
                 *   }
                 *   else _Quote.ProposalID = 0;
                 *   ret.id = QuoteDataLayer.GetInstance().InsertQuote(connection, _Quote, _userI);
                 *   ret.isSuccess = true;
                 * }
                 * catch (Exception ex)
                 * {
                 *   ret.isSuccess = false;
                 *   ret.err.msgCode = "Internal Error";
                 *   ret.err.msgString = ex.Message;
                 * }*/
            }
            return(ret);
        }
Example #2
0
        private static void SetOptionalFields(GcpBEDocumentoVenda quoteInfo, QuoteInfo jsonObject)
        {
            if (jsonObject.Cliente != null)
            {
                quoteInfo.set_Entidade(jsonObject.Cliente);
                quoteInfo.set_EntidadeFac(jsonObject.Cliente);
            }

            if (jsonObject.NomeCliente != null)
            {
                quoteInfo.set_Nome(jsonObject.NomeCliente);
            }

            if (jsonObject.EnderecoEntrega != null)
            {
                if (jsonObject.EnderecoEntrega != null)
                    quoteInfo.set_CodigoPostal(jsonObject.EnderecoEntrega.CodigoPostal);
                if (jsonObject.EnderecoEntrega != null)
                    quoteInfo.set_Distrito(jsonObject.EnderecoEntrega.Distrito);
                if (jsonObject.EnderecoEntrega != null)
                    quoteInfo.set_Localidade(jsonObject.EnderecoEntrega.Localidade);
                if (jsonObject.EnderecoEntrega != null)
                    quoteInfo.set_Morada(jsonObject.EnderecoEntrega.Morada);
                if (jsonObject.EnderecoEntrega != null)
                    quoteInfo.set_Pais(jsonObject.EnderecoEntrega.Pais);
            }
        }
Example #3
0
        public QuoteInfo GetQuote(string tickerSymbol)
        {
            QuoteInfo i = new QuoteInfo();

            i.Symbol = tickerSymbol;
            return(i);
        }
        // PUT api/quotes/{$quoteId}/
        // FEATURE: Modificar encomenda existente
        public HttpResponseMessage Put(string id, [FromBody] QuoteInfo jsonObject)
        {
            if (Authentication.VerifyToken("?"))
            {
                try
                {
                    var operationResult = QuoteIntegration.Update(Authentication.GetRepresentative(null), HttpUtility.UrlDecode(id), jsonObject);

                    if (operationResult == null)
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound));
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.OK, operationResult));
                    }
                }
                catch (Exception ex)
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
                }
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.Forbidden));
            }
        }
        private void ImpliedMarketTimer_Tick(object sender, EventArgs e)
        {
            bool canCalculateImpliedMarket = true;

            for (int i = 1; i < Level2Forms.Count; i++)
            {
                legs[i - 1] = Level2Forms[i].getRecentQuoteBook();
                if (legs[i - 1].AskBk == null)
                {
                    canCalculateImpliedMarket = false;
                }
            }

            if (canCalculateImpliedMarket)
            {
                SpreadCalculationHelper.ImpliedMarketData impMkt = _spreadCalc.CalculateImpliedMarket(legs);
                QuoteInfo infoBid = new QuoteInfo()
                {
                    prc = impMkt.bidPrice, sz = impMkt.bidSize
                };
                QuoteInfo infoAsk = new QuoteInfo()
                {
                    prc = impMkt.askPrice, sz = impMkt.askSize
                };
                impliedMarketBook.BidBk = new QuoteInfo[] { infoBid };
                impliedMarketBook.AskBk = new QuoteInfo[] { infoAsk };

                Level2Forms[0].InfraDataReceiveHandler(impliedMarketBook);
            }
        }
Example #6
0
        private void ImpliedMarketTimer_Tick(object sender, EventArgs e)
        {
            bool canCalculateImpliedMarket = true;

            for (int i = 0; i < legs.Count; i++)
            {
                legs[i] = _level2PanelList[i].getRecentQuoteBook();
                if (legs[i].AskBk == null)
                {
                    canCalculateImpliedMarket = false;
                }
            }

            if (!canCalculateImpliedMarket)
            {
                return;
            }

            SpreadCalculationHelper.ImpliedMarketData impMkt = impliedMarket.CalculateImpliedMarket(legs);
            QuoteInfo infoBid = new QuoteInfo(), infoAsk = new QuoteInfo();

            infoBid.prc = impMkt.bidPrice;
            infoBid.sz  = impMkt.bidSize;
            infoAsk.prc = impMkt.askPrice;
            infoAsk.sz  = impMkt.askSize;
            bookToSendToLevel2Panel.BidBk = new QuoteInfo[] { infoBid };
            bookToSendToLevel2Panel.AskBk = new QuoteInfo[] { infoAsk };

            SendInfraData(bookToSendToLevel2Panel);
        }
Example #7
0
        public ProposalDetailWithContactItemsInfo GetProposalWithContactItemsByCode(string code, string _userID)
        {
            ProposalDetailBase   proposalDetail = new ProposalDetailBase();
            SqlConnectionFactory sqlConnection  = new SqlConnectionFactory();
            ProposalDetailWithContactItemsInfo ret;

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                proposalDetail = ProposalDataLayer.GetInstance().getProposalDetailByCode(connection, code, _userID);
                if (proposalDetail == null)
                {
                    return(null);
                }
                ret = new ProposalDetailWithContactItemsInfo(proposalDetail);

                int       QuoteID = ProposalDataLayer.GetInstance().getQuoteIDWithHaveFinalContact(connection, proposalDetail.ProposalID);
                QuoteInfo quote   = QuoteDataLayer.GetInstance().getQuote(connection, QuoteID, _userID);
                if (quote.TotalCost > 30000000)
                {
                    ret.DeliveryReceiptType = 2;
                }
                else
                {
                    ret.DeliveryReceiptType = 1;
                }


                ret.Items = new List <ItemInfo>();
                ret.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, QuoteID);
            }
            return(ret);
        }
Example #8
0
        public IActionResult Delete(int id)
        {
            QuoteInfo itemRemove = _context.QuoteInfo.Where(x => x.QuoteID == id).FirstOrDefault();

            _context.QuoteInfo.Remove(itemRemove);
            _context.SaveChanges();
            return(View("Confirmation"));
        }
Example #9
0
        public async Task <ActionMessage> CreateQuoteWithAttachFIles(QuoteInfo _Quote, string _userI, IList <IFormFile> files)
        {
            ActionMessage ret = new ActionMessage();

            /* int insetId = -1;
             * SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
             * using (SqlConnection connection = sqlConnection.GetConnection())
             * {
             *   try
             *   {
             *       insetId = QuoteDataLayer.GetInstance().InsertQuote(connection, _Quote, _userI);
             *   }
             *   catch (Exception ex)
             *   {
             *       throw ex;
             *   }
             * }
             * if (insetId > -1)
             * {
             *   ret.id = insetId;
             *   using (SqlConnection connection = sqlConnection.GetConnection())
             *   {
             *       try
             *       {
             *           foreach (ItemInfo item in _Quote.Items)
             *           {
             *               QuoteDataLayer.GetInstance().UpdateItemDetails(connection, item, _userI , insetId);
             *           }
             *       }
             *       catch (Exception ex)
             *       {
             *           throw ex;
             *       }
             *   }
             *
             *   foreach (var item in files)
             *   {
             *       DocumentInfo documentInfo = new DocumentInfo();
             *       documentInfo.TableName = TableFile.Quote.ToString();
             *       documentInfo.PreferId = insetId.ToString();
             *       documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
             *       documentInfo.FileName = item.FileName;
             *       documentInfo.Length = item.Length.ToString();
             *       documentInfo.Type = item.ContentType;
             *       ret = await FilesHelpers.UploadFile(TableFile.Quote.ToString(), insetId.ToString(), item, documentInfo.Link);
             *       DocumentService.GetInstance().InsertDocument(documentInfo, _userI.ToString());
             *   }
             *   ret.isSuccess = true;
             * }
             * else
             * {
             *   ret.isSuccess = false;
             *   ret.err.msgCode = "lỗi thêm phiếu báo giá";
             *   ret.err.msgString = "lỗi thêm phiếu báo giá";
             * }*/
            return(ret);
        }
Example #10
0
 public IActionResult InputQuote(QuoteInfo quoteInput)
 {
     if (ModelState.IsValid)
     {
         _context.QuoteInfo.Add(quoteInput);
         _context.SaveChanges();
         return(View("Confirmation"));
     }
     return(View(quoteInput));
 }
Example #11
0
        public async Task <ActionMessage> editBidPlan(int id, BidPlanInfo _BidPlan, string _userU, IList <IFormFile> files, string _userID)
        {
            ActionMessage        ret           = new ActionMessage();
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                var chkBidPlanInfo = BidPlanDataLayer.GetInstance().getBidPlan(connection, id, _userID);
                if (chkBidPlanInfo != null)
                {
                    try
                    {
                        QuoteInfo quoteInfo = QuoteDataLayer.GetInstance().getQuote(connection, _BidPlan.QuoteID, _userID);
                        if (quoteInfo != null)
                        {
                            _BidPlan.QuoteID = quoteInfo.QuoteID;

                            //var ProposalInfo = ProposalDataLayer.GetInstance().getProposalDetail(connection, _BidPlan.ProposalID);
                            //if (ProposalInfo != null)
                            //{
                            //    _BidPlan.ProposalCode = ProposalInfo.ProposalCode;
                            //}
                        }
                        else
                        {
                            _BidPlan.QuoteID /*= _BidPlan.ProposalID*/ = 0;
                        }
                        BidPlanDataLayer.GetInstance().UpdateBidPlan(connection, id, _BidPlan, _userU);
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
                DocumentService.GetInstance().DeleteDocumentsNotExitsInList(_BidPlan.ListDocument, TableFile.BidPlan.ToString(), _BidPlan.BidPlanID);

                foreach (var item in files)
                {
                    DocumentInfo documentInfo = new DocumentInfo();
                    documentInfo.TableName = TableFile.BidPlan.ToString();
                    documentInfo.PreferId  = _BidPlan.BidPlanID.ToString();
                    documentInfo.Link      = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
                    documentInfo.FileName  = item.FileName;
                    documentInfo.Length    = item.Length.ToString();
                    documentInfo.Type      = item.ContentType;
                    ret = await FilesHelpers.UploadFile(TableFile.BidPlan.ToString(), _BidPlan.BidPlanID.ToString(), item, documentInfo.Link);

                    DocumentService.GetInstance().InsertDocument(documentInfo, _userU);
                }
                ret.isSuccess = true;


                return(ret);
            }
        }
Example #12
0
        public async Task <ActionMessage> createBidPlan2(BidPlanInfo _BidPlan, string _userI, IList <IFormFile> files, string _userID)
        {
            ActionMessage        ret           = new ActionMessage();
            int                  insetId       = -1;
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                try
                {
                    QuoteInfo quoteInfo = QuoteDataLayer.GetInstance().getQuote(connection, _BidPlan.QuoteID, _userID);
                    if (quoteInfo != null)
                    {
                        _BidPlan.QuoteID = quoteInfo.QuoteID;
                    }
                    else
                    {
                        _BidPlan.QuoteID /*= _BidPlan.ProposalID*/ = 0;
                    }
                    insetId = BidPlanDataLayer.GetInstance().InsertBidPlan(connection, _BidPlan, _userI);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                if (insetId > -1)
                {
                    ret.id = insetId;
                    foreach (var item in files)
                    {
                        DocumentInfo documentInfo = new DocumentInfo();
                        documentInfo.TableName = TableFile.BidPlan.ToString();
                        documentInfo.PreferId  = insetId.ToString();
                        documentInfo.Link      = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
                        documentInfo.FileName  = item.FileName;
                        documentInfo.Length    = item.Length.ToString();
                        documentInfo.Type      = item.ContentType;
                        ret = await FilesHelpers.UploadFile(TableFile.BidPlan.ToString(), insetId.ToString(), item, documentInfo.Link);

                        DocumentService.GetInstance().InsertDocument(documentInfo, _userI.ToString());
                    }
                    ret.isSuccess = true;
                }
                else
                {
                    ret.isSuccess     = false;
                    ret.err.msgCode   = "lỗi thêm biên bản họp giá";
                    ret.err.msgString = "lỗi thêm biên bản họp giá";
                }
                return(ret);
            }
        }
Example #13
0
        public static QuoteInfo Insert(string sessionId, QuoteInfo jsonObject)
        {
            if (PrimaveraEngine.InitializeCompany() == false)
            {
                throw new DatabaseConnectionException();
            }

            var quoteInfo = new GcpBEDocumentoVenda();

            try
            {
                SetDefaultQuotesInfo(sessionId, quoteInfo);
                SetOptionalFields(quoteInfo, jsonObject);

                if (jsonObject.Produtos != null)
                {
                    foreach (var produto in jsonObject.Produtos)
                    {
                        PrimaveraEngine.Engine.Comercial.Vendas.AdicionaLinha(quoteInfo, produto.Produto.Identificador, produto.Quantidade, "", "", produto.Preco, produto.Desconto);
                    }
                }

                PrimaveraEngine.Engine.IniciaTransaccao();
                PrimaveraEngine.Engine.Comercial.Vendas.Actualiza(quoteInfo);
                PrimaveraEngine.Engine.TerminaTransaccao();
            }
            catch (Exception ex)
            {
                PrimaveraEngine.Engine.DesfazTransaccao();
                throw ex;
            }

            return new QuoteInfo
            {
                NumEncomenda = quoteInfo.get_NumDoc(),
                Cliente = quoteInfo.get_Entidade(),
                NomeCliente = quoteInfo.get_Nome(),
                EnderecoEntrega = new Address
                {
                    Morada = quoteInfo.get_Morada(),
                    CodigoPostal = quoteInfo.get_CodigoPostal(),
                    Localidade = quoteInfo.get_Localidade(),
                    Distrito = LocationIntegration.DistritoReference(quoteInfo.get_Distrito()),
                    Pais = quoteInfo.get_Pais()
                },
                Data = quoteInfo.get_DataDoc(),
                IdOportunidade = quoteInfo.get_IdOportunidade(),
                TotalMerc = quoteInfo.get_TotalMerc(),
                Produtos = null
            };
        }
Example #14
0
        public async Task <ActionMessage> EditQuote(int id, QuoteInfo _Quote, string _userU, IList <IFormFile> files)
        {
            ActionMessage ret = new ActionMessage();

            /*SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
             * using (SqlConnection connection = sqlConnection.GetConnection())
             * {
             *  try
             *  {
             *       QuoteDataLayer.GetInstance().UpdateQuote(connection, _Quote.QuoteID, _Quote, _userU);
             *  }
             *  catch (Exception ex)
             *  {
             *      throw ex;
             *  }
             * }
             *
             * DocumentService.GetInstance().GetInstance().DeleteDocumentsNotExitsInList(_Quote.ListDocument, TableFile.Quote.ToString(), _Quote.QuoteID);
             *
             * using (SqlConnection connection = sqlConnection.GetConnection())
             *  {
             *      try
             *      {
             *          foreach (ItemInfo item in _Quote.Items)
             *          {
             *              QuoteDataLayer.GetInstance().UpdateItemDetails(connection, item, _userU, _Quote.QuoteID);
             *          }
             *      }
             *      catch (Exception ex)
             *      {
             *          throw ex;
             *      }
             *  }
             *
             *  foreach (var item in files)
             *  {
             *      DocumentInfo documentInfo = new DocumentInfo();
             *      documentInfo.TableName = TableFile.Quote.ToString();
             *      documentInfo.PreferId = _Quote.QuoteID.ToString();
             *      documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
             *      documentInfo.FileName = item.FileName;
             *      documentInfo.Length = item.Length.ToString();
             *      documentInfo.Type = item.ContentType;
             *      ret = await FilesHelpers.UploadFile(TableFile.Quote.ToString(), _Quote.QuoteID.ToString(), item, documentInfo.Link);
             *      DocumentService.GetInstance().InsertDocument(documentInfo, _userU);
             *  }
             *  ret.isSuccess = true;*/

            return(ret);
        }
Example #15
0
 public QuoteBookStruct(bool initialize)
 {
     Instr   = new InstrInfo[2];
     BidBk   = new QuoteInfo[10];
     AskBk   = new QuoteInfo[10];
     AskExch = new byte[10];
     BidExch = new byte[10];
     NumAsk  = 10;
     NumBid  = 10;
     TS      = 0;
     PartID  = 0;
     Mod     = 0;
     TEST_TIMESTAMP_TICKS = DateTime.Now.Ticks;
     InstrumentName       = "";
 }
Example #16
0
        public IActionResult Update(QuoteInfo updatedObj)
        {
            if (ModelState.IsValid)
            {
                QuoteInfo itemUpdate = _context.QuoteInfo.Where(x => x.QuoteID == updatedObj.QuoteID).FirstOrDefault();
                itemUpdate.Quote         = updatedObj.Quote;
                itemUpdate.AuthorSpeaker = updatedObj.AuthorSpeaker;
                itemUpdate.Date          = updatedObj.Date;
                itemUpdate.Subject       = updatedObj.Subject;
                itemUpdate.Citation      = updatedObj.Citation;
                _context.SaveChanges();
                return(View("Confirmation"));
            }

            return(View(updatedObj));
        }
Example #17
0
        public ActionMessage Post([FromBody] QuoteInfo _quote)
        {
            ActionMessage ret = new ActionMessage();

            try
            {
                ret = QuoteService.GetInstance().createQuote(_quote, GetUserId());
            }
            catch (Exception ex)
            {
                ret.isSuccess     = false;
                ret.err.msgCode   = "Internal Error !!!";
                ret.err.msgString = ex.ToString();
            }
            return(ret);
        }
Example #18
0
        public ActionMessage Put(int id, [FromBody] QuoteInfo _quote)
        {
            ActionMessage ret = new ActionMessage();

            /*  try
             * {
             *    ret = QuoteService.GetInstance().editQuote(id, _quote, getUserId());
             * }
             * catch (Exception ex)
             * {
             *    ret.isSuccess = false;
             *    ret.err.msgCode = "Internal Error !!!";
             *    ret.err.msgString = ex.ToString();
             * }*/
            return(ret);
        }
Example #19
0
        public async Task <ActionMessage> Put(int id, [FromForm] QuoteInfo _quote, [FromForm] List <IFormFile> files)
        {
            ActionMessage ret = new ActionMessage();

            try
            {
                ret = await QuoteService.GetInstance().EditQuote(id, _quote, GetUserId(), files);
            }
            catch (Exception ex)
            {
                ret.isSuccess     = false;
                ret.err.msgCode   = "Internal Error !!!";
                ret.err.msgString = ex.ToString();
            }
            return(ret);
        }
Example #20
0
        public async Task <ActionMessage> PostwithAttFile([FromForm] QuoteInfo QuoteObj, [FromForm] List <IFormFile> files)
        {
            ActionMessage ret = new ActionMessage();

            try
            {
                ret = await QuoteService.GetInstance().CreateQuoteWithAttachFIles(QuoteObj, GetUserId(), files);
            }
            catch (Exception ex)
            {
                ret.isSuccess     = false;
                ret.err.msgCode   = "Internal Error !!!";
                ret.err.msgString = ex.ToString();
            }
            return(ret);
        }
Example #21
0
        public ContractInfo GetContractByCode(string code, string _userID)
        {
            ContractInfo         record        = new ContractInfo();
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                record = ContractDataLayer.GetInstance().GeContractByCode(connection, code, _userID);
                if (record == null)
                {
                    return(null);
                }

                record.Items = new List <ItemInfo>();
                record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID);

                QuoteInfo quote = QuoteDataLayer.GetInstance().getQuote(connection, record.QuoteID, _userID);
                if (quote.TotalCost > 30000000)
                {
                    record.DeliveryReceiptType = 2;
                }
                else
                {
                    record.DeliveryReceiptType = 1;
                }
                //Get document
                DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria();
                documentCriteria.TableName = TableFile.Contract.ToString();
                documentCriteria.PreferId  = record.QuoteID.ToString();
                record.ListDocument        = DocumentService.GetInstance().GetDocument(documentCriteria);

                //get Comment
                CommentSeachCriteria commentCriteria = new CommentSeachCriteria();
                commentCriteria.TableName = TableFile.Contract.ToString();
                commentCriteria.PreferId  = record.QuoteID.ToString();
                record.ListComment        = CommentService.GetInstance().getComment(commentCriteria);
                foreach (var item in record.ListComment)
                {
                    DocumentSeachCriteria documentCriteria2 = new DocumentSeachCriteria();
                    documentCriteria2.TableName = TableFile.Comment.ToString();
                    documentCriteria2.PreferId  = item.AutoID.ToString();
                    item.ListDocument           = DocumentService.GetInstance().GetDocument(documentCriteria2);
                }

                return(record);
            }
        }
        public ActionResult GetQuoteBySymbol(string symbol)
        {
            RestClient  client  = new RestClient(getServerUrl);
            RestRequest request = new RestRequest(getQuoteQueryStart + symbol + getQuoteQueryEnd);
            var         quote   = client.Execute <YahooResponse>(request);

            client  = new RestClient("http://feeds.finance.yahoo.com/");
            request = new RestRequest("rss/2.0/headline?s=" + symbol.ToLower() + "&region=US&lang=en-US");
            var rss = client.Execute <Rss>(request);

            QuoteInfo quoteInfo = new QuoteInfo
            {
                Channel = rss.Data.Channel,
                Quote   = quote.Data.Query.Results.Quote.First()
            };

            return(Json(quoteInfo, JsonRequestBehavior.AllowGet));
        }
Example #23
0
        public QuoteInfo GetQuote(string tickerSymbol)
        {
            if (string.IsNullOrEmpty(tickerSymbol))
            {
                throw this.Factory.Create(
                          Context.Request.Url,
                          "No string provided.",
                          "Parameter tickerSymbol cannot be null or empty.");
            }

            try
            {
                var svc      = new StockQuote.StockQuote();
                var response = svc.GetQuote(tickerSymbol);

                if (response == "exception")
                {
                    throw this.Factory.Create(
                              Context.Request.Url,
                              "Invalid ticker symbol provided.",
                              "The provided ticker symbol could not be found.");
                }

                var doc = new XmlDocument();
                doc.LoadXml(response);
                var stock = doc.FirstChild.FirstChild;

                var i = new QuoteInfo();
                i.Symbol        = stock["Symbol"].InnerText;
                i.LastPrice     = double.Parse(stock["Last"].InnerText);
                i.LastPriceDate = stock["Date"].InnerText;
                i.LastPriceTime = stock["Time"].InnerText;

                return(i);
            }
            catch
            {
                throw this.Factory.Create(
                          Context.Request.Url,
                          "Internal Exception.",
                          "A fatal exception occured while retrieving the results.");
            }
        }
Example #24
0
        public static bool Update(string sessionId, string quoteId, QuoteInfo jsonObject)
        {
            if (PrimaveraEngine.InitializeCompany() == false)
            {
                throw new DatabaseConnectionException();
            }

            var queryObject = PrimaveraEngine.Consulta(new SqlBuilder()
                .FromTable("CabecDoc")
                .Columns(new SqlColumn[] { new SqlColumn("CabecDoc.Id", null) })
                .Where("NumDoc", Comparison.Equals, quoteId));

            if (queryObject == null || queryObject.Vazia())
            {
                return false;
            }

            var quotesTable = PrimaveraEngine.Engine.Comercial.Vendas;
            var quoteInfo = quotesTable.EditaID(quoteId);

            if (CheckPermissions(quoteInfo, sessionId) == false)
            {
                return false;
            }

            try
            {
                quoteInfo.set_EmModoEdicao(true);
                quoteInfo.set_DataUltimaActualizacao(DateTime.Now);
                SetOptionalFields(quoteInfo, jsonObject);
                PrimaveraEngine.Engine.IniciaTransaccao();
                quotesTable.Actualiza(quoteInfo);
                PrimaveraEngine.Engine.TerminaTransaccao();
            }
            catch (Exception)
            {
                PrimaveraEngine.Engine.DesfazTransaccao();
                return false;
            }

            return true;
        }
        // GET: Admin
        public ActionResult Index()
        {
            using (CarInsuranceEntities db = new CarInsuranceEntities())
            {
                var quoteinfo = db.QuoteInfoes;
                var quotes    = new List <QuoteInfo>();
                foreach (var quote in quoteinfo)
                {
                    var quoteInfo = new QuoteInfo();
                    quoteInfo.Id           = quote.Id;
                    quoteInfo.FirstName    = quote.FirstName;
                    quoteInfo.LastName     = quote.LastName;
                    quoteInfo.EmailAddress = quote.EmailAddress;
                    quoteInfo.Quote        = quote.Quote;
                    quotes.Add(quoteInfo);
                }

                return(View(quotes));
            }
        }
Example #26
0
        public QuoteInfo GetQuoteDetailsBycode(string code, string _userID)
        {
            QuoteInfo            record        = new QuoteInfo();
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                record = QuoteDataLayer.GetInstance().getQuoteByCode(connection, code, _userID);
                if (record == null)
                {
                    return(null);
                }

                record.ListComment = new List <CommentInfo>();

                //Get document
                DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria();
                documentCriteria.TableName = TableFile.Quote.ToString();
                documentCriteria.PreferId  = record.QuoteID.ToString();
                record.ListDocument        = DocumentService.GetInstance().GetDocument(documentCriteria);

                record.Items = new List <ItemInfo>();
                record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID);

                //get Comment
                CommentSeachCriteria commentCriteria = new CommentSeachCriteria();
                commentCriteria.TableName = TableFile.Quote.ToString();
                commentCriteria.PreferId  = record.QuoteID.ToString();
                record.ListComment        = CommentService.GetInstance().getComment(commentCriteria);
                foreach (var item in record.ListComment)
                {
                    DocumentSeachCriteria documentCriteria2 = new DocumentSeachCriteria();
                    documentCriteria2.TableName = TableFile.Comment.ToString();
                    documentCriteria2.PreferId  = item.AutoID.ToString();
                    item.ListDocument           = DocumentService.GetInstance().GetDocument(documentCriteria2);
                }
            }
            return(record);
        }
        public ActionResult AutoInfo(string firstName, string lastName, string emailAddress, string dateOfBirth, string carYear, string carMake, string carModel, bool dui, string tickets, bool coverage)
        {
            if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress) || string.IsNullOrEmpty(dateOfBirth) ||
                string.IsNullOrEmpty(carYear) || string.IsNullOrEmpty(carMake) || string.IsNullOrEmpty(carModel) || string.IsNullOrEmpty(tickets))
            {
                return(View("~/Views/Shared/Error.cshtml"));
            }
            else
            {
                using (AutoInsuranceEntities db = new AutoInsuranceEntities())
                {
                    var autoquote = new QuoteInfo();
                    autoquote.FirstName    = firstName;
                    autoquote.LastName     = lastName;
                    autoquote.EmailAddress = emailAddress;

                    db.QuoteInfoes.Add(autoquote);
                    db.SaveChanges();
                }

                return(View("Success"));
            }
        }
Example #28
0
 public override void OnBeforeDeleteQuote(QuoteInfo quote, ISaleInfo sale, IContactInfo contact)
 {
     //ReadInData();
 }
Example #29
0
 public C.Quote UpdateQuote(int id, QuoteInfo apiClassInfo)
 {
     return(_service.Update(id, new C.Quote(id, apiClassInfo.Content, apiClassInfo.Quote_Author, apiClassInfo.Quote_Book, apiClassInfo.LastEdit)));
 }
Example #30
0
 public C.Quote AddQuote(QuoteInfo apiClassInfo)
 {
     return(_service.Insert(new C.Quote(apiClassInfo.Content, apiClassInfo.Quote_Author, apiClassInfo.Quote_Book, apiClassInfo.LastEdit)));
 }