private BtCFileInfo GetTrueBtcFile(string UserName) { logger.InfoFormat("GetTrueBtcFile [UserName:{0}]", UserName); BOC.Entities.CompanyBtcFile lCompanyBtcFile = _BOCWebDBContext.CompanyBtcFiles.Find(UserName); if (lCompanyBtcFile != null) { BtCFileInfo lBtCFileInfo = new BtCFileInfo(); List<BOC.Entities.CompanyBtcFileTraded> lCompanyBtcFileTradeds = _BOCWebDBContext.CompanyBtcFileTradeds .Where(e => e.CompanyName == UserName) .OrderByDescending(e => e.TradeYear).ThenBy(e => e.FromCountry).ThenBy(e => e.ImportExport).ThenBy(e => e.BeefSource) .ToList(); int lLastTradeYear = -1; decimal lTotalTradeQuantity = 0; foreach (BOC.Entities.CompanyBtcFileTraded CompanyBtcFileTraded in lCompanyBtcFileTradeds) { if (lLastTradeYear == -1) { lLastTradeYear = CompanyBtcFileTraded.TradeYear; } if (lLastTradeYear > CompanyBtcFileTraded.TradeYear) { lLastTradeYear = CompanyBtcFileTraded.TradeYear; } lTotalTradeQuantity += CompanyBtcFileTraded.Quantity; } lBtCFileInfo.LastTradeYear = lLastTradeYear; lBtCFileInfo.TotalTradeQuantity = lTotalTradeQuantity; lBtCFileInfo.CompanyBtCFile = lCompanyBtcFile; lBtCFileInfo.CompanyBtCFileTradeList = lCompanyBtcFileTradeds; lBtCFileInfo.IsTrueBtcFile = true; return lBtCFileInfo; } else { return null; } }
public IHttpActionResult SetBtCFileInfo(BtCFileInfo aBtCFileInfo) { logger.InfoFormat("SetBtCFileInfo {0}", aBtCFileInfo.ToString()); try { BOC.Entities.CompanyBtcFile lCompanyBtcFile = _BOCWebDBContext.CompanyBtcFiles.Find(aBtCFileInfo.CompanyBtCFile.CompanyName); if (lCompanyBtcFile != null) { lCompanyBtcFile.CompanyLocalName = aBtCFileInfo.CompanyBtCFile.CompanyLocalName; lCompanyBtcFile.CompanyLocalNameCeritificate = aBtCFileInfo.CompanyBtCFile.CompanyLocalNameCeritificate; lCompanyBtcFile.CompanyType = aBtCFileInfo.CompanyBtCFile.CompanyType; lCompanyBtcFile.CompanyTypeCeritificate = aBtCFileInfo.CompanyBtCFile.CompanyTypeCeritificate; lCompanyBtcFile.CompanyYearFounded = aBtCFileInfo.CompanyBtCFile.CompanyYearFounded; lCompanyBtcFile.CompanyYearFoundedCeritificate = aBtCFileInfo.CompanyBtCFile.CompanyYearFoundedCeritificate; _BOCWebDBContext.CompanyBtcFiles.Attach(lCompanyBtcFile); _BOCWebDBContext.Entry<BOC.Entities.CompanyBtcFile>(lCompanyBtcFile).State = System.Data.Entity.EntityState.Modified; //_BOCWebDBContext.Entry<BOC.Entities.CompanyBtcFile>(lCompanyBtcFile).State = System.Data.Entity.EntityState.Modified; foreach (BOC.Entities.CompanyBtcFileTraded CompanyBtcFileTraded in aBtCFileInfo.CompanyBtCFileTradeList) { if (CompanyBtcFileTraded.CompanyBtcFileTradedID == 0 || CompanyBtcFileTraded.CompanyName == null) { CompanyBtcFileTraded.CompanyName = aBtCFileInfo.CompanyBtCFile.CompanyName; _BOCWebDBContext.CompanyBtcFileTradeds.Add(CompanyBtcFileTraded); } else { BOC.Entities.CompanyBtcFileTraded lCompanyBtcFileTradedTemp = _BOCWebDBContext.CompanyBtcFileTradeds.Find(CompanyBtcFileTraded.CompanyBtcFileTradedID); if (lCompanyBtcFileTradedTemp != null) { lCompanyBtcFileTradedTemp.CompanyName = CompanyBtcFileTraded.CompanyName; lCompanyBtcFileTradedTemp.TradeYear = CompanyBtcFileTraded.TradeYear; lCompanyBtcFileTradedTemp.Quantity = CompanyBtcFileTraded.Quantity; lCompanyBtcFileTradedTemp.ImportExport = CompanyBtcFileTraded.ImportExport; lCompanyBtcFileTradedTemp.FromCountry = CompanyBtcFileTraded.FromCountry; lCompanyBtcFileTradedTemp.BeefSource = CompanyBtcFileTraded.BeefSource; lCompanyBtcFileTradedTemp.IsCertificate = CompanyBtcFileTraded.IsCertificate; lCompanyBtcFileTradedTemp.IsRequireCertificate = CompanyBtcFileTraded.IsRequireCertificate; //lCompanyBtcFileTradedTemp.RequireCertificateDateTime = CompanyBtcFileTraded.RequireCertificateDateTime; lCompanyBtcFileTradedTemp.RequireStatus = CompanyBtcFileTraded.RequireStatus; lCompanyBtcFileTradedTemp.CompanyName = aBtCFileInfo.CompanyBtCFile.CompanyName; _BOCWebDBContext.CompanyBtcFileTradeds.Attach(lCompanyBtcFileTradedTemp); _BOCWebDBContext.Entry<BOC.Entities.CompanyBtcFileTraded>(lCompanyBtcFileTradedTemp).State = System.Data.Entity.EntityState.Modified; } else { CompanyBtcFileTraded.CompanyName = aBtCFileInfo.CompanyBtCFile.CompanyName; _BOCWebDBContext.CompanyBtcFileTradeds.Add(CompanyBtcFileTraded); } //_BOCWebDBContext.CompanyBtcFileTradeds.Attach(CompanyBtcFileTraded); //_BOCWebDBContext.Entry<BOC.Entities.CompanyBtcFileTraded>(CompanyBtcFileTraded).State = System.Data.Entity.EntityState.Modified; } } _BOCWebDBContext.SaveChanges(); return Ok(); } else { _BOCWebDBContext.CompanyBtcFiles.Add(aBtCFileInfo.CompanyBtCFile); foreach (BOC.Entities.CompanyBtcFileTraded CompanyBtcFileTraded in aBtCFileInfo.CompanyBtCFileTradeList) { CompanyBtcFileTraded.CompanyName = aBtCFileInfo.CompanyBtCFile.CompanyName; _BOCWebDBContext.CompanyBtcFileTradeds.Add(CompanyBtcFileTraded); } _BOCWebDBContext.SaveChanges(); return Ok(); } } catch(Exception e) { return BadRequest(e.ToString()); } }
private BtCFileInfo GetFackBtcFile(string UserName) { logger.InfoFormat("GetFackBtcFile [UserName:{0}]", UserName); BOC.Entities.CompanyBtcFile lCompanyBtcFile = _BOCWebDBContext.CompanyBtcFiles.Where(e => e.CompanyName == UserName).FirstOrDefault(); int lCount = _BOCWebDBContext.CompanyBtcFileTradeds.Where(e => e.CompanyName == UserName).Count(); BtCFileInfo lBtCFileInfo = new BtCFileInfo(); lBtCFileInfo.CompanyBtCFile = new BOC.Entities.CompanyBtcFile(); lBtCFileInfo.CompanyBtCFile.CompanyLocalName = "******"; lBtCFileInfo.CompanyBtCFile.CompanyYearFounded = "******"; if (lCompanyBtcFile != null) { lBtCFileInfo.CompanyBtCFile.CompanyType = lCompanyBtcFile.CompanyType; } else { lBtCFileInfo.CompanyBtCFile.CompanyType = "Not Set"; } if(lCompanyBtcFile != null) { if (lCompanyBtcFile.CompanyLocalName != null && lCompanyBtcFile.CompanyLocalName != "") { lBtCFileInfo.CompanyBtCFile.CompanyLocalName = "******"; } else { lBtCFileInfo.CompanyBtCFile.CompanyLocalName = "_none"; } if (lCompanyBtcFile.CompanyYearFounded != null && lCompanyBtcFile.CompanyYearFounded != "") { lBtCFileInfo.CompanyBtCFile.CompanyYearFounded = "******"; } else { lBtCFileInfo.CompanyBtCFile.CompanyYearFounded = "_none"; } if (lCompanyBtcFile.CompanyType != null && lCompanyBtcFile.CompanyType != "") { lBtCFileInfo.CompanyBtCFile.CompanyType = lCompanyBtcFile.CompanyType; } else { lBtCFileInfo.CompanyBtCFile.CompanyType = "_none"; } } else { lBtCFileInfo.CompanyBtCFile.CompanyLocalName = "_none"; lBtCFileInfo.CompanyBtCFile.CompanyYearFounded = "_none"; lBtCFileInfo.CompanyBtCFile.CompanyType = "_none"; } lBtCFileInfo.CompanyBtCFileTradeList = new List<BOC.Entities.CompanyBtcFileTraded>(); if (lCount > 5) { lCount = 5; } var lCompanyBtcFileTradeds = _BOCWebDBContext.CompanyBtcFileTradeds.Where(e => e.CompanyName == UserName); foreach (BOC.Entities.CompanyBtcFileTraded lCompanyBtcFileTraded in lCompanyBtcFileTradeds) { BOC.Entities.CompanyBtcFileTraded lCompanyBtcFileTradedTemp = new BOC.Entities.CompanyBtcFileTraded(); lCompanyBtcFileTradedTemp.IsCertificate = lCompanyBtcFileTraded.IsCertificate; lBtCFileInfo.CompanyBtCFileTradeList.Add(lCompanyBtcFileTradedTemp); } lBtCFileInfo.IsTrueBtcFile = false; return lBtCFileInfo; }
public BtCFileInfo GetFackBtcFile(string UserName) { BOC.Entities.CompanyBtcFile lCompanyBtcFile = _BOCWebDBContext.CompanyBtcFiles.Where(e => e.CompanyName == UserName).FirstOrDefault(); int lCount = _BOCWebDBContext.CompanyBtcFileTradeds.Where(e => e.CompanyName == UserName).Count(); BtCFileInfo lBtCFileInfo = new BtCFileInfo(); lBtCFileInfo.CompanyBtCFile = new BOC.Entities.CompanyBtcFile(); lBtCFileInfo.CompanyBtCFile.CompanyLocalName = "******"; //lBtCFileInfo.CompanyBtCFile.CompanyProfile = "******"; //lBtCFileInfo.CompanyBtCFile.MainlyCutsTraded = "******"; lBtCFileInfo.CompanyBtCFile.CompanyYearFounded = "******"; if (lCompanyBtcFile != null) { lBtCFileInfo.CompanyBtCFile.CompanyType = lCompanyBtcFile.CompanyType; } else { lBtCFileInfo.CompanyBtCFile.CompanyType = "Not Set"; } lBtCFileInfo.CompanyBtCFileTradeList = new List<BOC.Entities.CompanyBtcFileTraded>(); if (lCount > 5) { lCount = 5; } for (int i = 0; i < lCount; i++) { BOC.Entities.CompanyBtcFileTraded lCompanyBtcFileTraded = new BOC.Entities.CompanyBtcFileTraded(); lBtCFileInfo.CompanyBtCFileTradeList.Add(lCompanyBtcFileTraded); } return lBtCFileInfo; }