public void Test2()
{
Banka banka = new Banka();
Racun racun = banka.DohvatiRacun("HR11");
Assert.AreEqual(racun.IBAN, "HR11");
}
public async Task <IActionResult> PutBanka(int id, Banka banka)
{
if (id != banka.Id)
{
return(BadRequest());
}
_context.Entry(banka).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BankaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static void comenzar(ref Banka banka)
{
bool salir = false;
int opcion;
do
{
InterfazAdminstracion.menu_administracion_cajero();
opcion = CH.leerOpcion(3);
switch (opcion)
{
case 1:
ControladorCajero.ingreso(ref banka);
break;
case 2:
ControladorCajero.reintegro(ref banka);
break;
case 3:
ControladorCliente.mostrarDatosCliente(banka.lista_clientes);
break;
case 0:
salir = true;
break;
}
} while (!salir);
}
private void buttonBankiAC_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
int i = 0;
foreach (var ca in _mladinskaEntities.CLENOVI_A)
{
if (String.IsNullOrWhiteSpace(ca.BANKA))
{
continue;
}
var ca1 = ca;
if (_avtorskaEntities.Banka.Count(b => b.NazivBanka.Contains(ca1.BANKA.Trim())) != 0)
{
continue;
}
var banka = new Banka {
NazivBanka = ca.BANKA
};
_avtorskaEntities.AddToBanka(banka);
_avtorskaEntities.SaveChanges();
i++;
}
Cursor.Current = Cursors.Default;
MessageBox.Show("CLENOVI_A.BANKA => Banka : " + i);
}
public async Task <ActionResult <Banka> > PostBanka(Banka banka)
{
_context.Banka.Add(banka);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetBanka", new { id = banka.Id }, banka));
}
public Banka Update(Banka entity)
{
try
{
SqlCommand komut = new SqlCommand("update Tbl_Banka set BANKAADI=@p1,IL=@p2,ILCE=@p3,SUBE=@p4,TELEFON=@p5,IBAN=@p6,HESAPNO=@p7,YETKILI=@p8,TARIH=@p9,HESAPTURU=@p10,FIRMAID=@p11 where ID=@p12", baglanti.BaglantiDondur());
komut.Parameters.AddWithValue("@p1", entity.BANKAADI);
komut.Parameters.AddWithValue("@p2", entity.IL);
komut.Parameters.AddWithValue("@p3", entity.ILCE);
komut.Parameters.AddWithValue("@p4", entity.SUBE);
komut.Parameters.AddWithValue("@p5", entity.TELEFON);
komut.Parameters.AddWithValue("@p6", entity.IBAN);
komut.Parameters.AddWithValue("@p7", entity.HESAPNO);
komut.Parameters.AddWithValue("@p8", entity.YETKILI);
komut.Parameters.AddWithValue("@p9", entity.TARIH);
komut.Parameters.AddWithValue("@p10", entity.HESAPTURU);
komut.Parameters.AddWithValue("@p11", entity.FIRMAID);
komut.Parameters.AddWithValue("@p12", entity.ID);
komut.ExecuteNonQuery();
baglanti.BaglantiDondur().Close();
return(entity);
}
catch (Exception)
{
return(null);
}
}
public void PlatiCommandExecute()
{
NalogPrenos nalog = new NalogPrenos(
-1,
"test",
SelektovanaFaktura.NazivKupca,
"Svrha placanja",
SelektovanaFaktura.NazivDobavljaca,
DateTime.Now,
DateTime.Now,
racun.BrojRacun,
97,
"poziv",
SelektovanaFaktura.UplataNaRacun,
97,
4464,
SelektovanaFaktura.UkupnoRobeIUsluga,
"RSD",
false
);
Banka banka = DAO.GetBanka(racun.BrojRacun);
ChannelFactory <IBank> factory = new ChannelFactory <IBank>(new NetTcpBinding(), new EndpointAddress("net.tcp://localhost:9000/" + banka.Naziv));
IBank proxy = factory.CreateChannel();
try
{
proxy.SendNalogPrenos(nalog);
}
catch (Exception e)
{ }
}
public static void accion(int accion, ref Banka banka)
{
switch (accion)
{
case 1:
ControladorEmpleado.registrarEmpleado(ref banka);
break;
case 2:
ControladorEmpleado.mostrarDatosEmpleado(banka.lista_empleados);
break;
case 3:
CH.lcd("A MODIFICAR CLIENTE");
CH.pausa();
// MODIFICAR CLIENTE
break;
case 4:
// ELIMINAR CLIENTE
break;
case 5:
// LISTAR TODOS LOS CLIENTES
InterfazDireccion.listarEmpleados(banka.lista_empleados);
break;
}
}
/// <summary>
/// Iz naloga izvlaci sve bitne podatke za sklapanje rtgs naloga
/// </summary>
/// <param name="nzp"></param>
/// <returns></returns>
private RTGSNalog NapraviRTGSIzNaloga(NalogZaPlacanje nzp)
{
string imeFirmeKojaPlaca = nzp.Duznik;
string imeFirmeKojaPrima = nzp.Primalac;
Banka bankaFirmeKojaPlaca = KombinacijeDB.GetBankByFirmName(imeFirmeKojaPlaca);
Banka bankaFirmeKojaPrima = KombinacijeDB.GetBankByFirmName(imeFirmeKojaPrima);
RTGSNalog rtgs = new RTGSNalog();
rtgs.IDPoruke = nzp.IDPoruke;
rtgs.SWIFTBankaDuznika = bankaFirmeKojaPlaca.SWIFTKod;
rtgs.ObracunskiRacunBankeDuznika = bankaFirmeKojaPlaca.ObracunskiRacun.ToString();
rtgs.SWIFTBankaPoverioca = bankaFirmeKojaPrima.SWIFTKod;
rtgs.ObracunskiRacunBankePoverioca = bankaFirmeKojaPrima.ObracunskiRacun.ToString();
rtgs.Duznik = imeFirmeKojaPlaca;
rtgs.SvrhaPlacanja = nzp.SvrhaPlacanja;
rtgs.Primalac = imeFirmeKojaPrima;
rtgs.DatumNaloga = DateTime.Now;
rtgs.DatumValute = DateTime.Now;
rtgs.RacunDuznika = nzp.RacunDuznika;
rtgs.ModelZaduzenja = nzp.ModelZaduzenja;
rtgs.PozivNaBrZaduzenja = nzp.PozivNaBrZaduzenja;
rtgs.RacunPoverioca = nzp.RacunPoverioca;
rtgs.ModelOdobrenja = nzp.ModelOdobrenja;
rtgs.PozivNaBrOdobrenja = nzp.PozivNaBrOdobrenja.ToString("F0");
rtgs.Iznos = nzp.Iznos;
rtgs.SifraValute = nzp.OznakaValute;
return(rtgs);
}
public async Task <ActionResult> CreateAsync(BankaCreateViewModel model)
{
if (ModelState.IsValid)
{
try
{
var addBank = new Banka
{
Emri = model.Emri,
Kodi = model.Kodi
};
var result = await bankRepository.AddAsync(addBank);
alertService.Success("Banka u shtua me sukses!");
return(RedirectToAction("Index"));
}
catch
{
alertService.Danger("Diqka shkoi gabim, provoni perseri!");
return(View(model));
}
}
alertService.Information("Plotesoni te gjitha fushat!");
return(View(model));
}
public static int Update_1_2(Banka banka, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
command.Parameters.AddWithValue("@idBanky", banka.idBanky);
command.Parameters.AddWithValue("@nazev", banka.nazev);
command.Parameters.AddWithValue("@DIC", banka.DIC);
command.Parameters.AddWithValue("@ICO", banka.ICO);
command.Parameters.AddWithValue("@tel", banka.tel);
command.Parameters.AddWithValue("@email", banka.email);
command.Parameters.AddWithValue("@deleted", banka.deleted == null ? DBNull.Value : (object)banka.deleted);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
public Banka Add(Banka entity)
{
try
{
SqlCommand komut = new SqlCommand("insert into Tbl_Banka(BANKAADI,IL,ILCE,SUBE,TELEFON,IBAN,HESAPNO,YETKILI,TARIH,HESAPTURU,FIRMAID) values(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11)", baglanti.BaglantiDondur());
komut.Parameters.AddWithValue("@p1", entity.BANKAADI);
komut.Parameters.AddWithValue("@p2", entity.IL);
komut.Parameters.AddWithValue("@p3", entity.ILCE);
komut.Parameters.AddWithValue("@p4", entity.SUBE);
komut.Parameters.AddWithValue("@p5", entity.TELEFON);
komut.Parameters.AddWithValue("@p6", entity.IBAN);
komut.Parameters.AddWithValue("@p7", entity.HESAPNO);
komut.Parameters.AddWithValue("@p8", entity.YETKILI);
komut.Parameters.AddWithValue("@p9", entity.TARIH);
komut.Parameters.AddWithValue("@p10", entity.HESAPTURU);
komut.Parameters.AddWithValue("@p11", entity.FIRMAID);
komut.ExecuteNonQuery();
baglanti.BaglantiDondur().Close();
return(entity);
}
catch (Exception)
{
return(null);
}
}
public static void comenzar(Banka banka)
{
bool salir = false;
int opcion;
do
{
InterfazAdminstracion.menu_administracion_comercial();
opcion = CH.leerOpcion(3);
switch (opcion)
{
case 1:
ControladorComercial.consultarContratosCliente(banka);
break;
case 2:
ControladorComercial.consultarProductos(banka.lista_productos);
break;
case 3:
ControladorComercial.contratarProductos(ref banka);
break;
case 0:
salir = true;
break;
}
} while (!salir);
}
public static void consultarContratosCliente(Banka banka)
{
// 1. Mostrar clientes con indice
// 2. Elegir clientes
// 3. Mostrar contratos del clientes
int opcion;
int numcli = 0;
if (banka != null)
{
numcli = banka.lista_clientes.Length;
}
if (numcli > 0)
{
InterfazDireccion.listarClientesIndice(banka.lista_clientes);
opcion = InterfazDireccion.pedirCliente(numcli, "Elige un cliente de la lista");
Cliente cliente = banka.lista_clientes[opcion - 1];
if (cliente.lista_contratos != null)
{
InterfazComercial.listarContratos(cliente);
}
else
{
CH.lcd("!> El cliente no tiene ningun contrato");
}
}
else
{
CH.lcd("i> No hay clientes que mostrar!");
}
CH.pausa();
}
public static void accion(int accion, Banka banka)
{
switch (accion)
{
case 1:
ControladorProducto.consultarProducto(banka.lista_productos);
break;
case 2:
ControladorProducto.registrarProducto(ref banka);
break;
case 3:
CH.lcd("A MODIFICAR CLIENTE");
CH.pausa();
// MODIFICAR CLIENTE
break;
case 4:
// ELIMINAR CLIENTE
break;
case 5:
// LISTAR TODOS LOS CLIENTES
ControladorProducto.listarProductos(banka.lista_productos);
break;
}
}
static void Main(string[] args)
{
Banka b = new Banka();
Klijent k = new Klijent("Muhamed");
b.RadSaKlijentomIRačunima(k, 1);
Console.WriteLine("Nakon dodavanja klijenta, broj klijenata banke je " + b.DajBrojKlijenata());
k.Ime = "Adnan";
b.RadSaKlijentomIRačunima(k, 3);
Console.WriteLine("Nakon promjene informacija klijenta, broj klijenata banke je " + b.DajBrojKlijenata());
Klijent pronađeni = b.DajKlijenta(k.ID1);
Console.WriteLine("Pronađeni klijent ima ID " + pronađeni.ID1 + " i ime " + pronađeni.Ime);
b.RadSaKlijentomIRačunima(k, 2);
Console.WriteLine("Nakon brisanja klijenta, broj klijenata banke je " + b.DajBrojKlijenata());
Račun r1 = new Račun();
PrivremeniRačun r2 = new PrivremeniRačun();
r1.PromijeniStanjeRačuna(-100);
r2.PromijeniStanjeRačuna(200);
Console.WriteLine("Stanje računa 1: " + r1.Iznos + ", Stanje računa 2: " + r2.Iznos);
b.RadSaKlijentomIRačunima(k, 1);
b.RadSaKlijentomIRačunima(r1, 1);
b.RadSaKlijentomIRačunima(r2, 1);
Console.WriteLine(b.DajSveKlijenteIRačune());
}
public void Test3()
{
Banka banka = new Banka();
Racun racun = banka.DohvatiRacun("HR44");
Assert.IsTrue(racun.IBAN == "HR44");
}
public ActionResult DeleteConfirmed(int id)
{
Banka banka = db.Banka.Find(id);
db.Banka.Remove(banka);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AdminView(FormCollection banka)
{
PopuniSifreBanaka1();
PopuniSifreBanaka();
PopuniStatuseBanaka();
PopuniVrsteBanaka();
PopuniLicence();
PopuniSifrebanakaVlasnickeStrukture();
if (ModelState.IsValid)
{
Licenca l = new Licenca();
l.DatumLicence = DateTime.Now;
l.StatusLicence = 1;
Random r = new Random();
l.LicencaID = r.Next();
Admin.GenerisiLicencuId(l);
Banka nov = new Banka();
nov.Naziv = banka["Naziv"];
nov.Sediste = banka["Sediste"];
nov.GodinaOsnivanja = int.Parse(banka["GodinaOsnivanja"]);
if (String.IsNullOrEmpty(banka["GodisnjiProfit"]))
{
nov.Godisnjiprofit = null;
}
else
{
nov.Godisnjiprofit = decimal.Parse(banka["GodisnjiProfit"], System.Globalization.CultureInfo.InvariantCulture);//dodato da bi parsirao kako treba jer inace je brojeve predstavljao kao int
}
if (String.IsNullOrEmpty(banka["UkupnaAktivaiUkupniDug"]))
{
nov.UkupnaAktivaiUkupniDug = null;
}
else
{
nov.Godisnjiprofit = decimal.Parse(banka["UkupnaAktivaiUkupniDug"], System.Globalization.CultureInfo.InvariantCulture);
}
nov.LicencaID = l.LicencaID;
nov.Vlasnistvo = banka["Vlasnistvo"];
nov.VrstaID = int.Parse(banka["VrstaBanke"]);
nov.StatusID = int.Parse(banka["StatusBanke"]);
nov.BankaID = r.Next();
Admin.DodajBanku(nov);
VlasnickaStrukturaBanke vlasnistvo = new VlasnickaStrukturaBanke();
vlasnistvo.BankaID = nov.BankaID;
vlasnistvo.VlasniciBanke = null;
vlasnistvo.Procenat = null;
Admin.DodajVlasnistvo(vlasnistvo);
TempData["Naziv"] = nov.Naziv;
TempData["Vlasnistvo"] = nov.Vlasnistvo;
return(RedirectToAction("AdminView"));
}
return(View());
}
public static void accion(int accion, ref Banka banka)
{
bool salir = false;
int opcion;
do
{
switch (accion)
{
case 1:
InterfazDireccion.mostrar_menu_clientes();
opcion = CH.leerOpcion(5);
if (opcion == 0)
{
salir = true;
}
else
{
ControladorCliente.accion(opcion, ref banka);
}
break;
case 2:
InterfazDireccion.mostrar_menu_empleados();
opcion = CH.leerOpcion(5);
if (opcion == 0)
{
salir = true;
}
else
{
ControladorEmpleado.accion(opcion, ref banka);
}
break;
case 3:
InterfazDireccion.mostrar_menu_productos();
opcion = CH.leerOpcion(5);
if (opcion == 0)
{
salir = true;
}
else
{
ControladorProducto.accion(opcion, banka);
}
break;
case 4:
break;
case 0:
salir = true;
break;
}
} while (!salir);
}
public void Test5()
{
Banka banka = new Banka();
Racun racun = banka.DohvatiRacun("HR11");
Racun primatelj = banka.DohvatiRacun("HR22");
racun.Isplati(primatelj, 30000);
Assert.IsTrue(racun.Stanje == 70000 && primatelj.Stanje == 80000);
}
protected override void Seed(DatabaseContext context)
{
Musteri musteri1 = new Musteri()
{
Name = "Beyza",
Surname = "Ozkara",
TCKN = 12345678912,
Password = "******",
Email = "*****@*****.**",
Adres = "Manisa turgutlu celal bayar",
TelNo = "5123456789",
MusteriNo = rand.Next(100000000, 999999999)
//MusteriID = 111222333
};
Musteri musteri2 = new Musteri()
{
Name = "Hanife",
Surname = "Keskin",
TCKN = 21345987612,
Password = "******",
Email = "*****@*****.**",
Adres = "Manisa turgutlu celal bayar",
TelNo = "5975462938",
MusteriNo = rand.Next(100000000, 999999999)
//MusteriID = 111222334
// $"musteriID{i}" formatı kullanılabilir
};
context.Musteris.Add(musteri1);
context.Musteris.Add(musteri2);
context.SaveChanges();
Banka banka1 = new Banka()
{
BankaAdi = "SingletonBank"
};
context.Bankas.Add(banka1);
context.SaveChanges();
//Hesap musteri1Hesap = new Hesap()
//{
// MusteriID = musteri1.MusteriID,
// Bakiye = 1000,
// EkNo = 1000,
// HesapNo = 1112223331122,
// IBAN = 123456789,
// Durum = true,
// BankaID = banka1.BankaID,
// MusteriNo = musteri1.MusteriNo
//};
//context.Hesaps.Add(musteri1Hesap);
//context.SaveChanges();
}
public ActionResult Edit([Bind(Include = "BankaID,BankaAdi,BankaResmi")] Banka banka)
{
if (ModelState.IsValid)
{
db.Entry(banka).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(banka));
}
private void button1TEKOVNA_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
int i = 0;
var list = new List <ZiroSmetkaAvtor>();
foreach (var ca in _mladinskaEntities.CLENOVI_A)
{
if (String.IsNullOrWhiteSpace(ca.TEKOVNA))
{
continue;
}
CLENOVI_A ca2 = ca;
if (_avtorskaEntities.ZiroSmetkaAvtor.Count(z => z.AvtorskiClenovi.ClenskiBroj == ca2.BROJ) != 0)
{
continue;
}
var ziroSmetkaAvtor = new ZiroSmetkaAvtor
{
ZiroSmetka = ca.TEKOVNA,
AvtorskiClenovi =
_avtorskaEntities.AvtorskiClenovi.FirstOrDefault(
c => c.ClenskiBroj == ca2.BROJ)
};
if (!String.IsNullOrWhiteSpace(ca2.BANKA))
{
if (_avtorskaEntities.Banka.Count(b => b.NazivBanka.Contains(ca2.BANKA.Trim())) == 0)
{
var banka = new Banka {
NazivBanka = ca2.BANKA
};
_avtorskaEntities.AddToBanka(banka);
_avtorskaEntities.SaveChanges();
ziroSmetkaAvtor.Banka = banka;
}
else
{
var banka = _avtorskaEntities.Banka
.FirstOrDefault(b => b.NazivBanka.Contains(ca2.BANKA.Trim()));
ziroSmetkaAvtor.Banka = banka;
}
}
else
{
var banka = _avtorskaEntities.Banka.FirstOrDefault(b => b.NazivBanka.Trim().Equals(""));
ziroSmetkaAvtor.Banka = banka;
}
_avtorskaEntities.AddToZiroSmetkaAvtor(ziroSmetkaAvtor);
list.Add(ziroSmetkaAvtor);
i++;
_avtorskaEntities.SaveChanges();
}
Cursor.Current = Cursors.Default;
MessageBox.Show("CLENOVI_A.TEKOVNA => ziroSmetkaAvtor : " + i);
}
public void BankaSil(Banka banka)
{
if (banka == null)
{
throw new ArgumentNullException("banka");
}
_bankaDepo.Sil(banka);
_önbellekYönetici.KalıpİleSil(BANKALAR_PATTERN_KEY);
_olayYayınlayıcı.OlaySilindi(banka);
}
public ActionResult Create([Bind(Include = "BankaID,BankaAdi,BankaResmi")] Banka banka)
{
if (ModelState.IsValid)
{
db.Banka.Add(banka);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(banka));
}
public static void reintegro(ref Banka banka)
{
// 1. Pedir dni
// 2. Listar Cuentas Ahorros
// 3. Pedir Cuentas
// -REPETIR ESTO HASTA CANTIDAD OK-
// 4. Pedir cantidad
// 5. Evaluar limite segun tipoCliente
// 6. Comprobar si hay saldo
// 6. Si ok, retirar Cantidad
}
public static void registrarProducto(ref Banka banka)
{
Producto producto = new Producto();
producto.id = banka.lista_productos.Length + 1;
producto.nombre = CH.leerString("NOMBRE PRODUCTO");
producto.descripcion = CH.leerCadena("DESCRIPCION....");
producto.tipo_interes = CH.leerFloat("TIPO DE INTERES");
banka.agregarProducto(producto);
CH.lcdColor("\ni> Se ha agreado un nuevo producto a la banka!", ConsoleColor.Green);
CH.pausa();
}
/// <summary>
/// Izvlaci sve podatke vezane za banku ako je banka isctana iz baze podataka vezana za banku.
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static Banka GetBankaFromReader(SqlDataReader reader)
{
Banka banka = new Banka();
banka.IdBanke = (int)reader["idbanke"];
banka.NazivBanke = (string)reader["naziv"];
banka.AdresaBanke = (string)reader["adresa"];
banka.ObracunskiRacun = (long)(decimal)reader["obracunskiracun"];
banka.SWIFTKod = (string)reader["SWIFTkod"];
return(banka);
}
private void btnAdd_Click(object sender, EventArgs e)
{
var connectionString = "mongodb://localhost/?safe=true";
var server = MongoServer.Create(connectionString);
var database = server.GetDatabase("TouristGuide");
var collection = database.GetCollection <Banka>("banke");
var opstine = database.GetCollection <Opstina>("opstine");
MongoCursor <Opstina> ops = opstine.FindAll();
Opstina o = new Opstina();
if (azuriranje == null)
{
foreach (Opstina op in ops)
{
if (op.Naziv == cbxOpstina.SelectedItem.ToString())
{
o = op;
}
}
}
Banka b = new Banka {
Naziv = txtNaziv.Text, Adresa = txtAdresa.Text, BrojBankomata = txtBroj.Text, Opstina = new MongoDBRef("opstine", o.Id)
};
Banka zaAzur = new Banka();
if (azuriranje == null)
{
//var bankecollection = database.GetCollection("banke");
collection.Insert(b);
o.Banke.Add(new MongoDBRef("banke", b.Id));
opstine.Save(o);
}
else
{
var query = (from banke in collection.AsQueryable <Banka>()
where banke.Id == azuriranje.Id
select banke).FirstOrDefault();
query.Naziv = txtNaziv.Text;
query.Adresa = txtAdresa.Text;
query.BrojBankomata = txtBroj.Text;
collection.Save(query);
}
this.Close();
}