public List <Prosesler> ProsesListele() { List <Prosesler> ProsesList = new List <Prosesler>(); using (SqlConnection connect = new SqlConnection(base.ConnectionString)) { string sql = "SELECT Id,ProsesAdi,ProsesKodu,ProsesHizmetTanimi,ProsesKaynaklari,ProsesHedefi,Durum FROM Prosesler WHERE Silindi=0"; connect.Open(); SqlCommand command = new SqlCommand(sql, connect); SqlDataReader read = command.ExecuteReader(); while (read.Read()) { Prosesler B = new Prosesler(); B.Id = (int)read["Id"]; B.ProsesAdi = (string)read["ProsesAdi"]; B.ProsesKodu = (string)read["ProsesKodu"]; B.ProsesHizmetTanimi = (string)read["ProsesHizmetTanimi"]; B.ProsesKaynaklari = (string)read["ProsesKaynaklari"]; B.ProsesHedefi = (int)read["ProsesHedefi"]; B.Durum = (Boolean)read["Durum"]; ProsesList.Add(B); } connect.Close(); } return(ProsesList); }
public Prosesler Id_Ile_Proses_Getir(string proses_id) { Prosesler d = new Prosesler(); using (SqlConnection connect = new SqlConnection(base.ConnectionString)) { string sql = "SELECT Id,ProsesAdi,ProsesKodu,ProsesHizmetTanimi,ProsesKaynaklari,ProsesHedefi,Durum FROM Prosesler WHERE Silindi=0 AND Id=@PROSES"; connect.Open(); SqlCommand command = new SqlCommand(sql, connect); command.Parameters.AddWithValue("@PROSES", proses_id); SqlDataReader read = command.ExecuteReader(); while (read.Read()) { d.Id = (int)read["Id"]; d.ProsesAdi = (string)read["ProsesAdi"]; d.ProsesKodu = (string)read["ProsesKodu"]; d.ProsesHizmetTanimi = (string)read["ProsesHizmetTanimi"]; d.ProsesKaynaklari = (string)read["ProsesKaynaklari"]; d.ProsesHedefi = (int)read["ProsesHedefi"]; d.Durum = (Boolean)read["Durum"]; } connect.Close(); } return(d); }
protected void ProsesKaydetButton_Click(object sender, EventArgs e) { Prosesler my_proses = new Prosesler(); my_proses.ProsesAdi = ProsesAdi.Value; my_proses.ProsesKodu = ProsesKodu.Value; my_proses.ProsesHizmetTanimi = ProsesHizmetTanimi.Value; my_proses.ProsesKaynaklari = ProsesKaynaklari.Value; my_proses.ProsesHedefi = int.Parse(ProsesHedefi.Value); bool result = base.Get_Proses_bl.Proses_Ekle(my_proses); if (result) { ProsesEkleDiv.Visible = false; Uyari_Division.Visible = true; Literal_Uyari.Text = "<h2>Kayıt Başarılı bir şekilde gerçekleştirilmiştir.</h2>"; Response.Redirect("islemler.aspx?Proses=listele"); } }
protected void ProsesDG_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Proses_Sil") { string id = ((Label)((DataGridItem)e.Item).FindControl("Label_p_Id")).Text; bool result = base.Get_Proses_bl.Proses_Sil(id); if (result) { islem_basarili.Visible = true; ProsesListeleDiv.Visible = true; ProsesDG.DataSource = base.Get_Proses_bl.ProsesListele(); ProsesDG.DataBind(); } else { islem_basarisiz.Visible = true; } } if (e.CommandName == "Proses_Duzenle") { Hosgeldiniz_label.Text = hesap_ismi + " -> <a href='islemler.aspx'>İşlemler</a> -> <a href='?Proses=listele'>Proses Listele</a> -> <a href='#'>Proses Güncelleme</a>"; string id = ((Label)((DataGridItem)e.Item).FindControl("Label_p_Id")).Text; Prosesler selected_Proses = new Prosesler(); selected_Proses = base.Get_Proses_bl.Id_Ile_Proses_Getir(id); ProsesListeleDiv.Visible = false; ProsesEkleDiv.Visible = true; ProsesGuncelleButton.Visible = true; ProsesId.Text = selected_Proses.Id.ToString(); ProsesAdi.Value = selected_Proses.ProsesAdi; ProsesKodu.Value = selected_Proses.ProsesKodu; ProsesHizmetTanimi.Value = selected_Proses.ProsesHizmetTanimi; ProsesKaynaklari.Value = selected_Proses.ProsesKaynaklari; ProsesHedefi.Value = selected_Proses.ProsesHedefi.ToString(); } }
public bool Proses_Guncelle(Prosesler Proses) { bool result = false; using (SqlConnection connect = new SqlConnection(base.ConnectionString)) { try { string sql = "UPDATE Prosesler SET ProsesAdi=@NAME,ProsesKodu=@CODE,ProsesHizmetTanimi=@SERVICES,ProsesKaynaklari=@SOURCES,ProsesHedefi=@GOALS,Durum=@STATUS WHERE Id=@ID"; connect.Open(); SqlCommand command = new SqlCommand(sql, connect); command.Parameters.AddWithValue("@NAME", Proses.ProsesAdi); command.Parameters.AddWithValue("@CODE", Proses.ProsesKodu); command.Parameters.AddWithValue("@SERVICES", Proses.ProsesHizmetTanimi); command.Parameters.AddWithValue("@SOURCES", Proses.ProsesKaynaklari); command.Parameters.AddWithValue("@GOALS", Proses.ProsesHedefi); command.Parameters.AddWithValue("@STATUS", Proses.Durum); command.Parameters.AddWithValue("@ID", Proses.Id); command.ExecuteNonQuery(); connect.Close(); result = true; } catch (Exception ex) { throw ex; } finally { if (connect.State == System.Data.ConnectionState.Open) { connect.Close(); } } return(result); } }
public bool Proses_Ekle(Prosesler P) { int id = 0; using (SqlConnection connect = new SqlConnection(base.ConnectionString)) { string sql; try { sql = "INSERT INTO Prosesler (ProsesAdi,ProsesKodu,ProsesHizmetTanimi,ProsesKaynaklari,ProsesHedefi) OUTPUT INSERTED.Id VALUES(@NAME,@KOD,@HİZMET,@KAYNAK,@HEDEF)"; connect.Open(); SqlCommand command = new SqlCommand(sql, connect); command.Parameters.AddWithValue("@NAME", P.ProsesAdi); command.Parameters.AddWithValue("@KOD", P.ProsesKodu); command.Parameters.AddWithValue("@HİZMET", P.ProsesHizmetTanimi); command.Parameters.AddWithValue("@KAYNAK", P.ProsesKaynaklari); command.Parameters.AddWithValue("@HEDEF", P.ProsesHedefi); id = (int)command.ExecuteScalar(); connect.Close(); } catch (Exception ex) { throw ex; } finally { if (connect.State == System.Data.ConnectionState.Open) { connect.Close(); } } } return(id > 0 ? true : false); }
public bool Proses_Guncelle(Prosesler P) { return(base.ProsesIslemleri.Proses_Guncelle(P)); }