public static List <cities> List()
{
List <cities> citiesList = new List <cities>();
SqlConnection connection = plansoni_webstoreData.GetConnection();
String selectProcedure = "[users_citiesSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
cities cities = new cities();
while (reader.Read())
{
cities = new cities();
cities.Name = System.Convert.ToString(reader["Name"]);
cities.CountryId = Convert.ToInt32(reader["CountryId"]);
citiesList.Add(cities);
}
reader.Close();
}
catch (SqlException)
{
return(citiesList);
}
finally
{
connection.Close();
}
return(citiesList);
}
public void setCity(bool set, cities size)
{
hasCity = cities.NONE;
if (set)
{
switch (size)
{
case cities.SMALL:
buildingLayer.GetComponent <Renderer>().material = sCity;
hasCity = cities.SMALL;
break;
case cities.MEDIUM:
buildingLayer.GetComponent <Renderer>().material = mCity;
hasCity = cities.MEDIUM;
break;
case cities.LARGE:
buildingLayer.GetComponent <Renderer>().material = lCity;
hasCity = cities.LARGE;
break;
}
buildingLayer.SetActive(true);
}
else
{
buildingLayer.SetActive(false);
}
}
protected void UploadButton_Click(object sender, EventArgs e)
{
try
{
string csvPath = Server.MapPath("~/Files/") + Path.GetFileName(FileUploader.PostedFile.FileName);
FileUploader.SaveAs(csvPath);
//string CSVFile = "cities.csv";
List <string> rowData = new List <string>();
string csvData = File.ReadAllText(csvPath);
foreach (string row in csvData.Split('\n'))
{
if (!string.IsNullOrEmpty(row))
{
foreach (string cell in row.Split(','))
{
rowData.Add(cell);
}
cities tempCity = new cities();
tempCity.LatD = rowData[0];
tempCity.LatM = rowData[1];
tempCity.LatS = rowData[2];
tempCity.NS = rowData[3];
tempCity.LonD = rowData[4];
tempCity.LonM = rowData[5];
tempCity.LonS = rowData[6];
tempCity.EW = rowData[7];
tempCity.CityName = rowData[8];
tempCity.cityState = rowData[9];
db.Cities.Add(tempCity);
db.SaveChanges();
tempCity = null;
rowData.Clear();
}
else
{
break;
}
}
}
catch (System.IO.IOException)
{
Server.Transfer("Default.aspx", true);
}
}
public ActionResult Create(string id)
{
var modell = new cities();
var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Basic).Structure_Code;
var modelll = dbcontext.cities.ToList();
var Code = "";
if (modelll.Count() == 0)
{
Code = stru + "1";
}
else
{
Code = stru + (modelll.LastOrDefault().ID + 1).ToString();
}
ViewBag.country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.area = new List <Area>();
ViewBag.state = new List <the_states>();
ViewBag.ter = new List <Territories>();
if (id != null)
{
var ID = int.Parse(id);
var county = dbcontext.Territories.FirstOrDefault(m => m.ID == ID);
var model = new cities {
Code = Code,
Territories = county, Territoriesid = county.ID.ToString(), stateid = county.the_states.ID, areaid = int.Parse(county.the_states.Areaid), countryid = int.Parse(county.the_states.Area.Countryid)
};
if (model.countryid > 0)
{
ViewBag.area = dbcontext.Area.Where(m => m.Countryid == model.countryid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
if (model.areaid > 0)
{
ViewBag.state = dbcontext.the_states.Where(m => m.Areaid == model.areaid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
if (model.stateid > 0)
{
ViewBag.ter = dbcontext.Territories.Where(m => m.the_statesid == model.stateid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
return(View(model));
}
var mmodel = new cities();
mmodel.Code = Code;
return(View(mmodel));
}
public JsonResult getCity()
{//this func goes over the fans table and makes a list of the fans cities
List <cities> address = new List <cities>();
foreach (var item in db.Fans)
{
cities place = new cities();
if (!String.IsNullOrEmpty(item.City))
{
place.addr = item.City;
address.Add(place);
}
}
return(Json(address, JsonRequestBehavior.AllowGet));
}
public string GetCities(String ConsumerKey, String ConsumerSecret)
{
cities objCities = new cities();
try
{
Connection = new SqlConnection(ConnectionString);
command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_WebAPI_GetCities";
command.Parameters.Add("@ConsumerKey", SqlDbType.VarChar).Value = ConsumerKey;
command.Parameters.Add("@ConsumerSecret", SqlDbType.VarChar).Value = ConsumerSecret;
command.Connection = Connection;
Connection.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
objCities.Add(new city(int.Parse(item["id"].ToString()), item["name"].ToString()));
}
}
Connection.Close();
}
catch (Exception ex)
{
// throw new System.Web.Http.HttpResponseException(HttpStatusCode.Forbidden);
throw ex;
}
finally
{
if (Connection.State == ConnectionState.Open)
Connection.Close();
}
return objCities.ToString();
}
public ActionResult Create(cities model, string command)
{
ViewBag.country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
ViewBag.area = new List <Area>();
ViewBag.state = new List <the_states>();
ViewBag.ter = new List <Territories>();
if (model.countryid > 0)
{
ViewBag.area = dbcontext.Area.Where(m => m.Countryid == model.countryid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
if (model.areaid > 0)
{
ViewBag.state = dbcontext.the_states.Where(m => m.Areaid == model.areaid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
if (model.stateid > 0)
{
ViewBag.ter = dbcontext.Territories.Where(m => m.the_statesid == model.stateid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID });
}
try
{
if (model.Territoriesid == "0")
{
ModelState.AddModelError("", HR.Resource.Basic.countyCodemustenter11);
return(View(model));
}
cities record = new cities();
record.Name = model.Name;
record.areaid = model.areaid;
record.stateid = model.stateid;
record.Territoriesid = model.Territoriesid;
record.countryid = model.countryid;
var ID = int.Parse(model.Territoriesid);
record.Territories = dbcontext.Territories.FirstOrDefault(m => m.ID == ID);
record.Description = model.Description;
record.Code = model.Code;
//var the_statesid = int.Parse(model.the_statesid);
//record.the_states = dbcontext.the_states.FirstOrDefault(m => m.ID == the_statesid);
var city = dbcontext.cities.Add(record);
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("city", HR.Models.user.Action.Create, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
if (command == "Submit")
{
return(RedirectToAction("Create", "Postalcode", new { id = city.ID }));
}
return(RedirectToAction("Index"));
}
catch (DbUpdateException)
{
TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists;
return(View(model));
}
catch (Exception e)
{
return(View(model));
}
}
public void setCity(bool set, cities size)
{
hasCity = cities.NONE;
if (set)
{
switch (size)
{
case cities.SMALL:
buildingLayer.GetComponent<Renderer>().material = sCity;
hasCity = cities.SMALL;
break;
case cities.MEDIUM:
buildingLayer.GetComponent<Renderer>().material = mCity;
hasCity = cities.MEDIUM;
break;
case cities.LARGE:
buildingLayer.GetComponent<Renderer>().material = lCity;
hasCity = cities.LARGE;
break;
}
buildingLayer.SetActive(true);
}
else
{
buildingLayer.SetActive(false);
}
}
public Emp() //Default Constructor
{
eid = 2000000000;
ename = "Kavin";
location = cities.Bangalore;
}