public int AddDetail(SellRecord data)
{
if (db != null)
{
db.SellRecords.Add(data);
db.SaveChanges();
return(1);
}
return(0);
}
private BuyRecord FindMatchingOrder(SellRecord sellRecord)
{
var findMatchingBuyOrder = _context.BuyRecords
.Where(b => b.TickerSymbol == sellRecord.TickerSymbol)
.Where(b => b.Quantity >= sellRecord.Quantity)
.Where(b => b.IsBought == false)
.FirstOrDefault(b => b.MaxPrice >= sellRecord.Price);
return(findMatchingBuyOrder);
}
public IActionResult Post([FromBody] SellRecord obj)
{
_log4net.Info(" Http Post request");
int isDone = isellRecord.AddDetail(obj);
if (isDone == 1)
{
return(Ok("Sell Record Added"));
}
return(NotFound("Error"));
}
public void Add_Detail_Test()
{
ISellRecordRepo BookData = new SellRecordRepo(db);
SellRecordController obj = new SellRecordController(BookData);
SellRecord book = new SellRecord {
BookName = "ttttttttt", SellQty = 990, date = DateTime.Parse("03-01-2020")
};
var data = obj.Post(book);
var okResult = data as OkObjectResult;
Assert.AreEqual(200, okResult.StatusCode);
}
public ActionResult Edit(int id)
{
SellRecord book = new SellRecord();
HttpResponseMessage response = client.GetAsync(client.BaseAddress + "api/SellRecord/" + id).Result;
if (response.IsSuccessStatusCode)
{
string data = response.Content.ReadAsStringAsync().Result;
book = JsonConvert.DeserializeObject <SellRecord>(data);
}
return(View(book));
}
public IActionResult Put(int id, [FromBody] SellRecord obj)
{
_log4net.Info("PUT ---Update Request");
int isDone = isellRecord.UpdateDetail(id, obj);
if (isDone == 1)
{
return(Ok("Updated"));
}
return(NotFound("Record not Found"));
}
public ActionResult Index(SellRecord book)
{
//string data = JsonConvert.SerializeObject(book);
//StringContent content = new StringContent(data, Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PutAsync(client.BaseAddress + "api/Sell/" + book.Id + "/" + book.SellQty, null).Result;
if (response.IsSuccessStatusCode)
{
return(RedirectToAction("GetDetails", "SellRecord"));
}
return(RedirectToAction("Error"));
}
public ActionResult Edit(SellRecord book)
{
string data = JsonConvert.SerializeObject(book);
StringContent content = new StringContent(data, Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PutAsync(client.BaseAddress + "api/SellRecord/" + book.Id, content).Result;
if (response.IsSuccessStatusCode)
{
return(RedirectToAction("GetDetails"));
}
return(BadRequest());
}
private SellRecord SaveOrderToDatabase(SellOrder order)
{
var sellRecord = new SellRecord
{
SellerId = order.SellerId,
Price = order.Price,
Quantity = order.Quantity,
TickerSymbol = order.TickerSymbol
};
_context.SellRecords.Add(sellRecord);
_context.SaveChanges();
return(sellRecord);
}
public int Update(int id, int data)
{
if (db != null)
{
SellRecord book = db.SellRecords.Where(x => x.Id == id).FirstOrDefault();
if (book != null)
{
book.SellQty += data;
book.date = DateTime.Now;
db.SaveChanges();
return(1);
}
return(0);
}
return(0);
}
public int DeleteDetail(int Id)
{
if (db != null)
{
SellRecord book = db.SellRecords.FirstOrDefault(x => x.Id == Id);
if (book != null)
{
db.SellRecords.Remove(book);
db.SaveChanges();
return(1);
}
return(0);
}
return(0);
}
private void UpdateRecordsOnMatch(SellRecord sellRecord, BuyRecord buyRecord)
{
sellRecord.IsSold = true;
buyRecord.IsBought = true;
var transaction = new Transaction
{
BuyRecordId = buyRecord.Id,
SellRecordId = sellRecord.Id
};
_context.Update(sellRecord);
_context.Update(buyRecord);
_context.Transactions.Add(transaction);
_context.SaveChanges();
}
public int UpdateDetail(int id, SellRecord data)
{
if (db != null)
{
try
{
data.Id = id;
db.SellRecords.Update(data);
db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
return(0);
}
/// <summary>
/// 保存购买记录对象
/// </summary>
public void Save(SellRecord purchase)
{
List <ValidationResult> results = new List <ValidationResult>();
bool isValid = Validator.TryValidateObject(purchase,
new ValidationContext(purchase),
results);
if (!isValid)
{
throw new ArgumentException("购买记录数据不合法！");
}
if (purchase.IsTransient())
{
purchase.GenerateNewIdentity();
_purchaseRepository.Add(purchase);
}
else
{
_purchaseRepository.Modify(purchase);
}
_purchaseRepository.UnitOfWork.Commit();
}
public void CreateDatas()
{
MMContext context = new MMContext();
var medium画布 = new Medium()
{
Name = "画布"
};
medium画布.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0000-0001-000000000001"));
context.Mediums.Add(medium画布);
var medium画纸 = new Medium()
{
Name = "画纸"
};
medium画纸.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0000-0001-000000000002"));
context.Mediums.Add(medium画纸);
var lecture = new Lecture()
{
Name = "水粉画基础",
Price = 998,
Count = 14,
Medium = medium画纸,
Description = "从零开始学习水粉画的基本画法"
};
lecture.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0001-000000000001"));
context.Lectures.Add(lecture);
lecture = new Lecture()
{
Name = "水粉画基础test",
Price = 998,
Count = 14,
Medium = medium画纸,
Description = "从零开始学习水粉画的基本画法"
};
lecture.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0001-000000000002"));
context.Lectures.Add(lecture);
var timesCard = new TimesCard()
{
Name = "500元画纸",
Price = 500,
Count = 12,
Medium = medium画纸
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000001"));
context.TimesCards.Add(timesCard);
timesCard = new TimesCard()
{
Name = "500元画布",
Price = 500,
Count = 8,
Medium = medium画布
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000002"));
context.TimesCards.Add(timesCard);
timesCard = new TimesCard()
{
Name = "1000元画纸",
Price = 1000,
Count = 26,
Medium = medium画纸
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000003"));
context.TimesCards.Add(timesCard);
timesCard = new TimesCard()
{
Name = "1000元画布",
Price = 1000,
Count = 18,
Medium = medium画布
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000004"));
context.TimesCards.Add(timesCard);
timesCard = new TimesCard()
{
Name = "1000元画布test",
Price = 1000,
Count = 18,
Medium = medium画布
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000005"));
context.TimesCards.Add(timesCard);
timesCard = new TimesCard()
{
Name = "1000元画布test",
Price = 1000,
Count = 18,
Medium = medium画布
};
timesCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0002-000000000006"));
context.TimesCards.Add(timesCard);
var oneTimeExperience = new OneTimeExperience()
{
Name = "一次性画纸", Price = 20, Medium = medium画纸
};
oneTimeExperience.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0003-000000000001"));
context.OneTimeExperiences.Add(oneTimeExperience);
oneTimeExperience = new Model.OneTimeExperience()
{
Name = "一次性画布", Price = 30, Medium = medium画纸
};
oneTimeExperience.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0003-000000000002"));
context.OneTimeExperiences.Add(oneTimeExperience);
oneTimeExperience = new Model.OneTimeExperience()
{
Name = "一次性画布test", Price = 30, Medium = medium画纸
};
oneTimeExperience.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0001-0003-000000000003"));
context.OneTimeExperiences.Add(oneTimeExperience);
Tutor tutor = new Tutor()
{
Name = "admin",
IsManager = true
};
tutor.SetPassword("password");
tutor.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0002-0001-000000000001"));
context.Tutors.Add(tutor);
SellRecord sellRecord = new SellRecord()
{
ProductId = Guid.Parse("00000000-0000-0001-0002-000000000001"),
Tutor = tutor,
Price = 500,
SellDate = DateTime.Parse("2017-3-1")
};
sellRecord.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0005-0001-000000000001"));
context.SellRecords.Add(sellRecord);
Member member = new Member()
{
Name = "李四", PhoneNumber = "1234567890"
};
member.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0003-0001-000000000001"));
LectureMemberCard lectureMemberCard = new LectureMemberCard()
{
Name = "500元画纸",
TotalCount = 12,
Remainder = 12,
MediumName = medium画纸.Name,
ProductId = Guid.Parse("00000000-0000-0001-0002-000000000001"),
Member = member,
PurchaseDate = DateTime.Parse("2017-3-1"),
SellRecord = sellRecord
};
lectureMemberCard.ChangeCurrentIdentity(Guid.Parse("00000000-0000-0004-0001-000000000001"));
member.MemberCards.Add(lectureMemberCard);
context.Members.Add(member);
context.SaveChanges();
}
