private void simpleButton1_Click(object sender, EventArgs e)
{
var Baza = new AbacusSUPEntities();
OperaterLogin.operater = Baza.Login.FirstOrDefault(qq => qq.username == textEdit1.Text && qq.pass == textEdit2.Text);
//OperaterLogin.podesavanja = new Settings();
if (OperaterLogin.operater != null)
{
if (OperaterLogin.operater.Podesavanja == null)
{
Podesavanja pod = new Podesavanja
{
minimize_notif = false,
minimize_tray = true,
novitask_notif = true,
};
Baza.Podesavanja.Add(pod);
Baza.SaveChanges();
Baza.Login.FirstOrDefault(qq => qq.username == textEdit1.Text && qq.pass == textEdit2.Text).id_podesavanja = pod.id_podesavanja;
Baza.SaveChanges();
}
FormMain frmmain = Program.MainForm = new FormMain(OperaterLogin.operater, progressBarControl1);
frmmain.Show();
OperaterLogin.loginforma = this;
OperaterLogin.NE_IZLAZI_AOAO = false;
this.Hide();
}
else
{
MessageBox.Show("Neispravan korisnik ili lozinka!", "Greska", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
var db = new AbacusSUPEntities();
if (db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).status_id == 1)
{
//var Baza = new AbacusSUPEntities();
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).status_id = db.Status.FirstOrDefault(qw => qw.opis == "Zavrseno").id_status;
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).datum_zatv = DateTime.Now;
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).login_id_zatv = OperaterLogin.operater.id;
labelControl6.Text = db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).datum_zatv.ToString();
List <VezaLT> listaveza = db.VezaLT.Where(qq => qq.id_task == task.id_task).ToList();
foreach (VezaLT veza in listaveza)
{
db.VezaLT.FirstOrDefault(qw => qw.id_veza == veza.id_veza).isActive = false;
}
simpleButton2.Text = "Otvori task";
db.SaveChanges();
var db2 = new AbacusSUPEntities();
labelControl6.Visible = true;
labelControl6.Text = "Task zatvorio " + db2.Task.FirstOrDefault(qq => qq.id_task == task.id_task).Login1.username.ToString() + ", " + db2.Task.FirstOrDefault(qq => qq.id_task == task.id_task).datum_zatv.ToString();
simpleButton1.Enabled = false;
if (OperaterLogin.operater.Podesavanja.task_github_upload)
{
zatvorigittask(task);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
else if (db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).status_id == 2)
{
if (XtraMessageBox.Show("Ovaj task je zatvoren. Otvoriti opet?", "Provjera", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).status_id = db.Status.FirstOrDefault(qw => qw.opis == "U toku").id_status;
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).datum_zatv = null;
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).login_id_zatv = null;
List <VezaLT> listaveza = db.VezaLT.Where(qq => qq.id_task == task.id_task).ToList();
foreach (VezaLT veza in listaveza)
{
db.VezaLT.FirstOrDefault(qw => qw.id_veza == veza.id_veza).isActive = true;
}
simpleButton2.Text = "Zatvori task";
simpleButton1.Enabled = true;
db.SaveChanges();
simpleButton3.Enabled = true;
labelControl6.Visible = false;
if (OperaterLogin.operater.Podesavanja.task_github_upload)
{
otvorigittask(task);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
private void FormDodajKomentar_FormClosing(object sender, FormClosingEventArgs e)
{
if (this.DialogResult != DialogResult.OK) //Ako nije save, a forma se zatvorila. Brisati slike...
{
var db = new AbacusSUPEntities();
db.Komentar.Remove(db.Komentar.First(qq => qq.id == tempid));
db.SaveChanges();
try //Directory.Delete(path, true) vjerovatno moze da obrise sve u direktorijumu, ali directory info je korisna klasa za znat
{
System.IO.DirectoryInfo direktorijum = new DirectoryInfo(System.Windows.Forms.Application.StartupPath + "\\Slike\\" + task.id_task.ToString() + "\\" + tempid.ToString());
foreach (FileInfo file in direktorijum.GetFiles()) //sve fajlove
{
file.Delete();
}
foreach (DirectoryInfo dir in direktorijum.GetDirectories()) //sve foldere
{
dir.Delete(true);
}
Directory.Delete(System.Windows.Forms.Application.StartupPath + "\\Slike\\" + task.id_task.ToString() + "\\" + tempid.ToString()); //sam direktorijum
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public async void napravigithubissue(Task task)
{
try
{
var client = new GitHubClient(new ProductHeaderValue("AbacusSUPP"));
var basicAuth = new Credentials("jovanmhn", "jovan123");
client.Credentials = basicAuth;
var noviIssue = new NewIssue(task.naslov);
noviIssue.Body = task.opis;
var issue = await client.Issue.Create("jovanmhn", "AbacusSUPP", noviIssue);
var db = new AbacusSUPEntities();
db.Task.First(qq => qq.id_task == task.id_task).git_id = issue.Number;
db.SaveChanges();
//var comment = client.Issue.Comment.Create("jovanmhn", "AbacusSUPP", 5, "test KOmentar 123"); //ovo radi, argumenti su owner/repo/issueNo/komentar
//var issueupitanju = await client.Issue.Get("jovanmhn", "AbacusSUPP", 3);
}
catch (Exception)
{
MessageBox.Show("Greska prilikom dodavanja na GitHub issues");
}
}
private void FormAddTask_FormClosing(object sender, FormClosingEventArgs e)
{
if (this.DialogResult != DialogResult.OK)
{
/*
* try
* {
* Baza = new AbacusSUPEntities();
* Baza.Task.Remove(Baza.Task.First(qq => qq.id_task == task.id_task));
* }
* catch (Exception ex)
* {
*
* MessageBox.Show(ex.Message);
* }*/
}
if (!sacuvano)
{
try
{
if (listaveza_old.Count > 0)
{
var Db = new AbacusSUPEntities();
Db.VezaLT.AddRange(listaveza_old);
Db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void barButtonItem11_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
settings:
if (OperaterLogin.operater.id_podesavanja != 0 && OperaterLogin.operater.id_podesavanja != null)
{
FormSettings frmsett = new FormSettings(OperaterLogin.operater.Podesavanja, gridView1);
var res = frmsett.ShowDialog();
if (res == DialogResult.OK)
{
var Baza = new AbacusSUPEntities();
OperaterLogin.operater = Baza.Login.First(qq => qq.id == OperaterLogin.operater.id);
}
}
else
{
Podesavanja pod = new Podesavanja
{
minimize_notif = false,
minimize_tray = true,
novitask_notif = true,
novikom_notif = true,
task_novi_prozor = false,
pixel_scr = false,
task_github_upload = false,
kom_github_upload = false,
};
var db = new AbacusSUPEntities();
db.Podesavanja.Add(pod);
db.SaveChanges();
var op = db.Login.First(qq => qq.id == OperaterLogin.operater.id);
op.id_podesavanja = pod.id_podesavanja;
db.SaveChanges();
var log = db.Login.First(qq => qq.id == OperaterLogin.operater.id);
OperaterLogin.operater = log;
goto settings;
}
/*frmsett.FormClosed += (ss, ee) => //NOVO**
* {
* Baza = new AbacusSUPEntities();
* OperaterLogin.operater = Baza.Login.First(qq => qq.id == OperaterLogin.operater.id);
* };*/
}
public void deleteTask(Task taskzaDelete) // ne koristi se!
{
//int id = taskzaDelete.id_task;
//List<Komentar> listakom = Baza.Komentar.Where(qq => qq.id_task == id).ToList();
//Baza.Komentar.RemoveRange(listakom);
//Baza.SaveChanges();
var Baza = new AbacusSUPEntities();
Baza.Task.Remove(taskzaDelete);
Baza.SaveChanges();
gridControl1.DataSource = Baza.Task.ToList().OrderByDescending(qq => qq.datum);
gridView1.RefreshData();
Baza = new AbacusSUPEntities();
}
public FormAddTask(Task _task)
{
InitializeComponent();
Baza = new AbacusSUPEntities();
partneriBindingSource.DataSource = Baza.Partneri.ToList();
//statusBindingSource.DataSource = Baza.Status.ToList();
prioritetBindingSource.DataSource = Baza.Prioritet.ToList();
labelBindingSource.DataSource = Baza.Label.ToList();
gridControl1.DataSource = Baza.Login.ToList().OrderBy(qq => qq.id);
this.DialogResult = DialogResult.Cancel;
if (_task.id_task == 0)
{
task = _task;
}
else
{
isEdit = true;
Baza = new AbacusSUPEntities();
task = Baza.Task.First(qq => qq.id_task == _task.id_task);
listaveza_old = Baza.VezaLT.Where(qq => qq.id_task == task.id_task).ToList();
List <Login> datasource = Baza.Login.OrderBy(qq => qq.id).ToList();
Baza.VezaLT.RemoveRange(listaveza_old);
Baza.SaveChanges();
List <VezaLT> listaveza = new List <VezaLT>();
listaveza.AddRange(listaveza_old);
foreach (VezaLT veza in listaveza)
{
idoperatera.Add(veza.id_login);
}
foreach (int id in idoperatera)
{
//int handle = datasource.IndexOf(datasource.First(qq => qq.id == id));
//if(gridView1.IsDataRow(handle))
//gridView1.SelectRow(handle);
var row = datasource.FirstOrDefault(qq => qq.id == id);
var r = gridView1.LocateByValue("username", row.username);
gridView1.SelectRow(r);
}
}
taskbindingSource.Add(task);
}
private async void barButtonItem21_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//-------------GitHub test sync----------------
var client = new GitHubClient(new ProductHeaderValue("AbacusSUPP"));
var basicAuth = new Credentials("jovanmhn", "jovan123");
client.Credentials = basicAuth;
var pomocniFiltar = new RepositoryIssueRequest
{
//Assignee = "none",
//Milestone = "none",
//Filter = IssueFilter.All,
State = ItemStateFilter.Closed
};
var issues = await client.Issue.GetAllForRepository("jovanmhn", "AbacusSUPP");//ovdje treci parametar moze da ide tipa RepositoryIssueRequest
List <int> otvoreni = new List <int>();
var db = new AbacusSUPEntities();
foreach (Issue iss in issues)
{
otvoreni.Add(iss.Number);
}
foreach (Task task in Main_lista.Where(qq => qq.status_id == 1))
{
if (task.git_id.HasValue)
{
if (!otvoreni.Contains(task.git_id.Value))
{
db.Task.First(qq => qq.id_task == task.id_task).status_id = 2;
db.Task.First(qq => qq.id_task == task.id_task).login_id_zatv = OperaterLogin.operater.id;
db.Task.First(qq => qq.id_task == task.id_task).datum_zatv = DateTime.Now;
}
}
}
db.SaveChanges();
Main_lista = db.Task.ToList();
gridControl1.DataSource = Main_lista;
gridView1.RefreshData();
//---------------------------------------------
}
public FormDodajKomentar(Task _task, GridControl gridcontrol, LayoutView layoutView, XtraScrollableControl xtraScrollableControl)
{
InitializeComponent();
Baza = new AbacusSUPEntities();
task = _task;
imageCollection = richEditControl1.Document.Images;
gridControl1 = gridcontrol;
layoutView1 = layoutView;
xtraScrollableControl1 = xtraScrollableControl;
#region Da olaksa .rtf! brisanje styleova i sl
//richEditControl1.Document.BeginUpdate();
//try
//{
// for (int i = richEditControl1.Document.TableStyles.Count - 1; i >= 1; i--)
// richEditControl1.Document.TableStyles.Delete(richEditControl1.Document.TableStyles[i]);
// for (int i = richEditControl1.Document.ParagraphStyles.Count - 1; i >= 1; i--)
// richEditControl1.Document.ParagraphStyles.Delete(richEditControl1.Document.ParagraphStyles[i]);
// for (int i = richEditControl1.Document.CharacterStyles.Count - 1; i >= 1; i--)
// richEditControl1.Document.CharacterStyles.Delete(richEditControl1.Document.CharacterStyles[i]);
//}
//finally
//{
// richEditControl1.Document.EndUpdate();
//}
#endregion
kom = new Komentar
{
datum = DateTime.Now,
sadrzaj = null,
id_login = OperaterLogin.operater.id,
id_task = task.id_task
};
Baza.Komentar.Add(kom);
Baza.SaveChanges();
tempid = kom.id;
}
private async void barButtonItem17_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Task task = (Task)gridView1.GetRow(gridView1.FocusedRowHandle);
Main_lista.Remove(task);
var db = new AbacusSUPEntities();
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).datum_zatv = DateTime.Now;
db.Task.FirstOrDefault(qq => qq.id_task == task.id_task).login_id_zatv = OperaterLogin.operater.id;
db.Task.First(qw => qw.id_task == task.id_task).status_id = 2;
db.SaveChanges();
var db2 = new AbacusSUPEntities();
Main_lista.Add(db2.Task.First(qq => qq.id_task == task.id_task));
taskBindingSource.DataSource = Main_lista.OrderByDescending(qq => qq.datum);
gridView1.RefreshData();
if (task.git_id.HasValue)
{
try
{
var client = new GitHubClient(new ProductHeaderValue("AbacusSUPP"));
var basicAuth = new Credentials("jovanmhn", "jovan123");
client.Credentials = basicAuth;
var issueupitanju = await client.Issue.Get("jovanmhn", "AbacusSUPP", task.git_id.Value);
var update = issueupitanju.ToUpdate();
update.State = ItemState.Closed;
var updatetest = await client.Issue.Update("jovanmhn", "AbacusSUPP", task.git_id.Value, update);
}
catch
{
}
}
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var Baza = new AbacusSUPEntities();
Task zaDel = (Task)gridView1.GetRow(gridView1.FocusedRowHandle);
Main_lista.Remove(Main_lista.First(qq => qq.id_task == zaDel.id_task));
Baza.Task.Remove(Baza.Task.First(qq => qq.id_task == zaDel.id_task));
Baza.SaveChanges();
try
{
Directory.Delete(System.Windows.Forms.Application.StartupPath + "\\Slike\\" + zaDel.id_task.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//gridControl1.DataSource = Baza.Task.ToList().OrderByDescending(qq => qq.datum);
Main_lista.OrderByDescending(qq => qq.datum);
taskBindingSource.DataSource = Main_lista.OrderByDescending(qq => qq.datum);
gridView1.RefreshData();
}
public async void napravigithubissue(Task task)
{
try
{
var client = new GitHubClient(new ProductHeaderValue("AbacusSUPP"));
var basicAuth = new Credentials("jovanmhn", "jovan123");
client.Credentials = basicAuth;
var noviIssue = new NewIssue(task.Partneri.naziv + " - " + task.naslov);
noviIssue.Body = task.opis;
noviIssue.Labels.Add("AbacusSUPP");
switch (task.prioritet_id)
{
case 1: { noviIssue.Labels.Add("low prio"); break; }
case 2: { noviIssue.Labels.Add("medium prio"); break; }
case 3: { noviIssue.Labels.Add("high prio"); break; }
default: { noviIssue.Labels.Add("medium prio"); break; }
}
noviIssue.Assignees.Add("jovanmhn");
var issue = await client.Issue.Create("jovanmhn", "AbacusSUPP", noviIssue);
//var update = issue.ToUpdate();
//update.AddLabel("AbacusSUPP");
var db = new AbacusSUPEntities();
db.Task.First(qq => qq.id_task == task.id_task).git_id = issue.Number;
db.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Greska prilikom dodavanja na GitHub issues");
}
}
private async void simpleButton1_Click(object sender, EventArgs e)
{
this.DialogResult = DialogResult.OK;
byte[] r1 = AbacusSUPP.Helper.Zip(richEditControl1.Document.RtfText);
string base64 = Convert.ToBase64String(r1);
var db = new AbacusSUPEntities();
db.Komentar.First(qq => qq.id == tempid).sadrzaj = base64;
kom.sadrzaj = base64; //zbog uploada na imgur, moguce je da nije potrebno
db.SaveChanges();
int id = 0;
//var db2 = new AbacusSUPEntities();
gridControl1.DataSource = db.Komentar.Where(qq => qq.id_task == task.id_task).OrderBy(ww => ww.datum).ToList();
layoutView1.RefreshData();
LayoutViewInfo info = layoutView1.GetViewInfo() as LayoutViewInfo;
layoutView1.OptionsBehavior.ScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Never;
gridControl1.Size = new Size(xtraScrollableControl1.Width - SystemInformation.VerticalScrollBarWidth, info.CalcRealViewHeight(new Rectangle(0, 0, 300, Int32.MaxValue)));
if (OperaterLogin.operater.Podesavanja.kom_github_upload)
{
try
{
//----------------------GitHub-----------------------------------------
var client = new GitHubClient(new ProductHeaderValue("AbacusSUPP"));
var basicAuth = new Credentials("jovanmhn", "jovan123");
client.Credentials = basicAuth;
string listal = getSveLinkove(kom);
var comment = await client.Issue.Comment.Create("jovanmhn", "AbacusSUPP", task.git_id.Value, vratiPlainText(richEditControl1) + Environment.NewLine + listal); //ovo radi, argumenti su owner/repo/issueNo/komentar
//var issueupitanju = await client.Issue.Get("jovanmhn", "AbacusSUPP", 3);
//---------------------------------------------------------------------
}
catch (Exception ex)
{
MessageBox.Show("Greska prilikom uploada komentara na GitHub" + Environment.NewLine + ex.Message);
}
}
#region Ovo sve je sranje, cijelu formu treba ispraviti, mozda GUID za link za sliku prije nego sto dobije ID...
//string uri = Application.StartupPath + "\\Slike\\" + task.id_task.ToString() + "\\" + id.ToString() + "\\";
//int broj = 0;
//foreach (DocumentImage image in richEditControl1.Document.Images)
//{
// var a = image.Range;
// uri += broj.ToString() + ".bmp";
// HyperlinkCollection hypcol = richEditControl1.Document.Hyperlinks;
// Hyperlink hyperlink = hypcol.Create(a);
// //Hyperlink hyperlink = richEditControl1.Document.CreateHyperlink(a);
// hyperlink.NavigateUri = uri;
// broj++;
//}
//byte[] test = AbacusSUPP.Helper.Zip(richEditControl1.Document.RtfText);
//string test2 = Convert.ToBase64String(test);
//var db3 = new AbacusSUPEntities();
//Komentar testkom = db3.Komentar.Single(qq => qq.id == tempid);
//testkom.sadrzaj = test2;
//db3.SaveChanges();
//gridControl1.DataSource = db3.Komentar.Where(qq => qq.id_task == task.id_task).OrderBy(ww => ww.datum).ToList();
//layoutView1.RefreshData();
#endregion
OperaterLogin.stara_kom_lista.Add(kom);
this.Close();
this.DialogResult = DialogResult.OK;
kraj :;
}
