private void utworzProjektbutton_Click(object sender, RoutedEventArgs e)
{
List <Pracownik> pracownicy = new List <Pracownik>();
List <Sponsor> sponsorzy = new List <Sponsor>();
foreach (Uzytkownik p in wybraniPracownicy)
{
pracownicy.Add((Pracownik)p);
}
foreach (Uzytkownik s in wybraniSponsorzy)
{
sponsorzy.Add((Sponsor)s);
}
if (nazwaBox.Text != "" && opisBox.Text != "")
{
Projekt p = new Projekt(nazwaBox.Text, opisBox.Text, (Manager)uzytkownik,
new List <Zadanie>(zadania), new List <Zadanie>(), pracownicy, sponsorzy);
BazaProjektow bp = BazaProjektow.Wczytaj_Baze();
bp.DodajDoBazy(p);
bp.Zapisz_Baze();
Window w1 = new Window6(uzytkownik, p);
this.Close();
w1.Show();
}
} // public Projekt(string nazwa, string opis, Manager manager,
public static void preSet_KickOffBis(Projekt obj, PropertyPreSetterEventArgs <DateTime?> e)
{
if (e.NewValue.HasValue)
{
e.Result = obj.KickOffAm.Date + e.NewValue.Value.TimeOfDay;
}
}
public async void ObrisiPrijavu(Projekt projekt)
{
prijavljeniProjekti.Remove(projekt);
ostaliProjekti.Add(projekt);
await _apiServices.ObrisiPrijavuProjektAsync(projekt.Id);
}
private void kd_delete_Click(object sender, RoutedEventArgs e)
{
Projekt foo = new Projekt(this.curr_id);
foo.delete();
this.refreshList();
}
public async Task <IActionResult> Edit(long id, [Bind("Id,NazwaProjektu,DataRozpoczeciaProjektu,DataZakonczeniaProjektu")] Projekt projekt)
{
if (id != projekt.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(projekt);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjektExists(projekt.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(projekt));
}
protected void BtnDaSpremi_Click(object sender, EventArgs e)
{
if (lblheader.Text == "Ažuriranje projekta")
{
Projekt ažuriraniProjekt = new Projekt();
ažuriraniProjekt.IDProjekt = int.Parse(ddlProjekt.SelectedValue);
ažuriraniProjekt.Naziv = tbNaziv.Text;
ažuriraniProjekt.DatumOtvaranja = DateTime.Parse(tbDatumOtvaranja.Text);
ažuriraniProjekt.KlijentID = int.Parse(ddlKlijent.SelectedValue);
ažuriraniProjekt.VoditeljProjektaID = int.Parse(ddlVoditeljProjekta.SelectedValue);
Djelatnik voditelj = Repozitorij.GetDjelatnik(ažuriraniProjekt.VoditeljProjektaID);
if (!privremeniDjelatnici.Contains(voditelj))
{
privremeniDjelatnici.Add(voditelj);
}
Repozitorij.UpdateProjekt(ažuriraniProjekt);
ModalPopupExtender1.Hide();
ddlProjekt.SelectedValue = ažuriraniProjekt.IDProjekt.ToString();
AžurirajDjelatnikeProjekta(ažuriraniProjekt.IDProjekt);
PrikaziPodatkeOProjektu();
PrikaziDdlProjekte();
PopuniListu();
}
else
{
var ddlID = ddlProjekt.SelectedValue;
ModalPopupExtender1.Hide();
PrikaziPodatkeOProjektu();
PopuniListu();
PrikaziDdlProjekte();
ddlProjekt.SelectedValue = ddlID;
}
}
public ActionResult addProject(int customerID, Projekt newProject)
{
query.addProject(newProject, customerID);
var updatedProjects = query.getProjects();
return(View("Projects", updatedProjects));
}
public ActionResult Create([Bind(Include = "id,name,beschreibung,status,prioritaet,startdatum_geplant,enddatum_geplant,startdatum_effektiv,enddatum_effektiv,fortschritt,dokument_link,projektleiter_id,vorgehensmodell_id")] Projekt projekt)
{
//Check if the Model (Data) is still valid
if (ModelState.IsValid)
{
//Loop through all VorgehensmodellPhases
foreach (VorgehensmodellPhase vp in db.VorgehensmodellPhase.Where(s => s.vorgehensmodell_id == projekt.vorgehensmodell_id))
{
//Create and add a copy of the VorgehensModellPhases as ProjectPhase to the context
db.ProjektPhase.Add(new ProjektPhase()
{
name = vp.name,
beschreibung = vp.beschreibung,
projekt_id = projekt.id,
status = 1,
fortschritt = 0
});
}
//Add the project object to the context
db.Projekt.Add(projekt);
//Save the changes on the database (IDs for ProjektPhasen are now generated!)
db.SaveChanges();
//Loop through all ProjektPhasen (including generated IDs)
foreach (ProjektPhase p in db.ProjektPhase.Where(p => p.projekt_id == projekt.id))
{
//Add a new Activity with some default data where needed
db.Aktivitaet.Add(new Aktivitaet()
{
name = "Neue Aktivität",
projektphase_id = p.id,
status = 1,
fortschritt = 0
});
//Add a new end-phase Milestone with default data where needed
db.Meilenstein.Add(new Meilenstein()
{
name = "Abschluss " + p.name + " Meilenstein",
status = 1,
nicht_loeschbar = 1,
projektphase_id = p.id
});
}
//Save the changes on the database
db.SaveChanges();
//Return to the index view
return(RedirectToAction("Index"));
}
//Populate Viewbag Data for the view in case the creation and the redirect failed
ViewBag.projektleiter_id = new SelectList(db.Mitarbeiter, "id", "name", projekt.projektleiter_id);
ViewBag.vorgehensmodell_id = new SelectList(db.Vorgehensmodell, "id", "name", projekt.vorgehensmodell_id);
//Return Create View in case the creation of the project failed
return(View(projekt));
}
private void Btn_SubTable_Add(object sender, RoutedEventArgs e)
{
TableBase table;
switch (SelectedMain)
{
case Firma f:
table = new Divizia();
f.SubTable.Add((Divizia)table);
break;
case Divizia d:
table = new Projekt();
d.SubTable.Add((Projekt)table);
break;
case Projekt p:
table = new Oddelenie();
p.SubTable.Add((Oddelenie)table);
break;
default:
throw new ArgumentOutOfRangeException();
}
_db.SaveChanges();
_mainWindow.Show(table);
}
private void buttonOeffnen_Click(object sender, RoutedEventArgs e)
{
Projekt p = (Projekt)listDokumente.SelectedItem;
if (p.Dateiart != null)
{
if (p.Name != null)
{
filename = p.Name;
switch (p.Dateiart)
{
case "word":
run1.openExistingWordFile(filename);
break;
case "powerpoint":
run1.openExistingPowerPointPresentation(filename);
break;
case "excel":
run1.openExistingPowerPointPresentation(filename);
break;
}
}
}
}
private void GenerateContractButtonClicked(object sender, EventArgs e)
{
Projekt proj = model.ProjektForIndex(projektComboBox.SelectedIndex);
Ansprechpartner kunden = model.CustomerForIndex(proj.AnsprechpartnerID);
DocumentManager.GenerateContractDocument(contractName.Text + ".docx", kunden, proj);
}
private static void AddProjectDetailToDatabase(Projekt project, OleDbConnection conn)
{
var cmd = new OleDbCommand("INSERT INTO Projekt " +
"(Projektnummer, StartDatum, EndDatum, AnsprechpartnerID, AnzahlStunden, Verrechnungssatz, Koordinator, Gesprächsperson, Disponent, ProjektTitel, ProjektBeschreibung) " +
"VALUES (@Projektnummer, @StartDatum, @EndDatum, @AnsprechpartnerID, @AnzahlStunden, @Verrechnungssatz, @Koordinator, @Gesprächsperson, @Disponent, @ProjektTitel, @ProjektBeschreibung)");
cmd.Connection = conn;
if (cmd.Connection.State == System.Data.ConnectionState.Open)
{
cmd.Parameters.Add("@Projektnummer", OleDbType.VarChar).Value = project.Projektnummer;
cmd.Parameters.Add("@StartDatum", OleDbType.VarChar).Value = project.StartDatum;
cmd.Parameters.Add("@EndDatum", OleDbType.VarChar).Value = project.EndDatum;
cmd.Parameters.Add("@AnsprechpartnerID", OleDbType.Integer).Value = project.AnsprechpartnerID;
cmd.Parameters.Add("@AnzahlStunden", OleDbType.Integer).Value = project.AnzahlStunden;
cmd.Parameters.Add("@Verrechnungssatz", OleDbType.Integer).Value = project.Verrechnungssatz;
cmd.Parameters.Add("@Koordinator", OleDbType.VarChar).Value = project.Koordinator;
cmd.Parameters.Add("@Gesprächsperson", OleDbType.VarChar).Value = project.Gesprächsperson;
cmd.Parameters.Add("@Disponent", OleDbType.VarChar).Value = project.Disponent;
cmd.Parameters.Add("@ProjektTitel", OleDbType.VarChar).Value = project.ProjektTitel;
cmd.Parameters.Add("@ProjektBeschreibung", OleDbType.VarChar).Value = project.ProjektBeschreibung;
cmd.ExecuteNonQuery();
MessageBox.Show("Project details of " + project.ProjektTitel + " is successfully entered to the database.");
}
}
public static void postSet_KickOffAm(Projekt obj, PropertyPostSetterEventArgs <DateTime> e)
{
if (obj.KickOffBis.HasValue)
{
obj.KickOffBis = e.NewValue.Date + obj.KickOffBis.Value.TimeOfDay;
}
}
protected void BtnUkloni_Click(object sender, EventArgs e)
{
if (lbProjekti.SelectedValue == string.Empty)
{
return;
}
List <Projekt> projektiKlijenta = new List <Projekt>();
projektiKlijenta.AddRange(Repozitorij.GetProjektiKlijenta(int.Parse(ddlKlijent.SelectedValue)));
int idProjektzaUklanjanje = int.Parse(lbProjekti.SelectedValue);
var itemUkloni = privremeniProjekti.Find(x => x.IDProjekt == idProjektzaUklanjanje);
var itemPostoji = new Projekt();
foreach (Projekt projekt in projektiKlijenta)
{
itemPostoji = projektiKlijenta.Find(x => x.IDProjekt == idProjektzaUklanjanje);
}
if (itemPostoji != null)
{
ModalPopupExtender2.Show();
}
else
{
privremeniProjekti.Remove(itemUkloni);
LoadLbProjekti();
}
}
private static Collection <T> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <T> projekts = new Collection <T>();
while (reader.Read())
{
Projekt projekt = new Projekt();
int i = -1;
projekt.RecordId = (int)reader.GetDecimal(++i);
if (!reader.IsDBNull(++i))
{
projekt.Name = reader.GetString(i);
}
projekt.Finish = reader.GetBoolean(++i);
projekt.IdManagEmp = reader.GetInt32(++i);
projekt.Start = reader.GetDateTime(++i);
if (!reader.IsDBNull(++i))
{
projekt.End = reader.GetDateTime(i);
}
projekts.Add((T)projekt);
}
return(projekts);
}
public ActionResult About(RegisterViewModel vm)
{
Response.Write("DET FUNKAR");
var nyProj = new Projekt {
Name = vm.Name, Problem = vm.Problem, Solution = vm.Solution, Result = vm.Result
};
WebApiConfig.GraphClient.Cypher
.Merge("(projekt:Projekt { Name: {Name} })")
.Set("projekt = {nyProj}")
.WithParams(new
{
Name = nyProj.Name,
nyProj
})
.ExecuteWithoutResults();
WebApiConfig.GraphClient.Cypher
.Match("(kund:Kund)", "(projekt:Projekt)", "(bestallare:Bestallare)")
.Where((Kund kund) => kund.Namn == vm.KundNamn)
.AndWhere((Projekt projekt) => projekt.Name == vm.Name)
.AndWhere((Bestallare bestallare) => bestallare.Namn == vm.Bestallare)
.CreateUnique("kund-[:BESTALLT]->projekt")
.CreateUnique("bestallare-[:BESTALLT_AV]->kund")
.ExecuteWithoutResults();
return(View());
}
public static void postSet_KickOffAm(Projekt obj, PropertyPostSetterEventArgs<DateTime> e)
{
if (obj.KickOffBis.HasValue)
{
obj.KickOffBis = e.NewValue.Date + obj.KickOffBis.Value.TimeOfDay;
}
}
// GET: Evaluation
public ActionResult Index(int id, int?kriterij)
{
AHPEntities4 db = new AHPEntities4();
List <UsporedbaKriterija> criteriaComparison = new List <UsporedbaKriterija>();
Projekt project = db.Projekts.Where(x => x.id == id).SingleOrDefault();
Kriterij parent = null;
if (kriterij != null)
{
parent = db.Kriterijs.Where(x => x.id == kriterij).SingleOrDefault();
foreach (Kriterij podkriterij in parent.Kriterij1.Where(x => x.obrisan != true).ToList())
{
List <UsporedbaKriterija> a = podkriterij.UsporedbaKriterijas.Where(x => (x.Kriterij.obrisan != true && x.Kriterij3.obrisan != true)).ToList();
//Je li dovoljno jednostrano ili je potrebno obostrano?? ispitati
//List<UsporedbaKriterija> b = podkriterij.UsporedbaKriterijas1.Where(x => (x.Kriterij.obrisan != true && x.Kriterij3.obrisan != true)).ToList();
criteriaComparison.AddRange(a);
}
}
else
{
criteriaComparison = db.UsporedbaKriterijas.Where(x => (x.Kriterij.Projekt1.id == id && x.Kriterij3.Projekt1.id == id && x.Kriterij.Kriterij2 == null && x.Kriterij3.Kriterij2 == null && x.Kriterij.obrisan != true && x.Kriterij3.obrisan != true)).ToList();
}
EvaluationCriteriaViewModel evaluationCriteriaViewModel = new EvaluationCriteriaViewModel(project, parent, criteriaComparison, GetListOfCriteria(id));
return(View(evaluationCriteriaViewModel));
}
public ProjekteDetail()
{
InitializeComponent();
p = new Projekt();
created = true;
binder = new DataBinding.Binder();
}
public static void preSet_KickOffBis(Projekt obj, PropertyPreSetterEventArgs<DateTime?> e)
{
if (e.NewValue.HasValue)
{
e.Result = obj.KickOffAm.Date + e.NewValue.Value.TimeOfDay;
}
}
public ProjekteDetail(Projekt p)
{
InitializeComponent();
this.p = p;
created = false;
binder = new DataBinding.Binder();
}
public override void SetUp()
{
base.SetUp();
DeleteObjects();
using (IZetboxContext ctx = GetContext())
{
Projekt prj1 = ctx.Create <Projekt>();
prj1.Name = ProjectName1;
Projekt prj2 = ctx.Create <Projekt>();
prj2.Name = ProjectName2;
for (int i = 0; i < Project1TaskCount; i++)
{
SetUpCreateTask(ctx, prj1, i);
}
for (int i = 0; i < Project2TaskCount; i++)
{
SetUpCreateTask(ctx, prj2, i);
}
ctx.SubmitChanges();
Project1ID = prj1.ID;
Project2ID = prj2.ID;
Console.WriteLine("Workaround for mono: {0}, {1}", Project1ID, Project2ID);
}
}
protected void BtnDaUnesi_Click(object sender, EventArgs e)
{
if (lblheader.Text == "Unos novog projekta")
{
Projekt projekt = new Projekt();
projekt.Naziv = tbNaziv.Text;
projekt.DatumOtvaranja = DateTime.Parse(tbDatumOtvaranja.Text);
projekt.KlijentID = int.Parse(ddlKlijent.SelectedValue);
projekt.VoditeljProjektaID = int.Parse(ddlVoditeljProjekta.SelectedValue);
Djelatnik voditelj = Repozitorij.GetDjelatnik(projekt.VoditeljProjektaID);
if (!privremeniDjelatnici.Contains(voditelj))
{
privremeniDjelatnici.Add(voditelj);
}
Repozitorij.InsertProjekt(projekt);
ModalPopupExtender1.Hide();
int idUnesenogProjekta = Repozitorij.GetProjektId(projekt);
AžurirajProjekteDjelatnika(idUnesenogProjekta);
ClearPoljaZaUnos();
}
else
{
ModalPopupExtender1.Hide();
ClearPoljaZaUnos();
}
}
/// <summary>
/// Konstruktor
/// </summary>
/// <param name="p">Projekt na którym pracujemy</param>
/// <param name="z">Zadanie do przydzielenia</param>
public Window10(Projekt p, Zadanie z)
{
InitializeComponent();
this.z = z;
projekt = p;
wybraniPracownicy = new ObservableCollection <Uzytkownik>(projekt.ListaPracownikow);
pracownicyLisBox.ItemsSource = wybraniPracownicy;
}
public ProjectViewModel(Projekt project, List <Kriterij> criteria, List <Alternativa> alternatives, List <Dnevnik> logs)
{
this.Project = project;
this.Criteria = criteria;
this.Alternatives = alternatives;
this.Logs = logs;
this.ContentHeader = GetContentHeader(project.naziv);
}
public static void GetSummaryReport(Projekt obj, MethodReturnEventArgs <System.Object> e, string title, Zetbox.App.Base.DateTimeRange range)
{
using (var rpt = _rptFactory())
{
ProjectReport.Call(rpt);
rpt.Open("ProjectReport.pdf");
}
}
public EvaluationCriteriaViewModel(Projekt project, Kriterij criteria, List <UsporedbaKriterija> criteriaComparison, List <Kriterij> listOfCriteria)
{
this.Projekt = project;
this.KriterijRoditelj = criteria;
this.ListaUsporedaba = criteriaComparison;
this.ListaKriterija = listOfCriteria;
this.ContentHeader = GetContentHeader(project.naziv, criteria.naziv);
}
public static void GetSummaryReport(Projekt obj, MethodReturnEventArgs<System.Object> e, string title, Zetbox.App.Base.DateTimeRange range)
{
using (var rpt = _rptFactory())
{
ProjectReport.Call(rpt);
rpt.Open("ProjectReport.pdf");
}
}
protected DefinicjaBrunchRow([Required] Projekt projekt) : base(true)
{
if (projekt == null)
{
throw new RequiredException(this, "Projekt");
}
GetRecord();
record.Projekt = projekt;
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if (cmbPersonal != null && cmbProjekt != null)
{
Projekt proj = cmbProjekt.SelectedItem as Projekt;
Personal pers = cmbPersonal.SelectedItem as Personal;
myDB.Eintragen(proj.Id, pers.Id, nudStd.Value);
}
}
private void CreateTasks(IZetboxContext ctx, Projekt p)
{
for (int i = 0; i < task_projectCount; i++)
{
var t = ctx.Create <Task>();
t.Name = "Task " + i;
p.Tasks.Add(t);
}
}
private static void PrepareCommand(SqlCommand command, Projekt projekt)
{
command.Parameters.AddWithValue("@id_projekt", projekt.RecordId);
command.Parameters.AddWithValue("@nazov", projekt.Name);
command.Parameters.AddWithValue("@hotovy", projekt.Finish);
command.Parameters.AddWithValue("@vytvorenie", projekt.Start);
command.Parameters.AddWithValue("@id_zamestnanca", projekt.IdManagEmp);
command.Parameters.AddWithValue("@ukonceny", projekt.End == null ? DBNull.Value : (object)projekt.End);
}
protected void BtnDodaj_Click(object sender, EventArgs e)
{
int idProjektZaDodavanje = int.Parse(ddlProjekti.SelectedValue);
Projekt projektDodaj = Repozitorij.GetProjekt(idProjektZaDodavanje);
privremeniProjekti.Add(projektDodaj);
LoadLbProjekti();
}
public ActionResult SelectProject(int Id)
{
ServisniZasah sz = new ServisniZasah();
sz = ServisniZasah.GetZasah(Id);
List <Projekt> list = Projekt.ProjectList(sz.Zakaznik.KodSAP, Id);
return(View(list));
}
public ActionResult Details(Projekt project)
{
ORDRforProject ordrfp = new ORDRforProject {
Projekt = project.Code, ProjektName = project.Name
};
return(PartialView("Details", ordrfp));
}
void DeleteProjekt(Projekt p)
{
try
{
BL.deleteProjekt(p);
}
catch (BLException ex)
{
MessageBox.Show(ex.Message, p.Name, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
BindTo();
}
private void SetUpCreateTask(IZetboxContext ctx, Projekt prj, int i)
{
Task t = ctx.Create<Task>();
t.Name = prj.Name + " - Task " + (i + 1);
t.DatumVon = DateTime.Today.AddDays(i);
t.DatumBis = DateTime.Today.AddDays(2 * i);
t.Aufwand = (i + 1);
prj.Tasks.Add(t);
}
protected virtual string FormatProjectName(Projekt prj)
{
return prj.Name;
}
public static void ToString(Projekt obj, MethodReturnEventArgs<string> e)
{
e.Result = obj.Name;
}
public static void NotifyPreSave(Projekt obj)
{
}
public static void postSet_Tasks(Projekt obj)
{
obj.Recalculate("AufwandGes");
}
private void btnProj_Handler(object sender, RoutedEventArgs e)
{
Button myButton = (Button)sender;
// Create new Project
if (myButton.Tag.ToString() == "new")
{
Projekt newProj = new Projekt();
int id;
var bool4 = Int32.TryParse(Application.Current.Properties["proj_id"].ToString(), out id); // saved max id to increment
newProj.ID = id += 1;
Application.Current.Properties["proj_id"] = (id += 1).ToString();
newProj.Name = this.projName.Text;
int offen;
var bool1 = Int32.TryParse(projOffene.Text, out offen);
int gesamt;
var bool2 = Int32.TryParse(projGesamt.Text, out gesamt);
newProj.OffeneZeitStunden = offen;
newProj.GesamtZeitStunden = gesamt;
newProj.IstAktiv = projAktiv.IsChecked.Value;
newProj.StartDatum = this.projStart.SelectedDate.Value;
newProj.EndDatum = this.projEnd.SelectedDate.Value;
Bibliothek.Projekt_Neu(newProj);
// Project Created - show success and reset form
this.projName.Text = "";
this.projOffene.Text = "";
this.projGesamt.Text = "";
this.projStart.SelectedDate = null;
this.projEnd.SelectedDate = null;
this.projAktiv.IsChecked = false;
this.success.Text = "Projekt erfolgrichlich erstellt";
this.success.Visibility = Visibility.Visible;
}
// Edit Project
if (myButton.Tag.ToString() == "edit")
{
int id;
var bool6 = Int32.TryParse(this.btnID.Tag.ToString(), out id);
Projekt proj = Bibliothek.Projekt_nach_ID(id);
proj.Name = this.projName.Text;
int offen;
var bool1 = Int32.TryParse(projOffene.Text, out offen);
int gesamt;
var bool2 = Int32.TryParse(projGesamt.Text, out gesamt);
proj.OffeneZeitStunden = offen;
proj.GesamtZeitStunden = gesamt;
proj.IstAktiv = projAktiv.IsChecked.Value;
proj.StartDatum = this.projStart.SelectedDate.Value;
proj.EndDatum = this.projEnd.SelectedDate.Value;
this.btnID.Tag = ""; // reset edit job id holder
// Project Edited - show success and reset form
this.projName.Text = "";
this.projOffene.Text = "";
this.projGesamt.Text = "";
this.projStart.SelectedDate = null;
this.projEnd.SelectedDate = null;
this.projAktiv.IsChecked = false;
this.success.Text = "Projekt erfolgrichlich gearbeitet";
this.success.Visibility = Visibility.Visible;
}
}
public static void isValid_KickOffBis(Projekt obj, PropertyIsValidEventArgs e)
{
e.IsValid = obj.KickOffBis == null || obj.KickOffBis >= obj.KickOffAm;
e.Error = e.IsValid ? string.Empty : "Bis-Datum ist leer oder liegt vor dem Von-Datum";
}
public static void get_AufwandGes(Projekt obj, PropertyGetterEventArgs<double?> e)
{
e.Result = obj.Tasks.Sum(t => t.Aufwand);
}
public static void GetFulltextIndexBody(Projekt obj, MethodReturnEventArgs<string> e)
{
e.Result = obj.Name + "\n" + obj.Kundenname;
}
private void CreateTestData()
{
{
srvCtx = scope.Resolve<IZetboxServerContext>();
var grpAdmin = Zetbox.NamedObjects.Base.Groups.Administrator.Find(srvCtx);
var grpEveryOne = Zetbox.NamedObjects.Base.Groups.Everyone.Find(srvCtx);
// Create Identities
admin = srvCtx.Create<Identity>();
admin.DisplayName = "Administrator";
admin.UserName = "******";
admin.Groups.Add(grpAdmin);
admin.Groups.Add(grpEveryOne);
identity1 = srvCtx.Create<Identity>();
identity1.DisplayName = "User 1";
identity1.UserName = "******";
identity1.Groups.Add(grpEveryOne);
identity2 = srvCtx.Create<Identity>();
identity2.DisplayName = "User 2";
identity2.UserName = "******";
identity2.Groups.Add(grpEveryOne);
identity3_low = srvCtx.Create<Identity>();
identity3_low.DisplayName = "User 3 with low privileges";
identity3_low.UserName = "******";
ma1 = srvCtx.Create<Mitarbeiter>();
ma1.Name = identity1.DisplayName;
ma1.Identity = identity1;
ma2 = srvCtx.Create<Mitarbeiter>();
ma2.Name = identity2.DisplayName;
ma2.Identity = identity2;
ma3_low = srvCtx.Create<Mitarbeiter>();
ma3_low.Name = identity3_low.DisplayName;
ma3_low.Identity = identity3_low;
srvCtx.SubmitChanges();
}
{
// Create 3 identity context
var ctx = scope.Resolve<ServerZetboxContextFactory>().Invoke(identity1);
// Create TestData with Identity 1
prj1 = ctx.Create<Projekt>();
prj1.Name = "Project User 1";
prj1.Mitarbeiter.Add(ctx.Find<Mitarbeiter>(ma1.ID));
CreateTasks(ctx, prj1);
// Create TestData with Identity 1, common
prjCommon = ctx.Create<Projekt>();
prjCommon.Name = "Project Common";
prjCommon.Mitarbeiter.Add(ctx.Find<Mitarbeiter>(ma1.ID));
prjCommon.Mitarbeiter.Add(ctx.Find<Mitarbeiter>(ma2.ID));
CreateTasks(ctx, prjCommon);
ctx.SubmitChanges();
prj1ID = prj1.ID;
prjCommonID = prjCommon.ID;
}
{
var ctx = scope.Resolve<ServerZetboxContextFactory>().Invoke(identity2);
// Create TestData with Identity 2
prj2 = ctx.Create<Projekt>();
prj2.Name = "Project User 2";
prj2.Mitarbeiter.Add(ctx.Find<Mitarbeiter>(ma2.ID));
CreateTasks(ctx, prj2);
ctx.SubmitChanges();
prj2ID = prj2.ID;
}
id1Ctx = scope.Resolve<ServerZetboxContextFactory>().Invoke(identity1);
id2Ctx = scope.Resolve<ServerZetboxContextFactory>().Invoke(identity2);
id3Ctx_low = scope.Resolve<ServerZetboxContextFactory>().Invoke(identity3_low);
prj1 = id1Ctx.Find<Projekt>(prj1ID);
prjCommon = id1Ctx.Find<Projekt>(prjCommonID);
prj2 = id2Ctx.Find<Projekt>(prj2ID);
// Fix security tables
// Own test checks if this works during object modifications too
var connectionString = config.Server.GetConnectionString(Helper.ZetboxConnectionStringKey);
using (var db = scope.ResolveNamed<ISchemaProvider>(connectionString.SchemaProvider))
{
db.Open(connectionString.ConnectionString);
db.ExecRefreshRightsOnProcedure(db.GetProcedureName("projekte", "RefreshRightsOn_Projekte"));
db.ExecRefreshRightsOnProcedure(db.GetProcedureName("projekte", "RefreshRightsOn_Tasks"));
db.ExecRefreshRightsOnProcedure(db.GetProcedureName("projekte", "RefreshRightsOn_Auftraege"));
}
}
private void CreateTasks(IZetboxContext ctx, Projekt p)
{
for (int i = 0; i < task_projectCount; i++)
{
var t = ctx.Create<Task>();
t.Name = "Task " + i;
p.Tasks.Add(t);
}
}
void EditProjekt(Projekt p)
{
Dialogs.ProjekteDetail tmp = new Dialogs.ProjekteDetail(p);
tmp.ShowDialog();
BindTo();
}
