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();
}
