public AddConferenceDistrictModel GetDistrict(int districtId)
{
SqlCommand sqlCommand = _sqlConnection.CreateCommand();
sqlCommand.Connection = _sqlConnection;
sqlCommand.Parameters.AddWithValue("@DistrictId", districtId);
sqlCommand.CommandText = " SELECT DictionaryDistrictId, DictionaryDistrictName, DistrictCode, DictionaryCountryId" +
" FROM DictionaryDistrict" +
" WHERE DictionaryDistrictId = @DistrictId";
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
AddConferenceDistrictModel district = null;
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
district = new AddConferenceDistrictModel
{
DictionaryDistrictId = sqlDataReader.GetInt32("DictionaryDistrictId"),
DictionaryDistrictName = sqlDataReader.GetString("DictionaryDistrictName"),
DistrictCode = sqlDataReader.GetString("DistrictCode"),
DictionaryCountryId = sqlDataReader.GetInt32("DictionaryCountryId")
};
}
}
sqlDataReader.Close();
return(district);
}
public void UpdateConferenceDistrict(AddConferenceDistrictModel conferenceDistrict)
{
var district = _electriccastleContext.DictionaryDistrict.Where(x => x.DictionaryDistrictId == conferenceDistrict.DictionaryDistrictId).FirstOrDefault();
district.DictionaryDistrictName = conferenceDistrict.DictionaryDistrictName;
district.DistrictCode = conferenceDistrict.DistrictCode;
_electriccastleContext.SaveChanges();
}
public void InsertConferenceDistrict(AddConferenceDistrictModel conferenceDistrict)
{
var district = _electriccastleContext.DictionaryDistrict.ToList();
var districts = new DictionaryDistrict {
DictionaryDistrictId = _electriccastleContext.DictionaryDistrict.Max(x => x.DictionaryDistrictId) + 1, DistrictCode = conferenceDistrict.DistrictCode, DictionaryDistrictName = conferenceDistrict.DictionaryDistrictName, DictionaryCountryId = conferenceDistrict.DictionaryCountryId
};
_electriccastleContext.DictionaryDistrict.Add(districts);
_electriccastleContext.SaveChanges();
}
public void InsertConferenceDistrict(AddConferenceDistrictModel conferenceDistrict)
{
try
{
SqlCommand sqlCommand = _sqlConnection.CreateCommand();
sqlCommand.Connection = _sqlConnection;
sqlCommand.Parameters.AddWithValue("@DistrictId", conferenceDistrict.DictionaryDistrictId);
sqlCommand.Parameters.AddWithValue("@DistrictName", conferenceDistrict.DictionaryDistrictName);
sqlCommand.Parameters.AddWithValue("@DistrictCode", conferenceDistrict.DistrictCode);
sqlCommand.Parameters.AddWithValue("@CountryId", conferenceDistrict.DictionaryCountryId);
sqlCommand.CommandText = " INSERT INTO DictionaryDistrict(DictionaryDistrictId," +
" DictionaryDistrictName, DistrictCode, DictionaryCountryId)" +
" VALUES(@DistrictId, @DistrictName, @DistrictCode, @CountryId)";
int rowsAdded = sqlCommand.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
private void NewDistrictForm_Load(object sender, EventArgs e)
{
countries = conferenceCountryRepository.GetConferencesCountry();
CountryComboBox.DataSource = countries;
CountryComboBox.DisplayMember = "DictionaryCountryName";
CountryComboBox.ValueMember = "DictionaryCountryId";
if (DistrictId == null)
{
DistrictId = conferenceDistrictRepository.GetNextId();
DistrictNameTextBox.Text = "";
DistrictCodeTextBox.Text = "";
SaveButton.Click += new EventHandler(AddDistrict);
CountryComboBox.SelectedIndex = 0;
}
else
{
AddConferenceDistrictModel district = conferenceDistrictRepository.GetDistrict((int)DistrictId);
DistrictNameTextBox.Text = district.DictionaryDistrictName;
DistrictCodeTextBox.Text = district.DistrictCode;
SaveButton.Click += new EventHandler(EditDistrict);
CountryComboBox.SelectedValue = district.DictionaryCountryId;
}
}
public void UpdateConferenceDistrict(AddConferenceDistrictModel conferenceDistrict)
{
try
{
SqlCommand sqlCommand = _sqlConnection.CreateCommand();
sqlCommand.Connection = _sqlConnection;
sqlCommand.Parameters.AddWithValue("@DistrictId", conferenceDistrict.DictionaryDistrictId);
sqlCommand.Parameters.AddWithValue("@DistrictName", conferenceDistrict.DictionaryDistrictName);
sqlCommand.Parameters.AddWithValue("@DistrictCode", conferenceDistrict.DistrictCode);
sqlCommand.Parameters.AddWithValue("@CountryId", conferenceDistrict.DictionaryCountryId);
sqlCommand.CommandText = " UPDATE DictionaryDistrict " +
" SET DictionaryDistrictName = @DistrictName," +
" DistrictCode = @DistrictCode," +
" DictionaryCountryId = @CountryId" +
" WHERE DictionaryDistrictId = @DistrictId";
int rowsEdited = sqlCommand.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
public IActionResult UpdateDistrict(AddConferenceDistrictModel conferenceDistrict)
{
_getDistrict.UpdateConferenceDistrict(conferenceDistrict);
return(Ok());
}
public IActionResult InsertCountry(AddConferenceDistrictModel conferenceDistrict)
{
_getDistrict.InsertConferenceDistrict(conferenceDistrict);
return(Ok());
}