public PlanEntry(IUnityContainer container, UIState state, Plan plan) : this() { this.container = new PlanContainer(container, state, plan); binding = new BindingSource(); binding.AddingNew += Binding_AddingNew; }
public PlanContainer(IUnityContainer container, UIState state, long id) : this(container, state) { if (state == UIState.New) { Entity = new Plan(); } else { QueryPlanById(id); } }
public PlanContainer(IUnityContainer container, UIState state, Plan plan) : this(container, state) { if (state == UIState.New) { Entity = new Plan(); } else { this.Entity = plan; } }
public bool Add(Plan t) { PlanHeader header = t.Header; IList<PlanLine> lines = t.Lines; header.CreatedBy = "admin"; header.UpdatedBy = "admin"; header.CreatedDateTime = DateTime.Now; header.UpdatedDateTime = DateTime.Now; IDALT dbHelper2 = containier.Resolve<IDALT>(); try { dbHelper2.Open(); SQLiteParameter[] parameters = new SQLiteParameter[]{ new SQLiteParameter("@PRODUCTID",header.ProductId), new SQLiteParameter("@ORDERQUANTITY",header.OrderQuantity), new SQLiteParameter("@DAILYCAPACITYPERONE",header.DailyCapacityPerOne), new SQLiteParameter("@ASSIGNEDCOUNT",header.AssignedCount), new SQLiteParameter("@STARTEDDATE",header.StartedDate), new SQLiteParameter("@PLANNEDENDDATE",header.PlannedEndDate), new SQLiteParameter("@ACTUALENDDATE",header.ActualEndDate), new SQLiteParameter("@STATE",header.State), new SQLiteParameter("@CREATEDBY",header.CreatedBy), new SQLiteParameter("@UPDATEDBY",header.UpdatedBy), new SQLiteParameter("@CREATEDDATETIME",header.CreatedDateTime), new SQLiteParameter("@UPDATEDDATETIME",header.UpdatedDateTime) }; dbHelper2.BeginTransaction(); header.Id = dbHelper2.ExecuteNonQueryWithReturningLastId(TableActionSQL.InsertPlanHeaderTable, parameters); foreach (PlanLine line in lines) { line.CreatedBy = "admin"; line.UpdatedBy = "admin"; line.CreatedDateTime = header.CreatedDateTime; line.UpdatedDateTime = header.UpdatedDateTime; line.PlanId = header.Id; SQLiteParameter[] lineParameters = new SQLiteParameter[]{ new SQLiteParameter("@PLANID",line.PlanId), new SQLiteParameter("@MACHINEID",line.MachineId), new SQLiteParameter("@STARTEDDATE",line.StartedDate), new SQLiteParameter("@PLANNEDENDDATE",line.PlannedEndDate), new SQLiteParameter("@ACTUALENDDATE",line.ActualEndDate), new SQLiteParameter("@STATE",line.State), new SQLiteParameter("@CREATEDBY",line.CreatedBy), new SQLiteParameter("@UPDATEDBY",line.UpdatedBy), new SQLiteParameter("@CREATEDDATETIME",line.CreatedDateTime), new SQLiteParameter("@UPDATEDDATETIME",line.UpdatedDateTime) }; line.Id = dbHelper2.ExecuteNonQueryWithReturningLastId(TableActionSQL.InsertPlanLineTable, lineParameters); } //SQLiteParameter parameterOutput = new SQLiteParameter("@ID"); //parameterOutput.Direction = ParameterDirection.ReturnValue; //long lastId = dbHelper.ExecuteNonQueryWithReturningLastId(TableActionSQL.InsertProductTable, parameters); //t.Id = lastId; dbHelper2.CommitTransaction(); //return lastId > 0; return true; } catch (SQLiteException se) { dbHelper2.RollBackTransaction(); Trace.WriteLine(se.Message + " \n\n" + se.Source + "\n\n" + se.StackTrace + "\n\n" + se.Data); return false; } catch (ArgumentException ae) { dbHelper2.RollBackTransaction(); Trace.WriteLine(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace + "\n\n" + ae.Data); return false; } catch (Exception ex) { dbHelper2.RollBackTransaction(); //Do any logging operation here if necessary Trace.WriteLine(ex.Message + "\n\n" + ex.Source + "\n\n" + ex.StackTrace + "\n\n" + ex.Data); return false; } finally { dbHelper2.Close(); } }
public int Update(Plan t) { throw new NotImplementedException(); }
public void QueryPlanById(long planId) { this.Entity = this.Service.QueryById(planId); }