public CityEdit(VisitaJayaPerkasa.Entities.City city)
{
InitializeComponent();
this.city = city;
if (city == null)
{
wantToCreateCity = true;
}
else
{
wantToCreateCity = false;
etCityCode.Text = city.CityCode;
etCityName.Text = city.CityName;
etDays.Text = city.Days.ToString();
}
}
public List<City> GetCity()
{
List<City> listCity = null;
try
{
using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString))
{
Constant.VisitaJayaPerkasaApplication.anyConnection = false;
con.Open();
Constant.VisitaJayaPerkasaApplication.anyConnection = true;
using (SqlCommand command = new SqlCommand(
"SELECT city_id, city_code, city_name, days FROM [City] " +
"WHERE (deleted is null OR deleted = '0') " +
"ORDER BY city_name ASC"
, con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
City city = new City();
city.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString());
city.CityCode = reader.GetString(1);
city.CityName = reader.GetString(2);
city.Days = reader.GetInt32(3);
if (listCity == null)
listCity = new List<City>();
listCity.Add(city);
city = null;
}
}
}
}
catch (Exception e)
{
Logging.Error("SqlCityRepository.cs - GetCity() " + e.Message);
}
return listCity;
}
public City GetCityByID(String cityID)
{
City city = null;
try
{
using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString))
{
Constant.VisitaJayaPerkasaApplication.anyConnection = false;
con.Open();
Constant.VisitaJayaPerkasaApplication.anyConnection = true;
using (SqlCommand command = new SqlCommand(
"SELECT TOP 1 city_id, city_code, city_name, days, deleted FROM [City] " +
"WHERE city_id = '" + cityID + "'"
, con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
city = new City();
city.ID = reader.GetGuid(0);
city.CityCode = reader.GetString(1);
city.CityName = reader.GetString(2);
city.Days = reader.GetInt32(3);
if (!Utility.Utility.IsDBNull(reader.GetValue(4)))
city.Deleted = (Boolean.Parse(reader.GetValue(4).ToString())) ? 1 : 0;
else
city.Deleted = 0;
}
}
}
}
catch (Exception e)
{
Logging.Error("SqlCityRepository.cs - GetCityByID() " + e.Message);
}
return city;
}
public List<City> ListCitySupplier(Guid ID)
{
List<City> listCitySupplier = null;
try
{
using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString))
{
Constant.VisitaJayaPerkasaApplication.anyConnection = false;
con.Open();
Constant.VisitaJayaPerkasaApplication.anyConnection = true;
using (SqlCommand command = new SqlCommand(
"SELECT city_id, city_name FROM [City], [Supplier_Destination] WHERE " +
"city_id = destination_id And supplier_id like '" + ID.ToString() + "'", con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (listCitySupplier == null)
listCitySupplier = new List<City>();
City objCity = new City();
objCity.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString());
objCity.CityName = reader.GetValue(1).ToString();
listCitySupplier.Add(objCity);
}
}
}
}
catch (Exception e)
{
Logging.Error("SqlSupplierRepository.cs - ListCitySupplier() " + e.Message);
}
return listCitySupplier;
}
