private void doCrud(conference c)
{
switch (currentCrudOp)
{
// create
case CrudOpr.Create:
if (crud.create(c) != null)
{
MessageBox.Show("Conference was added!");
this.Close();
}
else
{
MessageBox.Show("Adding was denied");
}
break;
case CrudOpr.Update:
c.conferenceId = formDTO.obj.conferenceId;
if (crud.updateWithCountry(c, newCountry))
{
MessageBox.Show("Conference was updated!");
this.Close();
}
else
{
MessageBox.Show("Updating was denied");
}
break;
}
}
public void Update(conference entity)
{
_iConnection.ExecuteScalar <conference>(
"UPDATE conference SET author=@author, editor=@editor, booktitle=@booktitle, entrytype=@entrytype, bibtexkey=@bibtexkey," +
"month=@month, note=@note, pages=@pages, series=@series, address=@address, organization=@organization," +
"publisher=@publisher, title=@title, volume=@volume, year=@year where ID = @ID", new
{
entity.editor,
entity.booktitle,
entity.entrytype,
entity.bibtexkey,
entity.author,
entity.month,
entity.note,
entity.pages,
entity.title,
entity.volume,
entity.year,
entity.ID,
entity.series,
entity.address,
entity.organization,
entity.publisher,
});
}
private void Add_Button_Click(object sender, RoutedEventArgs e)
{
MainWindow main = Application.Current.Windows.OfType <MainWindow>().First();
conference _conference = new conference()
{
bibtexkey = bibtexkey_Txt.Text,
title = title_Txt.Text,
year = year_Txt.Text != "" ? Convert.ToInt32(year_Txt.Text) : null as int?,
series = series_Txt.Text != "" ? Convert.ToInt32(series_Txt.Text) : null as int?,
month = month_Txt.Text != "" ? Convert.ToInt32(month_Txt.Text) : null as int?,
volume = volume_Txt.Text != "" ? Convert.ToInt32(volume_Txt.Text) : null as int?,
author = author_Txt.Text,
address = address_Txt.Text,
pages = pages_Txt.Text,
note = note_Txt.Text,
booktitle = bookTitle_Txt.Text,
organization = organization_Txt.Text,
publisher = publisher_Txt.Text,
editor = editor_Txt.Text,
entrytype = GetEntryType.GetValueByEnum(GetEntryType.EntryType.Conference)
};
bool result = AllFieldEmpty();
if (!result)
{
_iConferenceService.Add(_conference);
SetFieldClear();
UIElement parent = App.Current.MainWindow;
parent.IsEnabled = true;
main.DataGridMain.ItemsSource = GetEntryType.GetAllByTypes();
this.Close();
}
else
{
if (MessageBox.Show("Are you Sure to create a empty .bib", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
//do no stuff
return;
}
else
{
_iConferenceService.Add(_conference);
SetFieldClear();
main.DataGridMain.ItemsSource = GetEntryType.GetAllByTypes();
UIElement parent = App.Current.MainWindow;
parent.IsEnabled = true;
this.Close();
//do yes stuff
}
}
}
private void OkButton_Click(object sender, EventArgs e)
{
conference c = new conference();
if (checkData())
{
c.conferenceName = conferenceDTO.name;
c.address = conferenceDTO.address;
c.date = conferenceDTO.date;
c.address = conferenceDTO.address;
doCrud(c);
}
}
public ComboBox addConferences(ComboBox cb)
{
conference all = new conference();
all.conferenceName = "all";
all.conferenceId = 0;
List <conference> confs = new List <conference>();
confs.Add(all);
confs.AddRange(db.conferences.ToList());
cb.DataSource = confs;
return(cb);
}
private void initDataForUpdate(conference obj)
{
tbConferenceName.Text = obj.conferenceName;
cbCountry.Text = obj.address1.country1.code;
cbAddress.Text = obj.address1.address1;
dateTimePicker.Value = obj.date;
if (!(formDTO.userData.userRole == UserRole.ADMIN ||
formDTO.userData.userRole == UserRole.CONFERENCE_MANAGER))
{
}
else
{
}
}
public ActionResult SHOW_CONFERENCE_HALL(int id)
{
//DataTable dt = new DataTable();
//using (SqlConnection con = new SqlConnection(connectionstring))
//{
// con.Open();
// string query = "Select * from hotel where CityId = @id";
// SqlDataAdapter ada = new SqlDataAdapter(query, con);
// ada.Fill(dt);
// con.Close();
//}
conference conferencemodel = new conference();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(connectionstring))
{
con.Open();
string query = "Select * from conference where HotelId = @HotelId";
SqlDataAdapter ada = new SqlDataAdapter(query, con);
ada.SelectCommand.Parameters.AddWithValue("@HotelId", id);
ada.Fill(dt);
con.Close();
}
if (dt.Rows.Count == 1)
{
conferencemodel.HallId = Convert.ToInt32(dt.Rows[0][0].ToString());
//conferencemodel.CityName = dt.Rows[0][1].ToString();
//conferencemodel.HallName = dt.Rows[0][2].ToString();
//conferencemodel.facilities = dt.Rows[0][3].ToString();
//conferencemodel.capacity = Convert.ToInt32(dt.Rows[0][6].ToString());
//conferencemodel.budget = Convert.ToInt32(dt.Rows[0][9].ToString());
//conferencemodel.address = dt.Rows[0][10].ToString();
return(View(conferencemodel));
}
else
{
return(View());
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
conference c = new conference();
c.conferenceId = Convert.ToInt32(dataGridView1.CurrentRow.Cells["conferenceId"].Value);
// updating
if (e.ColumnIndex == 5)
{
formDTO.op = CrudOpr.Update;
conference findConf = dataFormDTO.db.conferences.Find(c.conferenceId);
formDTO.obj = findConf;
CreateUpdateConferenceForm form = new CreateUpdateConferenceForm(this, formDTO);
form.Show();
}
// deleting
if (e.ColumnIndex == 6)
{
// Запрашиваем подтверждение
string message = "Do you want to delete?";
string caption = "Y/n";
var result = MessageBox.Show(message, caption,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
// deleting
if (conferenceCrud.delete(c))
{
MessageBox.Show("Conference was deleted!");
resetData();
}
else
{
MessageBox.Show("Deleting was denied");
}
}
}
}
public void Add(conference entity)
{
_iConnection.ExecuteScalar <conference>(
"INSERT INTO conference (editor, booktitle, author, month, note, pages, title, volume, year, address," +
" bibtexkey, entrytype, series, organization, publisher) VALUES( @editor, @booktitle, @author, @month, @note, @pages, @title," +
" @volume, @year, @address, @bibtexkey, @entrytype, @series, @organization, @publisher)", new
{
entity.entrytype,
entity.bibtexkey,
entity.editor,
entity.booktitle,
entity.author,
entity.month,
entity.note,
entity.pages,
entity.title,
entity.volume,
entity.year,
entity.series,
entity.address,
entity.organization,
entity.publisher,
});
}
private void cbConference_SelectedIndexChanged(object sender, EventArgs e)
{
conference c = (conference)cbConference.SelectedItem;
filter.conference = c.conferenceId;
}
private void cbConference_SelectedIndexChanged(object sender, EventArgs e)
{
conference c = (conference)cbConference.SelectedItem;
participantDTO.conference = c.conferenceId;
}
public ConferenceView()
{
_iConferenceService = InstanceFactory.GetInstance <DapperConferenceDal>();
InitializeComponent();
DataContext = new conference();
}
