public string Empdml(EmpClass emp, out string msg)
{
msg = "";
try
{
SqlCommand com = new SqlCommand("KT_Sistem2", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@id", emp.id);
com.Parameters.AddWithValue("@Kadi", emp.Kadi);
com.Parameters.AddWithValue("@Tel", emp.Tel);
com.Parameters.AddWithValue("@Adsoyad", emp.Adsoyad);
com.Parameters.AddWithValue("@Adres", emp.Adres);
com.Parameters.AddWithValue("@Acik", emp.Acik);
com.Parameters.AddWithValue("@ekle", emp.ekle);
com.Parameters.AddWithValue("@cikar", emp.cikar);
com.Parameters.AddWithValue("@bakiye", emp.Bakiye);
com.Parameters.AddWithValue("@flag", emp.flag);
con.Open();
com.ExecuteNonQuery();
con.Close();
msg = "Islem Basariyla Gerceklestirildi";
return(msg);
}
catch (Exception ex)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
msg = ex.Message;
return(msg);
}
}
//SqlConnection con = new SqlConnection("Data Source=LAPTOP-KBMKH7SD\\SQLEXPRESS;Initial Catalog=kasa;Integrated Security=True");
public DataSet Empget(EmpClass emp, out string msg)
{
DataSet ds = new DataSet();
msg = "";
try
{
SqlCommand com = new SqlCommand("KT_Sistem2", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@id", emp.id);
com.Parameters.AddWithValue("@Kadi", emp.Kadi);
com.Parameters.AddWithValue("@Tel", emp.Tel);
com.Parameters.AddWithValue("@Adsoyad", emp.Adsoyad);
com.Parameters.AddWithValue("@Adres", emp.Adres);
com.Parameters.AddWithValue("@Acik", emp.Acik);
com.Parameters.AddWithValue("@ekle", emp.ekle);
com.Parameters.AddWithValue("@cikar", emp.cikar);
com.Parameters.AddWithValue("@bakiye", emp.Bakiye);
com.Parameters.AddWithValue("@flag", emp.flag);
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(ds);
msg = "Islem Basariyla Gerceklestirildi";
return(ds);
}
catch (Exception ex)
{
msg = ex.Message;
return(ds);
}
}
