public bool UpdateDisplayWeeks(DisplayWeeks displayWeek)
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "SP_UpdatesDisplayWeek";
sqlCommand.Parameters.AddWithValue("@weekName", displayWeek.WeekName);
sqlCommand.Parameters.AddWithValue("@displayWeeksID", displayWeek.DisplayWeeksID);
try
{
if (sqlConnection.State != ConnectionState.Open)
{
sqlConnection.ConnectionString = connectionPath;
sqlConnection.Open();
}
return(sqlCommand.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
var errorMessage = $"An error has occurred during deletion: {ex}";
return(false);
}
finally
{
sqlConnection.Close();
}
}
public object SelectDisplayWeeks(DisplayWeeks displayWeek)
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "SP_SelectsDisplayWeek";
sqlCommand.Parameters.AddWithValue("@displayWeeksID", displayWeek.DisplayWeeksID);
try
{
if (sqlConnection.State != ConnectionState.Open)
{
sqlConnection.ConnectionString = connectionPath;
sqlConnection.Open();
}
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dtSelectDisplayWeeks = new DataTable();
sqlDataAdapter.Fill(dtSelectDisplayWeeks);
return(dtSelectDisplayWeeks);
}
catch (Exception ex)
{
var errorMessage = $"An error has occurred during deletion: {ex}";
return(false);
}
finally
{
sqlConnection.Close();
}
}
public bool DeletesDisplayWeeks(DisplayWeeks displayWeek)
{
if (displayWeek.DisplayWeeksID <= 0)
{
return(false);
}
return(displayWeeksManagement.DeleteDisplayWeeks(displayWeek));
}
private void btnSelectsWeek_Click(object sender, EventArgs e)
{
DisplayWeeks displayWeek = new DisplayWeeks
{
DisplayWeeksID = Convert.ToInt32(txtSelectsWeek.Text.Trim())
};
DisplayWeeksManagement displayWeeksManagement = new DisplayWeeksManagement();
dtListDisplayWeeks.DataSource = displayWeeksManagement.SelectDisplayWeeks(displayWeek);
}
public bool InsertsDisplayWeeks(DisplayWeeks displayWeek)
{
if (string.IsNullOrWhiteSpace(displayWeek.WeekName))
{
return(false);
}
if (displayWeek.WeekName.Length > 20)
{
return(false);
}
return(displayWeeksManagement.InsertDisplayWeeks(displayWeek));
}
public bool UpdatesDisplayWeeks(DisplayWeeks displayWeek)
{
if (string.IsNullOrWhiteSpace(displayWeek.WeekName))
{
return(false);
}
if (displayWeek.WeekName.Length > 20)
{
return(false);
}
if (displayWeek.DisplayWeeksID <= 0)
{
return(false);
}
return(displayWeeksManagement.UpdateDisplayWeeks(displayWeek));
}
private void btnDeleteWeek_Click(object sender, EventArgs e)
{
DisplayWeeks displayWeek = new DisplayWeeks
{
DisplayWeeksID = Convert.ToInt32(txtDeleteWeek.Text.Trim())
};
DisplayWeeksController displayWeeksController = new DisplayWeeksController();
bool IsWeekDeleted = displayWeeksController.DeletesDisplayWeeks(displayWeek);
if (IsWeekDeleted)
{
string successMessage = "Hafta silme başarılı.";
MessageBox.Show(successMessage);
}
else
{
string failMessage = "Hafta silme başarısız.";
MessageBox.Show(failMessage);
}
}
private void btnInsertWeek_Click(object sender, EventArgs e)
{
DisplayWeeks displayWeek = new DisplayWeeks
{
WeekName = txtInsertWeek.Text.Trim()
};
DisplayWeeksController displayWeeksController = new DisplayWeeksController();
bool IsWeekInserted = displayWeeksController.InsertsDisplayWeeks(displayWeek);
if (IsWeekInserted)
{
string successMessage = "Hafta ekleme başarılı.";
MessageBox.Show(successMessage);
}
else
{
string failMessage = "Hafta ekleme başarısız.";
MessageBox.Show(failMessage);
}
}
private void btnUpdateWeek_Click(object sender, EventArgs e)
{
DisplayWeeks displayWeek = new DisplayWeeks
{
WeekName = txtUpdateWeekName.Text.Trim(),
DisplayWeeksID = Convert.ToInt32(txtDisplayWeeksIDToBeUpdated.Text.Trim())
};
DisplayWeeksController displayWeeksController = new DisplayWeeksController();
bool IsWeekUpdated = displayWeeksController.UpdatesDisplayWeeks(displayWeek);
if (IsWeekUpdated)
{
string successMessage = "Hafta güncelleme başarılı.";
MessageBox.Show(successMessage);
}
else
{
string failMessage = "Hafta güncelleme başarısız.";
MessageBox.Show(failMessage);
}
}
