public async Task <List <Entitys.Approved> > Get(Entitys.Approved approved) { List <Entitys.Approved> list = new List <Entitys.Approved>(); db = new IdeaBankBaseEntities(); using (_con = new SqlConnection(_connect)) { try { _cmd = new SqlCommand("spGetListOfApproved", _con) { CommandType = CommandType.StoredProcedure }; SqlParameter param = new SqlParameter { ParameterName = "@UserId", Value = approved.UserId }; _cmd.Parameters.Add(param); SqlParameter paramOfferId = new SqlParameter { ParameterName = "@OfferId", Value = approved.OfferId }; _cmd.Parameters.Add(paramOfferId); _con.Open(); _sqlReader = await _cmd.ExecuteReaderAsync(); if (_sqlReader.HasRows) { while (_sqlReader.Read()) { Entitys.Approved approv = new Entitys.Approved { UserId = _sqlReader["UserId"].ToString(), UserName = db.AspNetUsers.ToList().Where(u => u.Id == _sqlReader["UserId"].ToString()).First().UserName, OfferId = (int)_sqlReader["OfferId"], StatusId = (int)_sqlReader["StatusId"], StatusName = db.Statuses.ToList().Where(s => s.Id == (int)_sqlReader["StatusId"]).First().Name }; if (!_sqlReader.IsDBNull(_sqlReader.GetOrdinal("DateApproved"))) { approv.DateApproved = (DateTime)_sqlReader["DateApproved"]; } list.Add(approv); } } _sqlReader.Close(); } finally { _con.Close(); } } return(list); }
public async Task <List <Entitys.AspNetUserRoles> > Get(Entitys.AspNetUserRoles approved) { List <Entitys.AspNetUserRoles> list = new List <Entitys.AspNetUserRoles>(); db = new IdeaBankBaseEntities(); using (_con = new SqlConnection(_connect)) { try { _cmd = new SqlCommand("spGetListOfUserRoles", _con) { CommandType = CommandType.StoredProcedure }; SqlParameter param = new SqlParameter { ParameterName = "@UserId", Value = approved.UserId }; _cmd.Parameters.Add(param); _con.Open(); _sqlReader = await _cmd.ExecuteReaderAsync(); if (_sqlReader.HasRows) { while (_sqlReader.Read()) { Entitys.AspNetUserRoles roles = new Entitys.AspNetUserRoles { UserId = _sqlReader["UserId"].ToString(), RoleId = _sqlReader["RoleId"].ToString(), RoleName = db.AspNetRoles.ToList().Where(u => u.Id == _sqlReader["RoleId"].ToString()).First().Name }; list.Add(roles); } } _sqlReader.Close(); } finally { _con.Close(); } } return(list); }
public TypeOfOffer() { db = new IdeaBankBaseEntities(); }
public Direction() { db = new IdeaBankBaseEntities(); }
public Category() { db = new IdeaBankBaseEntities(); }
public AspNetRole() { db = new IdeaBankBaseEntities(); }
public StatusController() { db = new IdeaBankBaseEntities(); }
public Problem() { db = new IdeaBankBaseEntities(); }
public Status() { db = new IdeaBankBaseEntities(); }
public Unit() { db = new IdeaBankBaseEntities(); }