public List <RequestAdministrator> GetAllRequest()
{
List <RequestAdministrator> lstRequests = new List <RequestAdministrator>();
var conexion = con.obtenConexion();
SqlCommand command = new SqlCommand("sp_getAllRequest", conexion);
command.CommandType = CommandType.StoredProcedure;
try
{
conexion.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
RequestAdministrator request = new RequestAdministrator();
request.RequestId = (Guid)reader["RequestId"];
request.Folio = (string)reader["Folio"];
request.CURP = (string)reader["CURP"];
request.NoISSSTE = (string)reader["NoISSSTE"];
request.Name = (string)reader["Name"];
request.Estatus = (string)reader["estatus"];
request.Date = (string)reader["Date"];
lstRequests.Add(request);
}
}
else
{
Console.WriteLine("No rows found.");
return(null);
}
//reader.Close();
conexion.Close();
return(lstRequests);
}
catch (Exception ex)
{
return(null);
}
}
public RequestAdministrator GetHistoryRequestByRequestId(string requestId)
{
RequestAdministrator request = new RequestAdministrator();
var conexion = con.obtenConexion();
SqlCommand command = new SqlCommand("sp_getHistoryRequest", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@RequestId", SqlDbType.VarChar).Value = requestId;
try
{
conexion.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
request.RequestId = (Guid)reader["RequestId"];
request.Folio = (string)reader["Folio"];
request.CURP = (string)reader["CURP"];
request.NoISSSTE = (string)reader["NoISSSTE"];
request.Name = (string)reader["Name"];
request.Estatus = (string)reader["estatus"];
request.Date = (string)reader["Date"];
}
}
else
{
Console.WriteLine("No rows found.");
return(null);
}
//reader.Close();
conexion.Close();
return(request);
}
catch (Exception ex)
{
return(null);
}
}
//
public List <RequestAdministrator> GetAllRequestHistoria(string NoIssste)
{
List <RequestAdministrator> lstRequests = new List <RequestAdministrator>();
//var conexion = con.obtenConexion();
//SqlCommand command = new SqlCommand("sp_getAllRequestHistory", conexion);
//command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("@NoIssste", SqlDbType.VarChar).Value = NoIssste;
string query = "exec sp_getAllRequestHistory @NoIssste='" + NoIssste + "'";
ds = con.obtenConsulta(query);
try
{
//conexion.Open();
//SqlDataReader reader = command.ExecuteReader();
foreach (DataRow dr in ds.Tables[0].Rows)
{
RequestAdministrator lector = new RequestAdministrator();
lector.RequestId = Guid.Parse(dr["RequestId"].ToString());
lector.Folio = dr["Folio"].ToString();
lector.CURP = dr["CURP"].ToString();
lector.NoISSSTE = dr["NoISSSTE"].ToString();
lector.Name = dr["Name"].ToString();
lector.Estatus = dr["estatus"].ToString();
lector.Date = dr["Date"].ToString();
lector.StatusId = Convert.ToInt32(dr["StatusId"].ToString());
lstRequests.Add(lector);
}
return(lstRequests);
}
catch (Exception ex)
{
return(null);
}
}
public async Task <IActionResult> RegisterResident([FromHeader] string Authotization, [FromBody] RequestAdministrator request)
{
try
{
var user = new User()
{
Name = request.Name,
LastName = request.LastName,
Email = request.Email,
Password = request.Password,
BirthDate = request.BirthDate,
Gender = request.Gender,
Phone = request.Phone,
Token = Guid.NewGuid().ToString().Replace("-", ""),
};
var userSaved = await _userService.Insert(user);
var admin = new Administrator()
{
PlanActivated = true,
IsBlocked = false,
UserId = userSaved.UserId
};
var adminSaved = await _administratorService.Insert(admin);
adminSaved.User = userSaved;
OkResponse(adminSaved);
return(new ObjectResult(response));
}
catch (Exception e)
{
InternalServerErrorResponse(e.Message);
return(new ObjectResult(response));
}
}
