private void ReloadGridData()
{
int smerGodinaId = 0;
try
{
smerGodinaId = Convert.ToInt32(mcbGodina.SelectedValue.ToString());
}
catch
{
smerGodinaId = 0;
}
if (smerGodinaId != 0)
{
using (var context = new documentumEntities())
{
var predmeti = from SmerGodinaPredmet in context.SmerGodinaPredmets.Where(s => s.smerGodinaId == smerGodinaId)
select new
{
SmerGodinaPredmet.Id,
SmerGodinaPredmet.redniBroj,
Naziv = SmerGodinaPredmet.Predmet.naziv,
Grupa = SmerGodinaPredmet.Grupa.naziv
};
metroGridPredmeti.DataSource = predmeti.OrderBy(p => p.redniBroj).ToList();
if (predmeti.Count() > 0)
{
metroGridPredmeti.Columns[0].Visible = false;
}
}
}
}
private void mbSave_Click(object sender, EventArgs e)
{
using (var context = new documentumEntities())
{
int smerGodinaId = Convert.ToInt32(mcbGodina.SelectedValue.ToString());
int predmetId = Convert.ToInt32(mcbPredmet.SelectedValue.ToString());
int grupaId = Convert.ToInt32(mcbGrupa.SelectedValue.ToString());
int redniBroj = Convert.ToInt32(mcbRedniBroj.SelectedItem.ToString());
int uticeNaUspeh = (byte)Convert.ToInt16(mcUspeh.Checked);
SmerGodinaPredmet predmet = context.SmerGodinaPredmets.SingleOrDefault(s => s.smerGodinaId == smerGodinaId && s.predmetId == predmetId);
if (predmet == null)
{
predmet = new SmerGodinaPredmet()
{
smerGodinaId = Convert.ToInt32(mcbGodina.SelectedValue.ToString()),
predmetId = Convert.ToInt32(mcbPredmet.SelectedValue.ToString()),
grupaId = Convert.ToInt32(mcbGrupa.SelectedValue.ToString()),
redniBroj = Convert.ToInt32(mcbRedniBroj.SelectedItem.ToString()),
uticeNaUspeh = (byte)Convert.ToInt16(mcUspeh.Checked)
};
context.SmerGodinaPredmets.Add(predmet);
}
else
{
predmet.redniBroj = Convert.ToInt32(mcbRedniBroj.SelectedItem.ToString());
predmet.grupaId = Convert.ToInt32(mcbGrupa.SelectedValue.ToString());
predmet.uticeNaUspeh = (byte)Convert.ToInt16(mcUspeh.Checked);
}
context.SaveChanges();
}
ReloadGridData();
}
private void InitializeMcbGodina()
{
int smerId = 0;
try
{
smerId = Convert.ToInt32(mcbSmer.SelectedValue.ToString());
}
catch
{
smerId = 0;
}
if (smerId != 0)
{
using (var context = new documentumEntities())
{
var smerGodine = from SmerGodina in context.SmerGodinas.Where(s => s.Smer.Id == smerId)
select new
{
SmerGodina.Id,
SmerGodina.Smer,
Godina = SmerGodina.godina
};
mcbGodina.DataSource = smerGodine.ToList();
mcbGodina.DisplayMember = "Godina";
mcbGodina.ValueMember = "Id";
}
}
}
private void ReloadGridBookmarks()
{
int documentTipId = 0;
try
{
documentTipId = int.Parse(DocumentumFactory.GetSelectedGridCellValue(metroGridDokumenta, "dokumentTipId").ToString());
}
catch
{
documentTipId = 0;
}
if (documentTipId > 0)
{
using (var context = new documentumEntities())
{
var bookmarks = from Bookmark in context.Bookmarks.Where(s => s.dokumentTipId == documentTipId)
select new
{
Bookmark.Id,
Bookmark.bookmarkTitle,
Bookmark.bookmarkName,
Bookmark.format
};
metroGridBookmarks.DataSource = bookmarks.ToList();
if (bookmarks.Count() > 0)
{
metroGridBookmarks.Columns[0].Visible = false;
}
}
}
}
private void ReloadGridDokumenta()
{
int smerGodinaId = 0;
try
{
smerGodinaId = Convert.ToInt32(mcbGodina.SelectedValue.ToString());
}
catch
{
smerGodinaId = 0;
}
if (smerGodinaId != 0)
{
using (var context = new documentumEntities())
{
var dokumenta = from SmerGodinaDokument in context.SmerGodinaDokuments.Where(s => s.smerGodinaId == smerGodinaId)
select new
{
SmerGodinaDokument.Id,
SmerGodinaDokument.DokumentTip.naziv,
SmerGodinaDokument.DokumentTip.templatePath,
SmerGodinaDokument.DokumentTip.outputPath,
SmerGodinaDokument.dokumentTipId
};
metroGridDokumenta.DataSource = dokumenta.ToList();
if (dokumenta.Count() > 0)
{
metroGridDokumenta.Columns[0].Visible = false;
metroGridDokumenta.Columns["dokumentTipId"].Visible = false;
}
}
}
}
private void mbDeleteBookmark_Click(object sender, EventArgs e)
{
int bookmarkId = DocumentumFactory.GetSelectedGridId(metroGridBookmarks);
using (var context = new documentumEntities())
{
Bookmark bookmark = context.Bookmarks.SingleOrDefault(b => b.Id == bookmarkId);
context.Bookmarks.Remove(bookmark);
context.SaveChanges();
}
}
private void UcDashboard_Load(object sender, EventArgs e)
{
using (var context = new documentumEntities())
{
var smerovi = from smer in context.Smers
select new
{
smer.Id,
Naziv = smer.naziv
};
metroGridSmer.DataSource = smerovi.ToList();
metroGridSmer.Columns[0].Visible = false;
}
}
private void metroGridPredmeti_RowEnter(object sender, DataGridViewCellEventArgs e)
{
int smerGodinaPredmetId = DocumentumFactory.GetSelectedGridId(metroGridPredmeti);
if (smerGodinaPredmetId > -1)
{
using (var context = new documentumEntities())
{
SmerGodinaPredmet smerGodinaPredmet = context.SmerGodinaPredmets.SingleOrDefault(s => s.Id == smerGodinaPredmetId);
mcbGrupa.SelectedValue = smerGodinaPredmet.grupaId;
mcbPredmet.SelectedValue = smerGodinaPredmet.predmetId;
mcbRedniBroj.SelectedItem = smerGodinaPredmet.redniBroj.ToString();
}
}
}
private void mbLogin_Click(object sender, EventArgs e)
{
string userName = mtbUserName.Text;
string password = mtbPassword.Text;
SimpleAES simpleAES = new SimpleAES();
//string crypted = simpleAES.EncryptToString(password);
using (var context = new documentumEntities())
{
Nastavnik nastavnik = context.Nastavniks.SingleOrDefault(n => n.username.Equals(userName));
if (nastavnik == null)
{
mlStatus.Visible = true;
DialogResult = DialogResult.None;
}
else
{
string passwordDecrypt = "";
try
{
passwordDecrypt = simpleAES.DecryptString(nastavnik.password);
} catch
{
}
if (!password.Equals(passwordDecrypt))
{
mlStatus.Visible = true;
DialogResult = DialogResult.None;
}
else
{
try
{
DocumentumFactory.Login = nastavnik;
} catch
{
}
}
}
}
}
private void mbSaveBookmark_Click(object sender, EventArgs e)
{
string bookmarkName = mtbBookmarkName.Text;
string bookmarkTitle = mtbBookmarkTitle.Text;
string format = mtbFormat.Text;
int documentTipId = 0;
try
{
documentTipId = int.Parse(DocumentumFactory.GetSelectedGridCellValue(metroGridDokumenta, "dokumentTipId").ToString());
}
catch
{
documentTipId = 0;
}
if (documentTipId > 0)
{
using (var context = new documentumEntities())
{
Bookmark bookmark = context.Bookmarks.SingleOrDefault(s => s.dokumentTipId == documentTipId && s.bookmarkName.Equals(bookmarkName));
if (bookmark != null)
{
bookmark.bookmarkTitle = bookmarkTitle;
bookmark.format = format;
}
else
{
bookmark = new Bookmark()
{
dokumentTipId = documentTipId,
bookmarkTitle = bookmarkTitle,
bookmarkName = bookmarkName,
format = format
};
context.Bookmarks.Add(bookmark);
}
context.SaveChanges();
}
ReloadGridBookmarks();
}
}
private void UcPlanProgram_Load(object sender, EventArgs e)
{
using (var context = new documentumEntities())
{
mcbSmer.DataSource = context.Smers.ToList();
mcbSmer.DisplayMember = "naziv";
mcbSmer.ValueMember = "Id";
mcbGrupa.DataSource = context.Grupas.ToList();
mcbGrupa.DisplayMember = "naziv";
mcbGrupa.ValueMember = "Id";
mcbPredmet.DataSource = context.Predmets.ToList();
mcbPredmet.DisplayMember = "naziv";
mcbPredmet.ValueMember = "Id";
mcbSmer.SelectedIndex = 0;
InitializeMcbGodina();
ReloadGridData();
ReloadGridDokumenta();
ReloadGridBookmarks();
}
}
