// GET: SecondaryTechnologies/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SecondaryTechnology secondaryTechnology = db.SecondaryTechnologies.Find(id);
if (secondaryTechnology == null)
{
return(HttpNotFound());
}
return(View(secondaryTechnology));
}
public ActionResult Create([Bind(Include = "SecondaryTechnologyID,SecondaryTech,PrimaryTechnologyID")] SecondaryTechnology secondaryTechnology)
{
if (ModelState.IsValid)
{
if (!db.SecondaryTechnologies.Any(x => x.SecondaryTech == secondaryTechnology.SecondaryTech))
{
db.SecondaryTechnologies.Add(secondaryTechnology);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("SecondaryTechnology", "Duplicate values are not allowed");
ViewBag.PrimaryTechnologyID = new SelectList(db.PrimaryTechnologies, "PrimaryTechnologyID", "PrimaryTech", secondaryTechnology.PrimaryTechnologyID);
return(View());
}
}
ViewBag.PrimaryTechnologyID = new SelectList(db.PrimaryTechnologies, "PrimaryTechnologyID", "PrimaryTech", secondaryTechnology.PrimaryTechnologyID);
return(View(secondaryTechnology));
}
public ActionResult DeleteConfirmed(int id)
{
SecondaryTechnology secondaryTechnology = db.SecondaryTechnologies.Find(id);
if (secondaryTechnology != null)
{
var sessions = db.Sessions.Where(s => s.SecondaryTechnologyID == secondaryTechnology.SecondaryTechnologyID).FirstOrDefault();
if (sessions == null)
{
db.SecondaryTechnologies.Remove(secondaryTechnology);
db.SaveChanges();
}
else
{
ResourceManager rm = new ResourceManager(typeof(ErrorMessages));
ViewBag.showDeleteMsg = rm.GetString("DeleteMsg").Trim('"') + " message: this secondary technology is refrenced to sessions.";
return(View(secondaryTechnology));
}
}
return(RedirectToAction("Index"));
}
public static TechnologiesResponse CreateTechnologiesResponse()
{
TechnologiesResponse techResponse = new TechnologiesResponse();
techResponse.AudienceTypes = new List <AudienceType>();
techResponse.AudienceOrgTypes = new List <AudienceOrg>();
techResponse.SecondaryTechnologies = new List <SecondaryTechnology>();
techResponse.Cities = new List <City>();
using (DbModel.TechReadyDbContext ctx = new DbModel.TechReadyDbContext())
{
var audience = (from c in ctx.AudienceTypes
select c).ToList();
foreach (var ev in audience)
{
try
{
var at = new AudienceType()
{
AudienceTypeId = ev.AudienceTypeID,
AudienceTypeName = ev.TypeOfAudience
};
techResponse.AudienceTypes.Add(at);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
}
}
var audienceOrg = (from c in ctx.AudienceOrgs select c).ToList();
foreach (var at in audienceOrg)
{
try
{
var ao = new AudienceOrg()
{
AudienceOrgId = at.AudienceOrgID,
AudienceTypeName = at.AudienceType1.TypeOfAudience,
AudienceOrgName = at.AudOrg
};
techResponse.AudienceOrgTypes.Add(ao);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
}
}
var stList = (from c in ctx.PrimaryTechnologies
select c).ToList();
foreach (var st in stList)
{
try
{
var dxSt = new SecondaryTechnology()
{
PrimaryTechnologyId = st.PrimaryTechnologyID,
SecondaryTechnologyId = st.PrimaryTechnologyID,
SecondaryTechnologyName = st.PrimaryTech,
PrimaryTechnologyName = st.PrimaryTech
};
techResponse.SecondaryTechnologies.Add(dxSt);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
}
}
var cl = (from c in ctx.Cities
select c).ToList();
foreach (var c in cl)
{
try
{
var dxc = new City()
{
CityName = c.CityName,
};
if (c.Location != null)
{
dxc.Location = new GeoCodeItem()
{
Latitude = c.Location.Latitude,
Longitude = c.Location.Longitude
};
}
techResponse.Cities.Add(dxc);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
}
}
}
return(techResponse);
}
