public class Ortak
{

public string scs(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteScalar().ToString();
}
catch (Exception ex)
{
return null;
}
}
}
}
public int scn(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteNonQuery();
}
catch (Exception ex)
{
return -1;
}
}
}
}
public DataTable sc(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlDataAdapter adap = new SqlDataAdapter(c, conn))
{
try
{
conn.Open();
if (p1 != null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

adap.Fill(dt);
}
catch (Exception ex)
{
}
}
}
return dt;
}
public static void Logla(string IP, string kim, string ne, string nasil)
{
if (ConfigurationManager.AppSettings["logla"] == "1")
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))
{
using (SqlCommand comm = new SqlCommand("INSERT INTO Logs(IP,Kim,Ne,Nasil) values (@ip,@kim,@ne,@nasil)", conn))
{
try
{
conn.Open();
comm.Parameters.AddWithValue("@ip", (IP==null?HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]:""));
comm.Parameters.AddWithValue("@kim", kim);
comm.Parameters.AddWithValue("@ne", ne);
comm.Parameters.AddWithValue("@nasil", nasil);


comm.ExecuteNonQuery();

}
catch (Exception ex)
{

}
}
}
}
}
}