/// <summary>
///
/// </summary>
/// <param name="Command"></param>
/// <param name="MyStatment"></param>
/// <returns></returns>
public async Task <object> MyMethodAsync(string Command, TypeStatment MyStatment)
{
using (SqlConnection connect = new SqlConnection(ConnectionServer))
{
await connect.OpenAsync();
SqlCommand cmd = new SqlCommand(Command, connect);
cmd.CommandType = CommandType.Text;
switch (MyStatment)
{
case TypeStatment.Select:
SqlDataReader read = await cmd.ExecuteReaderAsync();
DataTable table = new DataTable();
table.Load(read);
return(table);
case TypeStatment.UpdateOrDeleteOrInsert:
int RowNumbers = await cmd.ExecuteNonQueryAsync();
return(RowNumbers);
case TypeStatment.AggregateFunction:
return(await cmd.ExecuteScalarAsync());
default:
return("Unknow Value");
}
}
}
/// <summary>
/// This is method Deals with Database
/// </summary>
/// <param name="storedProcedure">Stord Procedure</param>
/// <param name="Par">Sql Parameter </param>
/// <param name="MyStatment">Type of Statment</param>
/// <returns></returns>
public object MyMethod(string storedProcedure, SqlParameter[] Par, TypeStatment MyStatment)
{
using (SqlConnection connect = new SqlConnection(ConnectionServer))
{
connect.Open();
SqlCommand cmd = new SqlCommand(storedProcedure, connect);
cmd.CommandType = CommandType.StoredProcedure;
if (Par != null)
{
for (int i = 0; i < Par.Length; i++)
{
cmd.Parameters.Add(Par[i]);
}
}
switch (MyStatment)
{
case TypeStatment.Select:
SqlDataReader read = cmd.ExecuteReader();
DataTable table = new DataTable();
table.Load(read);
return(table);
case TypeStatment.UpdateOrDeleteOrInsert:
int Rows = cmd.ExecuteNonQuery();
return(Rows);
case TypeStatment.AggregateFunction:
return(cmd.ExecuteScalar());
default:
return("Unknown");
}
}
}
