//ADD NEW INVENTORY
public void AddInventory(IntakeDataViewModel vm, int Id, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
//try
//{
CYCA_PersonalAndFacilityInventory newob = new CYCA_PersonalAndFacilityInventory();
newob.Person_Id = Id;
newob.Item_Handed_By = userId;
newob.Admission_Id = (from a in db.CYCA_Admissions_AdmissionDetails
join c in db.Clients on a.Client_Id equals c.Client_Id
join f in db.apl_Cyca_Facility on a.Facility_Id equals f.Facility_Id
where c.Person_Id == Id && a.Is_Active == true
select a.Admission_Id).FirstOrDefault();
newob.Facility_Id = (from a in db.CYCA_Admissions_AdmissionDetails
join c in db.Clients on a.Client_Id equals c.Client_Id
join f in db.apl_Cyca_Facility on a.Facility_Id equals f.Facility_Id
where c.Person_Id == Id && a.Is_Active == true
select f.Facility_Id).FirstOrDefault();
newob.Inventory_Type_Id = Convert.ToInt32(vm.Inventory_Type_Id);
newob.Item_Color = vm.Item_Color;
newob.Item_Type = vm.Item_Type;
newob.Item_Description = vm.Item_Description;
newob.Item_Quantity = Convert.ToInt32(vm.Item_Quantity);
newob.Date_Handed_In = Convert.ToDateTime(vm.Date_Handed_Inn);
newob.Item_Handed_To = Convert.ToInt32(vm.Item_Handed_To);
newob.Return_Status_Id = 1;
newob.Date_Created = DateTime.Now;
newob.Created_By = userId;
newob.Is_Active = true;
newob.Is_Deleted = false;
db.CYCA_PersonalAndFacilityInventory.Add(newob);
db.SaveChanges();
//}
//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;
//}
}
}
//EDIT INVENTORY
public void UpdateInventory(IntakeDataViewModel vm, int Inventory_Id, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
CYCA_PersonalAndFacilityInventory edit = db.CYCA_PersonalAndFacilityInventory.Find(Inventory_Id);
edit.Inventory_Type_Id = Convert.ToInt32(vm.Inventory_Type_Id);
edit.Item_Type = vm.Item_Type;
edit.Item_Color = vm.Item_Color;
edit.Item_Description = vm.Item_Description;
edit.Item_Quantity = Convert.ToInt32(vm.Item_Quantity);
edit.Date_Handed_In = Convert.ToDateTime(vm.Date_Handed_In);
edit.Item_Handed_To = Convert.ToInt32(vm.Item_Handed_To);
edit.Return_Status_Id = vm.Return_Status_Id;
edit.Quantity_Returned = Convert.ToInt32(vm.Quantity_Returned);
edit.Reason_Not_Returned = vm.Reason_Not_Returned;
edit.Returned_By = vm.Returned_By;
//edit.Date_Returned = Convert.ToDateTime(vm.Date_Returnedd);
edit.Date_Returned = string.IsNullOrEmpty(vm.Date_Returnedd) ? (DateTime?)null : DateTime.Parse(vm.Date_Returnedd);
edit.Date_Last_Modified = DateTime.Now;
edit.Modified_By = userId;
db.SaveChanges();
}
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;
}
}
}
//POPULATE INVENTORY FORM
public IntakeDataViewModel GetInventoryByInventoryId(int InventoryId)
{
IntakeDataViewModel vm = new IntakeDataViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
CYCA_PersonalAndFacilityInventory act = db.CYCA_PersonalAndFacilityInventory.Find(InventoryId);
if (act != null)
{
vm.Inventory_Id = InventoryId;
vm.Inventory_Type_Id = act.Inventory_Type_Id;
vm.selectedInventoryType = db.apl_Cyca_Inventory_Type.Find(act.Inventory_Type_Id).Description;
vm.Admission_Id = act.Admission_Id;
vm.Item_Type = act.Item_Type;
vm.Item_Color = act.Item_Color;
vm.Item_Quantity = act.Item_Quantity.ToString();
vm.Item_Description = act.Item_Description;
vm.Date_Handed_In = act.Date_Handed_In;
vm.Date_Handed_Inn = act.Date_Handed_In.ToString("yyyy/MM/dd");
vm.Item_Handed_To = act.Item_Handed_To;
vm.selectedUser = db.Users.Find(act.Item_Handed_To).First_Name + " " + db.Users.Find(act.Item_Handed_To).Last_Name;
vm.Return_Status_Id = act.Return_Status_Id;
vm.selectedReturnStatus = db.apl_Cyca_Inventory_Return_Status.Find(act.Return_Status_Id).Description;
vm.Returned_By = act.Returned_By;
DateTime dateReturned = Convert.ToDateTime(act.Date_Returned);
vm.Reason_Not_Returned = act.Reason_Not_Returned;
vm.Quantity_Returned = act.Quantity_Returned.ToString();
if (vm.Return_Status_Id == 2)
{
vm.Date_Returnedd = dateReturned.ToString("yyyy/MM/dd");
vm.selectedReturnedBy = db.Users.Find(act.Returned_By).First_Name + " " + db.Users.Find(act.Returned_By).Last_Name;
}
else if (vm.Reason_Not_Returned != null)
{
vm.Date_Returnedd = dateReturned.ToString("yyyy/MM/dd");
vm.selectedReturnedBy = db.Users.Find(act.Returned_By).First_Name + " " + db.Users.Find(act.Returned_By).Last_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);
}
