public IEnumerable <CommissionDto> GetCommissions()
{
try
{
List <Commission> commissions = new List <Commission>();
List <CommissionDto> commisionDto = new List <CommissionDto>();
List <Member> members = new List <Member>();
CommissionDto commis;
Address address = new Address();
commissions = _context.Commission.ToList();
members = _context.Member.Include("user").ToList();
foreach (Commission co in commissions)
{
commis = new CommissionDto(co.Id, co.code, co.libelle);
foreach (Member member in members)
{
if (co.Id == member.commissionId)
{
commis.members.Add(new User(member.user.firstName, member.user.lastName, member.user.date, member.user.mail, member.user.numberTel, member.user.password, member.user.type, address));
}
}
commisionDto.Add(commis);
}
return(commisionDto);
}
catch (Exception e)
{
Debug.WriteLine(e.Message + e.StackTrace);
throw;
}
}
/// <summary>
/// 转换为佣金实体
/// </summary>
/// <param name="dto">佣金数据传输对象</param>
public static Commission ToEntity(this CommissionDto dto)
{
if (dto == null)
{
return(new Commission());
}
return(dto.MapTo(new Commission(dto.Id.ToGuid())));
}
public async Task CreateCurrency(string name, CommissionDto dto)
{
var currency = new CurrencyRecord {
Name = name
};
await _context.Currencies.AddAsync(currency);
await _context.SaveChangesAsync();
var deposit = CommissionManager.CreateCommission(currency.Id, dto, OperationType.Deposit);
var transfer = CommissionManager.CreateCommission(currency.Id, dto, OperationType.Transfer);
var withdrawal = CommissionManager.CreateCommission(currency.Id, dto, OperationType.Withdrawal);
await _context.Commissions.AddRangeAsync(deposit, transfer, withdrawal);
await _context.SaveChangesAsync();
}
public bool addCommission(CommissionDto commission)
{
try
{
Commission newCommission = new Commission(commission.code, commission.libelle);
Console.WriteLine(newCommission);
foreach (User member in commission.members)
{
_context.User.Find(member.Id).member.Add(new Member(newCommission, member));
}
_context.SaveChanges();
return(true);
}
catch (Exception e)
{
Debug.WriteLine(e.Message + e.StackTrace);
throw;
}
}
public static CommissionRecord CreateCommission(int currencyId, CommissionDto commissionDto,
OperationType type, string userId = null)
{
var commission = new CommissionRecord
{
CurrencyId = currencyId, Type = commissionDto.Type, OperationType = type,
MaxValue = commissionDto.MaxOperationValue, UserId = userId
};
if (commissionDto.Type == CommissionType.Absolute)
{
commission.Value = commissionDto.Value;
}
else
{
commission.Rate = commissionDto.Rate;
commission.MinCommission = commissionDto.MinimalCommission;
commission.MaxCommission = commissionDto.MaximalCommission;
}
return(commission);
}
public bool Post([FromBody] CommissionDto commission)
{
Console.WriteLine(commission);
return(commissionRepository.addCommission(commission));
}
public static Task <List <CommissionDto> > ReadCommision(IFormFile file, string fileName, int companyId)
{
if (!string.IsNullOrEmpty(fileName))
{
fileName += Guid.NewGuid().ToString() + ".xlsx";
}
using (FileStream fileStream = System.IO.File.Create(fileName))
{
file.CopyTo(fileStream);
fileStream.Flush();
}
var commmisions = new List <CommissionDto>();
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
using (var stream = System.IO.File.Open(fileName, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
while (reader.Read())
{
if (reader.Depth == 0)
{
continue;
}
//commmisions.Add(new CommissionDto()
//{
// TransactionId = reader.GetValue(0) != null ? reader.GetValue(0).ToString() : "",
// ProcessType = reader.GetValue(1) != null ? reader.GetValue(1).ToString() : "",
// OrderNumber = reader.GetValue(2) != null ? reader.GetValue(2).ToString() : "",
// OdemeStatus = reader.GetValue(5) != null ? reader.GetValue(5).ToString() : "",
// ProcessDate = reader.GetValue(6) != null ? Convert.ToDateTime(reader.GetValue(6)) : new DateTime(),
// Seller = reader.GetValue(7) != null ? reader.GetValue(7).ToString() : "",
// VendorCurrentName = reader.GetValue(8) != null ? reader.GetValue(8).ToString() : "",
// ProductName = reader.GetValue(9) != null ? reader.GetValue(9).ToString() : "",
// Barcode = reader.GetValue(10) != null ? reader.GetValue(10).ToString() : "",
// CommissionRate = Convert.ToDouble(reader.GetValue(17)),
// TYProgressPayment = Convert.ToDouble(reader.GetValue(17)),
// SellerProgressPayment = Convert.ToDouble(reader.GetValue(17)),
// TermTime = Convert.ToInt32(reader.GetValue(18)),
// AgreeDate = reader.GetValue(6) != null ? Convert.ToDateTime(reader.GetValue(6)) : new DateTime(),
// ShippingDate = reader.GetValue(6) != null ? Convert.ToDateTime(reader.GetValue(6)) : new DateTime(),
// TermDate = reader.GetValue(6) != null ? Convert.ToDateTime(reader.GetValue(6)) : new DateTime(),
// CommissionInvoiceNumber = reader.GetValue(10) != null ? reader.GetValue(10).ToString() : "",
// TotalAmount = Convert.ToDouble(reader.GetValue(17))
//});
var commission = new CommissionDto();
commission.CompanyId = companyId;
commission.TransactionId = reader.GetValue(0) != null?reader.GetValue(0).ToString() : "";
commission.ProcessType = reader.GetValue(1) != null?reader.GetValue(1).ToString() : "";
commission.OrderNumber = reader.GetValue(2) != null?reader.GetValue(2).ToString() : "";
commission.OrderDate = !string.IsNullOrEmpty(reader.GetValue(3)?.ToString()) ? Convert.ToDateTime(reader.GetValue(3)) : new DateTime();
commission.OdemeStatus = reader.GetValue(4) != null?reader.GetValue(4).ToString() : "";
commission.ProcessDate = !string.IsNullOrEmpty(reader.GetValue(5)?.ToString()) ? Convert.ToDateTime(reader.GetValue(5)) : new DateTime();
commission.Seller = reader.GetValue(6) != null?reader.GetValue(6).ToString() : "";
commission.VendorCurrentName = reader.GetValue(7) != null?reader.GetValue(7).ToString() : "";
commission.ProductName = reader.GetValue(8) != null?reader.GetValue(8).ToString() : "";
commission.Barcode = reader.GetValue(9) != null?reader.GetValue(9).ToString() : "";
commission.CommissionRate = Convert.ToDouble(reader.GetValue(10));
commission.TYProgressPayment = Convert.ToDouble(reader.GetValue(11));
commission.SellerProgressPayment = Convert.ToDouble(reader.GetValue(12));
commission.TermTime = Convert.ToInt32(reader.GetValue(13));
commission.AgreeDate = !string.IsNullOrEmpty(reader.GetValue(14)?.ToString()) ? Convert.ToDateTime(reader.GetValue(14)) : new DateTime();
commission.Deliverydate = !string.IsNullOrEmpty(reader.GetValue(15)?.ToString()) ? Convert.ToDateTime(reader.GetValue(15)) : new DateTime();
commission.TermDate = !string.IsNullOrEmpty(reader.GetValue(16)?.ToString()) ? Convert.ToDateTime(reader.GetValue(16)) : new DateTime();
commission.CommissionInvoiceNumber = reader.GetValue(17) != null?reader.GetValue(17).ToString() : "";
commission.TotalAmount = Convert.ToDouble(reader.GetValue(18));
commission.Name = reader.GetValue(19) != null?reader.GetValue(19).ToString() : "";
commission.Surname = reader.GetValue(20) != null?reader.GetValue(20).ToString() : "";
commission.ShippingDate = !string.IsNullOrEmpty(reader.GetValue(21)?.ToString()) ? Convert.ToDateTime(reader.GetValue(21)) : new DateTime();
commmisions.Add(commission);
}
}
}
// model doldurulduktan sonra file delete
System.IO.File.Delete(fileName);
return(Task.FromResult(commmisions));
}
