public void Izvjestaji(object sender, EventArgs e)
{
if (ugdNarudzbenica.ActiveRow != null)
{
BusinessLogic.Narudzbenica.pID_Narudzbenica = BusinessLogic.Narudzbenica.IsDbNull <int>(ugdNarudzbenica.ActiveRow.Cells["ID"].Value);
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
ReportDocument rpt = new ReportDocument();
rpt.Load(System.Windows.Forms.Application.StartupPath + @"\Izvjestaji\crpNarudzbeniceIspis.rpt");
// Set connection string from config in existing LogonProperties
rpt.DataSourceConnections[0].SetConnection(Mipsed7.Core.ApplicationDatabaseInformation.ServerName, Mipsed7.Core.ApplicationDatabaseInformation.DatabaseName, true);
rpt.DataSourceConnections[0].SetLogon(Mipsed7.Core.ApplicationDatabaseInformation.SqlUserName, Mipsed7.Core.ApplicationDatabaseInformation.SqlPassword);
rpt.DataSourceConnections[0].IntegratedSecurity = false;
rpt.SetDataSource(objekt.GetNarudzbenicaIspis(BusinessLogic.Narudzbenica.pID_Narudzbenica));
ExtendedWindowWorkspace workspace = new ExtendedWindowWorkspace();
PreviewReportWorkItem item = this.Controller.WorkItem.Items.Get <PreviewReportWorkItem>("Pregled");
if (item == null)
{
item = this.Controller.WorkItem.Items.AddNew <PreviewReportWorkItem>("Pregled");
}
item.Izvjestaj = rpt;
item.Activate();
item.Show(item.Workspaces["main"]);
}
}
private void uscNarudzbenica_Load(object sender, EventArgs e)
{
BusinessLogic.Narudzbenica.pNarudzbeProizvod = new DataTable();
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("SEL", typeof(bool));
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("ID Proizvod", typeof(int));
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("Naziv proizvoda", typeof(string));
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("Jedinica mjere", typeof(string));
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("Količina", typeof(decimal));
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Columns.Add("ID_JedinicaMjere", typeof(int));
BusinessLogic.Narudzbenica.pOdabraniProizvodi = new List <string>();
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
LoadPartner(objekt);
LoadNacinIsporuke(objekt);
LoadNacinPlacanja(objekt);
if (FormEditMode == Enums.FormEditMode.Update || FormEditMode == Enums.FormEditMode.Copy)
{
LoadNarudzbeniceByID(objekt);
}
if (FormEditMode == Enums.FormEditMode.Insert || FormEditMode == Enums.FormEditMode.Copy)
{
CalculateBrojNarudzbe(objekt);
}
}
private void LoadGridNarudzbenica()
{
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
ugdNarudzbenica.DataSource = objekt.GetDataMainGrid();
ugdNarudzbenica.DataBind();
Utils.Tools.UltraGridStyling(ugdNarudzbenica);
if (ugdNarudzbenica.DisplayLayout.Bands.Count > 0)
{
ugdNarudzbenica.DisplayLayout.Bands[0].Columns["ID"].Hidden = true;
ugdNarudzbenica.DisplayLayout.Bands[0].Columns["Naziv partnera"].Width = 200;
ugdNarudzbenica.DisplayLayout.Bands[0].Columns["Partner adresa"].Width = 200;
ugdNarudzbenica.DisplayLayout.Bands[1].Columns["ID_Narudzbenica"].Hidden = true;
ugdNarudzbenica.DisplayLayout.Bands[1].Columns["Naziv proizvoda"].Width = 200;
}
foreach (UltraGridRow row in ugdNarudzbenica.Rows)
{
if (row.Index == BusinessLogic.Narudzbenica.pSelectedIndex)
{
ugdNarudzbenica.ActiveRow = row;
}
}
}
private void ucbProizvod_ValueChanged(object sender, EventArgs e)
{
BusinessLogic.Narudzbenica.pID_Proizvod = BusinessLogic.Narudzbenica.IsDbNull <int>(ucbProizvod.Value);
if (ucbProizvod.Value != null)
{
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
LoadJedinicaMjere(objekt);
}
}
private void bnDodajNacinIsporuke_Click(object sender, EventArgs e)
{
using (MaticniPodaci.uscNacinIsporukeForm objekt = new MaticniPodaci.uscNacinIsporukeForm(Enums.FormEditMode.Insert))
{
if (objekt.ShowDialogForm("Način isporuke") == DialogResult.OK)
{
BusinessLogic.Narudzbenica objekt2 = new BusinessLogic.Narudzbenica();
LoadNacinIsporuke(objekt2);
}
}
}
private void tsbNarudzbenicaSpremiNovi_Click(object sender, EventArgs e)
{
if (SaveData())
{
FormEditMode = Enums.FormEditMode.Insert;
uteNapomena.Value = null;
ugdNarudzbenicaProizvod.DataSource = null;
BusinessLogic.Narudzbenica.pNarudzbeProizvod.Clear();
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
CalculateBrojNarudzbe(objekt);
}
}
private void tsbNarudzbenicaSpremiNovi_Click(object sender, EventArgs e)
{
if (SaveData())
{
lblJedinicaMjere.Text = null;
ucbProizvod.Value = null;
uneKolicina.Value = 0;
BusinessLogic.Narudzbenica.pOdabraniProizvodi.Clear();
foreach (DataRow odabrani in BusinessLogic.Narudzbenica.pNarudzbeProizvod.Rows)
{
BusinessLogic.Narudzbenica.pOdabraniProizvodi.Add(odabrani["ID Proizvod"].ToString());
}
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
LoadProizvod(objekt);
}
}
public void Delete(object sender, EventArgs e)
{
if (ugdNarudzbenica.ActiveRow != null)
{
BusinessLogic.Narudzbenica.pID_Narudzbenica = Convert.ToInt32(ugdNarudzbenica.ActiveRow.Cells["ID"].Value);
if (MessageBox.Show(string.Format("Obrisati narudžbenicu '{0}-{1}'?", BusinessLogic.Narudzbenica.pID_Narudzbenica, ugdNarudzbenica.ActiveRow.Cells["Broj narudžbe"].Value),
"Brisanje narudžbenice", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
if (!objekt.Delete())
{
MessageBox.Show("Dogodila se greška prilikom brisanja narudžbenice.\nKontaktirajte administratora [Error:00020]");
}
LoadGridNarudzbenica();
}
}
}
private bool SaveData()
{
lblValidationMessages.ResetText();
BusinessLogic.Narudzbenica.pID_Partner = (int?)ucbPartner.Value;
BusinessLogic.Narudzbenica.pBrojNarudzbe = uteBrojNarudzbe.Value.ToString();
if (uteNapomena.Value != null)
{
BusinessLogic.Narudzbenica.pNapomena = uteNapomena.Value.ToString();
}
BusinessLogic.Narudzbenica.pDatumNarudzbe = (DateTime?)udtDatumNarudzbe.Value;
BusinessLogic.Narudzbenica.pNacinIsporuke = (int?)ucbNacinIsporuke.Value;
BusinessLogic.Narudzbenica.pNacinPlacanja = (int?)ucbNacinPlacanja.Value;
StringBuilder message = ValidateDataInput();
if (message.Length == 0)
{
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
if (FormEditMode == Enums.FormEditMode.Insert || FormEditMode == Enums.FormEditMode.Copy)
{
if (objekt.Insert(message, ugdNarudzbenicaProizvod))
{
FormEditMode = Enums.FormEditMode.Update;
return(true);
}
}
else if (this.FormEditMode == Enums.FormEditMode.Update)
{
if (objekt.Update(message, ugdNarudzbenicaProizvod))
{
return(true);
}
}
}
lblValidationMessages.Text = message.ToString();
return(false);
}
private void LoadNarudzbeniceByID(BusinessLogic.Narudzbenica objekt)
{
if (objekt.NarudzbenicaByID())
{
ucbPartner.Value = BusinessLogic.Narudzbenica.pID_Partner;
uteBrojNarudzbe.Value = BusinessLogic.Narudzbenica.pBrojNarudzbe;
udtDatumNarudzbe.Value = BusinessLogic.Narudzbenica.pDatumNarudzbe;
uteNapomena.Value = BusinessLogic.Narudzbenica.pNapomena;
ugdNarudzbenicaProizvod.DataSource = BusinessLogic.Narudzbenica.pNarudzbeProizvod.DefaultView;
ucbNacinPlacanja.Value = BusinessLogic.Narudzbenica.pNacinPlacanja;
ucbNacinIsporuke.Value = BusinessLogic.Narudzbenica.pNacinIsporuke;
Utils.Tools.UltraGridStyling(ugdNarudzbenicaProizvod);
if (ugdNarudzbenicaProizvod.DisplayLayout.Bands.Count > 0)
{
ugdNarudzbenicaProizvod.DisplayLayout.Bands[0].Columns["SEL"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
ugdNarudzbenicaProizvod.DisplayLayout.Bands[0].Columns["SEL"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
ugdNarudzbenicaProizvod.DisplayLayout.Bands[0].Columns["ID_JedinicaMjere"].Hidden = true;
}
}
}
private void LoadPartner(BusinessLogic.Narudzbenica objekt)
{
ucbPartner.DataSource = objekt.GetPartner();
ucbPartner.DataBind();
}
private void NarudzbenicaProizvodForm_Load(object sender, EventArgs e)
{
BusinessLogic.Narudzbenica objekt = new BusinessLogic.Narudzbenica();
LoadProizvod(objekt);
}
private void LoadProizvod(BusinessLogic.Narudzbenica objekt)
{
ucbProizvod.DataSource = objekt.GetProizvod();
ucbProizvod.DataBind();
}
private void LoadJedinicaMjere(BusinessLogic.Narudzbenica objekt)
{
lblJedinicaMjere.Text = objekt.GetJedinicaMjere();
}
private void CalculateBrojNarudzbe(BusinessLogic.Narudzbenica objekt)
{
uteBrojNarudzbe.Value = objekt.GetBrojNarudzbe();
}
private void LoadNacinPlacanja(BusinessLogic.Narudzbenica objekt)
{
ucbNacinPlacanja.DataSource = objekt.GetNacinPlacanja();
ucbNacinPlacanja.DataBind();
}
private void LoadNacinIsporuke(BusinessLogic.Narudzbenica objekt)
{
ucbNacinIsporuke.DataSource = objekt.GetNacinIsporuke();
ucbNacinIsporuke.DataBind();
}