public async Task <ResultModel> Post(TransferRecord record)
{
var result = new ResultModel();
var accessToken = Request.Headers["Authorization"];
var user = await _TokenGetUserHelper.GetUser(accessToken);
try
{
record.CreateDate = DateTime.Now.ToLocalTime();
_context.TransferRecords.Add(record);
result.IsSuccess = true;
result.Message = "添加轉帳紀錄成功.";
await _context.SaveChangesAsync();
result.Data = new { record.Id };
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = "DB ERROR";
}
logger.Info("userId=" + user.Id + ", username="******"\nCreate " + "TransferRecord id= " + record.Id + " " + result.Message);
return(result);
}
public async Task <ResultModel> Post([FromBody] Friend f)
{
var result = new ResultModel();
result.Message = f.Name;
var query = from o in _context.Friends
where o.Name == f.Name
select o;
if (query.Count() > 0)
{
result.IsSuccess = false;
result.Message = f.Name + " exist.";
return(result);
}
var queryCity = _context.Cities.Include(c => c.TownShips).FirstOrDefault(c => c.Id == f.CityId);
if (queryCity == null)
{
result.IsSuccess = false;
result.Message = "CityId not exist.";
return(result);
}
var queryTownships = queryCity.TownShips.FirstOrDefault(t => t.Id == f.TownshipId);
if (queryTownships == null)
{
result.IsSuccess = false;
result.Message = "TownshipId not exist.";
return(result);
}
try
{
await _context.Friends.AddAsync(f);
result.IsSuccess = true;
result.Message = "添加友宮成功";
await _context.SaveChangesAsync();
result.Data = new {
Id = f.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="******"\n Create " + "Friends id= " + f.Id + ", name=" + f.Name + " successfully.");
return(result);
}
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 async Task <ResultModel> Post([FromBody] member n)
{
member newMember = new member();
newMember = n;
var result = new ResultModel();
ResultModel checkMemberResult = CheckMember(newMember, "IsDuplicate");
var accessToken = Request.Headers["Authorization"];
var user = await _TokenGetUserHelper.GetUser(accessToken);
if (checkMemberResult.IsSuccess)
{
/// <summary>
///註冊日期
///
newMember.CreateDate = DateTime.Now.ToLocalTime().ToString();
try
{
await _context.members.AddAsync(newMember);
result.Data = n.MemberId.ToString();
result.IsSuccess = true;
result.Message = "會員添加成功.";
await _context.SaveChangesAsync();
result.Data = new
{
MemberId = newMember.MemberId
};
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = "DB ERROR";
logger.Warn("userId=" + user.Id + ", username="******"\nCreate " + "member id= " + newMember.MemberId + ", name=" + n.Name + " " + result.Message);
return(result);
}
}
else
{
//checkMemberResult fail
result = checkMemberResult;
}
logger.Info("userId=" + user.Id + ", username="******"\nCreate " + "member id= " + newMember.MemberId + ", name=" + n.Name + " " + result.Message);
return(result);
}
public async Task <ResultModel> Post(ToDoListItem model)
{
var result = new ResultModel();
model.CreatedDate = DateTime.Now;
_context.ToDoLists.Add(model);
try
{
await _context.SaveChangesAsync();
}
catch (Exception e)
{
result.IsSuccess = false;
result.Message = e.Message;
return(result);
}
result.IsSuccess = true;
result.Data = new { model.Id, model.Subject };
result.Message = "新增成功";
return(result);
}
public async Task <ResultModel> Post(FinancialRecord record)
{
var result = new ResultModel();
var existFinancialItem = _context.FinancialItems.FirstOrDefault(a => a.Id == record.FinancialItemId);
if (record.FinancialItemId == 57 || record.FinancialItemId == 75)
{
//計算xx燈剩餘位子數量
int max_Light = 666;
if (record.Position > max_Light / 2)
{
result.IsSuccess = false;
result.Message = "位置最多為" + max_Light / 2;
return(result);
}
var existPosition = _context.FinancialRecords
.Where(a => a.FinancialItemId == record.FinancialItemId)
.Where(a => a.Position == record.Position)
.Where(a => a.DueDate > DateTime.Now);
if (existPosition.Count() > 0)
{
result.IsSuccess = false;
result.Message = "位置已佔用,請重新選擇";
return(result);
}
}
try
{
NotifyModel notify = new NotifyModel();
notify.CreateDate = DateTime.Now;
notify.IsRead = false;
notify.ItemName = existFinancialItem.Name;
notify.MemberName = record.CustomerName;
_context.Notification.Add(notify);
record.CreateDate = DateTime.Now.ToLocalTime();
_context.FinancialRecords.Add(record);
result.IsSuccess = true;
result.Message = "添加紀錄成功.";
await _context.SaveChangesAsync();
result.Data = new
{
Id = record.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="******"\n Create " + "FinancialRecord id= " + record.Id + " successfully.");
return(result);
}
public async Task <ResultModel> Post([FromBody] BorrowViewModel b)
{
ResultModel result = new ResultModel();
RitualMoneyRecord record = new RitualMoneyRecord();
if (!string.IsNullOrEmpty(b.Name))
{
b.Name = b.Name.Trim().ToUpper();
}
var query = from m in _context.members
where (string.IsNullOrEmpty(b.Name) ? true : m.Name.ToUpper() == (b.Name)) &&
(string.IsNullOrEmpty(b.Identity) ? true : m.Identity == b.Identity)
select m;
//查無會員
if (query.Count() == 0)
{
result.IsSuccess = false;
result.Message = "查無資料.";
return(result);
}
//查詢到多筆同名會員
if (query.Count() > 1)
{
result.IsSuccess = false;
result.Message = "查詢到多筆同名會員";
return(result);
}
//
var recordQuery = from o in _context.RitualMoneyRecords
where (o.MemberId == query.SingleOrDefault().MemberId) &&
(o.IsReturn == false)
select o;
if (recordQuery.Count() > 0)
{
result.IsSuccess = false;
result.Message = "尚有未還願的借用紀錄";
return(result);
}
try
{
var member = query.SingleOrDefault();
record.MemberId = member.MemberId;
record.BorrowDate = DateTime.Now.ToLocalTime();
record.BorrowAmount = b.BorrowAmount;
//_context.RitualMoneyRecords.Add(record);
await _context.RitualMoneyRecords.AddAsync(record);
await _context.SaveChangesAsync();
result.IsSuccess = true;
result.Message = "借用發財金成功.";
}
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 " + "RitualMoney id= " + record.RitualMoneyRecordId +" successfully.");
return(result);
}