public IActionResult Post([FromBody] Bank_Account bank_Account)
{
if (ModelState.IsValid)
{
if (bank_Account.race_id == null)
{
return(BadRequest());
}
if (bank_Account.owner_id == null)
{
return(BadRequest());
}
if (bank_Account.race_id == null)
{
return(BadRequest());
}
try
{
dataBaseHandler.insertDataBase(DataBaseConstants.bank_account,
"number_account, owner_id, race_id",
bank_Account.number_account + "','" +
bank_Account.owner_id + "','" +
bank_Account.race_id + "'");
return(Ok());
}
catch { }
}
return(BadRequest());
}
public ActionResult CreateAccountBank([DataSourceRequest] DataSourceRequest request, Bank_Account b)
{
if (b != null && ModelState.IsValid)
{
try
{
Bank_Account ba = Bank_Account.Get_BankAccounts(b.BankAccountNumber, b.BankBranchID);
if (ba == null)
{
b.UserName = User.Identity.Name;
b.CreatedUser = User.Identity.Name;
b.CreatedDatetime = DateTime.Now;
b.Save();
return(Json(new { success = true }));
}
else
{
ModelState.AddModelError("Bank Account", " Bank Account is exist");
return(Json(new[] { b }.ToDataSourceResult(request, ModelState)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "");
return(Json(new[] { b }.ToDataSourceResult(request, ModelState)));
}
}
return(Json(new { success = true }));
}
public ActionResult ReadAccountBank([DataSourceRequest] DataSourceRequest request)
{
var u = new Users();
u.UserName = User.Identity.Name;
return(Json(Bank_Account.Get_BankAccounts(u.UserName).ToDataSourceResult(request)));
}
public IActionResult Put(string number_account, [FromBody] Bank_Account bank_Account)
{
try
{
string attribsToModify = "number_account = '" + bank_Account.number_account;
if (number_account.Equals(bank_Account.number_account))
{
if (bank_Account.owner_id != null)
{
if (!((bank_Account.owner_id).Equals("")))
{
attribsToModify = attribsToModify + "', owner_id = '" + bank_Account.owner_id;
}
}
if (bank_Account.race_id != null)
{
if (!((bank_Account.race_id).Equals("")))
{
attribsToModify = attribsToModify + "', race_id = '" + bank_Account.race_id;
}
}
dataBaseHandler.updateDataBase(DataBaseConstants.bank_account, attribsToModify + "'", "number_account = '" + bank_Account.number_account + "'");
return(Ok());
}
}
catch { }
return(BadRequest());
}
public Task <BaseResponse> Add(BankAccountAddRequest request)
{
var response = new BaseResponse();
TryCatch(() =>
{
var bankAccount = bankAccountService.GetAllBankAccounts();
var arrBankAccount = bankAccount.Select(x => x.BankAccount).ToArray();
if (arrBankAccount.Contains(request.BankAccount))
{
throw new ErrorCodeException(ErrorCodeDefine.CHECK_BANK_ACCOUNT);
}
var model = new Bank_Account();
model.BankAccount = request.BankAccount;
model.BankName = request.BankName;
model.Branch = request.Branch;
model.Address = request.Address;
model.Province = request.Province;
model.Owner = request.Owner;
model.Note = request.Note;
bankAccountService.Add(model);
unitOfWork.Commit();
response.Successful();
}, response);
return(Task.FromResult(response));
}
public ActionResult UpdateAccountBank([DataSourceRequest] DataSourceRequest request, Bank_Account b)
{
if (b != null && ModelState.IsValid)
{
Bank_Account ba = Bank_Account.CheckExist(b.BankAccountNumber, b.BankBranchID, b.ID);
if (ba == null)
{
try
{
b.UserName = User.Identity.Name;
b.LastUpdatedUser = User.Identity.Name;
b.LastUpdatedDateTime = DateTime.Now;
b.Update();
return(Json(new { success = true }));
}
catch (Exception ex)
{
ModelState.AddModelError("BankAccountNumber", "BankAccountNumber is already existed");
return(Json(new[] { b }.ToDataSourceResult(request, ModelState)));
}
}
else
{
ModelState.AddModelError("Bank Account", " Bank Account is exist");
return(Json(new[] { b }.ToDataSourceResult(request, ModelState)));
}
}
return(Json(new[] { b }.ToDataSourceResult(request, ModelState)));
}
public ActionResult DeleteConfirmed(int id)
{
Bank_Account bank_Account = db.Bank_Account.Find(id);
db.Bank_Account.Remove(bank_Account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "bank_account_id,bank_name,account_number,branch_name,swift_code")] Bank_Account bank_Account)
{
if (ModelState.IsValid)
{
db.Entry(bank_Account).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank_Account));
}
public ActionResult Edit([Bind(Include = "Id,AccNo,AssetId,OpenDate,CloseDate")] Bank_Account bank_Account)
{
if (ModelState.IsValid)
{
//创建instance
db.Entry(bank_Account).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank_Account));
}
public ActionResult Create([Bind(Include = "Id,AccNo,AssetId,OpenDate,CloseDate")] Bank_Account bank_Account)
{
if (ModelState.IsValid)
{
db.Bank_Account.Add(bank_Account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank_Account));
}
public ActionResult Create([Bind(Include = "bank_account_id,bank_name,account_number,branch_name,swift_code")] Bank_Account bank_Account)
{
if (ModelState.IsValid)
{
db.Bank_Accounts.Add(bank_Account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank_Account));
}
public static void Save(Bank_Account ba)
{
if (isTableCreated())
{
con = new MySqlConnection(conString);
cmd = con.CreateCommand();
cmd.CommandText = "UPDATE INTO BankData money=@money WHERE Owner=@owner";
con.Open();
cmd.Parameters.AddWithValue("@money", ba.money);
cmd.Parameters.AddWithValue("@owner", ba.owner.p.name);
cmd.ExecuteNonQuery();
}
}
public static void loadBanks()
{
con = new MySqlConnection(conString);
cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM BankData";
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
Account a = methods.getMethods.getAccountByName(reader.GetString("Owner"));
int number = reader.GetInt32("money");
Bank_Account ba = new Bank_Account(a, number);
}
}
// GET: Account/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Bank_Account bank_Account = db.Bank_Account.Find(id);
if (bank_Account == null)
{
return(HttpNotFound());
}
return(View(bank_Account));
}
public Bank_Account getBank_Account(string number_account)
{
Bank_Account bank_Account = new Bank_Account();
try
{
NpgsqlDataReader reader = dataBaseHandler.getSingleRecord(DataBaseConstants.bank_account, "number_account", number_account);
while (reader.Read())
{
bank_Account.race_id = (string)reader["race_id"];
bank_Account.owner_id = (string)reader["owner_id"];
bank_Account.number_account = (string)reader["number_account"];
}
}
catch { }
return(bank_Account);
}
public static Bank_Account createAccount(Account owner)
{
if (isTableCreated())
{
int price = 0;
int count = methods.getMethods.getBanksByUser(owner).Count;
price = getPrice(count);
con = new MySqlConnection(conString);
cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO BankData (money,Owner,price) VALUES (@money,@owner)";
con.Open();
cmd.Parameters.AddWithValue("@money", 0);
cmd.Parameters.AddWithValue("@owner", owner.p.name);
cmd.ExecuteNonQuery();
Bank_Account ba = new Bank_Account(owner, Convert.ToInt16(cmd.LastInsertedId));
con.Close();
return(ba);
}
return(null);
}
public void bnk_cmd(Client p, int kntNR)
{
Boolean isatBank = false;
foreach (Vector3 pos in mysql.MySQL_POIData.getBanks())
{
if (pos.DistanceTo(p.position) < 5)
{
isatBank = true;
}
}
if (isatBank == true)
{
Account a = methods.getMethods.getAccountByClient(p);
Bank_Account ba = methods.getMethods.getBankByNumber(kntNR);
if (ba == null)
{
API.sendChatMessageToPlayer(p, "Konto nicht gefunden.");
loggers.logger_usercmd.log_cmd(p, "bank", kntNR, 2);
}
else if (ba.owner != a)
{
loggers.logger_usercmd.log_cmd(p, "bank", kntNR, 3);
API.sendChatMessageToPlayer(p, "Du hast keinen Zugriff auf das Konto");
}
else
{
loggers.logger_usercmd.log_cmd(p, "bank", kntNR, 1);
API.triggerClientEvent(p, "BankMenu", ba.money, ba.number);
}
}
else
{
API.sendChatMessageToPlayer(p, "Du bist bei keiner Bank");
loggers.logger_usercmd.log_cmd(p, "bank", kntNR, 4);
}
}
public void bnkacc_create_cmd(Client p)
{
Boolean isatBank = false;
foreach (Vector3 pos in mysql.MySQL_POIData.getBanks())
{
if (pos.DistanceTo(p.position) < 5)
{
isatBank = true;
}
}
if (isatBank == true)
{
Account a = methods.getMethods.getAccountByClient(p);
Bank_Account ba = mysql.MySQL_Bank.createAccount(a);
API.sendChatMessageToPlayer(p, "Bankkonto erfogreich erstellt. Kontonummer: " + ba.number);
loggers.logger_usercmd.log_cmd(p, "createbankaccount", ba.number, 1);
}
else
{
API.sendChatMessageToPlayer(p, "Du bist bei keiner Bank");
loggers.logger_usercmd.log_cmd(p, "createbankaccount", "00000", 2);
}
}
public void Update(Bank_Account bank_Account)
{
bankAccountRepository.Update(bank_Account);
}
public void Add(Bank_Account bank_Account)
{
bankAccountRepository.Add(bank_Account);
}
public void Delete(Bank_Account bank_Account)
{
bankAccountRepository.Delete(bank_Account);
}
public void API_onClientEventTrigger(Client p, string eventName, params object[] arguments)
{
switch (eventName)
{
case "setSkin":
mysql.MySQL_PlayerData.set(p, "skin", arguments[0].ToString());
PedHash pedhash = API.pedNameToModel(arguments[0].ToString());
API.setPlayerSkin(p, pedhash);
API.setEntityDimension(p, 0);
API.setEntityInvincible(p, false);
p.freeze(false);
API.triggerClientEvent(p, "resetCamera");
API.sendChatMessageToPlayer(p, methods.stringMethods.success_skin);
API.setEntityData(p, "status", "INGAME");
break;
case "Einzahlen":
Bank_Account ba = methods.getMethods.getBankByNumber(Convert.ToInt32(arguments[0].ToString()));
string amount = arguments[1].ToString();
int am = Convert.ToInt32(amount);
Account a = methods.getMethods.getAccountByClient(p);
if (a.money >= am)
{
ba.money += am;
a.money -= am;
}
else
{
API.sendChatMessageToPlayer(p, "Du hast zu wenig Geld zum Einzahlen");
}
break;
case "Auszahlen":
Bank_Account ba2 = methods.getMethods.getBankByNumber(Convert.ToInt32(arguments[0].ToString()));
string amount2 = arguments[0].ToString();
int am2 = Convert.ToInt32(amount2);
Account a2 = methods.getMethods.getAccountByClient(p);
if (ba2.money >= am2)
{
ba2.money -= am2;
a2.money += am2;
}
else
{
API.sendChatMessageToPlayer(p, "Du hast zu wenig Geld zum Auszahlen");
}
break;
case "Ueberweisen":
Bank_Account ba3 = methods.getMethods.getBankByNumber(Convert.ToInt32(arguments[0].ToString()));
Bank_Account empf = methods.getMethods.getBankByNumber(Convert.ToInt32(arguments[2].ToString()));
int amoun = Convert.ToInt16(arguments[1].ToString());
if (empf != null)
{
if (ba3.money >= amoun)
{
ba3.money -= amoun;
empf.money += amoun;
}
else
{
API.sendChatMessageToPlayer(p, "Dein Bankkonto hat nicht genung Geld");
}
}
else
{
API.sendChatMessageToPlayer(p, "Dieses Konto gibt es nicht");
}
break;
case "VehicleBuy":
Account a3 = methods.getMethods.getAccountByClient(p);
char te = ':';
string car = arguments[0].ToString();
string name = car.Split(te).First();
int price = Convert.ToInt32(car.Split(te).Last());
Vector3 carSP = mysql.MySQL_POIData.getShopSpawn(p.position);
Vector3 carRT = mysql.MySQL_POIData.getShopSpawnRot(p.position);
if (a3.money >= price)
{
a3.money -= price;
mysql.MySQL_Vehicles.createVehicle(a3, car, carSP, carRT);
}
break;
}
}
