public List <MissingModel> GetAllMissingModels(MissingModel model)
{
var mmList = new List <MissingModel>();
using (var db = new practiceEntities())
{
var missingList = db.Missings
.Include(x => x.Office)
.Include(x => x.User)
.Where(x => x.VerifyStatus == "V")
.OrderByDescending(x => x.verifydate)
.ToList();
var missingModelList = Mapper.MissingMapper.MissingListToMissingModelList(missingList);
mmList.AddRange(missingModelList);
foreach (var missingModel in mmList)
{
missingModel.PDistrictName = missingModel.PDistrictId != null?
db.Districts.SingleOrDefault(x => x.Id == missingModel.PDistrictId)?.DistrictNameEng : "";
missingModel.MDistrictName = missingModel.MDistrictId != null?
db.Districts.SingleOrDefault(x => x.Id == missingModel.MDistrictId)?.DistrictNameEng : "";
missingModel.PMunicipalityName = missingModel.PMunicipalityId != null?
db.Municipalities.SingleOrDefault(x => x.Id == missingModel.PMunicipalityId)?.MunicipalityName : "";
missingModel.MMunicipalityName = missingModel.MMunicipalityId != null?
db.Municipalities.SingleOrDefault(x => x.Id == missingModel.MMunicipalityId)?.MunicipalityName : "";
}
return(missingModelList);
}
}
public void Update(MissingModel model)
{
var missingOld = unitOfWork.MissingRepository.GetById(model.Id);
var missingNew = Mapper.MissingMapper.MissingModelToMissing(model);
unitOfWork.MissingRepository.Update(missingOld, missingNew);
}
public byte[] GetPhoto(HttpPostedFileBase File, MissingModel model, IEnumerable <HttpPostedFileBase> Files)
{
var photo = new byte[File.ContentLength];
File.InputStream.Read(photo, 0, File.ContentLength);
return(photo);
}
public IHttpActionResult PutMissing(MissingModel missingModel, Guid missingTypeId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var missingExist = db.Missings.FirstOrDefault(w => w.Id == missingModel.Id);
if (missingExist != null)
{
missingExist.MissingFrom = Common.CreatePoint(missingModel.Latitude, missingModel.Longitude);
missingExist.Description = missingModel.Description;
missingExist.Name = missingModel.Name;
db.SaveChanges();
}
else
{
var missing = new Missing();
missing.Id = Guid.NewGuid();
missing.IsActive = true;
missing.MissingTypeId = missingTypeId;
missing.CreatedDate = DateTime.UtcNow;
missing.MissingFrom = Common.CreatePoint(missingModel.Latitude, missingModel.Longitude);
missing.Description = missingModel.Description;
missing.Name = missingModel.Name;
missing.OrgUserId = Guid.Parse("5F6C19ED-2B71-4F8B-8E45-77372C4DA40A");
missing.Contact = missingModel.Contact;
db.Missings.Add(missing);
db.SaveChanges();
Common.Push(missingModel.Longitude, missingModel.Latitude, 10000, missingModel.Name + " is missing! Have you seen this person?", missing.Id, 3);
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IEnumerable <MissingModel> MissingMatches(MissingModel model)
{
var missingModelList = new List <MissingModel>();
using (var context = new practiceEntities())
{
missingModelList = context.spMissingMatches(model.Fname, model.Lname, model.Alias, model.DOB, model.Gender, model.FatherName, model.MotherName)
.Select(x => new MissingModel
{
Id = x.Id,
Fname = x.Fname,
Lname = x.Lname,
Photo = x.Photo,
ComplainByName = x.ComplainByName,
ComplainDate = x.ComplainDate,
EnteredDate = x.EnteredDate,
OfficeName = x.OfficeName
})
.ToList();
}
return(missingModelList);
}
public MissingModel GetOneMissingModel(object id)
{
using (practiceEntities db = new practiceEntities())
{
MissingModel missingModel = null;
try
{
var Id = Convert.ToInt32(id);
var missing = db.Missings
.Include(x => x.Religion)
.Include(x => x.country)
.Include(x => x.EducationLevel)
.Include(x => x.Colour)
.Include(x => x.Office)
.Include(x => x.IdType)
.Include(x => x.User)
.SingleOrDefault(x => x.Id == Id);
missingModel = Mapper.MissingMapper.MissingToMissingModel(missing);
if (missing != null)
{
missingModel.Verifier = unitOfWork.UserRepository
.Get(x => x.UserId == missing.UserId)
.SingleOrDefault()
.Username;
missingModel.HairColor = unitOfWork.ColourRepository
.Get(x => x.id == missing.HairColorId)
.SingleOrDefault()
.ColourName;
missingModel.EyeColor = unitOfWork.ColourRepository
.Get(x => x.id == missing.EyeColorId)
.SingleOrDefault()
.ColourName;
missingModel.PMunicipalityName = unitOfWork.MunicipalityRepository
.Get(x => x.Id == missing.PMunicipalityId)
.SingleOrDefault()
.MunicipalityName;
missingModel.TMunicipalityName = unitOfWork.MunicipalityRepository
.Get(x => x.Id == missing.TMunicipalityId)
.SingleOrDefault()
.MunicipalityName;
missingModel.MMunicipalityName = unitOfWork.MunicipalityRepository
.Get(x => x.Id == missing.MMunicipalityId)
.SingleOrDefault()
.MunicipalityName;
missingModel.PState = unitOfWork.StateRepository
.Get(x => x.StateId == missing.PStateId)
.SingleOrDefault()
.StateName;
missingModel.TState = unitOfWork.StateRepository
.Get(x => x.StateId == missing.TStateId)
.SingleOrDefault()
.StateName;
missingModel.MState = unitOfWork.StateRepository
.Get(x => x.StateId == missing.MStateId)
.SingleOrDefault()
.StateName;
missingModel.TDistrictName = unitOfWork.DistrictRepository
.Get(x => x.Id == missing.TDistrictId)
.SingleOrDefault()
.DistrictNameEng;
missingModel.MDistrictName = unitOfWork.DistrictRepository
.Get(x => x.Id == missing.MDistrictId)
.SingleOrDefault()
.DistrictNameEng;
missingModel.PDistrictName = unitOfWork.DistrictRepository
.Get(x => x.Id == missing.PDistrictId)
.SingleOrDefault()
.DistrictNameEng;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(missingModel);
}
}
public Missing AddMissing(MissingModel model)
{
var missing = Mapper.MissingMapper.MissingModelToMissing(model);
return(unitOfWork.MissingRepository.Create(missing));
}
public void Add(MissingModel model)
{
var missing = Mapper.MissingMapper.MissingModelToMissing(model);
unitOfWork.MissingRepository.Create(missing);
}
public static Missing MissingModelToMissing(MissingModel model)
{
var missing = new Missing
{
Id = model.Id,
OfficeId = model.OfficeId,
UserId = model.UserId,
FiscalYearId = model.FiscalYearId,
RegistrationNumber = model.RegistrationNumber,
VerifyUserId = model.VerifyUserId,
VerifyStatus = model.VerifyStatus,
verifydate = model.verifydate,
VerifyMessage = model.VerifyMessage,
EnteredDate = model.EnteredDate,
Fname = model.Fname,
Lname = model.Lname,
Alias = model.Alias,
MaritialStatus = model.MaritialStatus,
EthnicityId = model.EthnicityId,
Gender = model.Gender,
PersonType = model.PersonType,
FatherName = model.FatherName,
MotherName = model.MotherName,
SpouseName = model.SpouseName,
NationalityId = model.NationalityId,
SpecialIdentifier = model.SpecialIdentifier,
IdTypeId = model.IdTypeId,
IdTypeNumber = model.IdTypeNumber,
ReligionId = model.ReligionId,
Occupation = model.Occupation,
EducationLevelId = model.EducationLevelId,
DOB = model.DOB,
EstimatedAge = model.EstimatedAge,
Hieght = model.Hieght,
Weight = model.Weight,
HeightUnit = model.HeightUnit,
ClothesWorn = model.ClothesWorn,
EyeColorId = model.EyeColorId,
HairColorId = model.HairColorId,
Build = model.Build,
Language = model.Language,
TStateId = model.TStateId,
TDistrictId = model.TDistrictId,
TMunicipalityId = model.TMunicipalityId,
TWardNumber = model.TWardNumber,
TToleName = model.TToleName,
TContactNumber = model.TContactNumber,
PStateId = model.PStateId,
PDistrictId = model.PDistrictId,
PMunicipalityId = model.PMunicipalityId,
PWardNumber = model.PWardNumber,
PContactNumber = model.PContactNumber,
PToleName = model.PToleName,
LastSeenDate = model.LastSeenDate,
LastSeenTime = model.LastSeenTime,
LastSeenPlace = model.LastSeenPlace,
MStateId = model.MStateId,
MDistrictId = model.MDistrictId,
MMunicipalityId = model.MMunicipalityId,
MWardNumber = model.MWardNumber,
MToleName = model.MToleName,
ComplainByName = model.ComplainByName,
ComplainDate = model.ComplainDate,
ComplainContactNumber = model.ComplainContactNumber,
Remarks = model.Remarks,
Photo = model.Photo,
PossiblePlaces = model.PossiblePlaces,
MissingStatus = model.MissingStatus,
DateOfFound = model.DateOfFound,
FoundAddress = model.FoundAddress,
LiveStatus = model.LiveStatus,
FoundRemarks = model.FoundRemarks,
FoundByOfficeId = model.FoundByOfficeId,
LastSearchActivityDate = model.LastSearchActivityDate,
RelationWithVictim = model.RelationWithVictim,
MissingReason = model.MissingReason,
HandOverTo = model.HandOverTo,
HandOverDetails = model.HandOverDetails,
HandOverDate = model.HandOverDate,
HandOverRelation = model.HandOverRelation,
HandOverContactNumber = model.HandOverContactNumber
};
return(missing);
}
public static MissingModel MissingToMissingModel(Missing model)
{
var missingModel = new MissingModel
{
Id = model.Id,
OfficeId = model.OfficeId,
UserId = model.UserId,
User = new UserModel
{
Username = model.User != null ? model.User.Username : ""
},
FiscalYearId = model.FiscalYearId,
RegistrationNumber = model.RegistrationNumber,
VerifyUserId = model.VerifyUserId,
VerifyStatus = model.VerifyStatus,
verifydate = model.verifydate,
VerifyMessage = model.VerifyMessage,
EnteredDate = model.EnteredDate,
Fname = model.Fname,
Lname = model.Lname,
Alias = model.Alias,
MaritialStatus = model.MaritialStatus,
EthnicityId = model.EthnicityId,
Gender = model.Gender,
PersonType = model.PersonType,
FatherName = model.FatherName,
MotherName = model.MotherName,
SpouseName = model.SpouseName,
NationalityId = model.NationalityId,
SpecialIdentifier = model.SpecialIdentifier,
IdTypeId = model.IdTypeId,
IdTypeNumber = model.IdTypeNumber,
ReligionId = model.ReligionId,
Occupation = model.Occupation,
EducationLevelId = model.EducationLevelId,
DOB = model.DOB,
EstimatedAge = model.EstimatedAge,
Hieght = model.Hieght,
Weight = model.Weight,
HeightUnit = model.HeightUnit,
ClothesWorn = model.ClothesWorn,
EyeColorId = model.EyeColorId,
HairColorId = model.HairColorId,
Build = model.Build,
Language = model.Language,
Hair = model.Hair,
TStateId = model.TStateId,
TDistrictId = model.TDistrictId,
TMunicipalityId = model.TMunicipalityId,
TWardNumber = model.TWardNumber,
TToleName = model.TToleName,
TContactNumber = model.TContactNumber,
PStateId = model.PStateId,
PDistrictId = model.PDistrictId,
PMunicipalityId = model.PMunicipalityId,
PWardNumber = model.PWardNumber,
PContactNumber = model.PContactNumber,
PToleName = model.PToleName,
LastSeenDate = model.LastSeenDate,
LastSeenTime = model.LastSeenTime,
LastSeenPlace = model.LastSeenPlace,
MStateId = model.MStateId,
MDistrictId = model.MDistrictId,
MMunicipalityId = model.MMunicipalityId,
MWardNumber = model.MWardNumber,
MToleName = model.MToleName,
ComplainByName = model.ComplainByName,
ComplainDate = model.ComplainDate,
ComplainContactNumber = model.ComplainContactNumber,
Remarks = model.Remarks,
Photo = model.Photo,
PossiblePlaces = model.PossiblePlaces,
MissingStatus = model.MissingStatus,
DateOfFound = model.DateOfFound,
FoundAddress = model.FoundAddress,
LiveStatus = model.LiveStatus,
FoundRemarks = model.FoundRemarks,
FoundByOfficeId = model.FoundByOfficeId,
LastSearchActivityDate = model.LastSearchActivityDate,
RelationWithVictim = model.RelationWithVictim,
MissingReason = model.MissingReason,
HandOverTo = model.HandOverTo,
HandOverDetails = model.HandOverDetails,
HandOverDate = model.HandOverDate,
HandOverRelation = model.HandOverRelation,
HandOverContactNumber = model.HandOverContactNumber,
Ethnicity = new EthnicityModel
{
EthnicityName = model.Ethnicity != null ? model.Ethnicity.EthnicityName : ""
},
Office = new OfficeModel
{
OfficeName = model.Office != null ? model.Office.OfficeName : ""
},
country = new CountryModel
{
Id = model.country?.Id ?? 0,
CountryName = model.country != null ? model.country.CountryName : "",
CountryCode = model.country != null ? model.country.CountryCode : "",
Nationality = model.country != null ? model.country.Nationality : ""
},
Religion = new ReligionModel
{
Id = model.Religion?.Id ?? 0,
ReligionName = model.Religion != null ? model.Religion.ReligionName : ""
},
EducationLevel = new EducationLevelModel
{
Id = model.EducationLevel?.Id ?? 0,
LevelName = model.EducationLevel != null ? model.EducationLevel.LevelName : ""
},
Colour = new ColourModel
{
id = model.Colour?.id ?? 0,
ColourName = model.Colour != null ? model.Colour.ColourName : "",
},
Municipality = new MunicipalityModel
{
Id = model.Municipality?.Id ?? 0,
MunicipalityName = model.Municipality != null ? model.Municipality.MunicipalityName : "",
MuniTypeId = model.Municipality != null ? model.Municipality.MuniTypeId : 0,
MunType = new MuncipalityTypeModel
{
MuniType = model.Municipality != null ? model.Municipality.MunicipalityType.MuniType : "",
},
District = new DistrictModel
{
DistrictCode = model.Municipality != null?Convert.ToInt32(model.Municipality.District?.DistrictCode) : 0,
DistrictNameEng = model.Municipality != null ? model.Municipality.District.DistrictNameEng : "",
State = new StateModel
{
StateName = model.Municipality != null ? model.Municipality.District.State.StateName : ""
}
}
}
};
return(missingModel);
}
