private void cbBorProstojba_SelectedIndexChanged(object sender, EventArgs e)
{
if (LoadCompleted)
{
DataTable DTt = RemoteDB.select("SELECT * FROM boravisna_pristojba WHERE id='" + cbBorProstojba.SelectedValue + "'", "boravisna_pristojba").Tables[0];
if (DTt.Rows.Count > 0)
{
txtIznosBorPristojbe.Text = DTt.Rows[0]["iznos"].ToString();
}
RacunajStavku();
RacunajUkupno();
}
}
//private void radioButton2_CheckedChanged(object sender, EventArgs e)
//{
// xIme.Visible = true;
// xPrezime.Visible = true;
// xGrad.Visible = true;
// xAdresa.Visible = true;
// xTel.Visible = false;
// xmail.Visible = true;
// xOIB.Visible = false;
// xTvrtka.Visible = false;
//}
//private void radioButton1_CheckedChanged(object sender, EventArgs e)
//{
// xIme.Visible = false;
// xPrezime.Visible = false;
// xGrad.Visible = true;
// xAdresa.Visible = true;
// xTel.Visible = true;
// xmail.Visible = true;
// xOIB.Visible = true;
// xTvrtka.Visible = true;
//}
private string brojPartner()
{
DataTable DSbr = RemoteDB.select("SELECT MAX(id_partner) FROM partners", "partners").Tables[0];
if (DSbr.Rows[0][0].ToString() != "")
{
return((Convert.ToDouble(DSbr.Rows[0][0].ToString()) + 1).ToString());
}
else
{
return("1");
}
}
private string brojKartice()
{
DataTable DSbr = RemoteDB.select("SELECT MAX(broj_kartice) FROM partners", "partners").Tables[0];
if (DSbr.Rows[0][0].ToString() != "")
{
return((Convert.ToDouble(DSbr.Rows[0][0].ToString()) + 1).ToString("000000"));
}
else
{
return(Convert.ToDouble("1").ToString("000000"));
}
}
private void FillPartner(string id)
{
DataTable DT = RemoteDB.select("SELECT * FROM partners WHERE id_partner='" + id + "'", "partners").Tables[0];
txtAdresa.Text = DT.Rows[0]["adresa"].ToString();
txtBodovi.Text = DT.Rows[0]["bodovi"].ToString();
txtBrojKartice.Text = DT.Rows[0]["broj_kartice"].ToString();
txtDjelatnost.SelectedValue = DT.Rows[0]["id_djelatnost"].ToString();
txtEmail.Text = DT.Rows[0]["email"].ToString();
txtIme.Text = DT.Rows[0]["ime"].ToString();
txtMob.Text = DT.Rows[0]["mob"].ToString();
txtOib.Text = DT.Rows[0]["oib"].ToString();
txtPopust.Text = DT.Rows[0]["popust"].ToString();
txtPrezime.Text = DT.Rows[0]["prezime"].ToString();
txtSifra.Text = DT.Rows[0]["id_partner"].ToString();
txtTel.Text = DT.Rows[0]["tel"].ToString();
txtTvrtka.Text = DT.Rows[0]["ime_tvrtke"].ToString();
txtZupanija.SelectedValue = DT.Rows[0]["id_zupanija"].ToString();
cbGrad.SelectedValue = DT.Rows[0]["id_grad"].ToString();
try
{
dtpDatum.Value = Convert.ToDateTime(DT.Rows[0]["datum_rodenja"].ToString());
DataTable DTzemlja = RemoteDB.select("SELECT id_drzava FROM grad WHERE id_grad='" + DT.Rows[0]["id_grad"] + "'", "grad").Tables[0];
cbDrzava.SelectedValue = (int)DTzemlja.Rows[0]["id_drzava"];
}
catch (Exception)
{
}
if (DT.Rows[0]["aktivan"].ToString() == "1")
{
chbAktivan.Checked = true;
}
if (DT.Rows[0]["primanje_letaka"].ToString() == "1")
{
chbPrimanjeLetaka.Checked = true;
}
if (DT.Rows[0]["vrsta_korisnika"].ToString() == "1")
{
rbPoslovni.Checked = true;
rbPrivatni.Checked = false;
}
else
{
rbPoslovni.Checked = false;
rbPrivatni.Checked = true;
}
}
private void button2_Click(object sender, EventArgs e)
{
frmNoviGrad novigr = new frmNoviGrad();
novigr.ShowDialog();
//CB grad
cbGrad.DataSource = null;
DataSet DSgrad = RemoteDB.select("SELECT * FROM grad WHERE id_drzava = '" + cbDrzava.SelectedValue.ToString() + "' ORDER BY grad ", "grad");
cbGrad.DataSource = DSgrad.Tables[0];
cbGrad.DisplayMember = "grad";
cbGrad.ValueMember = "id_grad";
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
string sql = "INSERT INTO vrsta_usluge (naziv_usluge,iznos,napomena,aktivnost) VALUES (" +
"'" + txtNazivUsluge.Text + "'," +
"'" + txtIznos.Text.Replace(",", ".") + "'," +
"'" + txtNapomena.Text + "'," +
"'1'" +
")";
RemoteDB.insert(sql);
SetVrstaUsluge();
MessageBox.Show("Spremljno.");
}
private void btnObrisiOznacenog_Click(object sender, EventArgs e)
{
if (dgv.RowCount > 0)
{
if (MessageBox.Show("Dali ste sigurni da želite obrisati ovu stavku?", "Upozorenje", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (dgv.CurrentRow.Cells["id_unos"].FormattedValue.ToString() != "")
{
RemoteDB.delete("DELETE FROM unos_rezervacije WHERE id='" + dgv.CurrentRow.Cells["id_unos"].FormattedValue.ToString() + "'");
}
dgv.Rows.RemoveAt(dgv.CurrentRow.Index);
return;
}
}
}
private void fillCB()
{
//fill valuta
DSValuta = RemoteDB.select("SELECT * FROM valute", "valute");
cbValuta.DataSource = DSValuta.Tables[0];
cbValuta.DisplayMember = "ime_valute";
cbValuta.ValueMember = "id_valuta";
cbValuta.SelectedValue = 5;
//fill komercijalist
DS_Zaposlenik = RemoteDB.select("SELECT ime +' '+prezime as IME,id_zaposlenik FROM zaposlenici", "zaposlenici");
cbIzradio.DataSource = DS_Zaposlenik.Tables[0];
cbIzradio.DisplayMember = "IME";
cbIzradio.ValueMember = "id_zaposlenik";
}
/// <summary>
/// Remote DB からデータを取得し、Local DB に入力します。
/// </summary>
public void Download()
{
DatabaseHelper dbhelper = (DatabaseHelper)LocalDB;
var maxRemoteID = dbhelper.GetMaxRemoteID();
var remoteComments = RemoteDB.Select($"SELECT * FROM COMMENTS WHERE {nameof(Comment.ID)} > {maxRemoteID};");
remoteComments.ForEach(hash =>
{
var comment = Comment.ToComment(hash);
comment.RemoteID = comment.ID;
comment.Uploaded = true;
LocalDB.InsertComment(comment);
});
}
private void SetComboBox()
{
txtDjeca.Text = "0";
txtOdrasli.Text = "0";
txtBebe.Text = "0";
txtAvans.Text = "0";
DataTable DTvrsta_gosta = classDBlite.LiteSelect("SELECT * FROM vrsta_gosta", "vrsta_gosta").Tables[0];
cbVrsteGosta.DataSource = DTvrsta_gosta;
cbVrsteGosta.DisplayMember = "vrsta_gosta";
cbVrsteGosta.ValueMember = "id";
DataTable DTgencija = RemoteDB.select("SELECT * FROM agencija", "agencija").Tables[0];
cbAgencija.DataSource = DTgencija;
cbAgencija.DisplayMember = "ime_agencije";
cbAgencija.ValueMember = "id";
DataTable DTtip_sobe = RemoteDB.select("SELECT * FROM tip_sobe", "tip_sobe").Tables[0];
cbTipSoba.DataSource = DTtip_sobe;
cbTipSoba.DisplayMember = "tip";
cbTipSoba.ValueMember = "id";
DataTable DTdrzava = RemoteDB.select("SELECT * FROM zemlja", "zemlja").Tables[0];
cbDrzava.DataSource = DTdrzava;
cbDrzava.DisplayMember = "zemlja";
cbDrzava.ValueMember = "country_code";
cbDrzava.SelectedValue = "HR";
DataSet DSs = RemoteDB.select("SELECT id,broj_sobe, naziv_sobe FROM sobe", "sobe");
DataTable DTsoba = DSs.Tables[0];
cbSoba.DataSource = DTsoba;
cbSoba.DisplayMember = "naziv_sobe";
cbSoba.ValueMember = "id";
txtBrojSobe.DataBindings.Add("Text", DSs.Tables[0], "broj_sobe");
DataTable DTvrsta_usluge = RemoteDB.select("SELECT * FROM vrsta_usluge", "vrsta_usluge").Tables[0];
cbVrstaUsluge.DataSource = DTvrsta_usluge;
cbVrstaUsluge.DisplayMember = "naziv_usluge";
cbVrstaUsluge.ValueMember = "id";
nuGodina.Value = DateTime.Now.Year;
}
private void button1_Click(object sender, EventArgs e)
{
RemoteDB.update(string.Format(@"UPDATE neuspjela_fiskalizacija
SET
xml = '{0}',
greska = '{1}'
WHERE broj_racuna = '{2}' AND id_ducan = '{3}' AND id_kasa = '{4}';",
poslano,
greska,
brojRacuna,
ducan,
blagajna));
MessageBox.Show("Spremljeno");
this.Close();
}
private void SetGrupe()
{
if (dgv.Rows.Count > 0)
{
dgv.Rows.Clear();
}
DataTable DT = RemoteDB.select("SELECT * FROM grad", "grad").Tables[0];
for (int i = 0; i < DT.Rows.Count; i++)
{
dgv.Rows.Add(DT.Rows[i]["grad"].ToString(), DT.Rows[i]["posta"].ToString(),
DT.Rows[i]["zupanija"].ToString(), DT.Rows[i]["id_drzava"].ToString(),
DT.Rows[i]["naselje"].ToString(), DT.Rows[i]["id_grad"].ToString());
}
}
private void cbDrzava_SelectedIndexChanged(object sender, EventArgs e)
{
if (preload == true)
{
try
{
//CB grad
DataSet DSgrad1 = RemoteDB.select("SELECT * FROM grad WHERE id_drzava = '" + cbDrzava.SelectedValue + "' ORDER BY grad ", "grad");
cbGrad.DataSource = DSgrad1.Tables[0];
cbGrad.DisplayMember = "grad";
cbGrad.ValueMember = "id_grad";
//cbGrad.SelectedValue = "2806";
}
catch { }
}
}
private void dgvSk_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgvSk.CurrentCell.ColumnIndex == 2)
{
try
{
string sql = "UPDATE valute SET ime_valute='" + dgvSk.Rows[e.RowIndex].Cells["naziv"].FormattedValue.ToString() + "' WHERE id_valuta='" + dgvSk.Rows[e.RowIndex].Cells["id_valuta"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else if (dgvSk.CurrentCell.ColumnIndex == 1)
{
try
{
string sql = "UPDATE valute SET naziv='" + dgvSk.Rows[e.RowIndex].Cells["Skraceni_naziv"].FormattedValue.ToString() + "' WHERE id_valuta='" + dgvSk.Rows[e.RowIndex].Cells["id_valuta"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else if (dgvSk.CurrentCell.ColumnIndex == 4)
{
try
{
decimal dec = 0;
if (String.IsNullOrEmpty(dgvSk.Rows[e.RowIndex].Cells["tecaj"].FormattedValue.ToString()))
{
dgvSk.Rows[e.RowIndex].Cells["tecaj"].Value = "0";
MessageBox.Show("Greška, kod unosa tečaja.");
return;
}
string sql = "UPDATE valute SET tecaj='" + dgvSk.Rows[e.RowIndex].Cells["tecaj"].FormattedValue.ToString() + "' WHERE id_valuta='" + dgvSk.Rows[e.RowIndex].Cells["id_valuta"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void dgv_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgv.CurrentCell.ColumnIndex == 0)
{
try
{
string sql = "UPDATE agencija SET ime_agencije='" + dgv.Rows[e.RowIndex].Cells["ime_agencije"].FormattedValue.ToString() + "' WHERE id='" + dgv.Rows[e.RowIndex].Cells["id"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
if (dgv.CurrentCell.ColumnIndex == 1)
{
try
{
string sql = "UPDATE agencija SET napomena='" + dgv.Rows[e.RowIndex].Cells["napomena"].FormattedValue.ToString() + "' WHERE id='" + dgv.Rows[e.RowIndex].Cells["id"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else if (dgv.CurrentCell.ColumnIndex == 2)
{
try
{
string aa = "0";
if (dgv.Rows[e.RowIndex].Cells["aktivnost"].FormattedValue.ToString() == "True")
{
aa = "1";
}
string sql = "UPDATE agencija SET aktivnost='" + aa + "' WHERE id='" + dgv.Rows[e.RowIndex].Cells["id"].FormattedValue.ToString() + "'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
if (txtKod.Text == "" || txtDrzava.Text == "")
{
MessageBox.Show("Greška niste upisali naziv ili kod države");
return;
}
string sql = "INSERT INTO zemlja (country_code,zemlja,aktivnost) VALUES (" +
"'" + txtKod.Text + "'," +
"'" + txtDrzava.Text + "','1'" +
")";
RemoteDB.insert(sql);
SetGrupe();
MessageBox.Show("Spremljno.");
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtTipSobe.Text))
{
MessageBox.Show("Greška, niste upisali tip sobe.");
return;
}
string sql = "INSERT INTO tip_sobe (tip,aktivnost) VALUES (" +
"'" + txtTipSobe.Text + "'," +
"'1'" +
")";
RemoteDB.insert(sql);
SetTipSobe();
MessageBox.Show("Spremljno.");
}
private void pictureBox2_Click(object sender, EventArgs e)
{
sifarnici.frmPartnerTrazi partnerTrazi = new sifarnici.frmPartnerTrazi();
partnerTrazi.ShowDialog();
if (RESORT.Properties.Settings.Default.id_partner != "")
{
DataSet partner = new DataSet();
partner = RemoteDB.select("SELECT id_partner,ime_tvrtke FROM partners WHERE id_partner ='" + RESORT.Properties.Settings.Default.id_partner + "'", "partners");
if (partner.Tables[0].Rows.Count > 0)
{
txtPartner.Text = partner.Tables[0].Rows[0]["id_partner"].ToString();
}
else
{
MessageBox.Show("Upisana šifra ne postoji.", "Greška");
}
}
}
private void SetValues()
{
DataTable DT = RemoteDB.select("SELECT sobe.naziv_sobe FROM unos_rezervacije LEFT JOIN sobe ON sobe.id=unos_rezervacije.id_soba WHERE unos_rezervacije.broj='" + broj_unosa + "' AND unos_rezervacije.godina='" + godina + "' GROUP BY sobe.naziv_sobe", "unos_rezervacije").Tables[0];
string s = "";
int i = 0;
foreach (DataRow row in DT.Rows)
{
if (i == 3 || i == 6 || i == 9 || i == 12)
{
s += "\r\n";
}
s += row["naziv_sobe"].ToString() + ", ";
i++;
}
lblNaslov.Text = "Broj unosa: " + broj_unosa + "\r\nSobe: " + s;
}
/// <summary> setup the initial session and application databases </summary>
protected void Page_Init(object sender, EventArgs e)
{
Application.Lock();
try {
if (Application[ApplicationRemoteKey] == null)
Application[ApplicationRemoteKey] = new RemoteDB();
if (Application[ApplicationLocalKey] == null)
Application[ApplicationLocalKey] = new LocalDB<string>();
lock (Session) {
if (Session[SessionLocalKey] == null)
Session[SessionLocalKey] = new LocalDB<string>();
if (Session[CurrentKey] == null)
Session[CurrentKey] = 0;
Session[SwitcherKey] = new Switcher(
new Enable(isEnabled => {
Toggle.Enabled = Search.Enabled = Enter.Enabled = Remove.Enabled = isEnabled;
}),
new IAccess[]{
new Access(() => Current.Text, s => { Current.Text = s; }),
new Access(() => Size.Text, s => { Size.Text = s; }),
new Access(() => Names.Text, s => { Names.Text = s; }),
new Access(() => Phones.Text, s => { Phones.Text = s; }),
new Access(() => Rooms.Text, s => { Rooms.Text = s; })},
new SetClick[]{
new SetClick((EventHandler eh) => { Toggle.Click += eh; }),
new SetClick((EventHandler eh) => { Search.Click += eh; }),
new SetClick((EventHandler eh) => { Enter.Click += eh; }),
new SetClick((EventHandler eh) => { Remove.Click += eh; }),
new SetClick((EventHandler eh) => { Size.Load += eh; }) },
new WorkQueue(),
"session local DB", Session[SessionLocalKey],
"application local DB", Application[ApplicationLocalKey],
"application remote DB", Application[ApplicationRemoteKey]);
}
} finally {
Application.UnLock();
}
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
decimal dec = 0;
if (String.IsNullOrEmpty(txtNazivSobe.Text))
{
MessageBox.Show("Greška, niste upisali naziv sobe.");
return;
}
if (!Decimal.TryParse(txtBrojSobe.Text, out dec))
{
MessageBox.Show("Greška, niste upisali pravilno broj sobe.");
return;
}
if (!Decimal.TryParse(txtBrojLezaja.Text, out dec))
{
MessageBox.Show("Greška, niste upisali pravilno broj ležaja.");
return;
}
if (!Decimal.TryParse(txtCijenaNocenja.Text, out dec))
{
txtCijenaNocenja.Text = "0";
//MessageBox.Show("Greška kod upisa cijene noćenja.", "Greška"); return;
}
string sql = "INSERT INTO sobe (broj_sobe,id_tip_sobe,naziv_sobe,broj_lezaja,cijena_nocenja,napomena,aktivnost) VALUES (" +
"'" + txtBrojSobe.Text + "'," +
"'" + cbTipSoba.SelectedValue + "'," +
"'" + txtNazivSobe.Text + "'," +
"'" + txtBrojLezaja.Text + "'," +
"'" + txtCijenaNocenja.Text + "'," +
"'" + txtNapomena.Text + "'," +
"'1'" +
")";
RemoteDB.insert(sql);
SetSobe();
MessageBox.Show("Spremljno.");
}
private void SetGrupe()
{
if (dgv.Rows.Count > 0)
{
dgv.Rows.Clear();
}
DataTable DT = RemoteDB.select("SELECT * FROM zemlja ORDER BY zemlja", "zemlja").Tables[0];
for (int i = 0; i < DT.Rows.Count; i++)
{
bool b = false;
if (DT.Rows[i]["aktivnost"].ToString() == "1")
{
b = true;
}
dgv.Rows.Add(DT.Rows[i]["country_code"].ToString(), DT.Rows[i]["zemlja"].ToString(), b, DT.Rows[i]["id_zemlja"].ToString());
}
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtNazivAgencije.Text))
{
MessageBox.Show("Greška, niste upisali naziv agencije.");
return;
}
string sql = "INSERT INTO agencija (ime_agencije,napomena,aktivnost) VALUES (" +
"'" + txtNazivAgencije.Text + "'," +
"'" + txtNapomena.Text + "'," +
"'1'" +
")";
RemoteDB.insert(sql);
SetSobe();
MessageBox.Show("Spremljno.");
}
private void btnNoviUnos_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtOznake.Text))
{
MessageBox.Show("Greška, niste upisali naziv pristojbe.");
return;
}
string sql = "INSERT INTO boravisna_pristojba (oznaka,boravisna_pristojba,iznos,aktivnost) VALUES (" +
"'" + txtOznake.Text + "'," +
"'" + txtNazivPristojbe.Text + "'," +
"'" + txtIznos.Text + "'," +
"'1'" +
")";
RemoteDB.insert(sql);
SetBoravisna_pristojba();
MessageBox.Show("Spremljno.");
}
private static void AlterValute()
{
DataTable dt = RemoteDB.select("select table_name from information_schema.tables where TABLE_TYPE <> 'VIEW'", "Table").Tables[0];
string provjeri_col_type = "select column_name, data_type, character_maximum_length from information_schema.columns where " +
" table_name='valute' AND column_name ='sifra'";
DataTable DTcoltype = RemoteDB.select(provjeri_col_type, "valute").Tables[0];
if (DTcoltype.Rows.Count < 1)
{
try
{
string sql = "ALTER TABLE valute ADD COLUMN sifra character(3); " +
"ALTER TABLE valute ADD COLUMN naziv character(3); " +
"ALTER TABLE valute ADD COLUMN puni_naziv character varying(100); " +
"ALTER TABLE valute ADD COLUMN paritet numeric; ";
RemoteDB.update(sql);
sql = "UPDATE valute SET sifra='978',naziv='EUR',puni_naziv='Euro',paritet='1'" +
" WHERE ime_valute='978 EUR'";
RemoteDB.update(sql);
sql = "UPDATE valute SET sifra='840',naziv='USD',puni_naziv='Američki Dolar',paritet='1'" +
" WHERE ime_valute='840 USD'";
RemoteDB.update(sql);
sql = "UPDATE valute SET sifra='348',naziv='HUF',puni_naziv='Mađarska forinta',paritet='100'" +
" WHERE ime_valute='348 HUF'";
RemoteDB.update(sql);
sql = "UPDATE valute SET sifra='756',naziv='CHF',puni_naziv='Švicarski franak',paritet='1'" +
" WHERE ime_valute='756 CHF'";
RemoteDB.update(sql);
sql = "UPDATE valute SET sifra='1',tecaj='1',naziv='HR',puni_naziv='Kune',paritet='1'" +
" WHERE id_valuta='1'";
RemoteDB.update(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void PrvoPokretanje()
{
DataTable DTt = RemoteDB.select("SELECT * FROM boravisna_pristojba WHERE id='" + cbBorProstojba.SelectedValue + "'", "boravisna_pristojba").Tables[0];
if (DTt.Rows.Count > 0)
{
txtIznosBorPristojbe.Text = DTt.Rows[0]["iznos"].ToString();
}
else
{
txtIznosBorPristojbe.Text = "0";
}
string sql = "SELECT r_cijenasoba.cijena_nocenja,valute.tecaj FROM r_cijenasoba " +
" LEFT JOIN valute ON valute.id_valuta=r_cijenasoba.id_valuta" +
" WHERE id_soba='" + cbSoba.SelectedValue.ToString() + "'" +
" AND '" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "'>=r_cijenasoba.od_datuma " +
" AND '" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "'<=r_cijenasoba.do_datuma;";
DataTable DTss = RemoteDB.select(sql, "sobe").Tables[0];
if (DTss.Rows.Count > 0)
{
cijena_sobe = Convert.ToDecimal(DTss.Rows[0]["cijena_nocenja"].ToString()) * Convert.ToDecimal(DTss.Rows[0]["tecaj"].ToString());
}
else
{
MessageBox.Show("Za današnji dan nemate zadanu cijenu za navedenu sobu.");
cijena_sobe = 0;
}
DataTable DTu = RemoteDB.select("SELECT * FROM vrsta_usluge WHERE id='" + cbVrstaUsluge.SelectedValue + "'", "vrsta_usluge").Tables[0];
if (DTu.Rows.Count > 0)
{
txtCijenaUsluge.Text = DTu.Rows[0]["iznos"].ToString();
}
RacunajStavku();
RacunajUkupno();
}
public void ReplicationTest()
{
RemoteDB remoteDB = new RemoteDB();
//DocInfo[] info = remoteDB.GetAllDocuments("http://127.0.0.1:5984", "test");
NouchDB nouchDB = new NouchDB();
//nouchDB.Delete(new Options());
//Debug.WriteLine(nouchDB.Changes());
//string res = RevsDiff(nouchDB, remoteDB, info);
//res = "{\"keys\":" + res + "}";
long lastSync = nouchDB.GetLastSync("http://127.0.0.1:5984/test");
JsonData docs = remoteDB.GetChanges("http://127.0.0.1:5984", "test", true, lastSync);
foreach (JsonData result in docs["results"])
{
string id = (string)result["id"];
string rev = (string)result["changes"][0]["rev"];
// //result.Remove("_rev");
// //result.Remove("_id");
string doc = result["doc"].ToJson();
try
{
nouchDB.PutDoc(id, doc, rev);
}
catch (Exception ee)
{
Debug.WriteLine(ee.ToString());
}
}
Debug.WriteLine("Document sync: " + docs["results"].Count);
Debug.WriteLine(nouchDB.AllDocs());
nouchDB.SetLastSync("http://127.0.0.1:5984/test", (int)docs["last_seq"]);
//nouchDB.Close();
}
private void btnUlaz_Click(object sender, EventArgs e)
{
DataTable DTzp = RemoteDB.select("SELECT id_zaposlenik FROM zaposlenici WHERE id_zaposlenik='" + cbBlagajnik.SelectedValue.ToString() + "' AND zaporka = '" + txtZaporka.Text.Trim() + "'", "zaposlenici").Tables[0];
if (DTzp.Rows.Count > 0)
{
prijava = true;
this.Close();
//var mdiForm = this.MdiParent;
//var childForm = new frmKasa();
Properties.Settings.Default.id_zaposlenik = cbBlagajnik.SelectedValue.ToString();
Properties.Settings.Default.Save();
//childForm.MainForm = MainForm;
//childForm.Show();
}
else
{
MessageBox.Show("Greška.\r\nVaša autorizacija nije valjana.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Upload()
{
// コメントをアップする処理の前にリモートのコメントを取得する。
// これを行わないと、後々整合性が取れなくなる。
Download();
DatabaseHelper localDBHelper = (DatabaseHelper)LocalDB;
var sql = $"SELECT * FROM {DatabaseHelper.DatabaesTableName} WHERE {nameof(Comment.RemoteID)} < 0 AND {nameof(Comment.Uploaded)} = 'False'";
var uploadComments = localDBHelper.Select(sql);
uploadComments.ForEach(hash =>
{
var comment = Comment.ToComment(hash);
RemoteDB.InsertComment(comment);
comment.Uploaded = true;
// RemoteID, Uploaded が書き換わるのでそれをローカルDBに反映する。
localDBHelper.Update(comment);
});
}
private void frmPopis_cijena_po_datumima_Load(object sender, EventArgs e)
{
string sql = "SELECT sobe.broj_sobe,valute.ime_valute,sobe.naziv_sobe,r_cijenasoba.od_datuma,r_cijenasoba.do_datuma,r_cijenasoba.cijena_nocenja " +
" FROM r_cijenasoba" +
" LEFT JOIN sobe ON sobe.id=r_cijenasoba.id_soba" +
" LEFT JOIN valute ON valute.id_valuta=r_cijenasoba.id_valuta" +
" WHERE sobe.id='" + _id_soba + "' ";
DataTable DT = RemoteDB.select(sql, "r_cijenasoba").Tables[0];
foreach (DataRow row in DT.Rows)
{
dgv.Rows.Add(row["broj_sobe"].ToString(),
row["naziv_sobe"].ToString(),
row["od_datuma"].ToString(),
row["do_datuma"].ToString(),
row["cijena_nocenja"].ToString(),
row["ime_valute"].ToString()
);
}
}
private void btnSviUnosi_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Potvrdom ovog unosa spremate cijene po svim sobama u iznosu od " + txtCijenaSobe.Text + " kn.\r\nDali ste sigurni da želite spremiti ove promjene?", "Upozorenje", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DataTable DT = RemoteDB.select("SELECT * FROM sobe", "sobe").Tables[0];
RemoteDB.delete("DELETE FROM r_cijenasoba");
foreach (DataRow row in DT.Rows)
{
string sql = "INSERT INTO r_cijenasoba (cijena_nocenja,od_datuma,do_datuma,id_valuta,broj_sobe,id_soba)" +
" VALUES" +
" ('" + txtCijenaSobe.Text.Replace(",", ".") + "'," +
"'" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "'," +
"'" + DateTime.Now.AddYears(20).ToString("yyyy-MM-dd H:mm:ss") + "'," +
"'" + cbValute.SelectedValue + "'," +
"'" + row["broj_sobe"] + "'," +
"'" + row["id"] + "'" +
")";
RemoteDB.insert(sql);
}
}
}
