//
// GET: /Home/
public ActionResult Home()
{
ProfileEntities db = new ProfileEntities();
ViewBag.Genders = db.Genders.ToList();
ViewBag.Status = db.MaritalStatus.ToList();
var citylist = db.Cities.Where(x => x.StateID == 15).OrderBy(x => x.CityName).ToList();
ViewBag.Cities = citylist;
return(View());
}
public void SaveVisitorDetails(LocationModel iLocation)
{
try
{
ProfileEntities db = new ProfileEntities();
VisitorDeail o = new VisitorDeail();
o = (from context in db.VisitorDeails
where context.IP.ToLower() == iLocation.IP.ToLower()
select context).FirstOrDefault();
if (o == null)
{
o = new VisitorDeail();
o.IP = iLocation.IP;
o.Country_Code = iLocation.Country_Code;
o.Country_Name = iLocation.Country_Name;
o.Region_Code = iLocation.Region_Code;
o.Region_Name = iLocation.Region_Name;
o.City = iLocation.City;
o.Zip_Code = iLocation.Zip_Code;
o.Time_Zone = iLocation.Time_Zone;
o.Latitude = iLocation.Latitude;
o.Longitude = iLocation.Longitude;
o.Metro_Code = iLocation.Metro_Code;
o.CreatedON = DateTime.Now;
o.AccessCount = 1;
o.ModifiedON = DateTime.Now;
db.VisitorDeails.Add(o);
db.SaveChanges();
}
else
{
o.AccessCount = o.AccessCount + 1;
o.ModifiedON = DateTime.Now;
db.SaveChanges();
}
}
catch (Exception)
{
}
}
