public override sdkxdr.Operation.OperationBody ToOperationBody()
{
var op = new sdkxdr.ManageOfferOp();
op.Selling = Selling.ToXdr();
op.Buying = Buying.ToXdr();
var amount = new sdkxdr.Int64();
amount.InnerValue = ToXdrAmount(Amount);
op.Amount = amount;
var price = stellar_dotnet_sdk.Price.FromString(Price);
op.Price = price.ToXdr();
var offerId = new sdkxdr.Uint64();
offerId.InnerValue = OfferId;
op.OfferID = offerId;
var body = new sdkxdr.Operation.OperationBody();
body.Discriminant = sdkxdr.OperationType.Create(sdkxdr.OperationType.OperationTypeEnum.MANAGE_OFFER);
body.ManageOfferOp = op;
return(body);
}
public ActionResult Selling(Buying model)
{
if (ModelState.IsValid)
{
var newSelling = new Selling
{
ArtifactId = model.ArtifactId,
DateTime = DateTime.Now,
UserId = model.UserId,
CharacterId = int.Parse(Request.Form["CharacterId"])
};
var saleWorth = int.Parse(Request.Form["SaleWorth"]);
var characterId = int.Parse(Request.Form["CharacterId"]);
var currentUser = model.UserId;
var currentCharacter = db.Characters.FirstOrDefault(c => c.UserId == currentUser && c.Id == characterId);
currentCharacter.GoldDime = currentCharacter.GoldDime + saleWorth;
db.Characters.AddOrUpdate(currentCharacter);
var selling = db.Buyings.Find(model.Id);
if (selling != null)
{
db.Buyings.Remove(selling);
db.SaveChanges();
}
return(RedirectToAction("Selling", "Page"));
}
return(View());
}
public OperationResult Create(SellingViewModel input)
{
var result = new OperationResult();
try
{
BizModel context = new BizModel();
using (var transaction = context.Database.BeginTransaction())//Rollback
{
var sellCount = input.Quantity;
var procurementRepo = new BizRepository <Procurement>(context);
var sellingSourceRepo = new BizRepository <SellingSource>(context);
var sellingRepo = new BizRepository <Selling>(context);
Selling entity = new Selling()
{
PartNo = input.PartNo,
Quantity = input.Quantity,
SalesJobNumber = input.SalesJobNumber,
SellingDay = input.SellingDay,
UnitPrice = input.UnitPrice
};
sellingRepo.Create(entity);
context.SaveChanges();
var products = procurementRepo.GetAll()
.Where((x) => x.PartNo == input.PartNo).OrderBy((x) => x.PurchasingDay);
foreach (var p in products)
{
if (sellCount <= 0)
{
break;
}
else
{
if (p.InvetoryQuantity >= sellCount)
{
p.InvetoryQuantity = p.InvetoryQuantity - sellCount;
CreateSellingSource(sellingSourceRepo, entity.SellingId, p.ProcurementId, sellCount);
sellCount = 0;
}
else
{
sellCount = sellCount - p.InvetoryQuantity;
CreateSellingSource(sellingSourceRepo, entity.SellingId, p.ProcurementId, p.InvetoryQuantity);
p.InvetoryQuantity = 0;
}
}
}
context.SaveChanges();
result.IsSuccessful = true;
transaction.Commit();
}
}
catch (Exception ex)
{
result.IsSuccessful = false;
result.exception = ex;
}
return(result);
}
public void IsItWorthSellingOrOwning(int numberOfYears)
{
Selling s2 = new Selling();
double c = s2.GetMoneyLeft(720000, 560500, 3);
double f = s2.GetMoneyGainedOnSelling(c, 12, numberOfYears);
Console.WriteLine("The money gained on Selling the property in " + numberOfYears + " years is " + f);
double sellingbenefit = s2.moneygainedonselling;
Owning o2 = new Owning();
o2.LessSaleCost(720000, 4, 3);
o2.MoneyGainedOnOwning(33319.2, 720000, 4, 560500, numberOfYears);
Console.WriteLine("The money gained on Owning the property in " + numberOfYears + " years is " + o2.moneygainedonowning);
double owningbenefit = o2.moneygainedonowning;
if (sellingbenefit < owningbenefit)
{
Console.WriteLine("Hello Sandeep, Please own the property for benefit. Good Luck! ");
}
else
{
Console.WriteLine("Hello Sandeep, Please sell the property for benefit. Good Luck! ");
}
}
public Selling Save([FromBody] Selling selling)
{
using (var transaction = _repository.BeginTransaction())
{
if (selling.Id == 0)
{
selling.OwnerId = _branchContext.Branch.Id;
selling.BranchId = _branchContext.Branch.Id;
selling.AuthorId = _sessionContext.UserId;
}
ModelState.Clear();
TryValidateModel(selling);
ModelState.Validate();
if (selling.Id > 0)
{
_repository.Update(selling);
}
else
{
_repository.Insert(selling);
}
transaction.Commit();
}
return(selling);
}
private void bt_Sale_Click(object sender, RoutedEventArgs e)
{
New_sale _newsalewind = new New_sale();
var _goods = dbSclad.Goods.Select(p => new
{
Id = p.Id,
Name = p.Name
}).ToList();
_newsalewind.cb_Good.ItemsSource = _goods;
_newsalewind.ShowDialog();
if (_newsalewind.DialogResult == false)
{
return;
}
Selling _newsale = new Selling();
_newsale.Customer = _newsalewind.tb_Customer.ToString();
_newsale.Date = _newsalewind.Date.SelectedDate.Value;
_newsale.Count = Convert.ToInt32(_newsalewind.tb_Count.Text);
_newsale.Cost = Convert.ToInt32(_newsalewind.tb_Cost.Text);
_newsale.Price = Convert.ToInt32(_newsalewind.tb_Price.Text);
//_newGood.Name = _viewAdd.tb_Name.Text;
// _newGood.Instock = Convert.ToInt32(_viewAdd.tb_Count.Text);
// dbSclad.Goods.Add(_newGood);
dbSclad.SaveChanges();
MessageBox.Show("Добавлена новая продажа");
}
public async Task <Selling> UpdateSelling(Selling selling)
{
await using var ctx = new ContextManager(_optionsBuilder.Options);
ctx.Selling.Update(selling);
await ctx.SaveChangesAsync();
return(selling);
}
public async Task <int> AddSelling(Selling selling)
{
await _context.Sellings.AddAsync(selling);
await _context.SaveChangesAsync();
return(selling.SellingId);
}
public List <Selling> Post([FromBody] Selling value)
{
service.Create(value);
return(service
.GetAll()
.Where(x => x.Customer != null)
.ToList());
}
public async Task <IActionResult> DeleteSelling(Selling selling)
{
if (await BL.BL.Instance.GetSellingById(selling.Id) == null)
{
return(NotFound("Selling not Found"));
}
BL.BL.Instance.DeleteSelling(selling);
return(Ok("Selling deleted"));
}
public static SellingModel ToSellingModel(Selling selling)
{
return(new SellingModel
{
ClientName = selling.Client.Name,
Cost = selling.Cost,
Date = selling.Date,
Id = selling.Id,
ManagerName = selling.Manager.Name,
ProductName = selling.Product.Name
});
}
public async Task <IActionResult> EditSelling(Selling selling)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.Values));
}
if (await BL.BL.Instance.GetSellingById(selling.Id) == null)
{
return(NotFound("Selling not Found"));
}
return(Ok(await BL.BL.Instance.UpdateSelling(selling)));
}
public void IsItWorthSellingOrOwning()
{
Selling s = new Selling();
double a = s.GetMoneyLeft(720000, 560500, 3);
double d = s.GetMoneyGainedOnSelling(a, 12, 1);
Console.WriteLine("The money gained on Selling the property in 1 year is " + d);
Selling s1 = new Selling();
double b = s1.GetMoneyLeft(720000, 560500, 3);
double e = s1.GetMoneyGainedOnSelling(b, 12, 3);
Console.WriteLine("The money gained on Selling the property in 3 years is " + e);
Selling s2 = new Selling();
double c = s2.GetMoneyLeft(720000, 560500, 3);
double f = s2.GetMoneyGainedOnSelling(c, 12, 5);
Console.WriteLine("The money gained on Selling the property in 5 years is " + f);
double sellingbenefit = s2.moneygainedonselling;
Owning o = new Owning();
o.LessSaleCost(720000, 4, 3);
o.MoneyGainedOnOwning(33319.2, 720000, 4, 560500, 1);
Console.WriteLine("The money gained on Owning the property in 1 year is " + o.moneygainedonowning);
Owning o1 = new Owning();
o1.LessSaleCost(720000, 4, 3);
o1.MoneyGainedOnOwning(33319.2, 720000, 4, 560500, 3);
Console.WriteLine("The money gained on Owning the property in 3 years is " + o1.moneygainedonowning);
Owning o2 = new Owning();
o2.LessSaleCost(720000, 4, 3);
o2.MoneyGainedOnOwning(33319.2, 720000, 4, 560500, 5);
Console.WriteLine("The money gained on Owning the property in 5 years is " + o2.moneygainedonowning);
double owningbenefit = o2.moneygainedonowning;
if (sellingbenefit < owningbenefit)
{
Console.WriteLine("Hello Sandeep, Please own the property for benefit. Good Luck! ");
}
else
{
Console.WriteLine("Hello Sandeep, Please sell the property for benefit. Good Luck! ");
}
}
public void AddNew(SellingModel sellingModel)
{
Selling selling = new Selling();
var manager = _unitOfWork.ManagerRepository.GetOne(x => x.Name == sellingModel.ManagerName);
if (manager == null)
{
_unitOfWork.ManagerRepository.Add(new Manager()
{
Name = sellingModel.ManagerName
});
var newManager = _unitOfWork.ManagerRepository.GetOne(x => x.Name == sellingModel.ManagerName);
selling.ManagerId = newManager.Id;
}
else
{
selling.ManagerId = manager.Id;
}
var client = _unitOfWork.ClientRepository.GetOne(x => x.Name == sellingModel.ClientName);
if (client == null)
{
_unitOfWork.ClientRepository.Add(new Client()
{
Name = sellingModel.ClientName
});
var newClient = _unitOfWork.ClientRepository.GetOne(x => x.Name == sellingModel.ClientName);
selling.ClientId = newClient.Id;
}
else
{
selling.ClientId = client.Id;
}
var product = _unitOfWork.ProductRepository.GetOne(x => x.Name == sellingModel.ProductName);
if (product == null)
{
_unitOfWork.ProductRepository.Add(new Product()
{
Name = sellingModel.ProductName
});
var newProduct = _unitOfWork.ProductRepository.GetOne(x => x.Name == sellingModel.ProductName);
selling.ProductId = newProduct.Id;
}
else
{
selling.ProductId = product.Id;
}
selling.Date = sellingModel.Date;
selling.Cost = sellingModel.Cost;
_unitOfWork.SellingRepository.Add(selling);
}
/// <summary>
/// 新增售房
/// </summary>
/// <returns></returns>
public ActionResult AddSell(Sell sell, Selling selling, Transactions transactions)
{
int id = 0;
int a = bLL.SellsAdd(sell);
//拿到 id
if (a == 1)
{
id = bLL.Last()[0].SellID;
}
else
{
return(Content("<script>alert('该房屋已经上传');history.go(-1)</script>"));
}
int b = bLL.SellingAdd(selling, id);
int c = bLL.TransactionsAdd(transactions, id);
//添加商品图片
if (Request.Files.Count > 0)
{
string[] fileTypeStr = { "image/gif", "image/png", "image/jpeg", "image/jpg", "image/bmp" };
List <string> strlist = new List <string>();
for (int i = 0; i < Request.Files.Count; i++)
{
if (fileTypeStr.Contains(Request.Files[i].ContentType))
{
string fileName = Path.GetFileName(Request.Files[i].FileName);
strlist.Add(fileName);
}
}
if (bLL.AddSImg(id, strlist))
{
//保存文件
//应用程序需要有服务器UploadFile文件夹的读写权限
for (int i = 0; i < Request.Files.Count; i++)
{
Request.Files[i].SaveAs(Server.MapPath("~/Content/Selling/" + Request.Files[i].FileName));
}
}
}
if (b == 1 && c == 1)
{
return(Content("<script>alert('添加成功');history.go(-1)</script>"));
}
else
{
return(Content("<script>alert('添加失败');history.go(-1)</script>"));
}
}
public async Task <IActionResult> AddSelling(Selling selling)
{
if (selling.Time.Day != DateTime.Now.Day)
{
selling.Time = DateTime.Now;
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.Values));
}
selling.Id ??= Guid.NewGuid();
return(Ok(await BL.BL.Instance.AddSelling(selling)));
}
public override sdkxdr.Operation.OperationBody ToOperationBody()
{
sdkxdr.CreatePassiveOfferOp op = new sdkxdr.CreatePassiveOfferOp();
op.Selling = Selling.ToXdr();
op.Buying = Buying.ToXdr();
sdkxdr.Int64 amount = new sdkxdr.Int64();
amount.InnerValue = ToXdrAmount(Amount);
op.Amount = amount;
Price price = Sdk.Price.FromString(Price);
op.Price = price.ToXdr();
sdkxdr.Operation.OperationBody body = new sdkxdr.Operation.OperationBody();
body.Discriminant =
sdkxdr.OperationType.Create(sdkxdr.OperationType.OperationTypeEnum.CREATE_PASSIVE_OFFER);
body.CreatePassiveOfferOp = op;
return(body);
}
public override sdkxdr.Operation.OperationBody ToOperationBody()
{
var op = new sdkxdr.CreatePassiveSellOfferOp();
op.Selling = Selling.ToXdr();
op.Buying = Buying.ToXdr();
var amount = new sdkxdr.Int64();
amount.InnerValue = ToXdrAmount(Amount);
op.Amount = amount;
var price = stellar_dotnet_sdk.Price.FromString(Price);
op.Price = price.ToXdr();
var body = new sdkxdr.Operation.OperationBody();
body.Discriminant = sdkxdr.OperationType.Create(sdkxdr.OperationType.OperationTypeEnum.CREATE_PASSIVE_SELL_OFFER);
body.CreatePassiveSellOfferOp = op;
return(body);
}
/// <summary>
/// 修改订单
/// </summary>
/// <param name="sell"></param>
/// <param name="selling"></param>
/// <param name="sImg"></param>
/// <param name="transactions"></param>
/// <returns></returns>
public ActionResult EditSELL(Sell sell, Selling selling, SImg sImg, Transactions transactions)
{
int a = sell.SellID;
//添加商品图片
if (Request.Files.Count > 0)
{
string[] fileTypeStr = { "image/gif", "image/png", "image/jpeg", "image/jpg", "image/bmp" };
List <string> strlist = new List <string>();
for (int i = 0; i < Request.Files.Count; i++)
{
if (fileTypeStr.Contains(Request.Files[i].ContentType))
{
string fileName = Path.GetFileName(Request.Files[i].FileName);
strlist.Add(fileName);
}
}
if (bll2.AddSImg(sell.SellID, strlist))
{
//保存文件
//应用程序需要有服务器UploadFile文件夹的读写权限
for (int i = 0; i < Request.Files.Count; i++)
{
Request.Files[i].SaveAs(Server.MapPath("~/Content/Selling/" + Request.Files[i].FileName));
}
}
}
if (bLL.EditSELL(sell, selling, transactions))
{
return(RedirectToAction("EditSelling", "Sale", new { SellID = a }));
}
else
{
return(Content("<script>alert('修改失败');history.go(-1)</script>"));
}
}
public async Task <Selling> AddSelling(Selling selling)
{
return(await _sellingDao.AddSelling(selling));
}
public void SetSystem(PlayerSystem player)
{
Owner = player;
sellButton = Instantiate(sellButton.gameObject, Owner.WorldCanvas.transform).GetComponent <Button>();
upgradeButton = Instantiate(upgradeButton.gameObject, Owner.WorldCanvas.transform).GetComponent <Button>();
Owner.InventoryUISystem.MoveItemToSpirit += OnMoveItemToSpirit;
Owner.PlayerInputSystem.ClickedOnSpirit += OnClickedOnSpirit;
Owner.PlayerInputSystem.ClickedOnCell += OnClickedOnCell;
Owner.PlayerInputSystem.ClikedOnGround += OnClickedOnGround;
Owner.PlayerInputSystem.RMBPresed += OnClickedOnGround;
Owner.ItemDropSystem.ItemUICreated += OnItemUICreated;
sellButton.onClick.AddListener(OnSellButtonClick);
upgradeButton.onClick.AddListener(OnUpgradeButtonClick);
void OnUpgradeButtonClick()
{
Upgrading?.Invoke();
UpdateUI();
}
void OnSellButtonClick()
{
Selling?.Invoke();
ActivateUI(false);
}
void OnItemUICreated(ItemUISystem itemUI)
{
itemUI.DoubleClickedInSpiritInventory += OnItemDoubleClicked;
itemUI.System.StatsApplied += OnStatsApplied;
void OnItemDoubleClicked(ItemUISystem _)
{
if (itemUI.DraggedFrom == DraggedFrom.SpiritInventory)
{
RemoveItemFromSpirit();
MoveItemToPlayer?.Invoke(itemUI);
}
void RemoveItemFromSpirit()
{
if (itemUI.DraggedFrom == DraggedFrom.SpiritInventory)
{
allItemsUIInSpirits.Remove(itemUI);
isSlotEmpty[itemUI.SlotNumber] = true;
itemSlots[itemUI.SlotNumber].gameObject.SetActive(true);
ItemRemovedFromSpirit?.Invoke(new SpiritItemEventArgs(choosedSpirit, itemUI));
UpdateValues();
}
}
}
}
void OnClickedOnSpirit(GameObject spirit) => ActivateUI(true);
void OnClickedOnCell(GameObject spirit) => ActivateUI(false);
void OnClickedOnGround() => ActivateUI(false);
void OnMoveItemToSpirit(ItemUISystem itemUI)
{
var emptySlot = isSlotEmpty.IndexOf(true);
if (emptySlot < 0)
{
MoveItemToPlayer?.Invoke(itemUI);
}
else
{
itemUI.transform.position = itemSlots[emptySlot].transform.position;
itemUI.transform.SetParent(itemSlots[emptySlot].transform.parent);
AddItemToSpirit(emptySlot);
}
void AddItemToSpirit(int slotNumber)
{
allItemsUIInSpirits.Add(itemUI);
isSlotEmpty[slotNumber] = false;
itemSlots[slotNumber].gameObject.SetActive(false);
itemUI.DraggedFrom = DraggedFrom.SpiritInventory;
itemUI.SlotNumber = slotNumber;
ItemAddedToSpirit?.Invoke(new SpiritItemEventArgs(choosedSpirit, itemUI));
UpdateItems();
UpdateValues();
}
}
void ActivateUI(bool activate)
{
if (Owner.PlayerInputSystem.ChoosedSpirit == null)
{
return;
}
UnsubscribeFromSpiritEvents();
if (activate)
{
baseAnimator.SetBool(isOpenBool, true);
choosedSpirit = Owner.PlayerInputSystem.ChoosedSpirit;
if (choosedSpirit.Owner == Owner)
{
sellButton.gameObject.SetActive(true);
sellButton.transform.position = choosedSpirit.Prefab.transform.position + new Vector3(40, 30, 0);
upgradeButton.transform.position = choosedSpirit.Prefab.transform.position + new Vector3(40, 60, 30);
}
HideExpandedStatValues(true);
SubscribeToSpiritEvents();
UpdateUI();
}
else
{
sellButton.gameObject.SetActive(false);
upgradeButton.gameObject.SetActive(false);
baseAnimator.SetBool(isOpenBool, false);
baseAnimator.SetBool(isExpandedBool, false);
UnsubscribeFromSpiritEvents();
}
void SubscribeToSpiritEvents()
{
if (choosedSpirit == null)
{
return;
}
choosedSpirit.AbilityControlSystem.AbilityUsed += OnAbilityUsed;
choosedSpirit.EffectApplied += OnEffectApplied;
choosedSpirit.EffectRemoved += OnEffectRemoved;
choosedSpirit.StatsChanged += OnStatsApplied;
}
void UnsubscribeFromSpiritEvents()
{
if (choosedSpirit == null)
{
return;
}
choosedSpirit.AbilityControlSystem.AbilityUsed -= OnAbilityUsed;
choosedSpirit.EffectApplied -= OnEffectApplied;
choosedSpirit.EffectRemoved -= OnEffectRemoved;
choosedSpirit.StatsChanged -= OnStatsApplied;
}
void OnEffectRemoved(Data.Effect effect)
{
var appliedEffectUI = appliedEffectsUI.Find(effectUI => effectUI.EntityIndex == effect.Index);
if (appliedEffectUI != null)
{
appliedEffectUI.gameObject.SetActive(false);
appliedEffectsUI.Remove(appliedEffectUI);
}
}
void OnEffectApplied(Data.Effect effect)
{
var poolObject = appliedEffectsUIPool.PopObject();
var appliedEffectUI = poolObject.GetComponent <SlotWithCooldown>();
appliedEffectUI.Set(effect.Description, effect.Image, effect.Index);
appliedEffectsUI.Add(appliedEffectUI);
}
void OnAbilityUsed(AbilitySystem e)
{
var slot = abilitySlots.Find(abilitySlot => abilitySlot.EntityIndex == e.Ability.Index);
slot.CooldownImage.fillAmount = 1f;
StartCoroutine(Cooldown());
IEnumerator Cooldown()
{
while (slot.CooldownImage.fillAmount > 0)
{
slot.CooldownImage.fillAmount -= 1 / e.Ability.Cooldown * Time.deltaTime * 2;
yield return(deltaTimeDelay);
}
}
}
}
void UpdateUI()
{
choosedSpirit = Owner.PlayerInputSystem.ChoosedSpirit;
UpdateItems();
UpdateValues();
UpdateSlotsWithCooldown(abilitySlots, choosedSpirit.Data.Abilities);
UpdateSlotsWithCooldown(traitSlots, choosedSpirit.Data.Traits);
void UpdateSlotsWithCooldown <T>(List <SlotWithCooldown> slots, List <T> slotEntities) where T : Entity
{
slots.ForEach(slot => slot.gameObject.SetActive(false));
for (int i = 0; i < slotEntities.Count; i++)
{
slots[i].Set(slotEntities[i].Description, slotEntities[i].Image, slotEntities[i].Index);
}
}
}
void UpdateItems()
{
var choosedSpiritItems = choosedSpirit.Data.Inventory.Items;
var maxSlots = choosedSpirit.Data.Get(Enums.Spirit.MaxInventorySlots).Value;
isSlotEmpty.Clear();
allItemsUIInSpirits.ForEach(item => item.gameObject.SetActive(false));
UpdateSlotsAmount();
choosedSpiritItems.ForEach(itemInInventory =>
{
var itemFromDroppedItems = allItemsUIInSpirits.Find(droppedItem => itemInInventory.Index == droppedItem.System.Index);
if (itemFromDroppedItems != null)
{
itemFromDroppedItems.gameObject.SetActive(true);
isSlotEmpty[itemFromDroppedItems.SlotNumber] = false;
}
});
void UpdateSlotsAmount()
{
for (int i = 0; i < itemSlots.Count; i++)
{
var isInSlotLimit = i < maxSlots;
itemSlots[i].gameObject.SetActive(isInSlotLimit);
isSlotEmpty.Add(isInSlotLimit);
}
}
}
void OnStatsApplied() => UpdateValues();
void UpdateValues()
{
var spirit = choosedSpirit.Data;
spiritName.text = spirit.Name;
image.sprite = spirit.Image;
SetExpBarValue();
SetStatValues();
void SetExpBarValue()
{
var neededExp = (float)ReferenceHolder.ExpToLevelUp[(int)spirit.Get(Numeral.Level).Value];
var currentExp = (float)spirit.Get(Numeral.Exp).Value;
var expBarValue = 1 / (neededExp / currentExp);
expBar.fillAmount = expBarValue;
}
void SetStatValues()
{
numeralStatValuesUI.ForEach(statUI => statUI.Value.text = statUI.NumeralValue.AttributeToString());
spiritStatValuesUI.ForEach(statUI => statUI.Value.text = statUI.SpiritValue.AttributeToString());
}
}
}
protected override void Seed(DiscContext context)
{
try
{
context.Bands.AddRange(
new List <Band>
{
new Band {
Name = "Сборники"
},
new Band {
Name = "Виа Гра", Year = 2002
},
new Band {
Name = "Ария", Year = 1984
},
new Band {
Name = "Меладзе", Year = 1995
},
new Band {
Name = "Тальков", Year = 1984
},
new Band {
Name = "Наутилус", Year = 1983
},
});
context.Formats.AddRange(
new List <Format>
{
new Format {
Name = "audio"
},
new Format {
Name = "mp3"
}
});
context.Sellers.AddRange(
new List <Seller>
{
new Seller {
Name = "Федоров Максим"
},
new Seller {
Name = "Орлов Александр"
}
});
context.SaveChanges();
Seller seller1 = context.Sellers.FirstOrDefault(s => s.Id == 1);
Seller seller2 = context.Sellers.FirstOrDefault(s => s.Id == 2);
context.CDs.AddRange(
new List <CD>
{
new CD {
Name = "Союз 28", Cd_Date = 2004, Band = context.Bands.FirstOrDefault(b => b.Id == 1), Format = context.Formats.FirstOrDefault(f => f.Id == 1)
},
new CD {
Name = "Стоп Снято", Cd_Date = 2002, Band = context.Bands.FirstOrDefault(b => b.Id == 2), Format = context.Formats.FirstOrDefault(f => f.Id == 1)
},
new CD {
Name = "Крещенье Огнем", Cd_Date = 2003, Band = context.Bands.FirstOrDefault(b => b.Id == 3), Format = context.Formats.FirstOrDefault(f => f.Id == 1)
},
new CD {
Name = "Все альбомы", Cd_Date = 2005, Band = context.Bands.FirstOrDefault(b => b.Id == 4), Format = context.Formats.FirstOrDefault(f => f.Id == 2)
},
new CD {
Name = "Все альбомы", Cd_Date = 2005, Band = context.Bands.FirstOrDefault(b => b.Id == 5), Format = context.Formats.FirstOrDefault(f => f.Id == 2)
},
new CD {
Name = "Лучшие песни", Cd_Date = 2005, Band = context.Bands.FirstOrDefault(b => b.Id == 3), Format = context.Formats.FirstOrDefault(f => f.Id == 2)
},
new CD {
Name = "Атлантида", Cd_Date = 1997, Band = context.Bands.FirstOrDefault(b => b.Id == 6), Format = context.Formats.FirstOrDefault(f => f.Id == 2)
},
new CD {
Name = "Атлантида", Cd_Date = 1997, Band = context.Bands.FirstOrDefault(b => b.Id == 6), Format = context.Formats.FirstOrDefault(f => f.Id == 1)
},
new CD {
Name = "Крылья", Cd_Date = 1997, Band = context.Bands.FirstOrDefault(b => b.Id == 6), Format = context.Formats.FirstOrDefault(f => f.Id == 1)
},
});
context.SaveChanges();
CD cD = context.CDs.FirstOrDefault(f => f.Name == "Союз 28");
context.Sellings.AddRange(
new List <Selling>
{
new Selling {
Seller = seller1, CD = cD
},
new Selling {
Seller = seller1, CD = context.CDs.FirstOrDefault(f => f.Id == 2)
},
new Selling {
Seller = seller1, CD = context.CDs.FirstOrDefault(f => f.Id == 3)
},
new Selling {
Seller = seller1, CD = context.CDs.FirstOrDefault(f => f.Id == 4)
},
new Selling {
Seller = seller1, CD = context.CDs.FirstOrDefault(f => f.Id == 5)
},
new Selling {
Seller = seller2, CD = context.CDs.FirstOrDefault(f => f.Id == 6)
},
new Selling {
Seller = seller2, CD = context.CDs.FirstOrDefault(f => f.Id == 1)
},
new Selling {
Seller = seller2, CD = context.CDs.FirstOrDefault(f => f.Id == 7)
},
new Selling {
Seller = seller1, CD = context.CDs.FirstOrDefault(f => f.Id == 8)
},
new Selling {
Seller = seller2, CD = context.CDs.FirstOrDefault(f => f.Id == 9)
},
});
// select B.Name, Sel.Name
//from dbo.Bands B
//join dbo.CDs C on C.Band_Id = B.Id
//Join dbo.Sellings S on S.Cd_Id = C.Id
//join dbo.Sellers Sel on Sel.Id = S.Seller_Id
context.SaveChanges();
Selling selling = context.Sellings.ToList()[0];
base.Seed(context);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public async void DeleteSelling(Selling selling)
{
await using var ctx = new ContextManager(_optionsBuilder.Options);
ctx.Selling.Remove(selling);
await ctx.SaveChangesAsync();
}
public Selling Sell([FromBody] Selling selling)
{
using (var transaction = _repository.BeginTransaction())
{
if (selling.Id == 0)
{
throw new PawnshopApplicationException("Сохраните реализацию для регистрации продажи");
}
if (selling.CashOrderId.HasValue)
{
throw new PawnshopApplicationException("Продажа уже зарегистрирована");
}
selling.Status = SellingStatus.Sold;
if (selling.ContractId.HasValue && selling.ContractPositionId.HasValue)
{
var contract = _contractRepository.Get(selling.ContractId.Value);
var position = contract.Positions.SingleOrDefault(p => p.Id == selling.ContractPositionId.Value);
if (position != null)
{
position.Status = ContractPositionStatus.Disposed;
}
if (contract.Positions.All(p => p.Status == ContractPositionStatus.Disposed))
{
contract.Status = ContractStatus.Disposed;
}
_contractRepository.Update(contract);
}
ModelState.Clear();
TryValidateModel(selling);
ModelState.Validate();
var settings = _branchContext.Configuration.CashOrderSettings
.Get(selling.CollateralType).DisposeSettings;
if (!selling.SellingDate.HasValue)
{
throw new PawnshopApplicationException("Поле дата продажи обязательно для заполнения");
}
if (!selling.SellingCost.HasValue)
{
throw new PawnshopApplicationException("Поле стоимость продажи обязательно для заполнения");
}
if (!settings.DebitId.HasValue)
{
throw new PawnshopApplicationException("В настройках организации заполните счет дебет для реализации");
}
if (!settings.CreditId.HasValue)
{
throw new PawnshopApplicationException("В настройках организации заполните счет кредит для реализации");
}
var cashOrder = new CashOrder
{
OrderType = OrderType.CashIn,
OrderNumber = _counterRepository.Next(
OrderType.CashIn, selling.SellingDate.Value.Year,
_branchContext.Branch.Id,
_branchContext.Configuration.CashOrderSettings.CashInNumberCode),
OrderDate = selling.SellingDate.Value,
OrderCost = selling.SellingCost.Value,
DebitAccountId = settings.DebitId.Value,
CreditAccountId = settings.CreditId.Value,
UserId = _sessionContext.UserId,
Reason = $"Продажа изделия {selling.Note}",
RegDate = DateTime.Now,
OwnerId = _branchContext.Branch.Id,
BranchId = _branchContext.Branch.Id,
AuthorId = _sessionContext.UserId
};
_cashOrderRepository.Insert(cashOrder);
selling.CashOrderId = cashOrder.Id;
selling.CashOrder = _cashOrderRepository.Get(cashOrder.Id);
_repository.Update(selling);
transaction.Commit();
}
return(selling);
}
/// <summary>
/// 添加卖点信息
/// </summary>
/// <param name="selling"></param>
/// <param name="id"></param>
/// <returns></returns>
public int SellingAdd(Selling selling, int id)
{
selling.SellID = id;
return(dal.SellingAdd(selling));
}
/// <summary>
/// 修改售房信息
/// </summary>
/// <param name="sell"></param>
/// <param name="selling"></param>
/// <param name="transactions"></param>
/// <param name="sImg"></param>
/// <returns></returns>
public bool EditSELL(Sell sell, Selling selling, Transactions transactions)
{
return(dal.EditSELL(sell, selling, transactions));
}
public void DeleteSelling(Selling selling)
{
_sellingDao.DeleteSelling(selling);
}
public Task RemoveSelling(Selling selling)
{
_context.Sellings.Remove(selling);
return(_context.SaveChangesAsync());
}
public void Put(Selling value)
{
service.Create(value);
}
public async Task <Selling> UpdateSelling(Selling selling)
{
return(await _sellingDao.UpdateSelling(selling));
}
