public LandingSite(string id, string landingSiteName, Waypoint waypoint, Municipality municipality)
{
LandingSiteID = id;
LandingSiteName = landingSiteName;
Waypoint = waypoint;
Municipality = municipality;
}
public void AddRecordToRepo(Municipality m)
{
if (m == null)
{
throw new ArgumentNullException("Error: The argument is Null");
}
MunicipalityCollection.Add(m);
}
public override string ToString()
{
if (Municipality != null)
{
return($"{LandingSiteName}, {Municipality.ToString()}");
}
else
{
return($"{LandingSiteName}");
}
}
public bool Add(Municipality m)
{
bool success = false;
using (OleDbConnection conn = new OleDbConnection(Global.ConnectionString))
{
conn.Open();
var sql = $@"Insert into Municipalities(ProvNo, MunNo, MunicipalityName, xCoord, yCoord, IsCoastal)
Values
({m.Province.ProvinceID}, {m.MunicipalityID}, '{m.MunicipalityName}', {m.Longitude}, {m.Latitude}, {m.IsCoastal})";
using (OleDbCommand update = new OleDbCommand(sql, conn))
{
success = update.ExecuteNonQuery() > 0;
}
}
return(success);
}
public void UpdateRecordInRepo(Municipality m)
{
if (m.MunicipalityID == 0)
{
throw new Exception("Error: ID cannot be zero");
}
int index = 0;
while (index < MunicipalityCollection.Count)
{
if (MunicipalityCollection[index].MunicipalityID == m.MunicipalityID)
{
MunicipalityCollection[index] = m;
break;
}
index++;
}
}
public bool Update(Municipality m)
{
bool success = false;
using (OleDbConnection conn = new OleDbConnection(Global.ConnectionString))
{
conn.Open();
var sql = $@"Update Municipalities set
ProvNo = {m.Province.ProvinceID},
MunicipalityName='{m.MunicipalityName}',
xCoord = {m.Longitude},
yCoord = {m.Latitude},
IsCoastal = {m.IsCoastal}
WHERE MunNo = {m.MunicipalityID}";
using (OleDbCommand update = new OleDbCommand(sql, conn))
{
success = update.ExecuteNonQuery() > 0;
}
}
return(success);
}
private List <Municipality> getMunicipalities()
{
List <Municipality> listMunicipalities = new List <Municipality>();
var dt = new DataTable();
using (var conection = new OleDbConnection(Global.ConnectionString))
{
try
{
conection.Open();
string query = $"Select * from Municipalities";
var adapter = new OleDbDataAdapter(query, conection);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
listMunicipalities.Clear();
foreach (DataRow dr in dt.Rows)
{
Municipality m = new Municipality();
m.Province = BSCEntities.ProvinceViewModel.GetProvince(Convert.ToInt32(dr["ProvNo"]));
m.MunicipalityID = (int)dr["MunNo"];
m.MunicipalityName = dr["MunicipalityName"].ToString();
m.Latitude = (Double)dr["yCoord"];
m.Longitude = (double)dr["xCoord"];
m.IsCoastal = (bool)dr["IsCoastal"];
listMunicipalities.Add(m);
}
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
return(listMunicipalities);
}
}
public bool EntityValidated(Municipality m, out List <string> messages, bool isNew = false, string oldName = "")
{
messages = new List <string>();
if (m.MunicipalityName.Length < 3)
{
messages.Add("Municipality name must be at least 3 characters long");
}
if (isNew && m.MunicipalityName.Length > 0 && MunicipalityNameExists(m.Province, m.MunicipalityName))
{
messages.Add("Municipality name already used");
}
if (!isNew && m.MunicipalityName.Length > 0 &&
oldName != m.MunicipalityName &&
MunicipalityNameExists(m.Province, m.MunicipalityName))
{
messages.Add("Municipality name already used");
}
return(messages.Count == 0);
}
public bool CanDeleteEntity(Municipality m)
{
return(false);
}
