public static void Add(RecieptForReturn recieptForReturn, Reciept reciept)
{
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("AddRecieptForReturn");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@idReciept", reciept.Id);
command.Parameters.AddWithValue("@idTransport", reciept.Transport.Id);
command.Parameters.AddWithValue("@idParking", recieptForReturn.Parking.Id);
command.Parameters.AddWithValue("@creationDate", recieptForReturn.CreationDate);
command.Parameters.Add(new SqlParameter("@idRecieptForReturn", SqlDbType.Int));
command.Parameters["@idRecieptForReturn"].Direction = ParameterDirection.Output;
connection.Open();
command.ExecuteNonQuery();
recieptForReturn.Id = (int)command.Parameters["@idRecieptForReturn"].Value;
if (recieptForReturn.FineReciept != null)
{
FineRecieptDAO.Add(recieptForReturn);
}
}
}
private RecieptForReturn CreateRecieptForReturn()
{
RecieptForReturn recieptForReturn = new RecieptForReturn();
recieptForReturn.Parking = (Parking)ctlParkings.SelectedItem;
recieptForReturn.CreationDate = ctlCreationDate.Value;
return(recieptForReturn);
}
private void btnEnterFine_Click(object sender, EventArgs e)
{
RecieptForReturn recieptForReturn = CreateRecieptForReturn();
FineReciept fineReciept = CreateFineReciept();
recieptForReturn.FineReciept = fineReciept;
RecieptForReturnDAO.Add(recieptForReturn, reciept);
DialogResult = DialogResult.OK;
this.Close();
}
public static void Add(RecieptForReturn recieptForReturn)
{
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("AddFineReciept");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@idRecieptForReturn", recieptForReturn.Id);
command.Parameters.AddWithValue("@fine", recieptForReturn.FineReciept.Fine);
command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int));
command.Parameters["@id"].Direction = ParameterDirection.Output;
connection.Open();
command.ExecuteNonQuery();
recieptForReturn.FineReciept.Id = (int)command.Parameters["@id"].Value;
}
}
private void btnEnter_Click(object sender, EventArgs e)
{
if (ctlCreationDate.Value > reciept.NecessaryReturnDate)
{
gbFine.Visible = true;
TimeSpan interval = ctlCreationDate.Value - reciept.NecessaryReturnDate;
txtInterval.Text = Math.Round(interval.TotalHours).ToString();
txtFine.Text = CalculateFine(interval, reciept).ToString();
}
else
{
RecieptForReturn recieptForReturn = CreateRecieptForReturn();
RecieptForReturnDAO.Add(recieptForReturn, reciept);
DialogResult = DialogResult.OK;
this.Close();
}
}
public static RecieptForReturn GetRecieptForReturnById(int id)
{
if (id == 0)
{
return(null);
}
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetRecieptForReturnById");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
RecieptForReturn recieptForReturn = new RecieptForReturn();
recieptForReturn.Id = int.Parse(reader["ID_КвОВозврате"].ToString());
int idParking = int.Parse(reader["Парковка"].ToString());
recieptForReturn.CreationDate = DateTime.Parse(reader["ДатаОформления"].ToString());
if (!string.IsNullOrEmpty(reader["ID_КвШтраф"].ToString()))
{
recieptForReturn.FineReciept = new FineReciept(int.Parse(reader["ID_КвШтраф"].ToString()),
double.Parse(reader["Штраф"].ToString()));
}
recieptForReturn.Parking = ParkingDAO.GetParkingById(idParking);
return(recieptForReturn);
}
}
}
return(null);
}