public ActionResult Search(string searchRecord)
{
SearchModel sm = new SearchModel(searchRecord);
if (sm.isValid)
{
switch (sm.searchType)
{
case SearchType.RecordNumber:
using (TipstaffDB db = new TipstaffDB())
{
var tipstaffRecord = db.TipstaffRecord.Find(sm.search);
if (tipstaffRecord != null)
{
return(RedirectToAction("Details", sm.RecordType, new { id = sm.tipstaffRecord.tipstaffRecordID }));
}
else
{
return(View(sm));
}
}
case SearchType.Name:
return(View(sm));
case SearchType.DateOfBirth:
return(View(sm));
default:
break;
}
}
return(View(sm));
}
public static string TypeOfTipstaffRecord(int id)
{
using (TipstaffDB tempDB = new TipstaffDB())
{
TipstaffRecord obj = tempDB.TipstaffRecord.Find(id);
return(isTipstaffRecordChildAbduction(obj) ? "ChildAbduction" : "Warrant");
}
}
public static List <SearchResultRow> getMatches(int month, int day)
{
TipstaffDB db = myDBContextHelper.CurrentContext;
try
{
List <SearchResultRow> Results = new List <SearchResultRow>();
var kids = db.Children.Where(f => ((DateTime)f.dateOfBirth).Month == month || ((DateTime)f.dateOfBirth).Day == day);
if (kids != null)
{
foreach (Child child in kids)
{
Results.Add(new SearchResultRow
{
name = child.fullname,
partyID = child.childID,
tipstaffRecordID = child.tipstaffRecordID,
DateOfBirth = (DateTime)child.dateOfBirth,
PartyType = "Child",
tipstaffRecordType = "ChildAbduction",
tipstaffUniqueRecordID = child.childAbduction.UniqueRecordID
});
}
}
var Resps = db.Respondents.Where(f => ((DateTime)f.dateOfBirth).Month == month || ((DateTime)f.dateOfBirth).Day == day);
if (Resps != null)
{
foreach (Respondent resp in Resps)
{
Results.Add(new SearchResultRow
{
name = resp.fullname,
partyID = resp.respondentID,
tipstaffRecordID = resp.tipstaffRecordID,
DateOfBirth = (DateTime)resp.dateOfBirth,
PartyType = "Respondent",
tipstaffRecordType = genericFunctions.TypeOfTipstaffRecord(resp.tipstaffRecordID),
tipstaffUniqueRecordID = resp.tipstaffRecord.UniqueRecordID
});
}
}
return(Results);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.Message);
return(null);
}
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
_isAuthorized = false;
UserAccessLevel = AccessLevel.Denied;
//check groups (strart with them for a bigger group target!)
using (TipstaffDB db = new TipstaffDB())
{
UserAccessLevel = (AccessLevel)db.UserAccessLevel(httpContext.User);
}
_isAuthorized = (UserAccessLevel > AccessLevel.Denied && UserAccessLevel >= MinimumRequiredAccessLevel);
IIdentity user = httpContext.User.Identity;
CPrincipal cPrincipal = new CPrincipal(user);
httpContext.User = cPrincipal;
return(_isAuthorized);
}
public static List <SearchResultRow> getMatches(DateTime DoB)
{
TipstaffDB db = myDBContextHelper.CurrentContext;
try
{
List <SearchResultRow> Results = new List <SearchResultRow>();
var kids = db.Children.Where(f => f.dateOfBirth == DoB);
if (kids != null)
{
foreach (Child child in kids)
{
string uniqID = "";
using (TipstaffDB tempDB = new TipstaffDB())
{
TipstaffRecord TR = tempDB.TipstaffRecord.Find(child.tipstaffRecordID);
uniqID = TR.UniqueRecordID;
};
Results.Add(new SearchResultRow
{
name = child.fullname,
partyID = child.childID,
tipstaffRecordID = child.tipstaffRecordID,
DateOfBirth = (DateTime)child.dateOfBirth,
PartyType = "Child",
tipstaffRecordType = "ChildAbduction",
tipstaffUniqueRecordID = uniqID
});
}
}
var Resps = db.Respondents.Where(f => f.dateOfBirth == DoB);
if (Resps != null)
{
foreach (Respondent resp in Resps)
{
string uniqID = "";
using (TipstaffDB tempDB = new TipstaffDB())
{
TipstaffRecord TR = tempDB.TipstaffRecord.Find(resp.tipstaffRecordID);
uniqID = TR.UniqueRecordID;
};
Results.Add(new SearchResultRow
{
name = resp.fullname,
partyID = resp.respondentID,
tipstaffRecordID = resp.tipstaffRecordID,
DateOfBirth = (DateTime)resp.dateOfBirth,
PartyType = "Respondent",
tipstaffRecordType = genericFunctions.TypeOfTipstaffRecord(resp.tipstaffRecordID),
tipstaffUniqueRecordID = uniqID
});
}
}
return(Results);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.Message);
return(null);
}
}
public static List <SearchResultRow> getMatches(string Name)
{
TipstaffDB db = myDBContextHelper.CurrentContext;
string lowerName = Name.ToLower();
try
{
List <SearchResultRow> Results = new List <SearchResultRow>();
var kids = db.Children.Where(f => f.nameFirst.ToLower().Contains(lowerName) || f.nameMiddle.ToLower().Contains(lowerName) || f.nameLast.ToLower().Contains(lowerName));
if (kids != null)
{
foreach (Child child in kids)
{
string uniqID = "";
using (TipstaffDB tempDB = new TipstaffDB())
{
TipstaffRecord TR = tempDB.TipstaffRecord.Find(child.tipstaffRecordID);
uniqID = TR.UniqueRecordID;
};
Results.Add(new SearchResultRow
{
name = child.fullname,
partyID = child.childID,
tipstaffRecordID = child.tipstaffRecordID,
DateOfBirth = child.dateOfBirth,
PartyType = "Child",
tipstaffRecordType = "ChildAbduction",
tipstaffUniqueRecordID = uniqID
});
}
}
var Resps = db.Respondents.Where(f => f.nameFirst.ToLower().Contains(lowerName) || f.nameMiddle.ToLower().Contains(lowerName) || f.nameLast.ToLower().Contains(lowerName));
System.Diagnostics.Debug.Print(Resps.Count().ToString());
if (Resps != null)
{
foreach (Respondent resp in Resps)
{
string typePart2 = "";
string uniqID = "";
using (TipstaffDB tempDB = new TipstaffDB())
{
if (genericFunctions.TypeOfTipstaffRecord(resp.tipstaffRecordID) == "Warrant")
{
Warrant temp = tempDB.Warrants.Find(resp.tipstaffRecordID);
typePart2 = string.Format(" ({0})", temp.division.Detail);
}
TipstaffRecord TR = tempDB.TipstaffRecord.Find(resp.tipstaffRecordID);
uniqID = TR.UniqueRecordID;
};
Results.Add(new SearchResultRow
{
name = resp.fullname,
partyID = resp.respondentID,
tipstaffRecordID = resp.tipstaffRecordID,
DateOfBirth = resp.dateOfBirth,
PartyType = "Respondent",
tipstaffRecordType = string.Format("{0}{1}", genericFunctions.TypeOfTipstaffRecord(resp.tipstaffRecordID)
, typePart2),
tipstaffUniqueRecordID = uniqID
});
}
}
return(Results);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.Message);
//return null;
throw new NotUploaded(ex.Message);
}
}
public CPrincipal(IIdentity identity, TipstaffDB rep)
{
db = rep;
this.Identity = identity;
}
public CPrincipal(TipstaffDB repository)
{
db = repository;
}
public UsersController(TipstaffDB repository)
{
db = repository;
}
