public ClubsForm()
{
InitializeComponent();
model = new ClubsModel();
InitDataControls();
}
public ActionResult Edit(int Id)
{
ClubsDAO clubsDAO = new ClubsDAO();
ClubsModel clubs = clubsDAO.FetchOne(Id);
return(View("ClubForm", clubs));
}
public ActionResult ProcessCreate(ClubsModel newClub)
{
ClubsDAO clubsDAO = new ClubsDAO();
clubsDAO.CreateOrUpdate(newClub);
return(View("Details", newClub));
}
public ActionResult Details(int Id)
{
ClubsDAO clubsDAO = new ClubsDAO();
ClubsModel clubs = clubsDAO.FetchOne(Id);
return(View("Details", clubs));
}
private void buttonAddClub_Click(object sender, EventArgs e)
{
var model = new ClubsModel();
try
{
model.AddNewClub(textBoxName.Text, textBoxCity.Text, textBoxPrize.Text);
MessageBox.Show("Sikeres mentés!");
}
catch (SwimSocietyDataException)
{
MessageBox.Show("Törléss sikertelen!", "Hiba!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
internal List <ClubsModel> SearchForDescription(string searchPhrase)
{
List <ClubsModel> returnList = new List <ClubsModel>();
//access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM dbo.ClubDetails WHERE Descriptions LIKE @searchForMe";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@searchForMe", System.Data.SqlDbType.NVarChar).Value = "%" + searchPhrase + "%";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//create a new club object. Add it to the list to return.
ClubsModel clubs = new ClubsModel();
clubs.ClubID = reader.GetInt32(0);
clubs.ClubName = reader.GetString(1);
clubs.MeetingDay = reader.GetString(2);
clubs.MeetLink = reader.GetString(3);
clubs.StartTime = reader.GetTimeSpan(4);
clubs.EndTime = reader.GetTimeSpan(5);
clubs.Advisor = reader.GetString(6);
clubs.AdvisorEmail = reader.GetString(7);
clubs.PresName = reader.GetString(8);
clubs.PresEmail = reader.GetString(9);
clubs.Descriptions = reader.GetString(10);
clubs.RoomNo = reader.GetInt32(11);
returnList.Add(clubs);
}
}
}
return(returnList);
}
internal int Delete(int id)
{
//access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "DELETE FROM dbo.ClubDetails WHERE ClubID = @ClubID";
//associate @id with Id parameter
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@ClubID", System.Data.SqlDbType.VarChar, 1000).Value = id;
connection.Open();
int deletedID = command.ExecuteNonQuery();
ClubsModel clubs = new ClubsModel();
return(deletedID);
}
}
//create new
public int CreateOrUpdate(ClubsModel clubModel)
{
//access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "";
if (clubModel.ClubID > 1)
{
sqlQuery = "UPDATE dbo.ClubDetails SET ClubName = @ClubName, MeetingDay = @MeetingDay, MeetLink = @MeetLink,StartTime = @StartTime, EndTime = @EndTime, Advisor = @Advisor, AdvisorEmail = @AdvisorEmail, PresName = @PresName, PresEmail = @PresEmail, Descriptions = @Descriptions, RoomNo = @RoomNo WHERE ClubID = @ClubID";
}
else
{
//create
sqlQuery = "INSERT INTO dbo.ClubDetails Values(@ClubName, @MeetingDay, @MeetLink, @StartTime, @EndTime, @Advisor, @AdvisorEmail, @PresName, @PresEmail, @Descriptions, @RoomNo)";
}
//associate @id with Id parameter
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@ClubID", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.ClubID;
command.Parameters.Add("@ClubName", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.ClubName;
command.Parameters.Add("@MeetingDay", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.MeetingDay;
command.Parameters.Add("@MeetLink", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.MeetLink;
command.Parameters.Add("@StartTime", System.Data.SqlDbType.Time).Value = clubModel.StartTime;
command.Parameters.Add("@EndTime", System.Data.SqlDbType.Time).Value = clubModel.EndTime;
command.Parameters.Add("@Advisor", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.Advisor;
command.Parameters.Add("@AdvisorEmail", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.AdvisorEmail;
command.Parameters.Add("@PresName", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.PresName;
command.Parameters.Add("@PresEmail", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.PresEmail;
command.Parameters.Add("@Descriptions", System.Data.SqlDbType.VarChar, 1000).Value = clubModel.Descriptions;
command.Parameters.Add("@RoomNo", System.Data.SqlDbType.Int).Value = clubModel.RoomNo;
connection.Open();
int newID = command.ExecuteNonQuery();
ClubsModel clubs = new ClubsModel();
return(newID);
}
}
//performs all database operations
public List <ClubsModel> FetchAll()
{
List <ClubsModel> returnList = new List <ClubsModel>();
//access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM dbo.ClubDetails";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//create a new club object. Add it to the list to return.
ClubsModel clubs = new ClubsModel();
clubs.ClubID = reader.GetInt32(0);
clubs.ClubName = reader.GetString(1);
clubs.MeetingDay = reader.GetString(2);
clubs.MeetLink = reader.GetString(3);
clubs.StartTime = reader.GetTimeSpan(4);
clubs.EndTime = reader.GetTimeSpan(5);
clubs.Advisor = reader.GetString(6);
clubs.AdvisorEmail = reader.GetString(7);
clubs.PresName = reader.GetString(8);
clubs.PresEmail = reader.GetString(9);
clubs.Descriptions = reader.GetString(10);
clubs.RoomNo = reader.GetInt32(11);
returnList.Add(clubs);
}
}
}
return(returnList);
}
public ClubsModel FetchOne(int Id)
{
//access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM dbo.ClubDetails WHERE ClubID = @Id";
//associate @id with Id parameter
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = Id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
ClubsModel clubs = new ClubsModel();
if (reader.Read())
{
if (reader.HasRows)
{
clubs.ClubID = reader.GetInt32(0);
clubs.ClubName = reader.GetString(1);
clubs.MeetingDay = reader.GetString(2);
clubs.MeetLink = reader.GetString(3);
clubs.StartTime = reader.GetTimeSpan(4);
clubs.EndTime = reader.GetTimeSpan(5);
clubs.Advisor = reader.GetString(6);
clubs.AdvisorEmail = reader.GetString(7);
clubs.PresName = reader.GetString(8);
clubs.PresEmail = reader.GetString(9);
clubs.Descriptions = reader.GetString(10);
clubs.RoomNo = reader.GetInt32(11);
}
}
return(clubs);
}
}
