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