/// <summary>
/// Popolnuvanje na tabelata so soodvetnite
/// podatoci koi vleguvaat vo izvestajot
/// </summary>
private void VcitajPodatoci()
{
String sqlTab = @"SELECT MESEC_PROMET, IZNOS_PROMET
FROM PROMET
WHERE RESTORAN_ID = :REST_ID AND GODINA_PROMET = :GOD
ORDER BY MESEC_PROMET";
OracleCommand cmd = new OracleCommand(sqlTab, Conn);
try
{
OracleParameter prm = new OracleParameter("REST_ID", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("GOD", OracleDbType.Int64);
prm.Value = this.tekovnaGodina;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
int ind = 0;
int godPromet = 0;
while (dr.Read())
{
int tmp = dr.GetInt32(1);
//int pom = int.Parse(dr.GetString(0).ToString()) - 1;
//MessageBox.Show(pom.ToString());
ind = int.Parse(dr.GetString(0).ToString()) - 1;
this.PrometMeseci[ind].Text = tmp.ToString() + " ден. ";
godPromet += tmp;
//ind++;
}
if (ind != 0)
{
this.lblPromet.Text = godPromet.ToString() + " ден. ";
}
else
{
this.lblPromet.Text = " - ";
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
}
private void tbIme_Click(object sender, EventArgs e)
{
if (!this.ModifyMode)
{
MessageBoxForm mbf = new MessageBoxForm("Не е возможна промена на тоа поле.\nПритиснете измени и обидете се повторно!", false);
mbf.ShowDialog();
this.LoseCursor(sender);
}
}
private void btnOtkazi_Click(object sender, EventArgs e)
{
MessageBoxForm mbf = new MessageBoxForm("Дали навистина сакате да ја откажете нарачката?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
}
Naracka = new Naracka(-1, 0, DateTime.Now);
}
private void btnOtkazi_Click(object sender, EventArgs e)
{
MessageBoxForm mbf = new MessageBoxForm("Промените ќе бидат отфрлени.\nДали сте сигурни дека сакате да ја напуштите формата?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.AutoValidate = AutoValidate.Disable;
this.Close();
}
}
/// <summary>
/// Popolnuvanje na tabelata so soodvetnite
/// podatoci koi vleguvaat vo izvestajot
/// </summary>
private void VcitajPodatoci()
{
String sqlTab = this.GetReportSQL();
OracleCommand cmd = new OracleCommand(sqlTab, Conn);
try
{
OracleParameter prm = new OracleParameter("REST_ID1", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("REST_ID2", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("REST_ID3", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("REST_ID4", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("GOD", OracleDbType.Int64);
prm.Value = this.tekovnaGodina;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
int ind = 0;
while (dr.Read())
{
this.VkPromet[ind].Text = dr.GetInt32(2).ToString() + " ден. ";
this.VkPlata[ind].Text = dr.GetInt32(3).ToString() + " ден. ";
this.VkDodatoci[ind].Text = dr.GetInt32(4).ToString() + " ден. ";
this.VkTrosoci[ind].Text = dr.GetInt32(5).ToString() + " ден. ";
this.Sostojba[ind].Text = dr.GetInt32(6).ToString() + " ден. ";
ind++;
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
}
private void tbKategorija_Validating(object sender, CancelEventArgs e)
{
TextBox tb = (sender as TextBox);
if (tb.Text.Trim() == "")
{
MessageBoxForm mbf = new MessageBoxForm("Полето е задолжително!", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
private void buttonSmetka_Click(object sender, EventArgs e)
{
if (this.CurrentEmp != null)
{
// se vcituvaat korisnickoto ime i lozinkata
// ako ne postojat treba da se prasa da se kreiraat
string sqlSmetka = @"SELECT KORISNICHKO_IME, LOZINKA FROM KORISNIK WHERE RESTORAN_ID = :REST_ID AND VRABOTEN_ID = :VRAB_ID";
OracleCommand cmd = new OracleCommand(sqlSmetka, this.Conn);
cmd.CommandType = CommandType.Text;
OracleParameter prm;
try
{
prm = new OracleParameter("REST_ID", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("VRAB_ID", OracleDbType.Int64);
prm.Value = this.CurrentEmp.VrabotenID;
cmd.Parameters.Add(prm);
OracleDataReader dr = cmd.ExecuteReader();
if (!dr.HasRows)
{
MessageBoxForm mbf = new MessageBoxForm("Вработениот нема корисничка сметка!\nДали сакате да ја креирате?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
UpravuvanjeSmetki SmetkiForma = new UpravuvanjeSmetki(this.CurrentEmp.VrabotenID, this.Restoran, this.Conn);
SmetkiForma.Show();
}
}
else
{
string user = dr.GetString(0);
string pass = dr.GetString(1);
UpravuvanjeSmetki SmetkiForma = new UpravuvanjeSmetki(this.CurrentEmp.VrabotenID, this.Restoran, this.Conn, user, pass);
SmetkiForma.Show();
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
this.Close();
else
this.Close();
}
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Немате одбрано вработен!\nОдберете вработен и обидете се повторно", false);
mbf.ShowDialog();
}
}
private void buttonFASAP5_Click(object sender, EventArgs e)
{
if (SelectedComponent == null)
{
return;
}
if (SelectedComponent is Meni && !(SelectedComponent as Meni).ValidnostMeni)
{
MessageBoxForm mb = new MessageBoxForm(String.Format("Активирај \"{0}\"?", SelectedComponent.GetName()));
if (mb.ShowDialog() == DialogResult.Yes)
{
try
{
SelectedComponent.SqlActivate(Conn, Restoran.RestoranID);
SelectedComponent = SelectedComponent;
PopolniListaMenija();
}
catch (Exception ex)
{
timer1.Stop();
lblErrorMessage.Text = ex.Message;
lblErrorMessage.Visible = true;
timer1.Start();
}
}
}
else
{
MessageBoxForm mb = new MessageBoxForm(String.Format("Бриши \"{0}\"?", SelectedComponent.GetName()));
if (mb.ShowDialog() == DialogResult.Yes)
{
try
{
SelectedComponent.SqlDelete(Conn, Restoran.RestoranID);
if (!ShowInactive)
{
SelectedComponent = null;
}
else
{
SelectedComponent = SelectedComponent;
}
PopolniListaMenija();
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
lblErrorMessage.Visible = true;
timer1.Start();
}
}
}
}
private void pbLeftG_Click(object sender, EventArgs e)
{
if (this.tekovnaGodina > 1950)
{
this.tekovnaGodina--;
this.ObnoviEkran();
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Извештаи постари од 1950 не може да бидат прикажани", false);
mbf.ShowDialog();
}
}
private void buttonDodatoci_Click(object sender, EventArgs e)
{
if (this.CurrentEmp != null)
{
PregledDodatoci viewAddForm = new PregledDodatoci(this.Conn, this.Restoran, this.CurrentEmp.VrabotenID);
viewAddForm.ShowDialog();
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Немате одбрано вработен!\nОдберете вработен и обидете се повторно", false);
mbf.ShowDialog();
}
}
private void pbRightG_Click(object sender, EventArgs e)
{
if (this.tekovnaGodina < DateTime.Now.Year)
{
this.tekovnaGodina++;
this.ObnoviEkran();
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Прикажана е тековната година", false);
mbf.ShowDialog();
}
}
private void tbDostava_Validating(object sender, CancelEventArgs e)
{
TextBox tb = (sender as TextBox);
int res;
if (tb.Text.Trim() != "" && !int.TryParse(tb.Text, out res))
{
MessageBoxForm mbf = new MessageBoxForm("Пoлето мора да содржи само цифри!", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
private void tbDatum_Validating(object sender, CancelEventArgs e)
{
Regex reg = new Regex(@"^(((0[1-9]|[12]\d|3[01])\/(0[13578]|1[02])\/((19|[2-9]\d)\d{2}))|((0[1-9]|[12]\d|30)\/(0[13456789]|1[012])\/((19|[2-9]\d)\d{2}))|((0[1-9]|1\d|2[0-8])\/02\/((19|[2-9]\d)\d{2}))|(29\/02\/((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))");
TextBox tb = (sender as TextBox);
if (tb.Text.Trim() != "" && !reg.IsMatch(tb.Text.Trim()))
{
MessageBoxForm mbf = new MessageBoxForm("Датумот треба да е во формат dd/MM/yyyy\nПример: 01/02/2013", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
private void tbOdmor_Validating(object sender, CancelEventArgs e)
{
if (this.ModifyMode)
{
TextBox tb = (sender as TextBox);
int res;
if (int.TryParse(tb.Text, out res) && res > 26)
{
MessageBoxForm mbf = new MessageBoxForm("Годишниот одмор не може да биде подолг од 26 дена!", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
}
private void buttonFASAP1_Click(object sender, EventArgs e)
{
if (!ValidateChildren() || tbURL.Text.Trim().Length == 0)
{
return;
}
MessageBoxForm mbf = new MessageBoxForm("Дали навистина сакате да го промените логото на ресторанот?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
CurrRestoran.LogoUrl = tbURL.Text;
Thread oThread = new Thread(new ThreadStart(PostaviNovoLogo));
oThread.Start();
LoadingMethod();
}
}
/// <summary>
/// Vcituvanje na site podatoci za dadeniot vraboten
/// i popolnuvanje na soodvetnite polinja
/// </summary>
private void PopolniInfo()
{
this.lblVrabotenID.Text = this.VrabotenID.ToString();
if (this.KorisnickoIme != null && this.Lozinka != null)
{
this.tbUserName.Text = this.KorisnickoIme;
this.tbPassword.Text = this.Lozinka;
return;
}
// Vcituvanje na podatocite za korisnickata smetka
string sqlSmetka = @"SELECT KORISNICHKO_IME, LOZINKA FROM KORISNIK WHERE RESTORAN_ID = :REST_ID AND VRABOTEN_ID = :VRAB_ID";
OracleCommand cmd = new OracleCommand(sqlSmetka, this.Conn);
cmd.CommandType = CommandType.Text;
OracleParameter prm;
try
{
prm = new OracleParameter("REST_ID", OracleDbType.Int64);
prm.Value = this.Restoran.RestoranID;
cmd.Parameters.Add(prm);
prm = new OracleParameter("VRAB_ID", OracleDbType.Int64);
prm.Value = this.VrabotenID;
cmd.Parameters.Add(prm);
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
tbUserName.Text = dr.GetString(0);
tbPassword.Text = dr.GetString(1);
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
}
/// <summary>
/// Gi azurira podatocite za funkcijata so menuvanje
/// na vrednostite na soodvetnite atributi vo bazata
/// </summary>
private bool AzurirajPodatoci()
{
string sqlPoz = @"INSERT INTO FUNKCIJA (POZICIJA) VALUES (:POZ)";
OracleCommand cmd = new OracleCommand(sqlPoz, this.Conn);
try
{
OracleParameter prm = new OracleParameter("POZ", OracleDbType.Varchar2);
prm.Value = this.tbImePozicija.Text;
cmd.Parameters.Add(prm);
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
//cmd.ExecuteNonQuery();
int br;
try
{
br = cmd.ExecuteNonQuery();
}
catch (Exception)
{
br = -1;
}
if (br == -1)
{
return(false);
}
//this.PopolniInfo();
return(true);
}
private void PopolniTelefoni()
{
this.telInd = 0;
this.Telefoni = new List <string>();
string sqlPozicii = @"SELECT TELEFON FROM IMENIK WHERE RESTORAN_ID= :REST_ID ";
OracleCommand cmd = new OracleCommand(sqlPozicii, this.Conn);
cmd.CommandType = CommandType.Text;
try
{
OracleParameter prm = new OracleParameter("REST_ID", OracleDbType.Int64);
prm.Value = this.RestoranID;
cmd.Parameters.Add(prm);
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
this.Telefoni.Add(dr.GetString(0));
}
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
if (Telefoni.Count() != 0)
{
lblListaTel.Text = Telefoni[0];
}
else
{
lblListaTel.Text = "";
}
}
/// <summary>
/// Prezemanje na site potrebni podatoci za vrabotenite
/// od bazata na podatoci
/// </summary>
public void VcitajVraboteni()
{
this.AllEmployees = new List<VrabotenInfo>();
this.indVrab = 0;
string sqlVraboteni = @"SELECT VRABOTEN_ID, IME_VRABOTEN, PREZIME_VRABOTEN, POZICIJA, PLATA, STATUS, IZVRSHENI_NARACHKI FROM VRABOTEN NATURAL JOIN IZVRSHUVA WHERE RESTORAN_ID = :RES_ID ORDER BY VRABOTEN_ID";
OracleCommand cmd = new OracleCommand(sqlVraboteni, Conn);
try
{
OracleParameter prm = new OracleParameter("RES_ID", OracleDbType.Int64);
prm.Value = Restoran.RestoranID;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
VrabotenInfo vr = new VrabotenInfo();
vr.VrabotenID = dr.GetInt32(0);
vr.Ime = dr.GetString(1);
vr.Prezime = dr.GetString(2);
vr.Pozicija = dr.GetString(3);
vr.Plata = dr.GetInt32(4);
int st;
if (int.TryParse(dr.GetString(5), out st))
vr.Status = st;
vr.Naracki = dr.GetInt32(6);
this.AllEmployees.Add(vr);
//samo privremeno
//this.ShowingEmployees.Add(vr);
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
this.Close();
else
this.Close();
}
//this.FiltrirajVraboteni();
this.UpdateScreen();
}
/// <summary>
/// Otstranuvanje na izbranata pozicija od bazata
/// </summary>
/// <returns></returns>
private bool OtstraniPozicija()
{
string sqlPoz = @"DELETE FROM FUNKCIJA WHERE POZICIJA LIKE :POZ";
OracleCommand cmd = new OracleCommand(sqlPoz, this.Conn);
try
{
OracleParameter prm = new OracleParameter("POZ", OracleDbType.Varchar2);
prm.Value = this.CurrentPoz;
cmd.Parameters.Add(prm);
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
//cmd.ExecuteNonQuery();
int br;
try
{
br = cmd.ExecuteNonQuery();
}
catch (Exception)
{
br = -1;
}
if (br == -1)
{
return(false);
}
//this.PopolniInfo();
return(true);
}
private void buttonOtkazi_Click(object sender, EventArgs e)
{
if (this.ModifyMode)
{
MessageBoxForm mbf = new MessageBoxForm("Дали сте сигурни дека сакате да ги отфрлите промените?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
//this.AutoValidate = AutoValidate.Disable;
this.ModifyMode = false;
this.ChangeVisibility();
}
}
else
{
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
private void tbGodina_Validating(object sender, CancelEventArgs e)
{
TextBox tb = (sender as TextBox);
int res;
if (tb.Text.Trim() == "")
{
e.Cancel = false;
return;
}
if (!int.TryParse(tb.Text, out res) || tb.Text.Length != 4)
{
MessageBoxForm mbf = new MessageBoxForm("Датумот е невалиден!", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
/// <summary>
/// Prezemanje na site mozni funkcii koi postojat vo bazata
/// </summary>
private void PopolniPozicii()
{
this.PozInd = 0;
this.Pozicii = new List <string>();
string sqlPozicii = @"SELECT * FROM FUNKCIJA ORDER BY POZICIJA";
OracleCommand cmd = new OracleCommand(sqlPozicii, this.Conn);
cmd.CommandType = CommandType.Text;
try
{
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
this.Pozicii.Add(dr.GetString(0));
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
for (int i = 0; i < this.Pozicii.Count; i++)
{
if (this.Pozicii[i] == this.lblPozicija.Text)
{
this.PozInd = i;
break;
}
}
UpdatePozicii();
}
private void buttonIzmeni_Click(object sender, EventArgs e)
{
if (!this.ModifyMode)
{
buttonIzmeni.Text = "Зачувај";
this.ModifyMode = true;
}
else
{
if (this.tbPassword.Text.Trim() == this.tbRetypePassword.Text.Trim())
{
MessageBoxForm mbf = new MessageBoxForm("Дали сте сигурни дека сакате да ги зачувате промените?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
if (this.AzurirajPodatoci() != -1)
{
MessageBoxForm mbf1 = new MessageBoxForm("Податоците беа успешно променети!", false);
mbf1.ShowDialog();
buttonIzmeni.Text = "Измени";
this.ModifyMode = false;
}
else
{
MessageBoxForm mbf1 = new MessageBoxForm("Обидот за промена на некои од податоците не беше успешен.\nОбидете се повторно.", false);
mbf1.ShowDialog();
}
}
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Потврдата на лозинката не одговара на првично внесената лозинка!", false);
mbf.ShowDialog();
this.tbPassword.Clear();
this.tbRetypePassword.Clear();
}
}
this.tbRetypePassword.Clear();
this.PostaviVidlivost();
this.PostaviMenlivost();
this.PopolniInfo();
}
private void btnPotvrdi_Click(object sender, EventArgs e)
{
MessageBoxForm mbf = new MessageBoxForm("Дали сакате достава?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
OnlineNarackaPodatoci onp = new OnlineNarackaPodatoci(Conn, Naracka, Restoran);
if (onp.ShowDialog() == DialogResult.Yes)
{
Naracka = new Naracka(-1, 0, DateTime.Now);
}
}
else
{
OnsiteNarackaPodatoci onp = new OnsiteNarackaPodatoci(Conn, Naracka, Restoran);
if (onp.ShowDialog() == DialogResult.Yes)
{
Naracka = new Naracka(-1, 0, DateTime.Now);
}
}
}
private void buttonFASAP2_Click(object sender, EventArgs e)
{
if (this.ModifyMode)
{
MessageBoxForm mbf = new MessageBoxForm("Дали сте сигурни дека сакате да ги отфрлите промените?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
//this.AutoValidate = AutoValidate.Disable;
this.ModifyMode = false;
this.buttonFASAP2.Text = "Измени";
this.PostaviVidlivost();
this.PostaviMenlivost();
this.PopolniInfo();
}
}
else
{
this.Close();
}
}
private void tbPass_Validating(object sender, CancelEventArgs e)
{
TextBox tb = (sender as TextBox);
Regex regex = new Regex(@".*(?=.{8,})(?=.*\d)(?=.*[a-zA-Z]).*$");
Regex regex2 = new Regex(@".*[!@#$%^&*()-_=+,/?].*$");
if (tb.Text.Trim() == "")
{
MessageBoxForm mbf = new MessageBoxForm("Полето е задолжително!", false);
e.Cancel = true;
mbf.ShowDialog();
}
else if (!regex.IsMatch(tb.Text.Trim()) || !regex2.IsMatch(tb.Text.Trim()))
{
MessageBoxForm mbf = new MessageBoxForm("Лозинката мора да содржи барем 1 буква, барем 1 цифра и барем 1 специјален знак и вкупно да има најмалку 8 знаци!", false);
e.Cancel = true;
mbf.ShowDialog();
}
tb.SelectAll();
}
public void vcitajPromet()
{
String sql = "select iznos_promet from promet where mesec_promet = :MESEC and godina_promet= :GODINA and restoran_id= :REST_ID";
OracleCommand cmd = new OracleCommand(sql, Conn);
try
{
OracleParameter prm = new OracleParameter("MESEC", OracleDbType.Int64);
prm.Value = lblMesec.Text;
cmd.Parameters.Add(prm);
prm = new OracleParameter("GODINA", OracleDbType.Int64);
prm.Value = lblGodina.Text;
cmd.Parameters.Add(prm);
prm = new OracleParameter("REST_ID", OracleDbType.Int64);
prm.Value = this.RestoranID;
cmd.Parameters.Add(prm);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lblPromet.Text = String.Format(": {0} ден. :", dr.GetInt32(0));
}
}
catch (Exception ex)
{
MessageBoxForm mbf = new MessageBoxForm("Настана грешка при поврзувањето со базата!", false);
if (mbf.ShowDialog() == DialogResult.Yes)
{
this.Close();
}
else
{
this.Close();
}
}
}
private void lblStavka1_Click(object sender, EventArgs e)
{
LabelFASAP lb = sender as LabelFASAP;
if (lb.LblObject != null)
{
if (IsChanged)
{
MessageBoxForm mbf = new MessageBoxForm("Имате несочувани промени. Дали сакате да ги сочувате?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
SocuvajPromeni();
}
else
{
IsChanged = false;
}
}
SelectedComponent = lb.LblObject as MenuComponent;
PopolniListaMenija();
}
}
private void buttonIzmeni_Click(object sender, EventArgs e)
{
if (!this.ModifyMode)
{
buttonIzmeni.Text = "Зачувај";
this.ModifyMode = true;
}
else
{
if (this.CheckDates())
{
MessageBoxForm mbf = new MessageBoxForm("Дали сте сигурни дека сакате да ги зачувате промените?");
if (mbf.ShowDialog() == DialogResult.Yes)
{
if (this.AzurirajPodatoci())
{
MessageBoxForm mbf1 = new MessageBoxForm("Податоците беа успешно променети!", false);
mbf1.ShowDialog();
buttonIzmeni.Text = "Измени";
this.ModifyMode = false;
}
else
{
MessageBoxForm mbf1 = new MessageBoxForm("Обидот за промена на некои од податоците не беше успешен.\nОбидете се повторно.", false);
mbf1.ShowDialog();
}
}
}
else
{
MessageBoxForm mbf = new MessageBoxForm("Невалиден датум!", false);
mbf.ShowDialog();
}
}
this.PostaviVidlivost();
this.PostaviMenlivost();
this.PopolniInfo();
}
