internal async Task ById(SearchByIdModel model, SqlConnection connection1, CompaniesByIdModel resultSeachByIdModel) { resultSeachByIdModel.name = ""; resultSeachByIdModel.users = new List <CompaniesUsersByIdDetailsModel>(); if (model.id != "0") { await GetById(connection1, model, resultSeachByIdModel); } await GetByUsers(connection1, model, resultSeachByIdModel); }
private async Task GetById(SqlConnection connection1, SearchByIdModel model, CompaniesByIdModel data) { SqlCommand cmd = new SqlCommand(); string cmdString = "SELECT name FROM Companies " + "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.name = reader.GetString(0); } reader.Close(); }
private async Task GetByUsers(SqlConnection connection1, SearchByIdModel model, CompaniesByIdModel data) { SqlCommand cmd = new SqlCommand(); string cmdString = "select a.id, a.email, u.firstName + ' ' + u.LastName as name, g.ischecked from AspNetUsers a " + "left join users u on a.id = u.id " + "left join companiesusers g on g.idcompany = @id and g.iduser = u.id " + "left join AspNetUserRoles ur on a.id = ur.UserId " + "left join AspNetRoles r on ur.RoleId = r.id " + "where a.LockoutEnabled = 0 and r.name is null " + "order by name"; 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()) { CompaniesUsersByIdDetailsModel details = new CompaniesUsersByIdDetailsModel(); details.id = reader.GetString(0); details.name = reader.GetString(1); if (!reader.IsDBNull(2)) { details.name = reader.GetString(2).Trim(); } if (reader.IsDBNull(3)) { details.ischecked = false; details.isEdit = 0; } else { details.ischecked = reader.GetBoolean(3); details.isEdit = 1; } data.users.Add(details); } reader.Close(); }
public async Task <HttpResponseMessage> Companies(CompaniesDataModel model) { Thread.CurrentThread.CurrentCulture = culture; List <CompaniesQueryModel> resultSeachModel = null; CompaniesByIdModel resultSeachByIdModel = null; Companies proxy = new Companies(); try { if (!await Authentication.isAdmin(User, Request)) { Authentication auth = new Authentication(); if (!await auth.AccesRights(User.Identity.GetUserId(), "companies", model.type)) { return(Request.CreateResponse(System.Net.HttpStatusCode.Unauthorized)); } auth = null; } using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { using (SqlConnection connection1 = new SqlConnection(connetionString)) { await connection1.OpenAsync(); if (model.type == 1) { resultSeachModel = new List <CompaniesQueryModel>(); await proxy.SearchQuery(model.search, resultSeachModel, connection1); } else if (model.type == 2) { resultSeachByIdModel = new CompaniesByIdModel(); 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)); }