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);
}
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);
}
}
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);
}
}
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);
}
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);
}
public IActionResult Delete(int id)
{
QuoteInfo itemRemove = _context.QuoteInfo.Where(x => x.QuoteID == id).FirstOrDefault();
_context.QuoteInfo.Remove(itemRemove);
_context.SaveChanges();
return(View("Confirmation"));
}
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);
}
public IActionResult InputQuote(QuoteInfo quoteInput)
{
if (ModelState.IsValid)
{
_context.QuoteInfo.Add(quoteInput);
_context.SaveChanges();
return(View("Confirmation"));
}
return(View(quoteInput));
}
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);
}
}
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);
}
}
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
};
}
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);
}
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 = "";
}
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));
}
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);
}
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);
}
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);
}
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);
}
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() + "®ion=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));
}
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.");
}
}
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));
}
}
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"));
}
}
public override void OnBeforeDeleteQuote(QuoteInfo quote, ISaleInfo sale, IContactInfo contact)
{
//ReadInData();
}
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)));
}
public C.Quote AddQuote(QuoteInfo apiClassInfo)
{
return(_service.Insert(new C.Quote(apiClassInfo.Content, apiClassInfo.Quote_Author, apiClassInfo.Quote_Book, apiClassInfo.LastEdit)));
}
