public static int db_Parameterized_Update_Delete_Insert(parameterizedQuery queryObject, bool blsetCommit = false)
{
try
{
using (SqlConnection connection = new SqlConnection(srConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = queryObject.srQuery;
cmd.Connection = connection;
foreach (var vrObject in queryObject.listofParameters)
{
cmd.Parameters.Add(vrObject.srParameterName, vrObject.typeofParameter).Value = vrObject.valueofParameter;
}
return(cmd.ExecuteNonQuery());
}
}
}
catch (Exception E)
{
// insertIntoTblSqlErrors(strQuery + " " + E.Message.ToString());
return(-1);
}
}
public static DataTable db_Parameterized_Select_DataTable(parameterizedQuery queryObject, bool blsetCommit = false)
{
DataTable dtResult = new DataTable();
try
{
using (SqlConnection connection = new SqlConnection(srConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = queryObject.srQuery;
cmd.Connection = connection;
foreach (var vrObject in queryObject.listofParameters)
{
cmd.Parameters.Add(vrObject.srParameterName, vrObject.typeofParameter).Value = vrObject.valueofParameter;
}
using (SqlDataAdapter sqlAdapt = new SqlDataAdapter(cmd))
{
sqlAdapt.Fill(dtResult);
}
}
}
}
catch (Exception E)
{
// insertIntoTblSqlErrors(strQuery + " " + E.Message.ToString());
}
return(dtResult);
}
