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)); }