// GET: Users/GetUser/GetUserRequest
public GetUserResponse GetUser([FromBody] GetUserRequest request)
{
if (!ModelState.IsValid)
{
throw new System.Exception(ModelState.ErrorCount.ToString());
}
CibitDb context = HttpContext.RequestServices.GetService(typeof(CibitDb)) as CibitDb;;
var config = new MapperConfiguration(mc => mc.CreateMap <GetUserRequest, UserDTO>());
var mapper = new Mapper(config);
var userinfo = mapper.Map <GetUserRequest, UserDTO>(request);
var spObj = Converters.GetUserConverter(userinfo);
var reader = context.StoredProcedureSql("getUser", spObj);
GetUserResponse response = new GetUserResponse();
while (reader.Read())
{
response.user = new User()
{
CibitId = reader["cibitId"].ToString(),
FName = reader["fName"].ToString(),
LName = reader["lName"].ToString(),
Email = reader["email"].ToString(),
University = reader["university"].ToString()
};
}
context.Connection.Close();
return(response);
}
// INSERT: Research/CreateResearch/CreateResearchRequest
public bool CreateResearch([FromBody] CreateResearchRequest request)
{
CibitDb context = HttpContext.RequestServices.GetService(typeof(CibitDb)) as CibitDb;
var config = new MapperConfiguration(mc => mc.CreateMap <CreateResearchRequest, ResearchDTO>());
var mapper = new Mapper(config);
var userinfo = mapper.Map <CreateResearchRequest, ResearchDTO>(request);
var spObj = Converters.CreateResearchConverter(userinfo);
var reader = context.StoredProcedureSql("CreateReasarch", spObj);
context.Connection.Close();
return(true);
}
// DELETE: Transaction/RemoveCoin/RemoveCoinRequest
public bool RemoveCoin([FromBody] RemoveCoinRequest request)
{
CibitDb context = HttpContext.RequestServices.GetService(typeof(CibitDb)) as CibitDb;
ValidateUser valid = new ValidateUser();
var config = new MapperConfiguration(mc => mc.CreateMap <RemoveCoinRequest, TransactionDTO>());
var mapper = new Mapper(config);
var userinfo = mapper.Map <RemoveCoinRequest, TransactionDTO>(request);
valid.VerifyCoinId(userinfo.CoinId, userinfo.SenderId);
var spObj = Converters.RemoveCoinConverter(userinfo);
var reader = context.StoredProcedureSql("RemoveCoin", spObj);
context.Connection.Close();
return(true);
}
// GET: Users/GetAllUsers/
public GetAllUsersResponse GetAllUsers()
{
CibitDb context = HttpContext.RequestServices.GetService(typeof(CibitDb)) as CibitDb;;
var reader = context.StoredProcedureSql("getUsers", null);
GetAllUsersResponse response = new GetAllUsersResponse();
while (reader.Read())
{
response.Users.Add(new User()
{
CibitId = reader["cibitId"].ToString(),
FName = reader["fName"].ToString(),
LName = reader["lName"].ToString(),
Email = reader["email"].ToString(),
University = reader["university"].ToString(),
CitationAmount = (int.TryParse(reader["citationAmount"].ToString(), out int number)) ? number : 0
});