public void DeleteRecords(string query)
{
try
{
SqlConnection con = DBConnection.connection();
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public static int CRUDRecords(string query)
{
try
{
int i = 1;
SqlConnection con = DBConnection.connection();
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetData(string proc)
{
SqlConnection con = DBConnection.connection();
DataTable allData = new DataTable();
try
{
SqlCommand cmd = new SqlCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(allData);
con.Close();
}
catch
{
con.Close();
}
return(allData);
}