//When Search using the NIC of the victim
public DataTable VictimNicSearchVictimDetails(VictimModel victim_nic)
{
try
{
SqlCommand command = new SqlCommand();
command.Connection = connection.GetConnection();
connection.OpenConnection();
command.CommandText = "SELECT * FROM [victim] WHERE NIC = '" + victim_nic.Nic + "'";
DataTable datatable = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(datatable);
connection.CloseConnection();
return(datatable);
}
catch (Exception exception)
{
throw exception;
}
}
public DataTable VictimNicSearchEntryDetails(VictimModel victim_nic)
{
try
{
SqlCommand command = new SqlCommand();
command.Connection = connection.GetConnection();
connection.OpenConnection();
command.CommandText = "SELECT Entry.Entry_id , Entry.Entry_type , Entry.Entry_Added_Date , Entry_Description.Date_of_Incident , Entry_Description.Incident_type , Entry_Description.Vehicle_No , Entry_Description.Deaths , Entry_Description.Injuries " +
"FROM [Entry] , [Entry_Description] , Victim WHERE victim.victim_ID = Entry.victim_id AND Entry.entry_id = Entry_Description.entry_id AND victim.NIC = '" + victim_nic.Nic + "'";
DataTable datatable = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(datatable);
connection.CloseConnection();
return(datatable);
}
catch (Exception exception)
{
throw exception;
}
}
public IdentityResult Register(AccountModel model)
{
var userStore = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(userStore);
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
user.FirstName = model.FirstName;
user.LastName = model.LastName;
user.PhoneNumber = model.PhoneNumber;
user.RegisteredDate = DateTime.Now;
IdentityResult result = userManager.Create(user, model.Password);
if (result.Succeeded)
{
userManager.AddToRole(user.Id, "Victim");
}
var data = new VictimModel();
var v = _victim.InsertVictim(data, user.Id);
return(result);
}
//Method for access the database to search user records
////// USING USER FULL NAME
public DataTable VictimFullNameSearch(VictimModel victim_fullname)
{
try
{
SqlCommand command = new SqlCommand();
command.Connection = connection.GetConnection();
connection.OpenConnection();
command.CommandText = "SELECT * FROM [Entry] WHERE Full_Name IN (SELECT Full_Name FROM Victim WHERE Full_Name LIKE '" + "%" + victim_fullname.FullName + "%" + "')";
DataTable datatable = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(datatable);
connection.CloseConnection();
return(datatable);
}
catch (Exception exception)
{
throw exception;
}
}
public HttpResponseMessage AddVictimProfile(VictimModel entity)
{
var user = HttpContext.Current.User.Identity as ClaimsIdentity;
var userId = user.FindFirst("UserId").Value;
var city = _victim.InsertVictim(entity, userId);
if (city > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, city));
}
return(Request.CreateResponse(HttpStatusCode.NotFound, city));
}
public int InsertVictim(VictimModel insertData, string userId)
{
using (var scope = new TransactionScope())
{
var percentProfile = 0;
if (insertData.Street != null && insertData.CityId != null &&
insertData.IncidentType != null && insertData.HomeAddress != null &&
insertData.IncidentDescription != null)
{
percentProfile = 100;
}
else
{
percentProfile = 20;
}
var victim = _unitOfWork.victimRepository.Get(c => c.VictimStatus == true && c.UserId == userId);
if (victim != null)
{
victim.UserId = userId;
victim.Street = insertData.Street;
victim.CityId = insertData.CityId;
victim.IncidentType = insertData.IncidentType;
victim.IncidentDate = insertData.IncidentDate;
victim.HomeAddress = insertData.HomeAddress;
victim.IncidentDescription = insertData.IncidentDescription;
victim.CreatedDate = DateTime.Now;
victim.VictimStatus = true;
victim.percentageProfile = percentProfile;
_unitOfWork.victimRepository.Update(victim);
_unitOfWork.Save();
scope.Complete();
return(victim.VictimId);
}
else
{
var city = _unitOfWork.CityRepository.GetFirst(c => c.CityStatus == true && c.CityId > 0).CityId;
var victimm = new Victim()
{
UserId = userId,
CityId = city,
CreatedDate = DateTime.Now,
VictimStatus = true,
percentageProfile = percentProfile,
};
_unitOfWork.victimRepository.Insert(victimm);
_unitOfWork.Save();
scope.Complete();
return(victimm.VictimId);
}
}
}
public bool Confirm()
{
try
{
if (EventSituation == null)
{
ShowMessage("Selecione a situação");
}
else
{
DispositionCodeModel dispositionCode = GetDispositionCode();
if (dispositionCode != null && !string.IsNullOrEmpty(dispositionCode.Id))
{
if (!IsSubmitted)
{
if (EventSituation == EventSituationEnum.NotFound)
{
VictimData = new VictimModel();
}
else
{
if (AsExpected == false)
{
if (string.IsNullOrEmpty(VictimData.SituationFound.Key))
{
ShowMessage("Favor selecionar a situação encontrada.");
return(false);
}
}
else
{
VictimData.SituationFound = new KeyValuePair <string, string>();
}
}
SubmissionBusiness.ExecuteCadUpdates(UnitId, AgencyEventId, EventSituation.Value, dispositionCode, Remarks, SelectedHospital, VictimData);
}
else
{
if (string.IsNullOrEmpty(VictimData.Name.Trim()))
{
ShowMessage("Favor inserir o nome da vítima.");
return(false);
}
if (VictimData.Age != null)
{
if (VictimData.AgeType == null || VictimData.AgeType == 0)
{
ShowMessage("Favor selecionar um tipo de idade válido para a vítima.");
return(false);
}
}
if (VictimData.AgeType != null && VictimData.AgeType.Value > 0)
{
if (VictimData.Age == null)
{
ShowMessage("Favor informar uma idade válida para a vítima.");
return(false);
}
}
if (AsExpected == false)
{
if (string.IsNullOrEmpty(VictimData.SituationFound.Key))
{
ShowMessage("Favor selecionar a situação encontrada.");
return(false);
}
}
else
{
VictimData.SituationFound = new KeyValuePair <string, string>();
}
string selectedHospitalName = SelectedHospital != null ? SelectedHospital.Name : string.Empty;
SubmissionBusiness.ExecuteCadEndUpdates(UnitId, AgencyEventId, EventSituation.Value, dispositionCode, Remarks, selectedHospitalName, HospitalHasChanged, VictimData, IsRetainedStretcherSituation);
}
SubmissionBusiness.SaveSubmission(UnitId, AgencyEventId, dispositionCode, AsExpected, SelectedHospital, Remarks, VictimData);
if (!HasNotRetainedStretcher && !IsRetainedStretcherSituation)
{
UserModel currentUser = PersonBusiness.GetCurrentUser();
RetainedStretcherBusiness.ComeBackUnitStatusToRetainedStretcher(UnitId, currentUser);
}
return(true);
}
}
}
catch (Exception ex)
{
logger.Error("Add/In.: Falha na finalização, Submission.", ex);
ShowMessage("Falha ao realizar solicitação.");
}
return(false);
}
