Exemple #1
0
 public TeknikKartForm(int cardid, List <Personel> personels)
 {
     InitializeComponent();
     button_add_card.Visible = false;
     card = DataBaseQueries.GetCardDetails(cardid);
     textBox_cardname.Text = card.cardname;
     label_cardno.Text     = card.cardid.ToString();
     label_cardname.Text   = card.cardname;
     textBox_desc.Text     = card.description;
     textBox_notes.Text    = card.notes;
     label_card_date.Text  = card.date.ToString("MM/dd/yyyy");
     foreach (IsTakip takip in card.isTakiplist)
     {
         dataGridView_takip.Rows.Add(takip.date, takip.durum, takip.yapilacak, takip.aciklama);
     }
     personels = personels.Except(card.cardpersonel, new PersonelEqualityComparer()).ToList();
     foreach (Personel personel1 in personels)
     {
         listBox_projectpersonel.Items.Add(personel1);
     }
     foreach (Personel personel in card.cardpersonel)
     {
         listBox_cardpersonel.Items.Add(personel);
     }
     CalculateTime();
 }
Exemple #2
0
 public TeknikKartForm(Project project)
 {
     InitializeComponent();
     this.current = project;
     button_delete_card.Visible = false;
     button_update_card.Visible = false;
     card = new ScrumCard();
     foreach (Personel personel in project.personels)
     {
         listBox_projectpersonel.Items.Add(personel);
     }
 }
Exemple #3
0
 private void button_add_card_Click(object sender, EventArgs e)
 {
     card = new ScrumCard(current.projectid, "panel_todo", DateTime.Today, textBox_desc.Text, textBox_notes.Text, textBox_cardname.Text);
     foreach (Personel item in listBox_cardpersonel.Items)
     {
         card.cardpersonel.Add(item);
     }
     foreach (DataGridViewRow row in dataGridView_takip.Rows)
     {
         card.isTakiplist.Add(new IsTakip(card.cardid, (DateTime)row.Cells[0].Value, (string)row.Cells[1].Value, (string)row.Cells[2].Value, (string)row.Cells[3].Value));
     }
     DataBaseQueries.AddNewCardToProject(card);
     this.Close();
 }
Exemple #4
0
 public static void UpdateCard(ScrumCard card)
 {
     using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.ScrumboarddbConnectionString))
     {
         using (SqlCommand command = new SqlCommand())
         {
             command.Connection  = connection;
             command.CommandText = "UPDATE Kartlar SET Aciklama=@Aciklama, Notlar=@Notlar, Kartadi=@Kartadi WHERE Kartid=@Kartid";
             command.Parameters.AddWithValue("@Kartid", card.cardid);
             command.Parameters.AddWithValue("@Kartadi", card.cardname);
             command.Parameters.AddWithValue("@Aciklama", card.description);
             command.Parameters.AddWithValue("@Notlar", card.notes);
             try
             {
                 connection.Open();
                 command.ExecuteNonQuery();
             }
             catch (SqlException)
             {
             }
             finally
             {
                 connection.Close();
             }
         }
         using (SqlCommand command = new SqlCommand())
         {
             command.Connection  = connection;
             command.CommandText = "DELETE From KartTeknikUzmanlar WHERE Kartid=@Kartid";
             command.Parameters.AddWithValue("@Kartid", card.cardid);
             try
             {
                 connection.Open();
                 command.ExecuteNonQuery();
             }
             catch (SqlException)
             {
             }
             finally
             {
                 connection.Close();
             }
         }
         foreach (Personel personel in card.cardpersonel)
         {
             using (SqlCommand command = new SqlCommand())
             {
                 command.Connection  = connection;
                 command.CommandText = "INSERT into KartTeknikUzmanlar (Kartid,Uzmanid) VALUES(@Kartid,@Uzmanid)";
                 command.Parameters.AddWithValue("@Kartid", card.cardid);
                 command.Parameters.AddWithValue("@Uzmanid", personel.personelid);
                 try
                 {
                     connection.Open();
                     command.ExecuteNonQuery();
                 }
                 catch (SqlException)
                 {
                 }
                 finally
                 {
                     connection.Close();
                 }
             }
         }
         using (SqlCommand command = new SqlCommand())
         {
             command.Connection  = connection;
             command.CommandText = "DELETE From Istakip WHERE Kartid=@Kartid";
             command.Parameters.AddWithValue("@Kartid", card.cardid);
             try
             {
                 connection.Open();
                 command.ExecuteNonQuery();
             }
             catch (SqlException)
             {
             }
             finally
             {
                 connection.Close();
             }
         }
         foreach (IsTakip takip in card.isTakiplist)
         {
             using (SqlCommand command = new SqlCommand())
             {
                 command.Connection  = connection;
                 command.CommandText = "INSERT into IsTakip (Kartid,Tarih,Durum,Yapilacakis,Aciklama) VALUES(@Kartid,@Tarih,@Durum,@Yapilacakis,@Aciklama)";
                 command.Parameters.AddWithValue("@Kartid", card.cardid);
                 command.Parameters.AddWithValue("@Tarih", takip.date);
                 command.Parameters.AddWithValue("@Durum", takip.durum);
                 command.Parameters.AddWithValue("@Yapilacakis", takip.yapilacak);
                 command.Parameters.AddWithValue("@Aciklama", takip.aciklama);
                 try
                 {
                     connection.Open();
                     command.ExecuteNonQuery();
                 }
                 catch (SqlException ex)
                 {
                 }
                 finally
                 {
                     connection.Close();
                 }
             }
         }
     }
 }
