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; } } } } } }