private void FillingCancellationReasons()
{
foreach (CancellationReason cr in CancellationReasonDAL.GetAllCancellationReasons())
{
cbReason.Items.Add(cr.Reason);
}
}
private void btnChange_Click(object sender, EventArgs e)
{
Passenger p = new Passenger();
Station s = new Station();
Driver d = new Driver();
Train t = new Train();
CancellationReason c = new CancellationReason();
if (TableType.Equals(p.GetType()))
{
UpdatePassenger(tbNewValue.Text);
}
if (TableType.Equals(s.GetType()))
{
UpdateStation(tbNewValue.Text);
}
if (TableType.Equals(d.GetType()))
{
UpdateDriver(tbNewValue.Text);
}
if (TableType.Equals(t.GetType()))
{
TrainDAL.UpdateTrainNum(tbNewValue.Text, Id);
}
if (TableType.Equals(c.GetType()))
{
CancellationReasonDAL.UpdateCancellationReason(tbNewValue.Text, Id);
}
}
private void CancellationReasonsFilling()
{
foreach (CancellationReason r in CancellationReasonDAL.GetAllCancellationReasons())
{
listBoxCT.Items.Add(r.Reason);
}
}
private void VisibleReason()
{
lbRTPassport.Text = "Причина";
dgvRT.Columns[0].HeaderText = "Причина";
dgvRT.Columns[0].DataPropertyName = "Reason";
dgvRT.Columns[0].Name = "Reason";
dgvRT.DataSource = CancellationReasonDAL.GetAllCancellationReasons();
}
private void AddReasons()
{
if (String.IsNullOrEmpty(tbRTPassport.Text))
{
MessageBox.Show("Введите причину!");
return;
}
string reason = tbRTPassport.Text;
CancellationReasonDAL.Insert(reason);
dgvRT.DataSource = CancellationReasonDAL.GetAllCancellationReasons();
ClearText();
}
private void updateCancellationReason()
{
string type = dgvRT.SelectedCells[0].OwningColumn.Name;
string value = dgvRT.SelectedCells[0].Value.ToString();
Type typeTable = dgvRT.SelectedCells[0].OwningRow.DataBoundItem.GetType();
int id = (dgvRT.SelectedCells[0].OwningRow.DataBoundItem as CancellationReason).Id_Reason;
fmChangeValueRT f = new fmChangeValueRT(type, value, id, typeTable);
f.Text = dgvRT.SelectedCells[0].OwningColumn.HeaderText;
if (f.ShowDialog() == DialogResult.OK)
{
MessageBox.Show("Значение изменено");
dgvRT.DataSource = CancellationReasonDAL.GetAllCancellationReasons();
}
}
private static List <CanceledTrip> GetTripsListFromDataReader(SqlDataReader reader)
{
List <CanceledTrip> result = new List <CanceledTrip>();
while (reader.Read())
{
CanceledTrip t = new CanceledTrip()
{
Id_CanceledTrip = reader.GetInt32(0),
Reason = CancellationReasonDAL.GetCancellationReasonById(reader.GetInt32(1)).Reason,
Id_id_Trip = reader.GetInt32(2)
};
result.Add(t);
}
return(result);
}
private void DelCancelledTrip()
{
int idCanceledTrip = (dgvCT.SelectedCells[0].OwningRow.DataBoundItem as CanceledTrip).Id_CanceledTrip;
CanceledTripDAL.Delete(idCanceledTrip);
if (listBoxCT.SelectedIndex >= 0)
{
int idReason = CancellationReasonDAL.GetCancellationReasonByReason(CancellationReasonDAL.GetAllCancellationReasons()[listBoxCT.SelectedIndex].Reason).Id_Reason;
dgvCT.DataSource = CanceledTripDAL.GetCancelledTripsByReason(idReason);
}
else
{
dgvCT.DataSource = CanceledTripDAL.GetAllCancelledTrips();
}
MessageBox.Show("Строка удалена");
}
private void btnAddTrips_Click(object sender, EventArgs e)
{
if (!GetReason())
{
return;
}
if (!GetTrip())
{
return;
}
int idReason = CancellationReasonDAL.GetAllCancellationReasons()[cbReason.SelectedIndex].Id_Reason;
int idTrip = TripDAL.GetAllTrips()[cbNumTrip.SelectedIndex].Id_Trip;
CanceledTripDAL.Insert(idReason, idTrip);
DialogResult = DialogResult.OK;
}
private void btnCTAdd_Click(object sender, EventArgs e)
{
fmAddCancelledtrip f = new fmAddCancelledtrip();
if (f.ShowDialog() == DialogResult.OK)
{
MessageBox.Show("Строка добавлена");
if (listBoxCT.SelectedIndex >= 0)
{
int idReason = CancellationReasonDAL.GetAllCancellationReasons()[listBoxCT.SelectedIndex].Id_Reason;
dgvCT.DataSource = CanceledTripDAL.GetCancelledTripsByReason(idReason);
}
else
{
dgvCT.DataSource = CanceledTripDAL.GetAllCancelledTrips();
}
}
}
public fmChangeCancelledTrip(string TypeV, string Value, int id)
{
InitializeComponent();
Type = TypeV;
Id = id;
tbValue.Text = Value;
if (Type == CancelledTripConst.Id_canTrip)
{
foreach (Trip tr in TripDAL.GetAllTrips())
{
cbNewV.Items.Add(tr.Id_Trip);
}
}
else
{
foreach (CancellationReason cr in CancellationReasonDAL.GetAllCancellationReasons())
{
cbNewV.Items.Add(cr.Reason);
}
}
}
private void btnChange_Click_1(object sender, EventArgs e)
{
string txt = cbNewV.Text;
int idNewV = Type == CancelledTripConst.Id_canTrip ? int.Parse(txt.Trim()): CancellationReasonDAL.GetCancellationReasonByReason(txt).Id_Reason;
UpdateCancelledTrip(idNewV);
}
private void DelCancellationReason(int id)
{
CancellationReasonDAL.Delete(id);
dgvRT.DataSource = CancellationReasonDAL.GetAllCancellationReasons();
}
private void listBoxCT_SelectedIndexChanged(object sender, EventArgs e)
{
int idReason = CancellationReasonDAL.GetCancellationReasonByReason(CancellationReasonDAL.GetAllCancellationReasons()[listBoxCT.SelectedIndex].Reason).Id_Reason;
dgvCT.DataSource = CanceledTripDAL.GetCancelledTripsByReason(idReason);
}
