private void btnUplati_Click(object sender, RoutedEventArgs e)
{
Uplata u = dgUplata.SelectedItem as Uplata;
u.StatusUplate = true;
UplataDAO.Uplati(u);
}
private void bIzmeni_Click(object sender, RoutedEventArgs e)
{
Uplata u = dgUplate.SelectedItem as Uplata;
UplateEditWindow uew = new UplateEditWindow(u, MOD.IZMENA);
uew.ShowDialog();
}
public ActionResult Snimi(UrediVM model)
{
Uplata x;
if (!ModelState.IsValid)
{
model.StudentStavka = StudentStavka();
return(View("Uredi", model));
}
if (model.Id == 0)
{
x = new Uplata();
db.Uplate.Add(x);
}
else
{
x = db.Uplate.Find(model.Id);
}
x.DatumUplate = model.Datum;
x.IznosUplate = model.IznosUplate;
x.svrhaUplate = model.svrhaUplate;
x.studentId = model.studentId;
db.SaveChanges();
return(RedirectToAction("Prikazi"));
}
public static void Update(Uplata u)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"Update Uplata Set KursId=@kursId, UcenikId=@ucenikId, DatumUplate=@datum, Cena=@cena Where Id=@id";
cmd.Parameters.Add(new SqlParameter("@kursId", u.Kurs.Id));
cmd.Parameters.Add(new SqlParameter("@ucenikId", u.Ucenik.Id));
cmd.Parameters.Add(new SqlParameter("@datum", u.Datum));
cmd.Parameters.Add(new SqlParameter("@cena", u.Cena));
cmd.Parameters.Add(new SqlParameter("@id", u.Id));
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
MessageBox.Show(e.Message, "Greska", MessageBoxButton.OK);
throw new Exception();
}
}
}
public IHttpActionResult PostYearlyMembership(Uplata uplata)
{
uplata.Datum = DateTime.Now;
if (uplata.YearId < 1)
{
ModelState.AddModelError("Year ID", "must be larger then 0");
}
if (!ModelState.IsValid)
{
ModelState.AddModelError("Errors", "Pleasse try fix errors");
return(BadRequest(ModelState));
}
var membership = repo.InsertMembership(uplata);
if (membership != null && repo.SaveAll())
{
return(Ok(membership));
}
else
{
return(InternalServerError());
}
}
public static void Read()
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR))
{
conn.Open();
Aplikacija.Instanca.Uplate = new ObservableCollection <Uplata>();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"Select * from Uplata Where Obrisan = 0";
SqlDataAdapter sqlDA = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sqlDA.Fill(ds, "Uplate");
foreach (DataRow row in ds.Tables["Uplate"].Rows)
{
Uplata u = new Uplata();
u.Id = (long)row["Id"];
Ucenik ucenik = GetUcenikByID((long)row["UcenikID"]);
ucenik.Uplate.Add(u);
u.Ucenik = ucenik;
u.Kurs = GetKursByID((long)row["KursID"]);
u.Datum = (DateTime)row["DatumUplate"];
u.Cena = (double)row["Cena"];
Aplikacija.Instanca.Uplate.Add(u);
}
}
}
public static bool Update(SqlConnection conn, Uplata uplata)
{
bool retVal = false;
try
{
string query = "UPDATE uplata " +
"SET datum=@datum,iznos=@iznos " +
"WHERE id=@id";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", uplata.Id);
cmd.Parameters.AddWithValue("@datum", uplata.Datum);
cmd.Parameters.AddWithValue("@iznos", uplata.Iznos);
if (cmd.ExecuteNonQuery() == 1)
{
retVal = true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(retVal);
}
public IActionResult Snimi(UplataDodajVM input)
{
if (!ModelState.IsValid)
{
return(Redirect("Dodaj?KupacID=" + input.KupacID));
}
var cijenaSaPDV = db.Nekretnine.Where(i => i.NekretninaID == input.NekretninaID).Select(i => i.Cijena).FirstOrDefault();
var cijenaBezPDV = cijenaSaPDV - (cijenaSaPDV * 0.17);
Uplata x = new Uplata
{
DatumUplate = input.DatumUplate,
KorisnikID = input.KupacID,
MjesecnaRata = input.MjesecnaRata,
NacinPlacanjaID = input.NacinPlacanjaID,
UgovorID = input.UgovorID,
NekretninaID = input.NekretninaID,
UkupanIznosBezPDV = cijenaBezPDV,
UkupanIznosPDV = cijenaBezPDV,
UposlenikID = db.Uposlenici.Where(i => i.Korisnik.KorisnickiNalogID == HttpContext.GetLogiraniKorisnik().KorisnickiNalogID&& i.Korisnik.Uloga.Naziv == "Uposlenik").Select(u => u.UposlenikID).First()
};
db.Add(x);
db.SaveChanges();
TempData["WarningMessage"] = "Uspješno ste dodali uplatu!";
return(Redirect("/Uplata/IndexUplate?KupacID=" + x.KorisnikID));
}
public static Uplata GetUplataById(SqlConnection conn, int id)
{
Uplata uplata = null;
try
{
string query = "SELECT id, datum, iznos " +
"FROM uplata " +
"WHERE id=" + id;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader r = cmd.ExecuteReader();
if (r.Read())
{
string datum = (string)r["datum"];
int iznos = (int)r["iznos"];
uplata = new Uplata(id, datum, iznos);
}
r.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(uplata);
}
public List <UplataModel> DodajUplatu(UplataInsertRequest request)
{
Uplata u = new Uplata
{
DatumUplate = request.DatumUplate,
Iznos = request.Iznos,
RezervacijaId = request.RezervacijaId,
SifraUplate = GenerateString(8)
};
if (request.KreditnaKartica != null)
{
KreditnaKartica k = new KreditnaKartica();
k.BrojKartice = request.KreditnaKartica.BrojKartice;
k.GodinaIsteka = request.KreditnaKartica.GodinaIsteka;
k.MjesecIsteka = request.KreditnaKartica.MjesecIsteka;
k.TipKartice = request.KreditnaKartica.TipKartice;
_context.KreditnaKartica.Add(k);
}
else
{
u.KreditnaKarticaId = 1;
}
_context.Uplata.Add(u);
_context.SaveChanges();
var Lista = _context.Uplata.Where(x => x.RezervacijaId == request.RezervacijaId).ToList();
return(_mapper.Map <List <UplataModel> >(Lista));
}
public static Uplata Create(Uplata u)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into uplate values(@obrisan, @kurs_id, @ucenik_id, @iznos, @datum);SELECT SCOPE_IDENTITY()";
cmd.Parameters.Add(new SqlParameter("@obrisan", u.Obrisan));
cmd.Parameters.Add(new SqlParameter("@kurs_id", u.Kurs.Id));
cmd.Parameters.Add(new SqlParameter("@ucenik_id", u.Ucenik.Id));
cmd.Parameters.Add(new SqlParameter("@iznos", u.Iznos));
cmd.Parameters.Add(new SqlParameter("@datum", u.Datum));
try
{
long id = long.Parse(cmd.ExecuteScalar().ToString());
u.Id = id;
}
catch (SqlException e)
{
MessageBox.Show(e.Message, "greska", MessageBoxButton.OK);
}
return(u);
}
}
private UplataModel MapUplataToUplataModel(Uplata uplata)
{
var returnModel = new UplataModel
{
DatumUplate = uplata.DatumUplate,
Id = uplata.Id,
Iznos = uplata.Iznos,
TipUplate = uplata.TipUplate.Naziv,
ImeIPrezimeKlijenta = uplata.Klijent.ApplicationUser.Ime + " " + uplata.Klijent.ApplicationUser.Prezime
};
if (uplata.KursInstancaId != null)
{
var kursInstanca = _context.KursInstanca
.Include(ki => ki.Kurs)
.Where(ki => ki.Id == uplata.KursInstancaId)
.FirstOrDefault();
returnModel.NamjenaZaKursInstancu = kursInstanca.Kurs.Naziv;
}
else
{
returnModel.NamjenaZaKursInstancu = "Nema";
}
var clanarina = _context.Clanarina
.Where(c => c.UplataId == uplata.Id)
.ToList();
if (clanarina.Count > 0)
{
returnModel.ProduzenaClanarinaDo = clanarina[0].DatumIsteka.Date;
}
return(returnModel);
}
public ActionResult SnimiUplatu([FromQuery] int nalogid, [FromBody] Uplata obj)
{
try
{
var nalog = _session.Load <RadniNalog>(nalogid);
obj.RadniNalog = nalog;
var kn = Tuv.Helper.Helper.GetIso8601WeekOfYear(obj.Datum);
//obj.Kn = kn;
var kurs = _session.QueryOver <KursnaLista>()
.Where(x => x.Godina == obj.Datum.Year)
.And(x => x.Nedelja == kn)
.SingleOrDefault <KursnaLista>()
.Kurs;
obj.Kurs = kurs;
_session.SaveOrUpdate(obj);
_session.Flush();
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(Json(new { Success = false, Message = ex.Message, obj }));
}
return(Json(new { Success = true, Message = "", obj }));
}
public IActionResult Dodaj(UplateDodajViewModel model)
{
if (!ModelState.IsValid)
{
return(View(GetDefaultViewModel(model)));
}
Korisnik korisnik = httpContext.HttpContext.Session.GetJson <Korisnik>(Konfiguracija.LogiraniKorisnik);
Uplata uplata = model.Uplata;
uplata.KlijentID = model.KlijentID;
uplata.ProjektID = model.ProjektID;
uplata.ClanUpraveID = korisnik.KorisnikID;
db.Uplate.Add(uplata);
db.SaveChanges();
LogiranjeAktivnosti logiranje = new LogiranjeAktivnosti(db);
Korisnik k = httpContext.HttpContext.Session.GetJson <Korisnik>(Konfiguracija.LogiraniKorisnik);
logiranje.Logiraj(korisnik.KorisnikID, DateTime.Now, httpContext.HttpContext.Connection.RemoteIpAddress.ToString(), httpContext.HttpContext.Request.Headers["User-Agent"].ToString().Substring(0, 100), "Dodavanje uplate", "Uplate");
return(RedirectToAction(nameof(Index)));
}
public IHttpActionResult PutUplata(int id, Uplata uplata)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != uplata.UplataId)
{
return(BadRequest());
}
db.Entry(uplata).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UplataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult Snimi(UplateDodajVM input)
{
if (!ModelState.IsValid)
{
GenerisiCmb(input);
return(View("Dodaj", input));
}
Uplata uNova = new Uplata
{
Datum = input.DatumUplate,
FakturaID = input.FakturaId,
Iznos = input.Iznos,
KlijentID = input.KlijentId,
NacinPlacanjaID = input.NacinPlacanjaId
};
_context.Uplata.Add(uNova);
_context.SaveChanges();
Faktura fNadji = _context.Faktura.Find(input.FakturaId);
fNadji.StatusFaktureID = 1; //Plaćena - Faktura je plaćena
_context.SaveChanges();
return(Redirect("/Prodaja/Fakture/Detalji?id=" + input.FakturaId));
}
private void bDodaj_Click(object sender, RoutedEventArgs e)
{
Uplata u = new Uplata();
UplateEditWindow uew = new UplateEditWindow(u);
uew.ShowDialog();
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if (mod == MOD.DODAVANJE)
{
original.Ucenik = comboBoxUcenik.SelectedItem as Ucenik;
original.Kurs = comboBoxKurs.SelectedItem as Kurs;
try
{
original.Iznos = float.Parse(textBoxIznos.Text);
}
catch
{
MessageBox.Show("Iznos mora biti broj, molimo izmenite.", "Greska", MessageBoxButton.OK);
}
Uplata novaUplata = UplateDAO.Create(original);
Aplikacija.Instanca.Uplate.Add(novaUplata);
novaUplata.Ucenik.Uplate.Add(novaUplata);
//int indexOdUcenika = Aplikacija.Instanca.Ucenici.IndexOf(novaUplata.Ucenik);
//Aplikacija.Instanca.Ucenici[indexOdUcenika].Uplate.Add(novaUplata);
}
else
{
original.setValues(editObject);
UplateDAO.Update(original);
}
this.DialogResult = true;
this.Close();
}
public static bool Add(SqlConnection conn, Uplata uplata)
{
bool retVal = false;
try
{
string query = "INSERT INTO uplata (id,datum,iznos)" +
"VALUES (@id,@datum,@iznos)";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", uplata.Id);
cmd.Parameters.AddWithValue("@datum", uplata.Datum);
cmd.Parameters.AddWithValue("@iznos", uplata.Iznos);
if (cmd.ExecuteNonQuery() == 1)
{
retVal = true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(retVal);
}
public static UplataUcenika GetUplataByUcenikId(SqlConnection conn, int id)
{
UplataUcenika uplUc = null;
try
{
string query = "SELECT uplata_id, ucenik_id " +
"FROM uplata_ucenika " +
"WHERE id=" + id;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader r = cmd.ExecuteReader();
if (r.Read())
{
int uplataId = (int)r["uplata_id"];
int ucenikId = (int)r["ucenik_id"];
Uplata uplata = UplataDAO.GetUplataById(Program.conn, uplataId);
Ucenik ucenik = UcenikDAO.GetUcenikById(Program.conn, ucenikId);
uplUc = new UplataUcenika(id, uplata, ucenik);
}
r.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(uplUc);
}
public static List <UplataUcenika> GetAll(SqlConnection conn)
{
List <UplataUcenika> sveUplateIUcenici = new List <UplataUcenika>();
try
{
string query = "SELECT id, ucenik_id, uplata_id " +
"FROM uplata_ucenika";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
int id = (int)r["id"];
int uplataId = (int)r["uplata_id"];
int ucenikId = (int)r["ucenik_id"];
Uplata uplata = UplataDAO.GetUplataById(Program.conn, uplataId);
Ucenik ucenik = UcenikDAO.GetUcenikById(Program.conn, ucenikId);
sveUplateIUcenici.Add(new UplataUcenika(id, uplata, ucenik));
}
r.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(sveUplateIUcenici);
}
public async Task <IActionResult> Edit(int id, [Bind("id,vrstaUplate,datum,iznos")] Uplata uplata)
{
if (id != uplata.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(uplata);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UplataExists(uplata.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(uplata));
}
public PlacanjeViewModel()
{
CreateUplata = new Uplata();
rfid = new Rfid();
rfid.InitializeReader(RfidReadSomething);
NavigationServis = new NavigationService();
PotvrdaUplate = new RelayCommand <object>(potvrda, mozeLiPotvrditi);
}
public IActionResult PlatiRacun(int BrojiloId)
{
Uplata uplata = new Uplata();
uplata.BrojiloID = BrojiloId;
return(PartialView("PlatiRacun", uplata));
}
private void Neaktivni(object sender, FilterEventArgs e)
{
Uplata j = e.Item as Uplata;
if (j != null)
{
e.Accepted = j.StatusUplate == false;
}
}
private void PretragaKurs(object sender, FilterEventArgs e)
{
Uplata j = e.Item as Uplata;
if (j != null)
{
e.Accepted = j.Kurs.ToString().ToLower().Contains(tbKurs.Text.ToLower());
}
}
private void PretragaUcenik(object sender, FilterEventArgs e)
{
Uplata j = e.Item as Uplata;
if (j != null)
{
e.Accepted = j.Ucenik.Ime.Contains(tbUcenik.Text.ToLower());
}
}
private void btnIzbrisi_Click(object sender, RoutedEventArgs e)
{
Uplata u = dgUplata.SelectedItem as Uplata;
u.Kurs.Uplate.Remove(u);
u.Ucenik.Uplate.Remove(u);
Aplikacija.Instanca.Uplate.Remove(u);
UplataDAO.Delete(u);
}
private void potvrda(object parametar)
{
Uplata uplata = CreateUplata;
if (uplata != null)
{
NavigationServis.Navigate(typeof(RecepcionerView), new RecepcionerViewModel(CreateUplata));
}
}
public UrediUplataPage(Uplata uplata)
{
InitializeComponent();
BindingContext = uplataVM = new UrediUplataVM()
{
Uplata = uplata
};
u = uplata;
}