/// <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"); } } }