public List <vPersonnalViewModel> viewPersonnalList()
{
//Mapping
using (var entity = new HimalDbEntities())
{
var ListModel = new List <vPersonnalViewModel>();
var collection = from v in entity.vPersonnels
select v;
foreach (var item in collection)
{
var model = new vPersonnalViewModel();
model.ProfileID = item.ProfileID;
model.DOB = item.DOB;
model.DODID = item.DODID;
model.eligibility = item.eligibility;
model.EligibilityDate = item.EligibilityDate;
model.FirstName = item.FirstName;
model.InvestigationType = item.InvestigationType;
model.LastName = item.LastName;
model.NDA = item.NDA;
model.NonSCIAccesses = item.NonSCIAccesses;
model.PersonalCategory = item.PersonalCategory;
model.POB = item.POB;
model.PositionSensitivity = item.PositionSensitivity;
model.PrevInvestigationCloseDate = item.PrevInvestigationCloseDate;
model.SMORelationship = item.SMORelationship;
model.MiddleName = item.MiddleName;
ListModel.Add(model);
}
//var viewData = entity.vPersonnels;
// ListModel = new List<vPersonnalViewModel>();
//foreach (var item in ListModel)
//{
// var model = new vPersonnalViewModel();
// model.ProfileID = item.ProfileID;
// model.DOB = item.DOB;
// model.DODID = item.DODID;
// model.eligibility = item.eligibility;
// model.EligibilityDate = item.EligibilityDate;
// model.FirstName = item.FirstName;
// model.InvestigationType = item.InvestigationType;
// model.LastName = item.LastName;
// model.NDA = item.NDA;
// model.NonSCIAccesses = item.NonSCIAccesses;
// model.PersonalCategory = item.PersonalCategory;
// model.POB = item.POB;
// model.PositionSensitivity = item.PositionSensitivity;
// model.PrevInvestigationCloseDate = item.PrevInvestigationCloseDate;
// model.SMORelationship = item.SMORelationship;
// model.MiddleName = item.MiddleName;
// ListModel.Add(model);
//}
return(ListModel);
}
}
public List <PersonnalViewModel> List(string searchText)
{
var splitSearch = searchText.Split(' ');
var searchValue = "";
if (splitSearch.Count() < 1)
{
searchValue = searchText;
}
else
{
searchValue = String.Join(" ", splitSearch);
}
using (var entity = new HimalDbEntities())
{
//int dodId = 0;
// bool checkInt = int.TryParse(searchValue, out var n); // check searchText is integer or not, it returns true or false boolean value.
var personnalList = entity.Personnels.ToList();
var ListModel = new List <PersonnalViewModel>();
//if (checkInt) // check searchtext is integer
//{
// dodId = Convert.ToInt32(searchValue); // if searchtext is integer then change searchText to int data type
// personnalList = personnalList.Where(x => x.DODID == dodId).ToList(); // filter according to DIDId
//}
// else
// {
if (splitSearch.Count() > 1)
{
personnalList = personnalList.Where(x => x.FIRSTNAME.ToUpper() == splitSearch[0].ToUpper() && x.LASTNAME.ToUpper().Contains(splitSearch[1].ToUpper())).ToList();
}
else
{
personnalList = personnalList.Where(x => x.FIRSTNAME.ToUpper().Contains(searchValue.ToUpper()) || x.LASTNAME.ToUpper().Contains(searchValue.ToUpper())).ToList(); // filter according to firstname or last name
}
// }
foreach (var item in personnalList)
{
var model = new PersonnalViewModel();
model.ID = item.ID;
model.FIRSTNAME = item.FIRSTNAME;
model.LASTNAME = item.LASTNAME;
model.EMAIL = item.EMAIL;
model.DODID = item.DODID;
model.DATEOFBIRTH = item.DATEOFBIRTH;
model.GENDER = item.GENDER;
ListModel.Add(model);
}
return(ListModel);
}
}
public void Update(PersonnalViewModel model)
{
using (var entity = new HimalDbEntities())
{
var editData = entity.Personnels.Where(x => x.DODID == model.DODID).FirstOrDefault();
editData.FIRSTNAME = model.FIRSTNAME;
editData.LASTNAME = model.LASTNAME;
editData.DATEOFBIRTH = model.DATEOFBIRTH;
editData.DODID = model.DODID;
editData.EMAIL = model.EMAIL;
editData.GENDER = model.GENDER;
entity.Entry(editData).State = EntityState.Modified;
entity.SaveChanges();
}
}
public void Insert(PersonnalViewModel model)
{
using (var entity = new HimalDbEntities())
{
var tableRow = new Personnel();
tableRow.FIRSTNAME = model.FIRSTNAME;
tableRow.LASTNAME = model.LASTNAME;
tableRow.DODID = model.DODID;
tableRow.GENDER = model.GENDER;
tableRow.EMAIL = model.EMAIL;
tableRow.DATEOFBIRTH = model.DATEOFBIRTH;
tableRow.PLACEOFBIRTH = model.PLACEOFBIRTH;
entity.Personnels.Add(tableRow);
entity.SaveChanges();
}
}
public PersonnalViewModel GetDetailById(int id)
{
using (var entity = new HimalDbEntities())
{
var personnalValue = entity.Personnels.Where(x => x.ID == id).FirstOrDefault();
var model = new PersonnalViewModel();
if (personnalValue != null)
{
model.ID = personnalValue.ID;
model.LASTNAME = personnalValue.LASTNAME;
model.PLACEOFBIRTH = personnalValue.PLACEOFBIRTH;
model.FIRSTNAME = personnalValue.FIRSTNAME;
model.GENDER = personnalValue.GENDER;
model.DATEOFBIRTH = personnalValue.DATEOFBIRTH;
model.DODID = personnalValue.DODID;
}
return(model);
}
}
