public string addReporterType(SettingsViewModel newSetting)
{
string id = null;
try
{
company_relationship idContain = db.company_relationship.Where(item => item.relationship_en.Trim().ToLower() == newSetting.data.Trim().ToLower() && item.company_id == newSetting.companyId).FirstOrDefault();
if (idContain != null)
{
idContain.status_id = 2;
db.SaveChanges();
return(idContain.id.ToString());
}
else
{
company_relationship custom = new company_relationship
{
company_id = newSetting.companyId,
client_id = newSetting.userId,
status_id = 2,
relationship_en = newSetting.data,
relationship_es = "",
relationship_ar = "",
relationship_fr = "",
relationship_jp = "",
relationship_ru = ""
};
custom = db.company_relationship.Add(custom);
db.SaveChanges();
id = custom.id.ToString();
}
}
catch (System.Data.DataException ex)
{
logger.Error(ex.ToString());
return("false");
}
return(id);
}
public company_relationship getOtherRelationship()
{
company_relationship other = null;
try
{
relationship otherDefault = db.relationship.Where(item => item.id == 20 || item.relationship_en.ToLower() == "other").FirstOrDefault();
if (otherDefault != null)
{
other = new company_relationship();
other.relationship_en = otherDefault.relationship_en;
other.relationship_ar = otherDefault.relationship_ar;
other.relationship_es = other.relationship_es;
other.relationship_fr = otherDefault.relationship_fr;
other.relationship_ru = otherDefault.relationship_ru;
}
}
catch (System.Data.DataException ex)
{
logger.Error(ex.ToString());
}
return(other);
}
public void merge(ReportViewModel rvm, CompanyModel companyModel, ReportModel reportModel, ReportViewModel model)
{
this.confidentialLevelInt = model.incident_anonymity_id;
if (model.incident_anonymity_id != 1)
{
name = model.userName;
surname = model.userLastName;
email = model.userEmail;
}
if (companyModel != null && rvm != null)
{
CountryModel country = new CountryModel();
country selectedCountry = country.loadById(model.reportFrom);
reportingFrom = selectedCountry.country_nm;
}
List <anonymity> list_anon = companyModel.GetAnonymities(companyModel._company.id, 0);
if (list_anon != null)
{
var temp = from n in list_anon where n.id == model.incident_anonymity_id select n;
anonymity anon = temp.FirstOrDefault();
confidentialLevel = anon.anonymity_company_en;
}
List <company_relationship> relationship = reportModel.getCustomRelationshipCompany(companyModel._company.id);
if (relationship != null)
{
var temp = from n in relationship where n.id == model.reporterTypeDetail select n;
company_relationship rel = temp.FirstOrDefault();
if (rel != null)
{
reportedAs = rel.relationship_en;
}
}
var locations = companyModel.Locations(companyModel._company.id).ToList();
if (locations != null)
{
var temp = from n in locations where n.id == model.locationsOfIncident select n.location_en;
if (temp != null)
{
incidentLocation = String.Join(", ", temp);
}
}
List <company_department> depActive = companyModel.CompanyDepartmentsActive(companyModel._company.id).ToList();
List <string> departments = model.departments;
List <int> departmentsInt = new List <int>();
foreach (string item in departments)
{
try
{
int temp = 0;
Int32.TryParse(item, out temp);
if (temp > 0)
{
departmentsInt.Add(temp);
}
else if (temp == 0)
{
departmentsInt.Add(0);
}
}
catch (Exception) { }
}
if (depActive != null && depActive.Count > 0 && departments != null && departments.Count > 0)
{
var temp = from n in depActive
join entry in departmentsInt
on n.id equals entry
select n.department_en;
foreach (string item in temp)
{
affectedDepartments = String.Join(", ", item);
}
if (affectedDepartments == null)
{
affectedDepartments = GlobalRes.notListed;
}
}
List <management_know> managament = companyModel.getManagamentKnow();
if (managament != null && model.managamentKnowId > 0)
{
var temp = from n in managament
where n.id == model.managamentKnowId
select n.text_en;
managamentKnow = temp.FirstOrDefault();
}
List <reported_outside> reported_outside = companyModel.getReportedOutside();
if (model.reported_outside_id > 0 && reported_outside != null)
{
var temp = from n in reported_outside where n.id == model.reported_outside_id select n;
outOrganization = temp.FirstOrDefault().description_en;
}
if (model.isUrgent == 0)
{
isCaseUrgent = GlobalRes.No;
}
else
{
isCaseUrgent = GlobalRes.Yes;
}
if (reportModel.isCustomIncidentTypes(model.currentCompanyId))
{
/*custom types*/
List <company_secondary_type> company_secondary_type = reportModel.getCompanySecondaryType(model.currentCompanyId);
foreach (int item in model.whatHappened)
{
if (item != 0)
{
var something = company_secondary_type.Where(m => m.id == item).FirstOrDefault();
IncidentType += something.secondary_type_en + ", ";
}
else
{
IncidentType += GlobalRes.Other + ", ";
}
}
}
else
{
/*default*/
List <secondary_type_mandatory> secondary_type_mandatory = reportModel.getSecondaryTypeMandatory();
foreach (int item in model.whatHappened)
{
if (item != 0)
{
var something = secondary_type_mandatory.Where(m => m.id == item).FirstOrDefault();
IncidentType += something.secondary_type_en + ", ";
}
else
{
IncidentType += GlobalRes.Other + ", ";
}
}
}
IncidentType = IncidentType.Remove(IncidentType.Length - 2);
IncidentDate = model.dateIncidentHappened.ToShortDateString();
switch (model.isOnGoing)
{
case 1:
incidentOngoing = GlobalRes.No;
break;
case 2:
incidentOngoing = GlobalRes.Yes;
break;
case 3:
incidentOngoing = GlobalRes.NotSureUp;
break;
}
List <injury_damage> injuryDamage = companyModel.GetInjuryDamages().ToList();
if (injuryDamage != null && injuryDamage.Count > 0 && model.incidentResultReport > 0)
{
var temp = from n in injuryDamage where n.id == model.incidentResultReport select n;
incidentResult = temp.FirstOrDefault().text_en;
}
incidentDescription = model.describeHappened;
if (model.files.Count > 0)
{
HttpFileCollectionBase files = model.files;
var fileItem = files["attachDocuments"];
if (fileItem != null)
{
attachFiles = fileItem.FileName;
}
}
this.report_by_myself = model.report_by_myself == true ? GlobalRes.Myself : GlobalRes.SomeoneElse;
this.personName = new List <string>();
this.personLastName = new List <string>();
this.personTitle = new List <string>();
this.personRole = new List <string>();
var personRoles = new List <int>();
if (model.personName != null)
{
this.personName = model.personName.ToList();
this.personLastName = model.personLastName.ToList();
this.personTitle = model.personTitle.ToList();
personRoles = model.personRole.ToList();
}
List <role_in_report> roleInReport = ReportModel.getRoleInReport();
for (int i = 0; i < personRoles.Count; i++)
{
role_in_report nameRole = roleInReport.Where(m => m.id == personRoles[i]).FirstOrDefault();
if (nameRole != null)
{
personRole.Add(nameRole.role_en);
}
}
}