public ActionResult Create(Firma firma)
{
if (ModelState.IsValid)
{
db.Firmas.Add(firma);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(firma);
}
public FirmViewModel(Firma obj)
{
this.Object = obj;
this.Id = obj.Id;
this.Name = obj.Name;
this.UID = obj.UID;
this.Adresse = obj.Adresse;
this.Deliveryaddress = obj.Lieferadresse;
this.Billingaddress = obj.Rechnungsadresse;
}
public String FirmaBolumEkleVeGetir(int?firmaid, string bolumadi)
{
try
{
Firma firma = db.Firmas.Find(firmaid);
IsyeriBolumu bolum = new IsyeriBolumu()
{
FirmaID = firma.Id,
Adi = bolumadi
};
db.IsyeriBolumus.Add(bolum);
db.SaveChanges();
return(BolumGetir(firma.Id));
}
catch { }
return("");
}
public void Save()
{
if (string.IsNullOrWhiteSpace(Id))
{
this.Id = Guid.NewGuid().ToString();
}
if (string.IsNullOrWhiteSpace(Company))
{
var firma = Firma.FromIco(Ico);
Company = firma.Jmeno;
}
var res = ES.Manager.GetESClient_KindexFeedback().IndexDocument(this); //druhy parametr musi byt pole, ktere je unikatni
if (!res.IsValid)
{
throw new ApplicationException(res.ServerError?.ToString());
}
}
public bool FirmaKaydetGuncelle(Firma firma)
{
if (firma.FirmaId != 0)
{
var firmaFromDb = this.FirmaGetir(firma.FirmaId);
firmaFromDb.Adi = firma.Adi;
firmaFromDb.VergiNo = firma.VergiNo;
firmaFromDb.GumrukKullaniciId = firma.GumrukKullaniciId;
firmaFromDb.BolgeKodu = firma.BolgeKodu;
}
else
{
_dbContext.Firmalar.Add(firma);
}
_dbContext.SaveChanges();
return(true);
}
public ActionResult SubjektHlidac(string Id)
{
if (string.IsNullOrWhiteSpace(Id))
{
return(new HomeController().NotFound("/", "Pokračovat na titulní straně"));
}
HlidacStatu.Lib.Data.Firma model = HlidacStatu.Lib.Data.Firmy.Get(Id);
if (model == null || !Firma.IsValid(model))
{
return(new HomeController().NotFound("/", "Pokračovat na titulní straně"));
}
else
{
var aktualnost = HlidacStatu.Lib.Data.Relation.AktualnostType.Nedavny;
ViewBag.Aktualnost = aktualnost;
return(View(model));
}
}
public static List <Faktura> GetInvoiceByStatusAndId(Firma firma, string tip)
{
List <Faktura> fakture = new List <Faktura>();
using (SqlConnection conn = MySQLUtils.NapraviFirmaConn())
{
conn.Open();
string sql = "";
string naziv = "";
if (tip == GlobalConst.STATUS_FAKTURE_KREIRANA)
{
sql = @"SELECT * FROM faktura WHERE nazivdobavljaca = @naziv AND status = '0'";
}
else if (tip == GlobalConst.STATUS_FAKTURE_POSLATA)
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv AND status = '1'";
}
else if (tip == GlobalConst.STATUS_FAKTURE_PLACENA)
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv AND status = '2'";
}
else
{
sql = @"SELECT * FROM faktura WHERE nazivkupca = @naziv";
}
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@naziv", firma.NazivFirme);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Faktura ret = new Faktura();
ret = ReadFromReader(reader);
fakture.Add(ret);
}
reader.Close();
}
conn.Close();
}
return(fakture);
}
public NIslemSonuc <Firma> Guncelle(Firma firma)
{
try
{
Firma donen_firma = (from f in entity.Firma where f.firma_id == firma.firma_id select f).FirstOrDefault();
donen_firma.adres = firma.adres;
donen_firma.boylam = firma.boylam;
donen_firma.cari_kod = firma.cari_kod;
donen_firma.durum_id = firma.durum_id;
donen_firma.enlem = firma.enlem;
donen_firma.kisa_ad = firma.kisa_ad;
donen_firma.mail = firma.mail;
donen_firma.sgk_no = firma.sgk_no;
donen_firma.silindi_mi = firma.silindi_mi;
donen_firma.telefon = firma.telefon;
donen_firma.unvan = firma.unvan;
donen_firma.vergi_daire = firma.vergi_daire;
donen_firma.vergi_no = firma.vergi_no;
entity.SaveChanges();
return(new NIslemSonuc <Firma>
{
basariliMi = true,
mesaj = "Güncelleme İşlemi Tamamlandı!",
Veri = donen_firma
});
}
catch (Exception ex)
{
return(new NIslemSonuc <Firma>
{
basariliMi = false,
mesaj = "Sistem Hatası!",
hata = new NHata
{
aciklama = "Güncelleme metodunda hata",
mesaj = ex.Message,
strace = ex.StackTrace,
sinif = "Firma Veritabani",
tarih = DateTime.Now
}
});
}
}
public ActionResult FirmaDuzenle(int?id)
{
try
{
ViewBag.iller = db.Ils.ToList();
ViewBag.musteriler = db.Musteris.ToList();
ViewBag.sektorler = db.Sektors.ToList();
Firma firma = db.Firmas.Find(id);
if (firma == null)
{
return(RedirectToAction("Firmalar"));
}
return(View(firma));
}
catch
{
return(RedirectToAction("Firmalar"));
}
}
private void btnFirmaSil_Click(object sender, EventArgs e)
{
if (lstFirmalar.SelectedItem == null)
{
return;
}
Firma seciliFirma = lstFirmalar.SelectedItem as Firma;
try
{
new FirmaRepo().Delete(seciliFirma);
lstFirmalar.DataSource = new FirmaRepo().GetAll();
seciliFirma = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool DodajFirmu(Firma firma)
{
try
{
ISession session = SessionManager.GetSession();
if (session == null)
{
return(false);
}
session.Execute("insert into \"Firma\" (pib, naziv, adresa) values ('" + firma.pib + "','"
+ firma.naziv + "','" + firma.adresa + "');");
}
catch (Exception e)
{
return(false);
}
return(true);
}
public int firmaAciklamaEkle(Firma firma, FirmaAciklama data, FirmaYetkili yetkili)
{
BusinesLayerResult <FirmaYetkili> layerResult = new BusinesLayerResult <FirmaYetkili>();
layerResult.result = repo_FirmaYetkili.Find(x => x.Adi == yetkili.Adi);
BusinesLayerResult <Firma> layerResult2 = new BusinesLayerResult <Firma>();
layerResult2.result = repo_Firma.Find(x => x.FirmaAdi == firma.FirmaAdi);
if (layerResult.result != null && layerResult2.result != null)
{
data.Yetkili = layerResult.result.ID;
data.firmaID = layerResult2.result.ID;
return(repo_FirmaAciklama.Insert(data));
}
else
{
return(-1);
}
}
public void FirmaAC(int ID)
{
try
{
Edit = true;
firmaId = ID;
Firma frm = DB.Firmalar.First(s => s.FirmaId == firmaId);
txtAdres.Text = frm.Adres;
txtEmail.Text = frm.Email;
txtFirma.Text = frm.FirmaAdi;
txtTel.Text = frm.Tel;
txtVd.Text = frm.Vd;
txtVn.Text = frm.Vn;
}
catch (Exception e)
{
M.Hata(e);
}
}
public IActionResult Kayit([Bind("Funvan,Isvrnadsoyad,Isvrngsm,Firmatlfn,Faks,Firmamail,Il,Ilce,Adres,Faaliyetalan,Sgksicil,Tehlikesinif,Grupsirket")]
Firma fir)
{
if (ModelState.IsValid)
{
baglantiSinifi bs = new baglantiSinifi();
string sorgu = "insert into firmagruplari(grup_ad) values('" + fir.Funvan + "')";
bs.baglanti("ekleme", sorgu);
int a = bs.baglanti("bulgrubu", "");
string sorgu1 = "insert into firma(funvan,isvrnadsoyad,isvrngsm,firmatlfn,faks,firmamail,il,ilce,adres,faaliyetalan,sgksicil,tehlikesinif,grupsirket,durum,grup_id) values" +
"('" + fir.Funvan + "','" + fir.Isvrnadsoyad + "','" + fir.Isvrngsm + "','" + fir.Firmatlfn + "','" + fir.Faks + "','" + fir.Firmamail + "','" + fir.Il + "','" + fir.Ilce + "','" + fir.Adres + "','" + fir.Faaliyetalan + "','" + fir.Sgksicil + "','" + fir.Tehlikesinif + "','" + fir.Grupsirket + "','ANA FİRMA','" + a + "')";
bs.baglanti("ekleme", sorgu1);
ViewBag.sonuc = "FİRMA Eklendi";
a = bs.baglanti("bulfirma", "");
return(RedirectToAction("FirmaKayit", "Register", new { id = a }));
}
return(View(fir));
}
private void RTGS(NalogPrenos prenos, Common.Model.Banka bankaDuznik, Common.Model.Banka bankaPrimaoca)
{
Firma duznik = DAO.GetFirmaBrojRacuna(prenos.RacunDuznika);
Firma primalac = DAO.GetFirmaBrojRacuna(prenos.RacunPrimalac);
Racun racunDuznika = DAO.GetRacunBrojRacuna(prenos.RacunDuznika);
DAO.UpdateStanjeRacuna(racunDuznika.BrojRacun, racunDuznika.Stanje - prenos.Iznos);
MT103 mt103 = new MT103(
"id",
bankaDuznik.Swift,
bankaDuznik.Racun,
bankaPrimaoca.Swift,
bankaPrimaoca.Racun,
duznik.Naziv,
prenos.SvrhaPlacanja,
primalac.Naziv,
prenos.DatumNaloga,
prenos.DatumValute,
prenos.RacunDuznika,
prenos.ModelZaduzenja,
prenos.PozivNaBrZaduzenja,
prenos.RacunPrimalac,
prenos.ModelOdobrenja,
prenos.PozivNaBrOdobrenja.ToString(),
prenos.Iznos,
"RSD"
);
ChannelFactory <ICentralnaBanka> factory = new ChannelFactory <ICentralnaBanka>(new NetTcpBinding(), new EndpointAddress("net.tcp://localhost:9000/CB"));
ICentralnaBanka proxy = factory.CreateChannel();
MT900 mt900 = null;
try
{
mt900 = proxy.RTGS(mt103);
}
catch (Exception)
{ }
}
public ActionResult Login1(Firma firma)
{
string mail = firma.Mail;
string sifre = firma.Sifre;
var user = (from u in db.Firmas where u.Mail == mail select u).FirstOrDefault();
if (user != null && (user.Mail == mail && user.Sifre == sifre))
{
FormsAuthentication.SetAuthCookie(mail, true);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", " Mail veya şifre hatalı!");
}
return(View(firma));
}
public void AddFirma(Firma f)
{
f.IdFirma = GetId();
try
{
using (StreamWriter swFisierText = new StreamWriter(NumeFisier, true))
{
swFisierText.WriteLine(f.ConversieLaSirPentruScriereInFisier());
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
}
public NIslemSonuc <Firma> Ekle(Firma EklenecekFirma)
{
try
{
entity.Firma.Add(EklenecekFirma);
entity.SaveChanges();
#region Log Kaydı Yap
Log logBilgisi = new Log
{
aktif_sayfa = HttpContext.Current.Request.Url.AbsoluteUri,
bilgisayar_ad = Genel_Islemler.GetComputerName(),
ip_adres = Genel_Islemler.GetIPAddress(),
personel_tc = (HttpContext.Current.Session["kullanici"] as Personel).personel_tc,
tarih = DateTime.Now,
tur_id = Sabitler.LogTur_KayitEkleme,
mesaj = Genel_Islemler.MesajOlustur(Sabitler.LogTur_KayitEkleme, HttpContext.Current.Session["kullanici"] as Personel, "Firma") + " Kaydedilen Veri: " + EklenecekFirma.unvan + " (Firma ID: " + EklenecekFirma.firma_id + ")",
};
Log_Veritabani.Ekle(logBilgisi);
#endregion
return(new NIslemSonuc <Firma>
{
basariliMi = true,
Veri = EklenecekFirma,
mesaj = "Firma Kaydı Tamamlandı!"
});
}
catch (Exception ex)
{
return(new NIslemSonuc <Firma>
{
basariliMi = false,
hata = new NHata
{
aciklama = "Ekleme Metodunda Hata",
mesaj = ex.Message,
strace = ex.StackTrace,
sinif = "Personel Veritabani",
tarih = DateTime.Now
},
mesaj = "Sistemde Bir Hata Oluştu!"
});
}
}
public RedirectToRouteResult Ekle(string ad, string alan, string tel, string mail, string sorumlu)
{
Context context = new Context();
Firma firma = new Firma()
{
Ad = ad,
Alan = alan,
Tel = tel,
Mail = mail,
Sorumlu = sorumlu
};
context.Firmalar.Add(firma);
context.SaveChanges();
return(RedirectToAction("Index", "Firma"));
}
private int KontrolEt(KategoriFirmaViewModel firma)
{
int i = 0;
if (firma.Firma.FirmaAdi == null)
{
i = 1;
ModelState.AddModelError("", "Firma Adı Gerekli");
}
Firma name = _managerFirma.Find(x => x.SeoName == firma.Firma.SeoName && x.ID != firma.Firma.ID);
if (name != null)
{
i = 1;
ModelState.AddModelError("", "Kayıtlı SeoName");
}
if (firma.Firma.FirmaTel == null)
{
i = 1;
ModelState.AddModelError("", "Firma Telefon Gerekli");
}
if (firma.Firma.Adres == null)
{
i = 1;
ModelState.AddModelError("", "Firma Adres Gerekli");
}
int s = 0;
foreach (var item in firma.FirmaKategoriler)
{
if (item.Secili)
{
s++;
}
}
if (s == 0)
{
i = 1;
ModelState.AddModelError("", "En Az Bir Kategori Seçmek Zorundasınız.");
}
return(i);
}
public ActionResult Detay(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Firma frm = _managerFirma.Find(x => x.ID == id.Value);
if (frm == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.ID = new SelectList(_managerFirmaKategori.List(), "ID", "KategoriAdi");
return(View(frm));
}
public void JsonApiCollectionDocument_TestIncludeToMany()
{
//var model = GetSomeData().FirstOrDefault();
var model = new Firma
{
Id = Guid.NewGuid().ToString(),
FirmenName = "bitbird",
FahrZeuge = new List <Fahrzeug> {
new Fahrzeug {
Id = Guid.NewGuid().ToString(), Kilometerstand = 4000
}, new Fahrzeug {
Id = Guid.NewGuid().ToString(), Kilometerstand = 10000
}
},
Fahrer = new Fahrer {
Id = Guid.NewGuid().ToString(), Name = "Christian", Keys = new List <string> {
"key0", "key1", "key2"
}
}
};
var testApiDocument = new JsonApiCollectionDocument <Firma>(model, new List <PropertyInfo>
{
model.GetType().GetProperty(nameof(model.Fahrer)), model.GetType().GetProperty(nameof(model.FahrZeuge))
});
JsonSerializerSettings settings = new JsonSerializerSettings()
{
Formatting = Formatting.Indented
};
string jsonString = JsonConvert.SerializeObject(testApiDocument, settings);
System.Diagnostics.Debug.WriteLine(jsonString);
var result = JsonConvert.DeserializeObject <JsonApiCollectionDocument <Firma> >(jsonString, settings);
var deserialzedModel = result.ToObject()?.FirstOrDefault();
Assert.IsNotNull(deserialzedModel);
Assert.AreEqual(deserialzedModel.FahrZeuge.Count(), model.FahrZeuge.Count());
Assert.AreEqual(deserialzedModel.FahrZeuge.First().Id, model.FahrZeuge.First().Id);
}
public ActionResult Erstellen(int Monatnummer)
{
log.Info("Rechnung - Erstellen - GET");
Benutzer aktBenutzer = BenutzerAdministrator.GetUser(User.Identity.Name);
List <Buchungsdetails> gesuchteBuchungsDetails = RechnungsVerwaltung.MonatsBuchungsDetails((int)aktBenutzer.Firma_id, Monatnummer);
Rechnung rechnung = RechnungsVerwaltung.LiefereRechnungzuFirmaAusMonat(gesuchteBuchungsDetails);
RechnungErstellenModel rechnungsModel = new RechnungErstellenModel();
Firma firma = FirmenVerwaltung.LiefereFirma((int)aktBenutzer.Firma_id);
rechnungsModel.Rg_Id = rechnung.Id;
rechnungsModel.Firmenname = firma.Bezeichnung;
rechnungsModel.FirmenstrassenNummer = firma.Nummer;
rechnungsModel.FirmenOrt = firma.Ort;
rechnungsModel.Firmenstrasse = firma.Strasse;
rechnungsModel.FirmenPlz = firma.Plz;
rechnungsModel.Datum = (DateTime)rechnung.Datum;
rechnungsModel.Firmenname = firma.Bezeichnung;
rechnungsModel.Gesamtpreis = gesuchteBuchungsDetails.Sum(x => x.Preis);
rechnungsModel.Steuerbetrag = (rechnungsModel.Gesamtpreis / 100) * 20;
rechnungsModel.RechnungsDetails = new List <RechnungsDetailModel>();
foreach (var buchungsDetail in gesuchteBuchungsDetails)
{
RechnungsDetailModel model = new RechnungsDetailModel()
{
Buchungs_ID = buchungsDetail.Id.ToString(),
Buchungsdatum = buchungsDetail.Datum,
Preis = buchungsDetail.Preis,
RaumNummer = RaumVerwaltung.GesuchterRaumName(buchungsDetail.Buchung_id)
};
rechnungsModel.RechnungsDetails.Add(model);
}
DateTime VonDatum = (from x in gesuchteBuchungsDetails orderby x.Datum select x.Datum).FirstOrDefault();
DateTime BisDatum = (from x in gesuchteBuchungsDetails orderby x.Datum descending select x.Datum).FirstOrDefault();
return(new Rotativa.ViewAsPdf("Erstellen", rechnungsModel));
}
internal static void Save(TextBox txtFirmaId, TextBox txtImePrezime, ComboBox cmbPol, TextBox txtEmbg, TextBox txtAdresa2, ComboBox cmbOpstina, TextBox txtTransak, ComboBox cmbPodracna, TextBox txtEmail2, TextBox txtBruto, TextBox txtNeto, ComboBox cmbSifra, TextBox txtSkrateno, DateTimePicker dateTimePicker1, CheckBox chbOtkaz, DateTimePicker dateTimePicker2)
{
String pol = cmbPol.SelectedItem.ToString();
String opstina = cmbOpstina.SelectedItem.ToString();
String podracna = cmbPodracna.SelectedItem.ToString();
String sifra = cmbSifra.SelectedItem.ToString();
DateTime?date2 = null;
if (chbOtkaz.Checked)
{
date2 = dateTimePicker2.Value;
}
long id = long.Parse(txtFirmaId.Text);
Firma firma = FirmaController.GetFirmaById(id);
DateTime date1 = dateTimePicker1.Value;
Vraboten vraboten = new Vraboten(txtImePrezime.Text, date1, date2, pol, txtEmbg.Text, txtAdresa2.Text, opstina, txtTransak.Text, podracna, txtEmail2.Text, int.Parse(txtBruto.Text), int.Parse(txtNeto.Text), sifra, int.Parse(txtSkrateno.Text), firma.id);
db.vraboteni.Add(vraboten);
db.SaveChanges();
}
private void SiparisleriYukle(Firma seciliFirma)
{
var urunler = new FirmaRepo().FirmaVerilenSiparisRapor(seciliFirma.ID);
if (rbTEdilmis.Checked)
{
lstFirmaSiparis.DataSource = urunler.Where(x => x.TeslimTarihi == null).ToList();
}
else
{
lstFirmaSiparis.DataSource = urunler.Where(x => x.TeslimTarihi != null).ToList();
}
chart1.Series["Satis"].XValueMember = "UrunAdi";
chart1.Series["Satis"].YValueMembers = "Toplam";
chart1.DataSource = new FirmaRepo().FirmaSatisChartRapor(seciliFirma.ID);
chart1.Series["Satis"].IsValueShownAsLabel = true; //veri etiketleri stili
chart1.Series["Satis"].IsValueShownAsLabel = true; //veri etiketleri stili
chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; // 3D grafik
chart1.Series["Satis"]["DrawingStyle"] = "Cylinder";
}
public void ContainsTextFirmaTest()
{
var firma = new Firma
{
Adresa = "abc",
Cui = "cde",
DataInfiintarii = DateTime.Now,
Iban = "xyz",
IdBanca = 2,
IdDelegat = 2,
Nume = "poi",
Rc = "pay",
Telefon = "y+2223"
};
string text = "21 2012";
var actual = firma.Contains(text);
var expected = true;
Assert.AreEqual(expected, actual);
}
public ActionResult UPDATE(Firma model)
{
NovapmEntities db = new NovapmEntities();
if (ModelState.IsValid)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(new JsonResult()
{
Data = true,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult()
{
Data = true,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public int FirmaUzmanYetkilendir(int?firmaid, int?uzmanid)
{
try
{
Firma firma = db.Firmas.Find(firmaid);
Uzman uzman = db.Uzmen.Find(uzmanid);
FirmaUzman fd = new FirmaUzman()
{
UzmanID = uzman.Id,
FirmaID = firma.Id,
AtayanID = (Session["yonetici"] as Yonetici).Id,
AtanmaTarihi = DateTime.Now
};
db.FirmaUzmen.Add(fd); db.SaveChanges(); return(1);
}
catch
{
return(0);
}
}
public ActionResult Firma(historia historia)
{
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
string fileName = Path.GetFileName(file.FileName);
string ext = Path.GetExtension(fileName);
string[] formatos = new string[] { ".jpg", ".jpeg", ".bmp", ".png", ".gif", ".JPG", ".JPEG", ".BMP", ".PNG", ".GIF" };
if (!String.IsNullOrEmpty(fileName) && (Array.IndexOf(formatos, ext) > 0))
{
Firma objfirma = new Firma();
//paciente.pac_firma = fileName;
string path = Path.Combine(Server.MapPath("~/Content/firmas_"), fileName);
string path01 = Path.Combine(Server.MapPath("~/Content/firmas"), fileName);
file.SaveAs(path);
objfirma.ResizeImage(path, path01, 200, 120);
historia.his_firma = ConvertBytes(path01);
return(RedirectToAction("Message", "Home", new { mensaje = "Proceso Finalizado" }));
}
else
{
if (!String.IsNullOrEmpty(ext))
{
if (Array.IndexOf(formatos, ext) <= 0)
{
ModelState.AddModelError("ext", "Extensión no Válida");
}
}
//else if (String.IsNullOrEmpty(fileName))
// ModelState.AddModelError("ext", "Debe Seleccionar un archivo");
return(RedirectToAction("Message", "Home", new { mensaje = "Proceso Finalizado" }));
}
}
if (ModelState.IsValid)
{
db.Entry(historia).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Message", "Home", new { mensaje = "Proceso Finalizado" }));
}
return(RedirectToAction("Message", "Home", new { mensaje = "Proceso Finalizado" }));
}
/*Die Bank hat verschiedene Kundentypen(z.B. privat,Firma...)
* es gibt normale Konten, Kreditkonten und Hypothekkonten*/
/*Jedes Konto gehört zu einem Kunden,hat einen aktuellen Kontostand und eine monatliche Zinsrate (monthly based).
* normale skonten dürfen einzahlen und Geld abheben.
* Kredit- und Hypothekenkonten können nur Geld einzahlen.*/
/*
* Alle Konten können ihren Zinsbetrag für einen bestimmten Zeitraum (in Monaten) berechnen.
* Im Normalfall wird es wie folgt berechnet: Anzahl_Monate * Zinssatz.
* Darlehenskonten sind in den ersten 3 Monaten nicht verzinslich
* wenn sie von Einzelpersonen gehalten werden und während der ersten 2 Monate von einer Firma gehalten
* werden.
*
* Einlagenkonten sind nicht verzinslich, wenn ihr Saldo positiv ist und weniger als 1000 beträgt.
* Hypothekenkonten sind in den ersten 12 Monaten für Unternehmen und in den ersten 6 Monaten nicht für Privatpersonen zu verzinsen.
*/
static void Main()
{
//dummy-kunden erstellen
Person person = new Person("Uschi", "Glas", "München", 123, 666);
Person person2 = new Person("Angela", "Merkel", "Berlin", 001, 1234);
Firma firma = new Firma("AfD", "Im Anus", TypderFirma.BriefkastenFirma, 69, 6666);
//konto erstellen mit zinsrate 3% = 0.03M
Einzahlungskonto ek1 = new Einzahlungskonto(person, 450.00M, 0.03M, 4);
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Kontostand von {0} {1} ist {2}", person.Vorname, person.Nachname, ek1.Kontostand + " Euro\n");
ek1.Kontostand = ek1.GeldEinzahlen(2400);
Console.WriteLine("{0}s Kontostand nach Einzahlung von 2400 Euro ist {1} Euro", person.Vorname, ek1.Kontostand);
Console.WriteLine("Zinsen auf Einzahlung {0} {1} {2} Euro", person.Vorname, person.Nachname, ek1.BerechneZinsen());
Console.ResetColor();
//Darlehenskonto besitzerDarlehensKonto = new Darlehenskonto(person, 3200.0M, 0.04M, 13);
//Console.WriteLine("Zinsen Darlehenskonto {0} is {1}", person.Vorname, besitzerDarlehensKonto.BerechneZinsen());
//Hypothekenkonto besitzerHypothekenKonto = new Hypothekenkonto(person, 5060.80M, 0.05M, 14);
//Console.WriteLine("Zinsen Hypothekenkonto {0} is {1}", person.Vorname, besitzerHypothekenKonto.BerechneZinsen());
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Green;
Einzahlungskonto ek2 = new Einzahlungskonto(person2, 3000.50M, 0.023M, 2);
Console.WriteLine("Kontostand von {0} {1} ist {2} Euro", person2.Vorname, person2.Nachname, ek2.Kontostand);
Console.ResetColor();
Console.WriteLine();
/* Console.ForegroundColor = ConsoleColor.Red;
* Einzahlungskonto ek3 = new Einzahlungskonto(firma, 500.0M, 0.07M, 5);
* Console.WriteLine("Kontostand \"{0}\" {1} ist {2} Euro", firma.FirmaName, firma._firmatyp, ek3.Kontostand);
* Console.WriteLine("Zinsen Konto {0} {1} {2} Euro", firma.FirmaName,firma._firmatyp, ek3.BerechneZinsen());
* Hypothekenkonto hk1 = new Hypothekenkonto(firma, 2500.00M, 0.05M, 13);
* Console.WriteLine("Zinsen Hypothekenkonto{0} {1} {2} Euro", firma.FirmaName,firma._firmatyp, hk1.BerechneZinsen());
* Console.ResetColor();*/
Console.ReadKey();
}
void StwórzWaluty()
{
string line;
System.IO.StreamReader file =
new System.IO.StreamReader(@"waluty.txt");
// Inwestycja init = new Inwestycja { Nazwa = "init", Data = DateTime.Now, Kurs = 0 };
while ((line = file.ReadLine()) != null)
{
string nazwa = line;
if (!ctx.Firma.Any(p => p.Name == nazwa))
{
Firma fm = new Firma()
{
Name = nazwa
}; //, AktualnaInwestycja=init };
ctx.Firma.Add(fm);
}
}
ctx.SaveChanges();
}
private void listing_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.listing.SelectedIndex >= 0)
{
this.curr_id = ((Firma)this.listing.Items[this.listing.SelectedIndex]).id;
this.listing.Visibility = Visibility.Collapsed;
Firma m = new Firma(this.curr_id);
// Blendet die Daten in den Textboxen ein
this.name.Text = m.name;
this.strasse.Text = m.strasse;
this.hsnr.Text = m.hsnr;
this.plz.Text = m.plz;
this.ort.Text = m.ort;
this.land.Text = m.land;
this.formular.Visibility = Visibility.Visible;
}
}
/// <summary>
/// private Methode zur Umwandlung einer Zeile der lokalen Datenbankkopie in ein Objekt der Klasse Eintrag
/// </summary>
/// <param name="row">umzuwandelnde Zeile</param>
/// <param name="id">laufende Nummer des Eintrags in der Datenbank</param>
/// <returns>Inhalt der Zeile als Objekt der Klasse Firma</returns>
private Eintrag _ToEintrag(DataRow row)
{
if ((bool)row["Firma"] == true)
{
Firma f = new Firma(row["Name"].ToString(), row["Kundennummer"].ToString(), GetAdress(row));
return f;
}
else
{
Person p = new Person(row["Name"].ToString(), row["Vorname"].ToString(), row["Kundennummer"].ToString(), GetAdress(row));
return p;
}
}
public ActionResult Edit(Firma firma)
{
if (ModelState.IsValid)
{
db.Entry(firma).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(firma);
}
public override void Search()
{
Proxy proxy = new Proxy();
if (Selected == "Kontakte")
{
ResultContact = proxy.Search(SearchText);
Items.Clear();
if (ResultContact.contact != null)
{
foreach (var obj in ResultContact.contact)
{
Items.Add(new ContactViewModel(obj));
}
}
else
{
Contact obj = new Contact();
obj.Vorname = "Keinen Eintrag gefunden!";
obj.Id = "x";
Items.Add(new ContactViewModel(obj));
}
}
else
{
ResultFirm = proxy.SearchFirm(SearchText);
Items.Clear();
if (ResultFirm.Firma != null)
{
foreach (var obj in ResultFirm.Firma)
{
Items.Add(new FirmViewModel(obj));
}
}
else
{
Firma obj = new Firma();
obj.Name = "Keinen Eintrag gefunden!";
obj.Id = "x";
Items.Add(new FirmViewModel(obj));
}
}
}
//MAIN SUBMIT METHOD
public void AddCorporationAction()
{
var firma = new Firma();
firma.registracne_cislo = RegNumber;
firma.nazov = Name;
firma.ulica = Street;
firma.id_obec = int.Parse(CitiesSelected);
_pharmacyDomainContext.Firmas.Add(firma);
_pharmacyDomainContext.SubmitChanges();
MessageBox.Show("Firma " + Name + " bola úspešne zaregistrovaná!");
}
