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;
}
