public IActionResult Insert(AFacilities value)
{
{
_context.AFacilities.Add(value);
try
{
_context.SaveChanges();
//
TempData["FacilityCode"] = value.FacilityCode;
TempData["Success"] = "Record Saved Successfully!";
int mynumber = value.FacilityCode;
}
catch (System.Data.Entity.Validation._contextEntityValidationException _contextEx)
{
Exception raise = _contextEx;
foreach (var validationErrors in _contextEx.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(RedirectToAction("Facility"));
}
public IActionResult Delete(int key)
{
AFacilities result = _context.AFacilities.FirstOrDefault(o => o.FacilityCode == key);
_context.AFacilities.Remove(result);
_context.SaveChanges();
return(Json(result, JsonRequestBehavior.AllowGet));
}
//batch update saving CRUDE OPERATION
public IActionResult Update(AFacilities value)
{
AFacilities table = _context.AFacilities.FirstOrDefault(o => o.FacilityCode == value.FacilityCode);
value.updated_at = DateTime.Now;
_context.Entry(table).CurrentValues.SetValues(value);
_context.Entry(table).State = EntityState.Modified;
_context.SaveChanges();
Session["ActivityId"] = value.FacilityCode;
return(Json(value, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Create([Bind("FacilityCode,DeliveryZoneCode,ImplimentingPartnerCode,DistrrictCode,Facility,SapCode,SupportedByMaul,IsAccredited,LevelOfCare,ClientTypeCode,RegionCode,RfsoUserName,OwnershipId,CdcregionId,FacilityTypeId,Longtitude,Latititude,VillageId,ComprehensiveImplimentingPartnerCode,PatientLoadCode,IsActive,NearestPublicHfDistance,Dsdm,ActiveArt")] AFacilities aFacilities)
{
if (ModelState.IsValid)
{
_context.Add(aFacilities);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CdcregionId"] = new SelectList(_context.ACdcregion, "CdcregionId", "CdcregionId", aFacilities.CdcregionId);
ViewData["ClientTypeCode"] = new SelectList(_context.AClientType, "ClientTypeCode", "ClientTypeCode", aFacilities.ClientTypeCode);
ViewData["ComprehensiveImplimentingPartnerCode"] = new SelectList(_context.AImplimentingPartners, "ImplimentingPartnerCode", "ImplimentingPartnerCode", aFacilities.ComprehensiveImplimentingPartnerCode);
ViewData["DeliveryZoneCode"] = new SelectList(_context.ADeliveryZone, "ZoneCode", "ZoneCode", aFacilities.DeliveryZoneCode);
ViewData["DistrrictCode"] = new SelectList(_context.ADistrict, "DistrictCode", "DistrictCode", aFacilities.DistrrictCode);
ViewData["FacilityTypeId"] = new SelectList(_context.AFacilityType, "FacilityTypeId", "FacilityTypeId", aFacilities.FacilityTypeId);
ViewData["LevelOfCare"] = new SelectList(_context.AFacilityLevelOfCare, "LevelOfCareCode", "LevelOfCareCode", aFacilities.LevelOfCare);
ViewData["OwnershipId"] = new SelectList(_context.AOwnership, "OwnershipId", "OwnershipId", aFacilities.OwnershipId);
ViewData["PatientLoadCode"] = new SelectList(_context.APatientLoad, "PatientLoadCode", "PatientLoadCode", aFacilities.PatientLoadCode);
ViewData["VillageId"] = new SelectList(_context.AVillage, "VillageId", "VillageId", aFacilities.VillageId);
return(View(aFacilities));
}
