private void LoadGridOsobe()
{
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
ugdZaduzenje.DataSource = objekt.GetOsobeZaduzenje();
ugdZaduzenje.DataBind();
if (ugdZaduzenje.DisplayLayout.Bands.Count > 0)
{
if (ugdZaduzenje.DisplayLayout.Bands[0].Columns.Count > 0)
{
ugdZaduzenje.DisplayLayout.Bands["VrsteOsoba"].Columns["ID"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["ID_VrstaVeze"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["ID_Osobe"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["ID_Opcina"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["ID_NacinIsplate"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["OIB"].Hidden = true;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Columns["Iznos"].Hidden = true;
ugdZaduzenje.Rows.ExpandAll(true);
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
ugdZaduzenje.DisplayLayout.Bands["VrsteOsoba"].Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
ugdZaduzenje.DisplayLayout.Bands["VrsteOsoba"].ColHeadersVisible = false;
ugdZaduzenje.DisplayLayout.Bands["OdabraneOsobe"].ColHeadersVisible = false;
}
}
}
private void LoadNacinIsplate()
{
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
ucbNacinIsplate.DataSource = objekt.GetNacinIsplate();
ucbNacinIsplate.DataBind();
}
private bool SaveData()
{
lblValidationMessages.ResetText();
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
StringBuilder message = new StringBuilder();
if (pFormEditMode == FormEditMode.Insert)
{
if (objekt.Insert(message))
{
return(true);
}
}
else if (pFormEditMode == FormEditMode.Update)
{
if (objekt.Update(message))
{
return(true);
}
}
lblValidationMessages.Text = message.ToString();
return(false);
}
private int GenerateSifraObracuna()
{
int sifra;
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
sifra = objekt.GetLastSifraObracuna();
return(sifra);
}
private void LoadDataMainGrid()
{
BusinessLogic.ObracunRazno element = new BusinessLogic.ObracunRazno();
//ugdSocijalnaPotpora.DataSource = element.GetSocijalnaPotpora().DefaultView;
//ugdOsobeVeze.DataBind();
//Tools.UltraGridStyling(ugdOsobeVeze);
//if (ugdOsobeVeze.DisplayLayout.Bands.Count > 0)
//{
// ugdOsobeVeze.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
//}
}
private void LoadDataMainGrid()
{
BusinessLogic.ObracunRazno element = new BusinessLogic.ObracunRazno();
ugdNagradeNatjecanja.DataSource = element.GetStudentServisOporezivo();
ugdNagradeNatjecanja.DataBind();
Tools.UltraGridStyling(ugdNagradeNatjecanja);
if (ugdNagradeNatjecanja.DisplayLayout.Bands.Count > 0)
{
ugdNagradeNatjecanja.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdNagradeNatjecanja.DisplayLayout.Bands[1].Columns["ID"].Hidden = true;
ugdNagradeNatjecanja.DisplayLayout.Bands[1].Columns["ID_JOPPDObracunRazno"].Hidden = true;
}
}
private void LoadDataMainGrid()
{
BusinessLogic.ObracunRazno element = new BusinessLogic.ObracunRazno();
ugdSocijalnaNaknada.DataSource = element.GetSocijalnaNaknada();
ugdSocijalnaNaknada.DataBind();
Tools.UltraGridStyling(ugdSocijalnaNaknada);
if (ugdSocijalnaNaknada.DisplayLayout.Bands.Count > 0)
{
ugdSocijalnaNaknada.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdSocijalnaNaknada.DisplayLayout.Bands[1].Columns["ID"].Hidden = true;
ugdSocijalnaNaknada.DisplayLayout.Bands[1].Columns["ID_JOPPDObracunRazno"].Hidden = true;
}
}
private void LoadObracunByID()
{
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
BusinessLogic.ObracunRazno.pVrstaObracuna = lblVrstaObracuna.Text;
if (objekt.ObracunByID())
{
uneMjesec.Value = BusinessLogic.ObracunRazno.pMjesec;
uneGodina.Value = BusinessLogic.ObracunRazno.pGodina;
txtNazivObracuna.Text = BusinessLogic.ObracunRazno.pNaziv;
cbkOstalo.Checked = BusinessLogic.ObracunRazno.pOstalo;
cbkUcenici.Checked = BusinessLogic.ObracunRazno.pUcenik;
cbkRoditelj.Checked = BusinessLogic.ObracunRazno.pRoditelj;
cbkUF.Checked = BusinessLogic.ObracunRazno.pUF;
cbkPraksa.Checked = BusinessLogic.ObracunRazno.pPraksa;
}
}
public void Delete(object sender, EventArgs e)
{
if (ugdNagradeNatjecanja.ActiveRow != null)
{
BusinessLogic.ObracunRazno.pID_ObracunRazno = (int)ugdNagradeNatjecanja.ActiveRow.Cells["ID"].Value;
BusinessLogic.ObracunRazno.pNaziv = ugdNagradeNatjecanja.ActiveRow.Cells["Naziv"].Value.ToString();
if (MessageBox.Show(string.Format("Obrisati obračun '{0}-{1}'?", BusinessLogic.ObracunRazno.pID_ObracunRazno, BusinessLogic.ObracunRazno.pNaziv),
"Brisanje obračuna", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BusinessLogic.ObracunRazno element = new BusinessLogic.ObracunRazno();
StringBuilder message = new StringBuilder();
if (!element.Delete(message))
{
MessageBox.Show(message.ToString());
}
LoadDataMainGrid();
}
}
}
private string LoadNazivOpcine(string id)
{
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
return(objekt.GetNazivOpcine(id));
}
private void PrikazTabova()
{
BusinessLogic.ObracunRazno objekt = new BusinessLogic.ObracunRazno();
if (!BusinessLogic.ObracunRazno.pUcenik)
{
tbcPrikazOsoba.TabPages.Remove(tbcPrikazOsoba.TabPages["tpUcenici"]);
}
else
{
if (BusinessLogic.ObracunRazno.pUF & !BusinessLogic.ObracunRazno.pPraksa)
{
ugdUcenici.DataSource = objekt.GetUceniciUF();
ugdUcenici.DataBind();
Tools.UltraGridStyling(ugdUcenici);
if (ugdUcenici.DisplayLayout.Bands.Count > 0)
{
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID_Opcina"].Hidden = true;
}
}
else if (BusinessLogic.ObracunRazno.pUF & BusinessLogic.ObracunRazno.pPraksa)
{
ugdUcenici.DataSource = objekt.GetUceniciAll();
ugdUcenici.DataBind();
Tools.UltraGridStyling(ugdUcenici);
if (ugdUcenici.DisplayLayout.Bands.Count > 0)
{
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID_Opcina"].Hidden = true;
}
}
else if (!BusinessLogic.ObracunRazno.pUF & BusinessLogic.ObracunRazno.pPraksa)
{
ugdUcenici.DataSource = objekt.GetUceniciPraksa();
ugdUcenici.DataBind();
Tools.UltraGridStyling(ugdUcenici);
if (ugdUcenici.DisplayLayout.Bands.Count > 0)
{
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdUcenici.DisplayLayout.Bands[0].Columns["Ozn"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdUcenici.DisplayLayout.Bands[0].Columns["ID_Opcina"].Hidden = true;
}
}
if (pFormEditMode == FormEditMode.Update)
{
foreach (UltraGridRow red in ugdUcenici.Rows)
{
foreach (DataRow red2 in BusinessLogic.ObracunRazno.pOdabraneOsobe.Rows)
{
if (red.Cells["OIB"].Value.ToString() == red2["OIB"].ToString())
{
red.Cells["Ozn"].Value = true;
}
}
}
}
}
if (!BusinessLogic.ObracunRazno.pRoditelj)
{
tbcPrikazOsoba.TabPages.Remove(tbcPrikazOsoba.TabPages["tpRoditelji"]);
}
else
{
ugdRoditelji.DataSource = objekt.GetRoditelji();
ugdRoditelji.DataBind();
Tools.UltraGridStyling(ugdRoditelji);
if (ugdRoditelji.DisplayLayout.Bands.Count > 0)
{
ugdRoditelji.DisplayLayout.Bands[0].Columns["Ozn"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdRoditelji.DisplayLayout.Bands[0].Columns["Ozn"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdRoditelji.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdRoditelji.DisplayLayout.Bands[0].Columns["ID_Opcina"].Hidden = true;
}
if (pFormEditMode == FormEditMode.Update)
{
foreach (UltraGridRow red in ugdRoditelji.Rows)
{
foreach (DataRow red2 in BusinessLogic.ObracunRazno.pOdabraneOsobe.Rows)
{
if (red.Cells["OIB"].Value.ToString() == red2["OIB"].ToString())
{
red.Cells["Ozn"].Value = true;
}
}
}
}
}
if (!BusinessLogic.ObracunRazno.pOstalo)
{
tbcPrikazOsoba.TabPages.Remove(tbcPrikazOsoba.TabPages["tpOstalo"]);
}
else
{
ugdOstalo.DataSource = objekt.GetOstalo();
ugdOstalo.DataBind();
Tools.UltraGridStyling(ugdOstalo);
if (ugdOstalo.DisplayLayout.Bands.Count > 0)
{
ugdOstalo.DisplayLayout.Bands[0].Columns["Ozn"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdOstalo.DisplayLayout.Bands[0].Columns["Ozn"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdOstalo.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdOstalo.DisplayLayout.Bands[0].Columns["ID_Opcina"].Hidden = true;
}
if (pFormEditMode == FormEditMode.Update)
{
foreach (UltraGridRow red in ugdOstalo.Rows)
{
foreach (DataRow red2 in BusinessLogic.ObracunRazno.pOdabraneOsobe.Rows)
{
if (red.Cells["OIB"].Value.ToString() == red2["OIB"].ToString())
{
red.Cells["Ozn"].Value = true;
}
}
}
}
}
}
