public CYCAAdmissionBodilySearchPartiallViewModel GetIllegalItemByIllegalItemId(int Item_Found_Id)
{
CYCAAdmissionBodilySearchPartiallViewModel vm = new CYCAAdmissionBodilySearchPartiallViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
CYCA_Admissions_IllegalItemsFound act = db.CYCA_Admissions_IllegalItemsFound.Find(Item_Found_Id);
if (act != null)
{
vm.Item_Found_Id = Item_Found_Id;
vm.Admission_Id = Convert.ToInt16(act.Admission_Id);
vm.Quantity = act.Quantity;
vm.Handed_By = act.Handed_By;
vm.Document_Type_Id = act.Document_Type_Id;
vm.Description = act.Description;
}
//CYCA_BodilySearch_Document bsd = db.CYCA_BodilySearch_Document.Find(BodySearchId);
//var docL = db.CYCA_BodilySearch_Document.ToList();
//if (bsd != null)
//{
// foreach (var item in docL)
// {
// vm.BodySearchId = BodySearchId;
// vm.DocumentId = bsd.Document_Id;
// vm.DocumentName = bsd.Document_Name;
// }
//}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
return(vm);
}
public CYCAAdmissionBodilySearchPartiallViewModel GetBodySearchByBodySearchId(int BodySearchId)
{
CYCAAdmissionBodilySearchPartiallViewModel vm = new CYCAAdmissionBodilySearchPartiallViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
CYCA_BodilySearch act = db.CYCA_BodilySearch.Find(BodySearchId);
if (act != null)
{
vm.BodySearchId = BodySearchId;
vm.Admission_Id = Convert.ToInt16(act.Admission_Id);
vm.BodySearchDate = act.Bodily_Search_Date.ToString();
vm.Search_Reason_Id = act.Search_Reason_Id;
vm.ReasonForSearch = db.apl_Cyca_Bodily_Search_Reasons.Find(act.Search_Reason_Id).Description;
vm.Conducted_By = act.Conducted_By;
vm.ConductedBy = db.Users.Find(act.Conducted_By).First_Name + " " + db.Users.Find(act.Conducted_By).Last_Name;
vm.Witnessed_By = act.Witnessed_By;
vm.WitnessedBy = db.Users.Find(act.Witnessed_By).First_Name + " " + db.Users.Find(act.Witnessed_By).Last_Name;
vm.Document_Type_Id = act.Document_Type_Id;
vm.Description = act.Description;
vm.saveBodySearchId = BodySearchId;
}
CYCA_BodilySearch_Document bsd = db.CYCA_BodilySearch_Document.Find(BodySearchId);
var bs = db.CYCA_BodilySearch_Document.Find(BodySearchId);
var docL = db.CYCA_BodilySearch_Document.ToList();
//if (bsd != null)
//{
foreach (var item in docL)
{
if (item.Bodily_Search_Id == BodySearchId)
{
vm.saveBodySearchId = BodySearchId;
vm.BodySearchId = BodySearchId;
vm.DocumentId = item.Document_Id;
vm.DocumentName = item.Document_Name;
}
}
//}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
return(vm);
}