Exemple #5
0
        public static ScrumCard GetCardDetails(int cardid)
        {
            ScrumCard       card      = new ScrumCard();
            List <Personel> personels = new List <Personel> {
            };
            List <int> personelid     = new List <int> {
            };
            List <IsTakip> takip      = new List <IsTakip> {
            };

            using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.ScrumboarddbConnectionString))
            {
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection  = connection;
                    command.CommandText = "SELECT * from Kartlar WHERE Kartid=@Kartid";
                    command.Parameters.AddWithValue("@Kartid", cardid);
                    connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            card = new ScrumCard(Convert.ToInt32(reader["Kartid"].ToString()),
                                                 Convert.ToInt32(reader["Projeid"].ToString()),
                                                 reader["Durum"].ToString(),
                                                 (DateTime)reader["Olusturulmatarihi"],
                                                 reader["Aciklama"].ToString(),
                                                 reader["Notlar"].ToString(),
                                                 reader["Kartadi"].ToString()
                                                 );
                        }
                    }
                    connection.Close();
                }
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection  = connection;
                    command.CommandText = "SELECT * from KartTeknikUzmanlar WHERE Kartid=@Kartid";
                    command.Parameters.AddWithValue("@Kartid", cardid);
                    connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            personelid.Add((int)reader["Uzmanid"]);
                        }
                    }
                    connection.Close();
                }
                foreach (int id in personelid)
                {
                    using (SqlCommand command = new SqlCommand())
                    {
                        command.Connection  = connection;
                        command.CommandText = "SELECT * from TeknikUzmanlar WHERE Uzmanid=@Uzmanid";
                        command.Parameters.AddWithValue("@Uzmanid", id);
                        connection.Open();
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                personels.Add(new Personel(id, reader["Uzmanisim"].ToString()));
                            }
                        }
                        connection.Close();
                    }
                }
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection  = connection;
                    command.CommandText = "SELECT * from Istakip WHERE Kartid=@Kartid";
                    command.Parameters.AddWithValue("@Kartid", cardid);
                    connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            takip.Add(new IsTakip(cardid, (DateTime)reader["Tarih"], reader["Durum"].ToString(),
                                                  reader["Yapilacakis"].ToString(), reader["Aciklama"].ToString()));
                        }
                    }
                    connection.Close();
                }
            }
            card.cardpersonel = personels;
            card.isTakiplist  = takip;
            return(card);
        }
Exemple #6
0
 public static ScrumCard AddNewCardToProject(ScrumCard card)
 {
     using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.ScrumboarddbConnectionString))
     {
         using (SqlCommand command = new SqlCommand())
         {
             command.Connection  = connection;
             command.CommandText = "INSERT into Kartlar (Kartadi,Projeid,Durum,Olusturulmatarihi,Aciklama,Notlar) OUTPUT inserted.Kartid " +
                                   "VALUES(@Kartadi,@Projeid,@Durum,@Olusturulmatarihi,@Aciklama,@Notlar)";
             command.Parameters.AddWithValue("@Kartadi", card.cardname);
             command.Parameters.AddWithValue("@Projeid", card.projectid);
             command.Parameters.AddWithValue("@Durum", card.panelname);
             command.Parameters.AddWithValue("@Olusturulmatarihi", card.date);
             command.Parameters.AddWithValue("@Aciklama", card.description);
             command.Parameters.AddWithValue("@Notlar", card.notes);
             try
             {
                 connection.Open();
                 using (SqlDataReader reader = command.ExecuteReader())
                 {
                     while (reader.Read())
                     {
                         card.cardid = Convert.ToInt32(reader["Kartid"].ToString());
                     }
                 }
             }
             catch (SqlException)
             {
             }
             finally
             {
                 connection.Close();
             }
         }
         foreach (Personel personel in card.cardpersonel)
         {
             using (SqlCommand command = new SqlCommand())
             {
                 command.Connection  = connection;
                 command.CommandText = "INSERT into KartTeknikUzmanlar (Kartid,Uzmanid) VALUES(@Kartid,@Uzmanid)";
                 command.Parameters.AddWithValue("@Kartid", card.cardid);
                 command.Parameters.AddWithValue("@Uzmanid", personel.personelid);
                 try
                 {
                     connection.Open();
                     command.ExecuteNonQuery();
                 }
                 catch (SqlException)
                 {
                 }
                 finally
                 {
                     connection.Close();
                 }
             }
         }
         foreach (IsTakip takip in card.isTakiplist)
         {
             using (SqlCommand command = new SqlCommand())
             {
                 command.Connection  = connection;
                 command.CommandText = "INSERT into IsTakip (Kartid,Tarih,Durum,Yapilacakis,Aciklama) VALUES(@Kartid,@Tarih,@Durum,@Yapilacakis,@Aciklama)";
                 command.Parameters.AddWithValue("@Kartid", card.cardid);
                 command.Parameters.AddWithValue("@Tarih", takip.date);
                 command.Parameters.AddWithValue("@Durum", takip.durum);
                 command.Parameters.AddWithValue("@Yapilacakis", takip.yapilacak);
                 command.Parameters.AddWithValue("@Aciklama", takip.aciklama);
                 try
                 {
                     connection.Open();
                     command.ExecuteNonQuery();
                 }
                 catch (SqlException)
                 {
                     throw;
                 }
                 finally
                 {
                     connection.Close();
                 }
             }
         }
     }
     return(card);
 }