private void btnSave_Click(object sender, System.Windows.RoutedEventArgs e)
{
try
{
if (lineBackup == null)
{
lineBackup = data.NewProductionLine(line.Name, line.Capacity, line.Efficiency);
line.Id = lineBackup.Id;
}
else
{
data.UpdateProductionLine(line, lineBackup);
lineBackup.Name = line.Name;
lineBackup.Capacity = line.Capacity;
lineBackup.Efficiency = line.Efficiency;
lineBackup.Active = line.Active;
}
}
catch { }
}
public void DeleteProductionLine(ProductionLine line)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
connection.Open();
// delete record from table
DeleteProductionLine(connection, line);
}
}
private void DeleteProductionLine(OracleConnection connection, ProductionLine line)
{
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "delete from tis_vyrobni_linka where vyrobni_linka_id = :1";
cmd.Parameters.Add(GetNumber(":1", line.Id));
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void UpdateProductionLine(ProductionLine newLine, ProductionLine oldLine)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
connection.Open();
// update record in table
UpdateProductionLine(connection, newLine, oldLine);
}
}
public Plan ProductionStart(ProductionLine line)
{
Plan plan = null;
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
connection.Open();
// update record in table
Nullable<int> planId = ProductionStart(connection, line);
if (planId != null)
plan = GetPlan(connection, (int)planId);
}
return plan;
}
public void ProductionEnd(ProductionLine line)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
connection.Open();
// update record in table
ProductionEnd(connection, line);
}
}
public Plan GetProductionLinePlan(ProductionLine line)
{
Plan plan = null;
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
connection.Open();
// select record from table
plan = GetProductionLinePlan(connection, line);
}
return plan;
}
private void UpdateProductionLine(OracleConnection connection, ProductionLine newLine, ProductionLine oldLine)
{
if (newLine.Id != oldLine.Id) // probably different production lines - wrong input
return;
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "update tis_vyrobni_linka set ";
cmd.CommandType = CommandType.Text;
int paramIdx = 1;
paramIdx = AddUpdateField(cmd, "nazev", paramIdx, CheckForInjection(newLine.Name), oldLine.Name);
paramIdx = AddUpdateField(cmd, "kapacita", paramIdx, newLine.Capacity, oldLine.Capacity);
paramIdx = AddUpdateField(cmd, "vykonnost", paramIdx, newLine.Efficiency, oldLine.Efficiency);
paramIdx = AddUpdateField(cmd, "aktivni", paramIdx, newLine.Active, oldLine.Active);
if (paramIdx > 1)
{
cmd.CommandText += " where vyrobni_linka_id = :" + paramIdx.ToString();
cmd.Parameters.Add(GetNumber(":" + paramIdx.ToString(), newLine.Id));
cmd.ExecuteNonQuery();
}
cmd.Dispose();
}
private Nullable<int> ProductionStart(OracleConnection connection, ProductionLine line)
{
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "TIS.vyroba_start";
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter res = cmd.Parameters.Add("result", OracleType.Int32);
res.Direction = ParameterDirection.ReturnValue;
OracleParameter par = cmd.Parameters.Add("p_vyrobni_linka_id", OracleType.Number);
par.Value = line.Id;
cmd.ExecuteNonQuery();
Nullable<int> planId = null;
try
{
planId = Convert.ToInt32(res.Value);
}
catch { }
cmd.Dispose();
return planId;
}
private void ProductionEnd(OracleConnection connection, ProductionLine line)
{
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "TIS.vyroba_konec";
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter par = cmd.Parameters.Add("p_vyrobni_linka_id", OracleType.Number);
par.Value = line.Id;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
private Plan GetProductionLinePlan(OracleConnection connection, ProductionLine line)
{
Plan plan = null;
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "select * from " +
"(select * from tis_plan where vyrobni_linka_id = :1 order by datum_vyroba_start desc)" +
" where rownum = 1";
cmd.Parameters.Add(GetNumber(":1", line.Id));
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Nullable<int> orderId = null;
if (!reader.IsDBNull(2))
orderId = reader.GetInt32(2);
Nullable<DateTime> dateStart = null;
if (!reader.IsDBNull(5))
dateStart = reader.GetDateTime(5);
Nullable<DateTime> dateEnd = null;
if (!reader.IsDBNull(6))
dateEnd = reader.GetDateTime(6);
plan = GetPlan(reader.GetInt32(0), reader.GetInt32(1), orderId, line.Id,
reader.GetDateTime(4), dateStart, dateEnd, reader.GetInt32(7), reader.GetString(8));
plan.ProductionLine = line;
}
cmd.Dispose();
if (plan != null)
{
// get product - musts be new query
plan.Product = GetProduct(connection, plan.ProductId);
// get order - musts be new query
if (plan.OrderId != null)
plan.Order = GetOrder(connection, (int)plan.OrderId);
}
return plan;
}
private void EditLine(ProductionLine editLine)
{
line = new ProductionLine();
if (editLine != null)
{
line.Id = editLine.Id;
line.Name = editLine.Name;
line.Capacity = editLine.Capacity;
line.Efficiency = editLine.Efficiency;
line.Active = editLine.Active;
}
gridEdit.DataContext = line;
}
