public NewDistillationForm()
{
InitializeComponent();
Season season = AdministrationLogic.GetActiveSeason();
Period period = AdministrationLogic.GetActivePeriod();
_distillation = new Distillation
{
StartTime = DateTime.Now,
Date = DateTime.Today.Date,
Payed = false,
Season = season,
Season_Id = season.Id,
Period = period,
Period_Id = period.Id
};
_reqTBs = new List <TextBox>
{
tbAmount,
tbDistVolume,
tbPercAlc
};
materialCB.DataSource = MaterialLogic.GetAllMaterial();
materialCB.DisplayMember = "Name";
tbPeriod.Text = period.Name;
tbSeason.Text = season.Name;
}
private static void PrepareCommand(SqlCommand sqlCom, Distillation distillation)
{
sqlCom.Parameters.AddWithValue("@Id", distillation.Id);
sqlCom.Parameters.AddWithValue("@date", distillation.Date);
sqlCom.Parameters.AddWithValue("@startTime", distillation.StartTime);
sqlCom.Parameters.AddWithValue("@endTime", distillation.EndTime);
sqlCom.Parameters.AddWithValue("@amount", distillation.Amount);
sqlCom.Parameters.AddWithValue("@ethanolPercentage", distillation.EthanolPercentage);
sqlCom.Parameters.AddWithValue("@distilledVolume", distillation.DistilledVolume);
sqlCom.Parameters.AddWithValue("@absoluteAlcoholVolume", distillation.AbsoluteAlcoholVolume);
sqlCom.Parameters.AddWithValue("@price", distillation.Price);
if (distillation.Payed)
{
sqlCom.Parameters.AddWithValue("@payed", 1);
}
else
{
sqlCom.Parameters.AddWithValue("@payed", 0);
}
sqlCom.Parameters.AddWithValue("@Customer_Id", distillation.Customer_Id);
sqlCom.Parameters.AddWithValue("@Material_Id", distillation.Material_Id);
sqlCom.Parameters.AddWithValue("@Season_Id", distillation.Season_Id);
sqlCom.Parameters.AddWithValue("@Period_Id", distillation.Period_Id);
}
private static Collection <Distillation> Read(SqlDataReader reader)
{
Collection <Distillation> distillations = new Collection <Distillation>();
while (reader.Read())
{
Distillation d = new Distillation();
int i = -1;
d.Id = reader.GetInt32(++i);
d.Date = reader.GetDateTime(++i);
d.StartTime = reader.GetDateTime(++i);
d.EndTime = reader.GetDateTime(++i);
d.Amount = reader.GetDouble(++i);
d.EthanolPercentage = reader.GetDouble(++i);
d.DistilledVolume = reader.GetDouble(++i);
d.AbsoluteAlcoholVolume = reader.GetDouble(++i);
d.Price = reader.GetDouble(++i);
d.Payed = reader.GetBoolean(++i);
d.Customer_Id = reader.GetInt32(++i);
d.Material_Id = reader.GetInt32(++i);
d.Season_Id = reader.GetInt32(++i);
d.Period_Id = reader.GetInt32(++i);
distillations.Add(d);
}
return(distillations);
}
public static int Insert(Distillation distillation)
{
using (SqlServerDatabase db = new SqlServerDatabase())
{
SqlCommand sqlCom = db.CreateCommand(SQL_INSERT);
PrepareCommand(sqlCom, distillation);
return(db.ExecuteNonQuery(sqlCom));
}
}
public static bool CanBeDeleted(Distillation distillation)
{
DateTime tenYearsAgo = DateTime.Now.AddYears(-10);
if (distillation.Date <= tenYearsAgo)
{
return(true);
}
return(false);
}
public static int CreateDistillation(Distillation distillation)
{
IDatabase db = Configuration.GetDatabase();
Season season = distillation.Season;
season.DistillationCount += 1;
db.Update(season);
return(db.Insert(distillation));
}
public DistillationDetail(int distillationId)
{
InitializeComponent();
_distillation = DistillationLogic.GetDistillation(distillationId);
}
public static int DeleteDistillation(Distillation distillation)
{
IDatabase db = Configuration.GetDatabase();
return(db.Delete(distillation));
}
