/// <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); } }