public IActionResult Index()
{
DALCity dc = new DALCity(_configuration);
List <City> lc = dc.getCityByName("1");
return(View(lc));
}
public bool InsertCity(City City)
{
AirlineConnect con = new AirlineConnect();
try
{
con.GetConnection();
SqlCommand cmd = new SqlCommand("usp_InsertCity", con.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CityName", City.CityName);
cmd.Parameters.AddWithValue("@CityCode", City.CityCode);
DALCity Dal = new DALCity();
Dal.insert(City);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.CloseConnection();
}
}
public IActionResult SearchTable(City city)
{
DALCity dc = new DALCity(_configuration);
try
{
List <City> lc = dc.getCityByDate(city.Date);
int len = lc.ToArray().Length;
DateTime[] date = new DateTime[len];
int[] confirmed = new int[len];
int[] death = new int[len];
int[] recovery = new int[len];
int[] remained = new int[len];
string[] name = new string[len];
int i = -1;
string strDate = "";
string strCon = "";
string strDeath = "";
string strRecovery = "";
string strRemained = "";
string strName = "";
foreach (City ct in lc)
{
i += 1;
date[i] = ct.Date;
confirmed[i] = ct.ConfirmedNum;
death[i] = ct.Death;
recovery[i] = ct.Recovery;
name[i] = ct.Name;
remained[i] = confirmed[i] - death[i] - recovery[i];
}
/*strDate = String.Join(",", date);
* strCon = String.Join(",", confirmed);
* strDeath = String.Join(",", death);
* strRecovery = String.Join(",", recovery);*/
strRemained = String.Join(",", remained);
strName = String.Join(",", name);
/*ViewBag.dateInfo = strDate;
* ViewBag.confirmedInfo = strCon;
* ViewBag.deathInfo = strDeath;
* ViewBag.recoveryInfo = strRecovery;
* ViewBag.incConfirmed = this.IncrementCalculation(confirmed, len);*/
ViewBag.remainedInfo = strRemained;
ViewBag.cityName = strName;
ViewBag.length = len;
return(View("Index", lc));
}
catch
{
return(View());
}
}
public IActionResult EditCity()
{
int uID = Convert.ToInt32(HttpContext.Session.GetString("uID"));
DALCity dc = new DALCity(_configuration);
City city = dc.getCity(uID);
return(View(city));
}
public IActionResult UpdateCity(City city)
{
int uID = Convert.ToInt32(HttpContext.Session.GetString("uID"));
city.UID = uID;
DALCity dc = new DALCity(_configuration);
dc.updateCity(city);
return(View("Page2", city));
}
public void DrpCityFill()
{
List <ENTSYSCITY> list = DALCity.GetAllListCity();
drpCity.Items.Clear();
drpCity.DataSource = list;
drpCity.DataValueField = "ID";
drpCity.DataTextField = "NAME";
drpCity.Items.Insert(0, new ListItem("Seçiniz", "0"));
drpCity.DataBind();
}
public IActionResult UpdateCityFromTable(City city)
{
int uID = Convert.ToInt32(HttpContext.Session.GetString("uID"));
city.UID = uID;
city.Date = Convert.ToDateTime(HttpContext.Session.GetString("EditDate"));
DALCity dc = new DALCity(_configuration);
dc.updateCity(city);
return(this.SearchTable(city));
}
public IActionResult DeleteCityFromTable()
{
int uID = Convert.ToInt32(HttpContext.Session.GetString("uID"));
City temp = new City();
temp.Name = HttpContext.Session.GetString("CityName");
DALCity dc = new DALCity(_configuration);
dc.deleteCity(uID);
return(this.SearchTable(temp));
}
public IActionResult Edit(int id)
{
int uID = id;
HttpContext.Session.SetString("uID", uID.ToString());
DALCity dc = new DALCity(_configuration);
City city = dc.getCity(uID);
HttpContext.Session.SetString("EditDate", city.Date.ToShortDateString());
HttpContext.Session.SetString("CityName", city.Name);
return(View(city));
}
public IActionResult Page2(City city)
{
//string connStr = _configuration.GetConnectionString("MyConnString");
//Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
DALCity dc = new DALCity(_configuration);
city.Date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
int uID = dc.addCity(city);
//SqlConnection conn = new SqlConnection(connStr);
//conn.Open();
city.UID = uID;
//save the uid to the session
HttpContext.Session.SetString("uID", uID.ToString()); //write to the session
return(View(city));
}
