public void CreditItem(FinancialItem financialItem)
{
int ffi = (int)financialItem.financialClass;
bankFinancialQuantityArray[ffi] += financialItem.quantity;
financialItem.BecomeObtained();
}
/// <summary>
/// Frissíti a FINANCIAL_ITEM tábla egy sorát.
/// </summary>
/// <param name="financialItem">Ezt fogja frissíteni.</param>
/// <returns>Mennyi mezőt frissített.</returns>
public int UpdateFinancialItem(FinancialItem financialItem)
{
try
{
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(UPDATE_FINANCIALITEM, conn))
{
cmd.Parameters.AddWithValue("@ID", financialItem.ID);
cmd.Parameters.AddWithValue("@DATE", financialItem.DATE);
cmd.Parameters.AddWithValue("@AMOUNT", financialItem.AMOUNT);
cmd.Parameters.AddWithValue("@PARTNER_ID", financialItem.PARTNER_ID);
return(cmd.ExecuteNonQuery());
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error at UpdateFinancialItem(): {0}, {1}", ex.StackTrace, ex.Message);
return(-1);
}
}
void addItem(FinancialItem item)
{
Controls.FinancialLineItem line_item = new Controls.FinancialLineItem();
line_item.AddItem(item);
addItemActions[item.Group].Invoke(line_item);
//this.FinancialItems.Children.Add(line_item);
}
public async Task <ResultModel> Put([FromBody] FinancialItem item)
{
var result = new ResultModel();
result.Message = item.Name;
if (item.Type != "收入" && item.Type != "支出")
{
result.IsSuccess = false;
result.Message = "Type:收入 or 支出";
return(result);
}
FinancialItem itemToUpdate = await _context.FinancialItems.FindAsync(item.Id);
if (itemToUpdate == null)
{
result.IsSuccess = false;
result.Message = "查無財務項目";
return(result);
}
//檢查名稱是否重複
var query = from o in _context.FinancialItems
where o.Name.ToUpper() == item.Name.ToUpper()
select o;
if (query.Count() > 0)
{//排除跟自己同名
if (query.FirstOrDefault().Id != item.Id)
{
result.IsSuccess = false;
result.Message = "Name: " + item.Name + " exist.";
return(result);
}
}
try
{
_context.Entry(itemToUpdate).CurrentValues.SetValues(item);
result.IsSuccess = true;
result.Message = "編輯財務項目成功";
await _context.SaveChangesAsync();
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = "DB ERROR";
}
var accessToken = Request.Headers["Authorization"];
var user = await _TokenGetUserHelper.GetUser(accessToken);
logger.Info("userId=" + user.Id + ", username="******"\nUpdate " + "FinancialItem id= " + item.Id + ", name=" + item.Name + " successfully.");
return(result);
}
public IActionResult Update(FinancialItem request)
{
_financialItemsService.UpdateItem(request.FinancialItemID, request.PartnerID, request.Date, request.Amount);
var viewModel = new FinancialItemsViewModel();
viewModel.FinancialItems = _financialItemsService.GetAllItems();
viewModel.Partners = _financialItemsService.GetAllPartners();
return(PartialView("_FinancialItemsListPartial", viewModel));
}
public void DebitItem(int ffi)
{
if (bankFinancialQuantityArray[ffi] >= 1)
{
FinancialClass financialClass = (FinancialClass)ffi;
float quantity = Mathf.Ceil(bankFinancialQuantityArray[ffi] / 3f);
FinancialItem.InstantiateFinancialItemGameObject(financialClass, quantity, transform);
bankFinancialQuantityArray[ffi] -= quantity;
}
}
public static FinancialItem InstantiateFinancialItemGameObject(FinancialClass financialClass, float quantity, Transform originTransform)
{
GameObject financialItemGameObject = Instantiate(PrefabReferences.prefabReferences.financialItemGameObject);
FinancialItem financialItem = financialItemGameObject.GetComponent <FinancialItem>();
financialItem.financialClass = financialClass;
financialItem.quantity = quantity;
financialItem.BecomeUnobtained(originTransform);
return(financialItem);
}
public void UpdateFinancialItem(FinancialItem updatedItem)
{
var oldItem = FinancialItems.First(x => x.FinancialItemID == updatedItem.FinancialItemID);
var itemIndex = FinancialItems.IndexOf(oldItem);
if (itemIndex > -1)
{
FinancialItems[itemIndex] = updatedItem;
}
}
public async Task <ResultModel> Post(FinancialItem item)
{
var result = new ResultModel();
///輸入資料檢查
if (item.Name == null || item.Type == null)
{
result.IsSuccess = false;
result.Message = "輸入資料不足";
return(result);
}
if (item.Type != "收入" && item.Type != "支出")
{
result.IsSuccess = false;
result.Message = "Type:收入 or 支出";
return(result);
}
//==============
var queryItem = from i in _context.FinancialItems
where i.Name.ToUpper() == item.Name.ToUpper()
select i;
if (queryItem.Count() > 0)
{
result.IsSuccess = false;
result.Message = "項目名稱重複";
return(result);
}
try
{
_context.FinancialItems.Add(item);
result.IsSuccess = true;
result.Message = "添加財務項目成功";
await _context.SaveChangesAsync();
result.Data = new {
item.Id
};
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = "DB ERROR";
}
var accessToken = Request.Headers["Authorization"];
var user = await _TokenGetUserHelper.GetUser(accessToken);
logger.Info("userId=" + user.Id + ", username="******"\nCreate " + "FinancialItem id= " + item.Id + ", name=" + item.Name + " successfully.");
return(result);
}
public void ObtainItem(Item item, int numNextIi = 0)
{
EquipableItem equipableItem = item.GetComponent <EquipableItem>();
FinancialItem financialItem = item.GetComponent <FinancialItem>();
if (equipableItem != null)
{
EquipItem(equipableItem, numNextIi);
}
else if (financialItem != null)
{
CreditItem(financialItem);
}
}
/// <summary>
/// Сохраняет в базе модель создания элемента.
/// </summary>
/// <param name="token">Токен безопасности.</param>
/// <param name="model">Модель создания сущности для сохранения.</param>
/// <param name="result">Результат с ошибками.</param>
public override void SaveCreateModel(SecurityToken token, FinancialItemCreateModel model, GridSaveModelResult result)
{
var entity = new FinancialItem
{
Description = model.Description,
EventDate = model.EventDate,
FinancialItemID = model.FinancialItemID,
FinancialItemKindID = model.FinancialItemKindID,
Title = model.Title,
TransactionKindID = model.TransactionKindID
};
RemontinkaServer.Instance.EntitiesFacade.SaveFinancialItem(token, entity);
}
private KeyValuePair <bool, string> CheckFileType()
{
Regex reg = new Regex(@"([^\.]+$)");
Match match = reg.Match(FileName);
BaseFile = match.ToString().Contains("xls") ? BaseFile = new Excel(FileName, FilePath)
: BaseFile = new CSV(FileName, FilePath);
var results = FormatFile(JsonConvert.SerializeObject(BaseFile));
ResultData = new FinancialItem().ParseData(results);
File.Delete(FilePath);
// send file to cosmos db
// delete temporary file here
return(ResultData);
}
/// <summary>
/// Kivesz a FINANCIAL_ITEM táblából PARTNERID szerint az összes elemet.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <FinancialItem> GetFinancialItemByPARTNERID(decimal id)
{
List <FinancialItem> financialItems = new List <FinancialItem>();
try
{
using (SqlConnection conn = new SqlConnection(_connectionString))
using (SqlCommand cmd = new SqlCommand(GET_FINANCIALITEM_BY_PARTNERID, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@PARTNER_ID", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
FinancialItem financialItem = new FinancialItem
{
ID = reader.GetInt32(reader.GetOrdinal("ID")),
PARTNER_ID = reader.GetDecimal(reader.GetOrdinal("PARTNER_ID")),
DATE = reader.GetDateTime(reader.GetOrdinal("DATE")),
AMOUNT = reader.GetDecimal(reader.GetOrdinal("AMOUNT"))
};
financialItems.Add(financialItem);
}
}
}
}
return(financialItems);
}
catch (Exception ex)
{
Console.WriteLine("Error at GetFinancialItemByPARTNERID(): {0}, {1}", ex.StackTrace, ex.Message);
return(null);
}
}
/// <summary>
/// Сохраняет в базе модель создания элемента.
/// </summary>
/// <param name="token">Токен безопасности.</param>
/// <param name="model">Модель создания сущности для сохранения.</param>
/// <param name="result">Результат выполнения..</param>
public override FinancialItemGridItemModel SaveCreateModel(SecurityToken token, FinancialItemCreateModel model, JGridSaveModelResult result)
{
var entity = new FinancialItem
{
Description = model.Description,
EventDate = model.EventDate,
FinancialItemID = model.Id,
FinancialItemKindID = model.FinancialItemKindID,
Title = model.Title,
TransactionKindID = model.TransactionKindID
};
RemontinkaServer.Instance.EntitiesFacade.SaveFinancialItem(token, entity);
return(new FinancialItemGridItemModel
{
Id = entity.FinancialItemID,
Title = entity.Title,
TransactionKindTitle = TransactionKindSet.GetKindByID(entity.TransactionKindID).Title,
RowClass = GetTransactionKindRowClass(entity.TransactionKindID)
});
}
public async Task <IActionResult> CreateFinancialItem(FinancialItem item)
{
if (!ModelState.IsValid)
{
return(View(item));
}
var data = JsonConvert.SerializeObject(item);
Uri address = new Uri(_config["api"] + "/FinancialItem");
ResultModel result = new ResultModel();
result = await _callApi.CallAPI(data, address, "POST");
TempData["IsSuccess"] = result.IsSuccess;
TempData["msg"] = result.Message;
if (!result.IsSuccess)
{
return(View(item));
}
return(RedirectToAction(nameof(CreateFinancialItem)));
}
private void HandleItem(int eeiHand)
{
Item minDistanceItem = completeBody.HandleItem(eeiHand);
if (minDistanceItem == null)
{
return;
}
EquipableItem minDistanceEquipableItem = minDistanceItem.GetComponent <EquipableItem>();
FinancialItem minDistanceFinancialItem = minDistanceItem.GetComponent <FinancialItem>();
if (minDistanceEquipableItem != null)
{
HudCanvasManager.hudCanvasManager.UpdateHandPocketEquipmentImage(minDistanceEquipableItem.eei);
}
else if (minDistanceFinancialItem != null)
{
HudCanvasManager.hudCanvasManager.UpdateFinanceText((int)minDistanceFinancialItem.financialClass); // TODO: test
}
}
public ActionResult SaveFinancialItem(FinancialViewModel model)
{
if (ModelState.IsValid)
{
FinancialItem financialItem = new FinancialItem()
{
PARTNER_ID = model.SelectedPartnerID,
AMOUNT = Convert.ToDecimal(model.Amount),
DATE = model.Date
};
int success = _baseFunctions.InsertFinancialItem(financialItem);
if (success == 1)
{
return(RedirectToAction("Index", "Home"));
}
}
return(View("UploadFinancial", model));
}
public async Task <ResultModel> Delete(int id)
{
var result = new ResultModel();
FinancialItem item = await _context.FinancialItems.FindAsync(id);
if (item == null)
{
result.IsSuccess = false;
result.Message = "查無財務項目";
}
else
{
try
{
_context.Remove(item);
await _context.SaveChangesAsync();
result.IsSuccess = true;
result.Message = "刪除財務項目成功";
}
catch (Exception e)
{
result.IsSuccess = false;
if (e.InnerException.Message.Contains("FOREIGN KEY constraint failed"))
{
result.Message = "項目使用中";
}
else
{
result.Message = "DB error.";
}
}
}
var accessToken = Request.Headers["Authorization"];
var user = await _TokenGetUserHelper.GetUser(accessToken);
logger.Info("userId=" + user.Id + ", username="******"\n Delete " + "FinancialItem id= " + item.Id + ", name=" + item.Name + " successfully.");
return(result);
}
/// <summary>
/// Beszúr egy elemet a FINANCIAL_ITEM táblába.
/// </summary>
/// <param name="financialItem">Ezt fogja beszúrni.</param>
/// <returns>Mennyi mezőt szúrt be.</returns>
public int InsertFinancialItem(FinancialItem financialItem)
{
try
{
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(INSERT_FINANCIALITEM, conn))
{
cmd.Parameters.Add(
new SqlParameter("@DATE", financialItem.DATE)
{
SqlDbType = System.Data.SqlDbType.Date
}
);
cmd.Parameters.Add(
new SqlParameter("@AMOUNT", financialItem.AMOUNT)
{
SqlDbType = System.Data.SqlDbType.Decimal
}
);
cmd.Parameters.Add(
new SqlParameter("@PARTNER_ID", financialItem.PARTNER_ID)
{
SqlDbType = System.Data.SqlDbType.Decimal
}
);
return(cmd.ExecuteNonQuery());
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error at InsertFinancialItem(): {0}, {1}", ex.StackTrace, ex.Message);
return(-1);
}
}
public async Task <IActionResult> Edit(int id)
{
ResultModel result = new ResultModel();
Uri address = new Uri(_config["api"] + "/FinancialItem/" + id);
result = await _callApi.CallAPI("null", address, "GET");
FinancialItem f = new FinancialItem();
if (result.IsSuccess == true)
{
f = JsonConvert.DeserializeObject <FinancialItem>(result.Data.ToString());
TempData["isSuccess"] = "true";
return(View(f));
}
else
{ //result.IsSuccess == false
TempData["isSuccess"] = "false";
TempData["msg"] = result.Message;
return(View());
}
}
public void AddFinancialItem(FinancialItem newItem)
{
FinancialItems.Add(newItem);
}
/// <summary>
/// Frissít egy FinancialItem-et.
/// </summary>
/// <param name="financialItem"></param>
/// <returns></returns>
public int UpdateFinancialItem(FinancialItem financialItem)
{
return(_dBContext.UpdateFinancialItem(financialItem));
}
public void AddItem(FinancialItem item)
{
this.Item = item;
}
/// <summary>
/// Beszúr egy FinancialItem-et.
/// </summary>
/// <param name="financialItem"></param>
/// <returns></returns>
public int InsertFinancialItem(FinancialItem financialItem)
{
return(_dBContext.InsertFinancialItem(financialItem));
}
public void Create(FinancialItemCreateDto financialItemCreateDto)
{
FinancialItem financialItem = Mapper.Map <FinancialItem>(financialItemCreateDto);
repository.Add(financialItem);
}
public void CreditItem(FinancialItem financialItem)
{
itemHandlerBody.CreditItem(financialItem);
}
private FinancialInfo ParseFinInfo(string content, DocLinkInfo.LinkTypeEnum linktype, FinInfoCategoria categoria, FinInfoTipo tipo)
{
var parser = new HtmlParser();
var doc = parser.Parse(content);
FinancialInfo finInfo = new FinancialInfo();
finInfo.Categoria = categoria;
finInfo.Tipo = tipo;
IHtmlTableElement table = null;
if (linktype == DocLinkInfo.LinkTypeEnum.Bovespa)
{
var div = doc.QuerySelector("div.ScrollMaker");
if (div == null)
{
var scripts = doc.QuerySelectorAll("script");
if (scripts.Any(s => s.TextContent.Contains("Não Possui Dados para Carregar a Página")))
{
// dado não existe
return(null);
}
}
table = div.FirstElementChild as IHtmlTableElement;
//table anterior a table é a linha que contém o multiplicador
var multiplierText = div.PreviousElementSibling.TextContent;
if (multiplierText.Contains("Mil"))
{
finInfo.Multiplicador = 1000;
}
}
else //cvm
{
var title = doc.QuerySelector("#TituloTabelaSemBorda");
if (title.TextContent.Contains("Reais Mil"))
{
finInfo.Multiplicador = 1000;
}
table = title.NextElementSibling as IHtmlTableElement;
if (table.InnerHtml.Contains("Justificativa para a não prestação da informação"))
{
// dado não existe
return(null);
}
}
foreach (var row in table.Rows)
{
bool isTopLine = false;
if (linktype == DocLinkInfo.LinkTypeEnum.Bovespa)
{
isTopLine = row.GetAttribute("valign") == "top";
}
else
{
isTopLine = row.Cells[0].TextContent.Trim() == "Conta";
}
if (isTopLine) // linha de título
{
// pega a data da terceira célula
// Valor do Trimestre Atual 01/04/2009 a 30/06/2009
var text = row.Cells[2].TextContent;
var iUltimoNum = text.LastIndexOfNum();
var start = iUltimoNum - 9;
var datetext = text.Substring(start, 10).Trim();
finInfo.Data = DateTime.ParseExact(datetext, "dd/MM/yyyy", new CultureInfo("pt-BR"));
}
else
{
var codconta = row.Cells[0].TextContent;
var nomeconta = row.Cells[1].TextContent;
var valortext = row.Cells[2].TextContent;
FinancialItem item = new FinancialItem();
item.Conta = codconta.Trim();
item.Nome = nomeconta.Trim();
item.Valor = ParseValor(valortext.Trim());
finInfo.Items.Add(item);
}
}
return(finInfo);
}