public static void MapTo(this Trader trader, TraderModel traderModel)
{
if (trader == null)
{
throw new ArgumentNullException(nameof(trader));
}
if (traderModel == null)
{
throw new ArgumentNullException(nameof(traderModel));
}
traderModel.Id = trader.Id;
traderModel.Name = trader.Name;
traderModel.LegacyForm = trader.LegacyForm;
traderModel.IdentityNumber = trader.IdentityNumber;
traderModel.ApplicantName = trader.ApplicantName;
traderModel.ParticipantName = trader.ParticipantName;
traderModel.ParticipantStatus = trader.ParticipantStatus;
traderModel.PhoneNumber = trader.PhoneNumber;
traderModel.Email = trader.Email;
traderModel.BankName = trader.BankName;
traderModel.BankAccountNumber = trader.BankAccountNumber;
traderModel.Swift = trader.Swift;
traderModel.AuctionDate = trader.AuctionDate;
}
public async Task <TraderModel> EditTrader(TraderModel trader)
{
if (trader == null)
{
throw new ArgumentNullException(nameof(trader));
}
using (var db = new AuctionContext())
{
var traderEntity = db.Traders.FirstOrDefault(t => t.Id == trader.Id);
if (traderEntity == null)
{
return(null);
}
traderEntity.LegacyForm = trader.LegacyForm;
traderEntity.IdentityNumber = trader.IdentityNumber;
traderEntity.ApplicantName = trader.ApplicantName;
traderEntity.ParticipantName = trader.ParticipantName;
traderEntity.ParticipantStatus = trader.ParticipantStatus;
traderEntity.PhoneNumber = trader.PhoneNumber;
traderEntity.Email = trader.Email;
traderEntity.BankName = trader.BankName;
traderEntity.BankAccountNumber = trader.BankAccountNumber;
traderEntity.Swift = trader.Swift;
traderEntity.AuctionDate = trader.AuctionDate;
await db.SaveChangesAsync();
return(trader);
}
}
public TraderModel Add(TraderModel newItem)
{
if (newItem == null)
{
Console.WriteLine("Item Is null in TraderRepo.");
return(null);
}
sqlConnection.Open();
string sql = "Insert into dbo.Traders values(@Trader_ID,@FirtsName,@LastName, @Addr, @Rating ,@Photo)";
Console.WriteLine(sql);
using (SqlCommand cmd = new SqlCommand(sql, sqlConnection))
{
cmd.Parameters.Add("@Trader_ID", SqlDbType.VarChar, 20).Value = newItem.ID;
cmd.Parameters.Add("@FirtsName", SqlDbType.NVarChar).Value = newItem.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = newItem.LastName;
cmd.Parameters.Add("@Addr", SqlDbType.NVarChar).Value = newItem.Address.ID;
cmd.Parameters.Add("@Rating", SqlDbType.NVarChar).Value = newItem.rating;
cmd.Parameters.Add("@Photo", SqlDbType.VarBinary).Value = newItem.Photo;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
sqlConnection.Close();
return(newItem);
}
public async Task <TraderModel> AddTrader(TraderModel trader)
{
if (trader == null)
{
throw new ArgumentNullException(nameof(trader));
}
using (var db = new AuctionContext())
{
var traderEntity = new Trader()
{
Name = trader.Name,
LegacyForm = trader.LegacyForm,
IdentityNumber = trader.IdentityNumber,
ApplicantName = trader.ApplicantName,
ParticipantName = trader.ParticipantName,
ParticipantStatus = trader.ParticipantStatus,
PhoneNumber = trader.PhoneNumber,
Email = trader.Email,
BankName = trader.BankName,
BankAccountNumber = trader.BankAccountNumber,
Swift = trader.Swift,
AuctionDate = trader.AuctionDate
};
db.Traders.Add(traderEntity);
await db.SaveChangesAsync();
trader.Id = traderEntity.Id;
return(trader);
}
}
public SlaveAccountModel(TraderModel masterModel, TradingAccount tradingAccountModel)
: this()
{
//Dimok: Use WeakReference
this.MasterModel = masterModel;
this.TradingAccountModel = tradingAccountModel;
}
public async Task <ActionResult <TraderModel> > PostTraderModel(TraderModel traderModel)
{
_context.TraderModel.Add(traderModel);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTraderModel", new { id = traderModel.TraderId }, traderModel));
}
public async Task <IActionResult> PutTraderModel(Guid id, TraderModel traderModel)
{
if (id != traderModel.TraderId)
{
return(BadRequest());
}
_context.Entry(traderModel).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TraderModelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void CreateModels()
{
shopModel = new ShopModel();
CustomerModel newCustomer = new CustomerModel("Leonard", 300);
newCustomer.AddComponent(new RPGStatsComponent(health: BASE_STATS_VALUE,
mana: BASE_STATS_VALUE, nourishment: BASE_STATS_VALUE, strength: BASE_STATS_VALUE));
customerModel = newCustomer;
}
public ActionResult <Trader> GetTrader(string name)
{
//var z = UserHelpers.GetUsername(User);
//var traderModel = new TraderModel(pandaRepo.GetTraderByName(name));
//return Ok(traderModel);
if (name.ToUpper() == UserHelpers.GetUsername(User).ToUpper())
{
var traderModel = new TraderModel(pandaRepo.GetTraderByName(name));
return(Ok(traderModel));
}
return(Unauthorized());
}
public TraderModel GetById(string id)
{
TraderModel item = null;
int i = 0;
foreach (TraderModel it in TraderCondition("Trader_ID = \'" + id + "\'"))
{
i++;
item = it;
}
Assert.IsTrue(item != null);
Assert.IsTrue(i == 1);
return(item);
}
public TraderModel Delete(string traderId)
{
TraderModel it = TraderCondition("Trader_ID = \'" + traderId + "\'").First();
sqlConnection.Open();
string sql = "delete from dbo.Traders where Trader_ID = \'" + traderId + "\'";
Console.WriteLine(sql);
using (SqlCommand cmd = new SqlCommand(sql, sqlConnection))
{
cmd.ExecuteNonQuery();
}
sqlConnection.Close();
return(it);
}
private IEnumerable <TraderModel> TraderCondition(string condition)
{
if (!String.IsNullOrEmpty(condition) && !condition.Equals("*"))
{
condition = " where " + condition;
}
else
{
condition = "";
}
Console.WriteLine("Select * from dbo.Traders" + condition);
List <TraderModel> MyList = new List <TraderModel>();
TraderModel curr;
sqlConnection.Open();
var arg = "Select * from dbo.Traders" + condition;
using (var command = new SqlCommand(arg, sqlConnection))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
curr = new TraderModel();
curr.ID = reader["Trader_ID"] as string;
curr.FirstName = reader["FirstName"] as string;
curr.LastName = reader["LastName"] as string;
string address = reader["Addr"] as string;
curr.Address = AddressRepo.GetInstance().GetById(address);
string rating = reader["Rating"] + "";
curr.rating = Double.Parse(rating);
curr.Photo = reader["Photo"] as byte[];
MyList.Add(curr);
}
}
}
sqlConnection.Close();
return(MyList);
}
public static Trader ToTrader(this TraderModel trader)
{
if (trader == null)
{
throw new ArgumentNullException(nameof(trader));
}
return(new Trader()
{
Name = trader.Name,
LegacyForm = trader.LegacyForm,
IdentityNumber = trader.IdentityNumber,
ApplicantName = trader.ApplicantName,
ParticipantName = trader.ParticipantName,
ParticipantStatus = trader.ParticipantStatus,
PhoneNumber = trader.PhoneNumber,
Email = trader.Email,
BankName = trader.BankName,
BankAccountNumber = trader.BankAccountNumber,
Swift = trader.Swift,
AuctionDate = trader.AuctionDate
});
}
public static void SetRandomUser()
{
DefaultTrader = traders[new Random().Next(0, traders.Length)];
}
