/// <summary>
/// Get School by id
/// </summary>
/// <param name="school"></param>
/// <returns></returns>
public SchoolAddViewModel ViewSchool(SchoolAddViewModel school)
{
try
{
SchoolAddViewModel SchoolAddViewModel = new SchoolAddViewModel();
var schoolMaster = this.context?.SchoolMaster.Include(x => x.SchoolDetail).Include(x => x.FieldsCategory).ThenInclude(x => x.CustomFields).ThenInclude(x => x.CustomFieldsValue).FirstOrDefault(x => x.TenantId == school.schoolMaster.TenantId && x.SchoolId == school.schoolMaster.SchoolId);
var schoolFieldCatagory = schoolMaster.FieldsCategory.Where(x => x.Module.Trim() == "School").OrderByDescending(x => x.IsSystemCategory).ThenBy(x => x.SortOrder).ToList();
var schoolcustomFields = schoolFieldCatagory.FirstOrDefault().CustomFields.OrderByDescending(y => y.SystemField).ThenBy(y => y.SortOrder).ToList();
if (schoolMaster != null)
{
school.schoolMaster = schoolMaster;
school.schoolMaster.FieldsCategory = schoolFieldCatagory;
school.schoolMaster.FieldsCategory.FirstOrDefault().CustomFields = schoolcustomFields;
if (school.schoolMaster.SchoolDetail.ToList().Count > 0)
{
school.schoolMaster.SchoolDetail.FirstOrDefault().SchoolMaster = null;
}
school._tenantName = school._tenantName;
return(school);
}
else
{
SchoolAddViewModel._failure = true;
SchoolAddViewModel._message = NORECORDFOUND;
return(SchoolAddViewModel);
}
}
catch (Exception es)
{
throw;
}
}
public SchoolAddViewModel ViewSchool(SchoolAddViewModel school)
{
try
{
SchoolAddViewModel SchoolAddViewModel = new SchoolAddViewModel();
var schoolMaster = this.context?.TableSchoolMaster.FirstOrDefault(x => x.TenantId == school.tblSchoolDetail.TableSchoolMaster.TenantId && x.SchoolId == school.tblSchoolDetail.TableSchoolMaster.SchoolId);
var schoolDetails = this.context?.TableSchoolDetail.FirstOrDefault(x => x.TenantId == school.tblSchoolDetail.TableSchoolMaster.TenantId && x.SchoolId == school.tblSchoolDetail.TableSchoolMaster.SchoolId);
if (schoolMaster != null)
{
if (schoolMaster.GeoPosition != null)
{
school.longitude = schoolMaster.GeoPosition.Centroid.X;
school.latitude = schoolMaster.GeoPosition.Centroid.Y;
}
school.tblSchoolDetail.TableSchoolMaster = schoolMaster;
school.tblSchoolDetail.TableSchoolMaster.GeoPosition = null;
school.tblSchoolDetail = schoolDetails;
school._tenantName = school._tenantName;
return(school);
}
else
{
SchoolAddViewModel._failure = true;
SchoolAddViewModel._message = NORECORDFOUND;
return(SchoolAddViewModel);
}
}
catch (Exception es)
{
throw;
}
}
public ActionResult <SchoolAddViewModel> ViewSchool(SchoolAddViewModel school)
{
SchoolAddViewModel schoolAdd = new SchoolAddViewModel();
try
{
schoolAdd = _schoolRegisterService.ViewSchool(school);
}
catch (Exception es)
{
schoolAdd._failure = true;
schoolAdd._message = es.Message;
}
return(schoolAdd);
}
public ActionResult <SchoolAddViewModel> AddUpdateSchoolLogo(SchoolAddViewModel schoolAddViewModel)
{
SchoolAddViewModel schoolLogoUpdate = new SchoolAddViewModel();
try
{
schoolLogoUpdate = _schoolRegisterService.AddUpdateSchoolLogo(schoolAddViewModel);
}
catch (Exception es)
{
schoolLogoUpdate._failure = true;
schoolLogoUpdate._message = es.Message;
}
return(schoolLogoUpdate);
}
public SchoolAddViewModel ViewSchool(SchoolAddViewModel schools)
{
SchoolAddViewModel SchoolAddViewModel = new SchoolAddViewModel();
if (TokenManager.CheckToken(schools._tenantName, schools._token))
{
SchoolAddViewModel = this.schoolRepository.ViewSchool(schools);
//return getAllSchools();
return(SchoolAddViewModel);
}
else
{
SchoolAddViewModel._failure = true;
SchoolAddViewModel._message = TOKENINVALID;
return(SchoolAddViewModel);
}
}
public SchoolAddViewModel AddSchool(SchoolAddViewModel school)
{
try
{
//int? MasterSchoolId = Utility<TableSchoolMaster>.GetMaxPK(this.context, new Func<TableSchoolMaster, int>(x => x.SchoolId));
// int? Detail_Id = (int)Utility<TableSchoolDetail>.GetMaxPK(this.context, new Func<TableSchoolDetail, int>(x => x.Id));
int?MasterSchoolId = Utility.GetMaxPK(this.context, new Func <TableSchoolMaster, int>(x => x.SchoolId));
int?Detail_Id = (int)Utility.GetMaxPK(this.context, new Func <TableSchoolDetail, int>(x => x.Id));
Point currentLocation = null;
var geometryFactory = NtsGeometryServices.Instance.CreateGeometryFactory(srid: 4326);
if (school.longitude != null && school.latitude != null)
{
currentLocation = geometryFactory.CreatePoint(new Coordinate((double)school.longitude, (double)school.latitude));
}
var schoolMaster = this.context?.TableSchoolMaster.ToList().OrderBy(x => x.SchoolId).LastOrDefault();
var schoolDetail = this.context?.TableSchoolDetail.ToList().OrderBy(x => x.SchoolId).LastOrDefault();
school.tblSchoolDetail.TableSchoolMaster.SchoolId = (int)MasterSchoolId;
school.tblSchoolDetail.SchoolId = MasterSchoolId;
school.tblSchoolDetail.Id = (int)Detail_Id;
school.tblSchoolDetail.TableSchoolMaster.DateCreated = DateTime.UtcNow;
school.tblSchoolDetail.TableSchoolMaster.TenantId = school.tblSchoolDetail.TableSchoolMaster.TenantId;
school.tblSchoolDetail.TableSchoolMaster.GeoPosition = currentLocation;
school.tblSchoolDetail.TenantId = school.tblSchoolDetail.TableSchoolMaster.TenantId;
this.context?.TableSchoolDetail.Add(school.tblSchoolDetail);
this.context?.SaveChanges();
school._failure = false;
school.tblSchoolDetail.TableSchoolMaster.GeoPosition = null;
return(school);
}
catch (Exception es)
{
throw;
}
}
/// <summary>
/// Add Update School Logo
/// </summary>
/// <param name="schoolAddViewModel"></param>
/// <returns></returns>
public SchoolAddViewModel AddUpdateSchoolLogo(SchoolAddViewModel schoolAddViewModel)
{
SchoolAddViewModel schoolLogoUpdate = new SchoolAddViewModel();
try
{
if (TokenManager.CheckToken(schoolAddViewModel._tenantName + schoolAddViewModel._userName, schoolAddViewModel._token))
{
schoolLogoUpdate = this.schoolRepository.AddUpdateSchoolLogo(schoolAddViewModel);
}
else
{
schoolLogoUpdate._failure = true;
schoolLogoUpdate._message = TOKENINVALID;
}
}
catch (Exception es)
{
schoolLogoUpdate._message = es.Message;
schoolLogoUpdate._failure = true;
}
return(schoolLogoUpdate);
}
/// <summary>
/// School Add
/// </summary>
/// <param name="school"></param>
/// <returns></returns>
public SchoolAddViewModel AddSchool(SchoolAddViewModel school)
{
try
{
int?MasterSchoolId = Utility.GetMaxPK(this.context, new Func <SchoolMaster, int>(x => x.SchoolId));
//int? MemberShipId = Utility.GetMaxPK(this.context, new Func<Membership, int>(x => x.MembershipId));
//int? CategoryId = Utility.GetMaxPK(this.context, new Func<FieldsCategory, int>(x => x.CategoryId));
school.schoolMaster.SchoolId = (int)MasterSchoolId;
if (school.schoolMaster.SchoolDetail.ToList().Count > 0)
{
school.schoolMaster.SchoolDetail.ToList().ForEach(p => p.Id = (int)Utility.GetMaxPK(this.context, new Func <SchoolDetail, int>(x => x.Id)));
}
school.schoolMaster.DateCreated = DateTime.UtcNow;
school.schoolMaster.TenantId = school.schoolMaster.TenantId;
school.schoolMaster.Membership = new List <Membership>()
{
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Super Administrator", Title = "Super Administrator", MembershipId = 1
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Administrator", Title = "Administrator", MembershipId = 2
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Teacher", Title = "Teacher", MembershipId = 3
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Student", Title = "Student", MembershipId = 4
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Parent", Title = "Parent", MembershipId = 5
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Admin Assistant", Title = "Admin Assistant", MembershipId = 6
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Administrator w/Custom", Title = "Administrator w/Custom", MembershipId = 7
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Teacher w/Custom", Title = "Teacher w/Custom", MembershipId = 8
},
new Membership()
{
LastUpdated = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, TenantId = school.schoolMaster.TenantId, Profile = "Parent w/Custom", Title = "Parent w/Custom", MembershipId = 9
},
};
school.schoolMaster.FieldsCategory = new List <FieldsCategory>()
{
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "General Information", Module = "School", SortOrder = 1, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 1
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Wash Information", Module = "School", SortOrder = 2, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 2
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "General Info", Module = "Student", SortOrder = 1, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 3
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Address & Contact", Module = "Student", SortOrder = 2, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 4
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "School & Enrollment Info", Module = "Student", SortOrder = 3, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 5
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Family Info", Module = "Student", SortOrder = 4, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 6
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Login Info", Module = "Student", SortOrder = 5, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 7
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Medical Info", Module = "Student", SortOrder = 6, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 8
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Comments", Module = "Student", SortOrder = 7, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 9
},
new FieldsCategory()
{
TenantId = school.schoolMaster.TenantId, SchoolId = school.schoolMaster.SchoolId, IsSystemCategory = true, Search = true, Title = "Documents", Module = "Student", SortOrder = 8, Required = true, Hide = false, LastUpdate = DateTime.UtcNow, UpdatedBy = school.schoolMaster.ModifiedBy, CategoryId = 10
}
};
bool checkInternalID = CheckInternalID(school.schoolMaster.TenantId, school.schoolMaster.SchoolInternalId);
if (checkInternalID == true)
{
this.context?.SchoolMaster.Add(school.schoolMaster);
this.context?.SaveChanges();
school._failure = false;
}
else
{
school.schoolMaster = null;
school._failure = true;
school._message = "School InternalID Already Exist";
}
//school.schoolMaster.Membership.ToList().ForEach(x=>x.SchoolMaster=null);
/*if (school.schoolMaster.SchoolDetail.ToList().Count>0)
* {
* school.schoolMaster.SchoolDetail.FirstOrDefault().SchoolMaster = null;
* }*/
//school.schoolMaster.FieldsCategory.ToList().ForEach(x => x.SchoolMaster = null);
/*if (school.schoolMaster.SchoolDetail.ToList().Count > 0)
* {
* school.schoolMaster.SchoolDetail.FirstOrDefault().SchoolMaster = null;
* }*/
return(school);
}
catch (Exception es)
{
throw;
}
}
public SchoolAddViewModel UpdateSchool(SchoolAddViewModel school)
{
try
{
var schoolMaster = this.context?.SchoolMaster.Include(x => x.SchoolDetail).Include(x => x.FieldsCategory).ThenInclude(x => x.CustomFields).ThenInclude(x => x.CustomFieldsValue).FirstOrDefault(x => x.TenantId == school.schoolMaster.TenantId && x.SchoolId == school.schoolMaster.SchoolId);
schoolMaster.SchoolAltId = school.schoolMaster.SchoolAltId;
schoolMaster.SchoolStateId = school.schoolMaster.SchoolStateId;
schoolMaster.SchoolDistrictId = school.schoolMaster.SchoolDistrictId;
schoolMaster.SchoolLevel = school.schoolMaster.SchoolLevel;
schoolMaster.SchoolClassification = school.schoolMaster.SchoolClassification;
schoolMaster.SchoolName = school.schoolMaster.SchoolName;
schoolMaster.AlternateName = school.schoolMaster.AlternateName;
schoolMaster.StreetAddress1 = school.schoolMaster.StreetAddress1;
schoolMaster.StreetAddress2 = school.schoolMaster.StreetAddress2;
schoolMaster.City = school.schoolMaster.City;
schoolMaster.County = school.schoolMaster.County;
schoolMaster.Division = school.schoolMaster.Division;
schoolMaster.State = school.schoolMaster.State;
schoolMaster.District = school.schoolMaster.District;
schoolMaster.Zip = school.schoolMaster.Zip;
schoolMaster.Country = school.schoolMaster.Country;
schoolMaster.Features = school.schoolMaster.Features;
schoolMaster.ModifiedBy = school.schoolMaster.ModifiedBy;
schoolMaster.DateModifed = DateTime.UtcNow;
schoolMaster.MaxApiChecks = school.schoolMaster.MaxApiChecks;
schoolMaster.SchoolInternalId = school.schoolMaster.SchoolInternalId;
schoolMaster.Latitude = school.schoolMaster.Latitude;
schoolMaster.Longitude = school.schoolMaster.Longitude;
var checkInternalId = this.context?.SchoolMaster.Where(x => x.TenantId == school.schoolMaster.TenantId && x.SchoolInternalId == school.schoolMaster.SchoolInternalId && x.SchoolId != school.schoolMaster.SchoolId).ToList();
if (checkInternalId.Count() > 0)
{
school.schoolMaster = null;
school._failure = true;
school._message = "School InternalID Already Exist";
}
else
{
if (schoolMaster.SchoolDetail.ToList().Count == 0 && school.schoolMaster.SchoolDetail.ToList().Count > 0)
{
school.schoolMaster.SchoolDetail.ToList().ForEach(p => p.Id = (int)Utility.GetMaxPK(this.context, new Func <SchoolDetail, int>(x => x.Id)));
school.schoolMaster.SchoolDetail.ToList().ForEach(p => p.SchoolId = school.schoolMaster.SchoolId);
school.schoolMaster.SchoolDetail.ToList().ForEach(p => p.TenantId = school.schoolMaster.TenantId);
this.context?.SchoolDetail.AddRange(school.schoolMaster.SchoolDetail);
}
if (schoolMaster.SchoolDetail.ToList().Count > 0)
{
foreach (var detailes in schoolMaster.SchoolDetail.ToList())
{
detailes.Affiliation = school.schoolMaster.SchoolDetail.FirstOrDefault().Affiliation;
detailes.Associations = school.schoolMaster.SchoolDetail.FirstOrDefault().Associations;
detailes.Locale = school.schoolMaster.SchoolDetail.FirstOrDefault().Locale;
detailes.LowestGradeLevel = school.schoolMaster.SchoolDetail.FirstOrDefault().LowestGradeLevel;
detailes.HighestGradeLevel = school.schoolMaster.SchoolDetail.FirstOrDefault().HighestGradeLevel;
detailes.DateSchoolOpened = school.schoolMaster.SchoolDetail.FirstOrDefault().DateSchoolOpened;
detailes.DateSchoolClosed = school.schoolMaster.SchoolDetail.FirstOrDefault().DateSchoolClosed;
detailes.Status = school.schoolMaster.SchoolDetail.FirstOrDefault().Status;
detailes.Gender = school.schoolMaster.SchoolDetail.FirstOrDefault().Gender;
detailes.Internet = school.schoolMaster.SchoolDetail.FirstOrDefault().Internet;
detailes.Electricity = school.schoolMaster.SchoolDetail.FirstOrDefault().Electricity;
detailes.Telephone = school.schoolMaster.SchoolDetail.FirstOrDefault().Telephone;
detailes.Fax = school.schoolMaster.SchoolDetail.FirstOrDefault().Fax;
detailes.Website = school.schoolMaster.SchoolDetail.FirstOrDefault().Website;
detailes.Email = school.schoolMaster.SchoolDetail.FirstOrDefault().Email;
detailes.Facebook = school.schoolMaster.SchoolDetail.FirstOrDefault().Facebook;
detailes.Twitter = school.schoolMaster.SchoolDetail.FirstOrDefault().Twitter;
detailes.Instagram = school.schoolMaster.SchoolDetail.FirstOrDefault().Instagram;
detailes.Youtube = school.schoolMaster.SchoolDetail.FirstOrDefault().Youtube;
detailes.LinkedIn = school.schoolMaster.SchoolDetail.FirstOrDefault().LinkedIn;
detailes.NameOfPrincipal = school.schoolMaster.SchoolDetail.FirstOrDefault().NameOfPrincipal;
detailes.NameOfAssistantPrincipal = school.schoolMaster.SchoolDetail.FirstOrDefault().NameOfAssistantPrincipal;
detailes.SchoolLogo = school.schoolMaster.SchoolDetail.FirstOrDefault().SchoolLogo;
detailes.RunningWater = school.schoolMaster.SchoolDetail.FirstOrDefault().RunningWater;
detailes.MainSourceOfDrinkingWater = school.schoolMaster.SchoolDetail.FirstOrDefault().MainSourceOfDrinkingWater;
detailes.CurrentlyAvailable = school.schoolMaster.SchoolDetail.FirstOrDefault().CurrentlyAvailable;
detailes.FemaleToiletType = school.schoolMaster.SchoolDetail.FirstOrDefault().FemaleToiletType;
detailes.TotalFemaleToilets = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalFemaleToilets;
detailes.TotalFemaleToiletsUsable = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalFemaleToiletsUsable;
detailes.FemaleToiletAccessibility = school.schoolMaster.SchoolDetail.FirstOrDefault().FemaleToiletAccessibility;
detailes.MaleToiletType = school.schoolMaster.SchoolDetail.FirstOrDefault().MaleToiletType;
detailes.TotalMaleToilets = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalMaleToilets;
detailes.TotalMaleToiletsUsable = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalMaleToiletsUsable;
detailes.MaleToiletAccessibility = school.schoolMaster.SchoolDetail.FirstOrDefault().MaleToiletAccessibility;
detailes.ComonToiletType = school.schoolMaster.SchoolDetail.FirstOrDefault().ComonToiletType;
detailes.TotalCommonToilets = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalCommonToilets;
detailes.TotalCommonToiletsUsable = school.schoolMaster.SchoolDetail.FirstOrDefault().TotalCommonToiletsUsable;
detailes.CommonToiletAccessibility = school.schoolMaster.SchoolDetail.FirstOrDefault().CommonToiletAccessibility;
detailes.HandwashingAvailable = school.schoolMaster.SchoolDetail.FirstOrDefault().HandwashingAvailable;
detailes.SoapAndWaterAvailable = school.schoolMaster.SchoolDetail.FirstOrDefault().SoapAndWaterAvailable;
detailes.HygeneEducation = school.schoolMaster.SchoolDetail.FirstOrDefault().HygeneEducation;
}
}
//Student Custom Field value With Delete
if (school.schoolMaster.FieldsCategory != null && school.schoolMaster.FieldsCategory.ToList().Count > 0)
{
var fieldsCategory = school.schoolMaster.FieldsCategory.FirstOrDefault(x => x.CategoryId == school.SelectedCategoryId);
if (fieldsCategory != null)
{
foreach (var customFields in fieldsCategory.CustomFields.ToList())
{
var customFieldValueData = this.context?.CustomFieldsValue.FirstOrDefault(x => x.TenantId == school.schoolMaster.TenantId && x.SchoolId == school.schoolMaster.SchoolId && x.CategoryId == customFields.CategoryId && x.FieldId == customFields.FieldId && x.Module == "School" && x.TargetId == school.schoolMaster.SchoolId);
if (customFieldValueData != null)
{
this.context?.CustomFieldsValue.RemoveRange(customFieldValueData);
}
if (customFields.CustomFieldsValue != null && customFields.CustomFieldsValue.ToList().Count > 0)
{
customFields.CustomFieldsValue.FirstOrDefault().Module = "School";
customFields.CustomFieldsValue.FirstOrDefault().CategoryId = customFields.CategoryId;
customFields.CustomFieldsValue.FirstOrDefault().FieldId = customFields.FieldId;
customFields.CustomFieldsValue.FirstOrDefault().CustomFieldTitle = customFields.Title;
customFields.CustomFieldsValue.FirstOrDefault().CustomFieldType = customFields.Type;
customFields.CustomFieldsValue.FirstOrDefault().SchoolId = school.schoolMaster.SchoolId;
customFields.CustomFieldsValue.FirstOrDefault().TargetId = school.schoolMaster.SchoolId;
this.context?.CustomFieldsValue.AddRange(customFields.CustomFieldsValue);
}
}
}
}
this.context?.SaveChanges();
if (school.schoolMaster.SchoolDetail.ToList().Count > 0)
{
school.schoolMaster.SchoolDetail.FirstOrDefault().SchoolMaster = null;
}
school._failure = false;
}
return(school);
}
catch (Exception ex)
{
school.schoolMaster = null;
school._failure = true;
school._message = NORECORDFOUND;
return(school);
}
}
public SchoolAddViewModel UpdateSchool(SchoolAddViewModel school)
{
var schoolMaster = this.context?.TableSchoolMaster.FirstOrDefault(x => x.TenantId == school.tblSchoolDetail.TableSchoolMaster.TenantId && x.SchoolId == school.tblSchoolDetail.TableSchoolMaster.SchoolId);
var schoolDetails = this.context?.TableSchoolDetail.FirstOrDefault(x => x.TenantId == school.tblSchoolDetail.TableSchoolMaster.TenantId && x.SchoolId == school.tblSchoolDetail.TableSchoolMaster.SchoolId);
if (schoolMaster != null && schoolDetails != null)
{
schoolMaster.SchoolAltId = school.tblSchoolDetail.TableSchoolMaster.SchoolAltId;
schoolMaster.SchoolStateId = school.tblSchoolDetail.TableSchoolMaster.SchoolStateId;
schoolMaster.SchoolDistrictId = school.tblSchoolDetail.TableSchoolMaster.SchoolDistrictId;
schoolMaster.SchoolLevel = school.tblSchoolDetail.TableSchoolMaster.SchoolLevel;
schoolMaster.SchoolClassification = school.tblSchoolDetail.TableSchoolMaster.SchoolClassification;
schoolMaster.SchoolName = school.tblSchoolDetail.TableSchoolMaster.SchoolName;
schoolMaster.AlternateName = school.tblSchoolDetail.TableSchoolMaster.AlternateName;
schoolMaster.StreetAddress1 = school.tblSchoolDetail.TableSchoolMaster.StreetAddress1;
schoolMaster.StreetAddress2 = school.tblSchoolDetail.TableSchoolMaster.StreetAddress2;
schoolMaster.City = school.tblSchoolDetail.TableSchoolMaster.City;
schoolMaster.County = school.tblSchoolDetail.TableSchoolMaster.County;
schoolMaster.Division = school.tblSchoolDetail.TableSchoolMaster.Division;
schoolMaster.State = school.tblSchoolDetail.TableSchoolMaster.State;
schoolMaster.District = school.tblSchoolDetail.TableSchoolMaster.District;
schoolMaster.Zip = school.tblSchoolDetail.TableSchoolMaster.Zip;
schoolMaster.Country = school.tblSchoolDetail.TableSchoolMaster.Country;
schoolMaster.Features = school.tblSchoolDetail.TableSchoolMaster.Features;
//schoolMaster.Plan_id = school.tblSchoolMaster.Plan_id;
//public Geometry Latitude
//public Geometry Longitude
schoolMaster.CreatedBy = school.tblSchoolDetail.TableSchoolMaster.CreatedBy;
schoolMaster.DateCreated = school.tblSchoolDetail.TableSchoolMaster.DateCreated;
schoolMaster.ModifiedBy = school.tblSchoolDetail.TableSchoolMaster.ModifiedBy;
schoolMaster.DateModifed = school.tblSchoolDetail.TableSchoolMaster.DateModifed;
schoolMaster.MaxApiChecks = school.tblSchoolDetail.TableSchoolMaster.MaxApiChecks;
schoolDetails.Affiliation = school.tblSchoolDetail.Affiliation;
schoolDetails.Associations = school.tblSchoolDetail.Associations;
schoolDetails.Locale = school.tblSchoolDetail.Locale;
schoolDetails.LowestGradeLevel = school.tblSchoolDetail.LowestGradeLevel;
schoolDetails.HighestGradeLevel = school.tblSchoolDetail.HighestGradeLevel;
schoolDetails.DateSchoolOpened = school.tblSchoolDetail.DateSchoolOpened;
schoolDetails.DateSchoolClosed = school.tblSchoolDetail.DateSchoolClosed;
schoolDetails.Status = school.tblSchoolDetail.Status;
schoolDetails.Gender = school.tblSchoolDetail.Gender;
schoolDetails.Internet = school.tblSchoolDetail.Internet;
schoolDetails.Electricity = school.tblSchoolDetail.Electricity;
schoolDetails.Telephone = school.tblSchoolDetail.Telephone;
schoolDetails.Fax = school.tblSchoolDetail.Fax;
schoolDetails.Website = school.tblSchoolDetail.Website;
schoolDetails.Email = school.tblSchoolDetail.Email;
schoolDetails.Facebook = school.tblSchoolDetail.Facebook;
schoolDetails.Twitter = school.tblSchoolDetail.Twitter;
schoolDetails.Instagram = school.tblSchoolDetail.Instagram;
schoolDetails.Youtube = school.tblSchoolDetail.Youtube;
schoolDetails.LinkedIn = school.tblSchoolDetail.LinkedIn;
schoolDetails.NameOfPrincipal = school.tblSchoolDetail.NameOfPrincipal;
schoolDetails.NameOfAssistantPrincipal = school.tblSchoolDetail.NameOfAssistantPrincipal;
schoolDetails.SchoolLogo = school.tblSchoolDetail.SchoolLogo;
schoolDetails.RunningWater = school.tblSchoolDetail.RunningWater;
schoolDetails.MainSourceOfDrinkingWater = school.tblSchoolDetail.MainSourceOfDrinkingWater;
schoolDetails.CurrentlyAvailable = school.tblSchoolDetail.CurrentlyAvailable;
schoolDetails.FemaleToiletType = school.tblSchoolDetail.FemaleToiletType;
schoolDetails.TotalFemaleToilets = school.tblSchoolDetail.TotalFemaleToilets;
schoolDetails.TotalFemaleToiletsUsable = school.tblSchoolDetail.TotalFemaleToiletsUsable;
schoolDetails.FemaleToiletAccessibility = school.tblSchoolDetail.FemaleToiletAccessibility;
schoolDetails.MaleToiletType = school.tblSchoolDetail.MaleToiletType;
schoolDetails.TotalMaleToilets = school.tblSchoolDetail.TotalMaleToilets;
schoolDetails.TotalMaleToiletsUsable = school.tblSchoolDetail.TotalMaleToiletsUsable;
schoolDetails.MaleToiletAccessibility = school.tblSchoolDetail.MaleToiletAccessibility;
schoolDetails.ComonToiletType = school.tblSchoolDetail.ComonToiletType;
schoolDetails.TotalCommonToilets = school.tblSchoolDetail.TotalCommonToilets;
schoolDetails.TotalCommonToiletsUsable = school.tblSchoolDetail.TotalCommonToiletsUsable;
schoolDetails.CommonToiletAccessibility = school.tblSchoolDetail.CommonToiletAccessibility;
schoolDetails.HandwashingAvailable = school.tblSchoolDetail.HandwashingAvailable;
schoolDetails.SoapAndWaterAvailable = school.tblSchoolDetail.SoapAndWaterAvailable;
schoolDetails.HygeneEducation = school.tblSchoolDetail.HygeneEducation;
this.context?.SaveChanges();
school._failure = false;
return(school);
}
else
{
school.tblSchoolDetail = null;
school.tblSchoolDetail.TableSchoolMaster = null;
school._failure = true;
school._message = NORECORDFOUND;
return(school);
}
}
