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();
}
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);
}
}
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();
}
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();
}
}
}
}
}
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);
}
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);
}
