public async Task <List <EntityTypeResponse> > SearchEntityType(string name)
{
List <EntityTypeResponse> dt = new List <EntityTypeResponse>();
await _connection.OpenAsync();
try
{
using (MySqlCommand cmd = new MySqlCommand("Search_EntityType", _connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EntityTypeNameVal", "%" + name + "%");
var dr = cmd.ExecuteReader();
while (dr.Read())
{
var row = new EntityTypeResponse();
row.Id = Convert.ToInt32(dr["ID"]);
row.Name = dr["Name"].ToString();
row.Description = dr["Description"].ToString();
dt.Add(row);
}
}
return(dt);
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}
public async Task <EntityTypeResponse> GetEntityTypeByID(int Id)
{
EntityTypeResponse row = null;
await _connection.OpenAsync();
try
{
using (MySqlCommand cmd = new MySqlCommand("Get_EntityTypeById", _connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EntityTypeId", Id);
var dr = cmd.ExecuteReader();
while (dr.Read())
{
row = new EntityTypeResponse();
row.Id = Convert.ToInt32(dr["ID"]);
row.Name = dr["Name"].ToString();
row.Description = dr["Description"].ToString();
}
}
return(row);
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}
public async Task <List <EntityTypeResponse> > GetAllEntityType()
{
try
{
List <EntityTypeResponse> dt = new List <EntityTypeResponse>();
await _connection.OpenAsync();
using (MySqlCommand cmd = new MySqlCommand("Get_AllEntityType", _connection))
{
cmd.CommandType = CommandType.StoredProcedure;
var dr = cmd.ExecuteReader();
while (dr.Read())
{
var row = new EntityTypeResponse();
row.Id = Convert.ToInt32(dr["ID"]);
row.Name = dr["Name"].ToString();
row.Description = dr["Description"].ToString();
dt.Add(row);
}
}
return(dt);
}
catch (Exception ex)
{
throw;
}
finally
{
await _connection.CloseAsync();
}
}
