public PCMChildrensCourtViewModel GetPCMFormalCourtEditDetails(int FormalCourtRecommId)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_Formal_Court_Recommendation
where (c.PCM_Formal_Court_Recomm_Id == FormalCourtRecommId)
select c.PCM_Formal_Court_Recomm_Id).FirstOrDefault();
PCM_Formal_Court_Recommendation fc = db.PCM_Formal_Court_Recommendation.Find(id);
if (fc != null)
{
vm.PCM_Formal_Court_Recomm_Id = db.PCM_Formal_Court_Recommendation.Find(fc.PCM_Formal_Court_Recomm_Id).PCM_Formal_Court_Recomm_Id;
vm.PCM_Recommendation_Id = fc.PCM_Recommendation_Id;
vm.Type_Of_Center_Id = fc.Type_Of_Center_Id;
vm.Type_Of_Placement_Id = fc.Type_Of_Placement_Id;
vm.Personal_Details_Id = fc.Personal_Details_Id;
vm.Facility_Id = fc.Facility_Id;
vm.Date_Modified = fc.Date_Modified;
vm.Modified_By = fc.Modified_By;
vm.Date_Created = fc.Date_Created;
vm.Withdrawal_Status = vm.Withdrawal_Status;
}
}
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 void CreatePCMFormalCourt(PCMChildrensCourtViewModel vm, int PcmReg, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Formal_Court_Recommendation newFC = new PCM_Formal_Court_Recommendation();
newFC.PCM_Recommendation_Id = PcmReg;
newFC.Type_Of_Center_Id = vm.Type_Of_Center_Id;
newFC.Type_Of_Placement_Id = vm.Type_Of_Placement_Id;
newFC.Personal_Details_Id = vm.Personal_Details_Id;
newFC.Facility_Id = vm.Facility_Id;
newFC.Created_By = userId;
newFC.Date_Modified = DateTime.Now;
newFC.Modified_By = userId;
newFC.Date_Created = DateTime.Now;
newFC.Withdrawal_Status = vm.Withdrawal_Status;
db.PCM_Formal_Court_Recommendation.Add(newFC);
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;
}
}
}
