private async Task GetById(SqlConnection connection1, SearchByIdModel model, MenuByIdModel data)
{
SqlCommand cmd = new SqlCommand();
string cmdString = "SELECT menu, entitie FROM menu m " +
"where id = @id";
cmd.CommandText = cmdString;
cmd.Connection = connection1;
SqlParameter parameter = new SqlParameter("@id", SqlDbType.VarChar);
parameter.Value = model.id;
cmd.Parameters.Add(parameter);
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
data.menu = reader.GetString(0);
data.entitie = reader.GetString(1);
}
reader.Close();
}
internal async Task ById(SearchByIdModel model, SqlConnection connection1, MenuByIdModel resultSeachByIdModel)
{
await GetById(connection1, model, resultSeachByIdModel);
}
public async Task <HttpResponseMessage> Menu(MenuDataModel model)
{
Thread.CurrentThread.CurrentCulture = culture;
List <MenuQueryModel> resultSeachModel = null;
MenuByIdModel resultSeachByIdModel = null;
try
{
Menu proxy = new Menu();
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
using (SqlConnection connection1 = new SqlConnection(connetionString))
{
await connection1.OpenAsync();
if (model.type == 1)
{
resultSeachModel = new List <MenuQueryModel>();
await proxy.SearchQuery(model.search, resultSeachModel, connection1);
}
else if (model.type == 2)
{
resultSeachByIdModel = new MenuByIdModel();
await proxy.ById(model.byId, connection1, resultSeachByIdModel);
}
else if (model.type == 3)
{
await proxy.New(connection1, model.update);
}
else if (model.type == 4)
{
await proxy.Update(connection1, model.update);
}
else if (model.type == 5)
{
await proxy.UpdateIsActive(connection1, model.isActive);
}
}
scope.Complete();
}
}
catch (TransactionAbortedException ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
catch (Exception ex)
{
ErrorModel _errors = new ErrorModel();
_errors.message = ex.Message;
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError, _errors));
}
if (model.type == 1)
{
return(Request.CreateResponse(System.Net.HttpStatusCode.OK, resultSeachModel));
}
else if (model.type == 2)
{
return(Request.CreateResponse(System.Net.HttpStatusCode.OK, resultSeachByIdModel));
}
return(Request.CreateResponse(System.Net.HttpStatusCode.OK));
}
