public bool AddPresentationConditionToCase(int CaseId, List <int> conditionsIds)
{
var dbContext = new SDIIS_DatabaseEntities();
try
{
var conditionsToEdit = dbContext.VEP_VictimsConditions.Where(x => x.Caseid.Equals(CaseId));
dbContext.VEP_VictimsConditions.RemoveRange(conditionsToEdit);
dbContext.SaveChanges();
foreach (var roleId in conditionsIds)
{
var newCondition = new VEP_VictimsConditions()
{
Caseid = CaseId,
PresentationConditionID = roleId
};
dbContext.VEP_VictimsConditions.Add(newCondition);
dbContext.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
var Test = ex.Message;
return(false);
}
}
public int Create(int selected_ConditionId, int CaseId)
{
var dbContext = new SDIIS_DatabaseEntities();
try
{
var victimRecord = new VEP_VictimsConditions();
victimRecord.Caseid = CaseId;
victimRecord.PresentationConditionID = selected_ConditionId;
dbContext.VEP_VictimsConditions.Add(victimRecord);
dbContext.SaveChanges();
return(victimRecord.Id);
}
catch (Exception ex)
{
var Test = ex.Message;
return(-1);
}
}
public VEP_VictimsConditions UpdateVictimCondition(VictimRecord Obj, int Id)
{
int CheckIfExistVEP_VictimsConditions = (from x in dbContext.VEP_VictimsConditions
where x.Caseid == Id
select x.Id).FirstOrDefault();
if (CheckIfExistVEP_VictimsConditions == 0)
{
VEP_VictimsConditions VCModel = new VEP_VictimsConditions();
VCModel.Caseid = Id;
//VCModel.Angry = Obj.VictimConditions.Angry;
//VCModel.ExecivelyAlert = Obj.VictimConditions.ExecivelyAlert;
//VCModel.FullyMobile = Obj.VictimConditions.FullyMobile;
//VCModel.LookAfraid = Obj.VictimConditions.LookAfraid;
//VCModel.Panic = Obj.VictimConditions.Panic;
//VCModel.VictimsConditionsID = 1;
dbContext.VEP_VictimsConditions.Add(VCModel);
dbContext.SaveChanges();
return(VCModel);
}
else
{
VEP_VictimsConditions VCModel = (from k in dbContext.VEP_VictimsConditions
where k.Caseid == Id
select k).FirstOrDefault();
VCModel.Caseid = Id;
//VCModel.Angry = Obj.VictimConditions.Angry;
//VCModel.ExecivelyAlert = Obj.VictimConditions.ExecivelyAlert;
//VCModel.FullyMobile = Obj.VictimConditions.FullyMobile;
//VCModel.LookAfraid = Obj.VictimConditions.LookAfraid;
//VCModel.Panic = Obj.VictimConditions.Panic;
//VCModel.VictimsConditionsID = 1;
dbContext.SaveChanges();
return(VCModel);
}
}