protected override void DoUpdate(AbstractDomain domain) { OrderHistory o = domain as OrderHistory; DbCommand cmd = CreateCommand("UP_ORDERHISTORY_UPDATE"); SetModifyParameters(domain, cmd, false); cmd.Connection.Open(); try { //execute the command DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { o.Id = Convert.ToInt32(reader[0]); reader.Close(); } } finally { CloseCommand(cmd); } }
protected override void DoUpdate(AbstractDomain domain) { Status s = domain as Status; DbCommand cmd = CreateCommand("up_STATUS_Update"); SetModifyParameters(domain, cmd, false); cmd.Connection.Open(); try { //execute the command DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { s.Id = Convert.ToInt32(reader[0]); reader.Close(); } } finally { CloseCommand(cmd); } }
public PointsToDataFlowOperationVisitor( AbstractDomain <PointsToAbstractValue> valueDomain, INamedTypeSymbol containingTypeSymbol, DataFlowAnalysisResult <NullAnalysis.NullBlockAnalysisResult, NullAnalysis.NullAbstractValue> nullAnalysisResultOpt) : base(valueDomain, containingTypeSymbol, nullAnalysisResultOpt: nullAnalysisResultOpt, pointsToAnalysisResultOpt: null) { }
protected override void DoLoad(int id, AbstractDomain domain) { Instructions s = domain as Instructions; DbCommand cmd = CreateCommand("UP_INSTRUCTIONS_GETBYID"); AddParameter(cmd, "@INSTRUCTION_ID", DbType.Int32, id); cmd.Connection.Open(); try { DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { PopulateDomain(reader, s); } else { throw new Exception("No Records found in the database."); } reader.Close(); } finally { CloseCommand(cmd); } }
public NullDataFlowOperationVisitor( AbstractDomain <NullAbstractValue> valueDomain, INamedTypeSymbol containingTypeSymbol, DataFlowAnalysisResult <PointsToAnalysis.PointsToBlockAnalysisResult, PointsToAnalysis.PointsToAbstractValue> pointsToAnalysisResultOpt) : base(valueDomain, containingTypeSymbol, nullAnalysisResultOpt: null, pointsToAnalysisResultOpt: pointsToAnalysisResultOpt) { }
protected override void DoLoad(int Id, AbstractDomain domain) { Change ch = domain as Change; DbCommand cmd = CreateCommand("UP_CHANGE_GETBYID"); AddParameter(cmd, "CHANGE_ID", DbType.Int32, Id); cmd.Connection.Open(); try { DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { PopulateDomain(reader, ch); } else { throw new Exception("No Records found in the database."); } reader.Close(); } finally { CloseCommand(cmd); } }
protected override void DoUpdate(AbstractDomain domain) { Change ch = domain as Change; DbCommand cmd = CreateCommand("UP_CHANGE_UPDATE"); SetModifyParameters(domain, cmd, false); cmd.Connection.Open(); try { //execute the command DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { ch.Id = Convert.ToInt32(reader[0]); //ch.Order_Id = Convert.ToInt32(reader[1]); reader.Close(); } } finally { CloseCommand(cmd); } }
protected override void DoLoad(int id, AbstractDomain domain) { UserHistory uh = domain as UserHistory; DbCommand cmd = CreateCommand("UP_USERHISTORY_GETBYID"); AddParameter(cmd, "@USERHIS_ID", DbType.Int32, id); cmd.Connection.Open(); try { DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { PopulateDomain(reader, uh); } else { throw new Exception("No Records found in the database."); } reader.Close(); } finally { CloseCommand(cmd); } }
protected override void DoInsert(AbstractDomain domain) { UserHistory uh = domain as UserHistory; DbCommand cmd = CreateCommand("UP_USERHISTORY_INSERT"); cmd.Connection.Open(); SetModifyParameters(domain, cmd, true); try { //execute the command cmd.ExecuteNonQuery(); uh.Id = (int)cmd.Parameters["@USERHIS_ID"].Value; } catch (Exception ex) { throw ex; } finally { CloseCommand(cmd); } }
public void Save(AbstractDomain domain) { if (domain.Id == 0) { DoInsert(domain); } else { DoUpdate(domain); } }
protected override void DoPopulateDomain(DbDataReader reader, AbstractDomain domain) { Change ch = domain as Change; ch.Id = CheckNull(reader, "CHANGE_ID", 0); ch.Order_Id = CheckNull(reader, "ORDER_ID", 0); ch.Design_By_Name = CheckNull(reader, "DESIGN_BY_NAME", ""); ch.Design_By_Id = CheckNull(reader, "DESIGN_BY_ID", 0); ch.Qa_By_Id = CheckNull(reader, "QA_BY_ID", 0); ch.Qa_By_Name = CheckNull(reader, "QA_BY_NAME", ""); }
/// <summary> /// This method will populate the domain object with the data that relates to the /// specified database id. /// </summary> /// <param name="id">The database id to use to load the domain object</param> /// <param name="domain">The domain object to populate</param> public void Load(int id, AbstractDomain domain) { try { DoLoad(id, domain); } catch { domain.Id = 0; } }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { Priority pr = domain as Priority; DbParameter param = AddParameter(cmd, "ID", DbType.Int32, pr.Id); if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "PRIORITY_ID", DbType.Int32, pr.Priority_Id); AddParameter(cmd, "PRIORITY_NAME", DbType.String, pr.Priority_Name); }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { Status s = domain as Status; DbParameter param = AddParameter(cmd, "@STATUS_ID", DbType.Int32, s.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_STATUS", DbType.String, 50, s.ORDER_STATUS); }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { User u = domain as User; DbParameter param = AddParameter(cmd, "@USER_ID", DbType.Int32, u.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@REALNAME", DbType.String, 50, u.RealName); AddParameter(cmd, "@LOGINID", DbType.String, 50, u.LoginId); AddParameter(cmd, "@PASSWORD", DbType.String, 50, u.Password); AddParameter(cmd, "@STATUS_ID", DbType.Int16, u.STATUS_ID); }
protected override void SetModifyParameters(AbstractDomain domain, DbCommand cmd, bool SetOutputParameter) { Change ch = domain as Change; DbParameter param = AddParameter(cmd, "@CHANGE_ID", DbType.Int32, ch.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_ID", DbType.Int32, ch.Order_Id); AddParameter(cmd, "@DESIGN_BY_NAME", DbType.String, 50, ch.Design_By_Name); AddParameter(cmd, "@DESIGN_BY_ID", DbType.Int32, ch.Design_By_Id); AddParameter(cmd, "@QA_BY_ID", DbType.Int32, ch.Qa_By_Id); AddParameter(cmd, "@QA_BY_NAME", DbType.String, 50, ch.Qa_By_Name); }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { Instructions s = domain as Instructions; DbParameter param = AddParameter(cmd, "@INSTRUCTION_ID", DbType.Int32, s.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_ID", DbType.Int32, s.ORDER_ID); AddParameter(cmd, "@Date", DbType.DateTime, s.Date); AddParameter(cmd, "@USER_ID", DbType.Int32, s.USER_ID); AddParameter(cmd, "@ADDITIONALINSTRUCTION", DbType.String, 50, s.ADDITIONALINSTRUCTION); }
protected override void DoInsert(AbstractDomain domain) { Priority pr = domain as Priority; DbCommand cmd = CreateCommand("UP_PRIORITY_INSERT"); cmd.Connection.Open(); SetModifyParameters(domain, cmd, false); try { cmd.ExecuteNonQuery(); pr.Id = (int)cmd.Parameters["Id"].Value; } finally { CloseCommand(cmd); } }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { OrderHistory o = domain as OrderHistory; DbParameter param = AddParameter(cmd, "@ORDERHIS_ID", DbType.Int32, o.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_ID", DbType.Int32, o.ORDER_ID); AddParameter(cmd, "@USER_ID", DbType.Int32, o.USER_ID); AddParameter(cmd, "@USERALLOCATED", DbType.Int32, o.USERALLOCATED); AddParameter(cmd, "@ORDER_STATUS", DbType.Int32, o.ORDER_STATUS); AddParameter(cmd, "@DATE", DbType.DateTime, o.DATE); AddParameter(cmd, "@ADDITIONALINSTRUCTION", DbType.String, 50, o.ADDITIONALINSTRUCTION); }
protected override void DoUpdate(AbstractDomain domain) { Priority pr = domain as Priority; DbCommand cmd = CreateCommand("UP_PRIORITY_UPDATE"); SetModifyParameters(domain, cmd, false); cmd.Connection.Open(); try { DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { pr.Id = Convert.ToInt32(reader[0]); reader.Close(); } } finally { CloseCommand(cmd); } }
protected override void DoInsert(AbstractDomain domain) { Change ch = domain as Change; DbCommand cmd = CreateCommand("UP_CHANGE_INSERT"); cmd.Connection.Open(); SetModifyParameters(domain, cmd, true); try { //execute the command cmd.ExecuteNonQuery(); ch.Id = (int)cmd.Parameters["@CHANGE_ID"].Value; } finally { CloseCommand(cmd); } }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { UserHistory uh = domain as UserHistory; DbParameter param = AddParameter(cmd, "@USERHIS_ID", DbType.Int32, uh.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_ID", DbType.Int16, uh.Order_Id); AddParameter(cmd, "@USER_ID", DbType.Int16, uh.User_Id); AddParameter(cmd, "@COMMENTS", DbType.String, 50, uh.Comments); AddParameter(cmd, "@STATUS_ID", DbType.Int16, uh.Status_Id); AddParameter(cmd, "ALLOCATED_DATE", DbType.DateTime, uh.Allocated_Date); AddParameter(cmd, "SUBMITTED_DATE", DbType.DateTime, uh.Submitted_Date); AddParameter(cmd, "@IMAGES", DbType.Int16, uh.Images); AddParameter(cmd, "@PAGES", DbType.Int16, uh.Pages); AddParameter(cmd, "TOTALTIME", DbType.DateTime, uh.Totaltime); }
protected override void SetModifyParameters(AbstractDomain domain, System.Data.Common.DbCommand cmd, bool SetOutputParameter) { Order o = domain as Order; DbParameter param = AddParameter(cmd, "@ADSID", DbType.Int32, o.Id); // primary key parameter if (SetOutputParameter) { param.Direction = ParameterDirection.Output; } AddParameter(cmd, "@ORDER_ID", DbType.Int16, o.ORDER_ID); AddParameter(cmd, "@EVENT_ID", DbType.Int16, o.EVENT_ID); AddParameter(cmd, "@GRAPHER_ID", DbType.String, 50, o.GRAPHER_ID); AddParameter(cmd, "@STATUS_ID", DbType.Int16, o.STATUS_ID); AddParameter(cmd, "@USER_ID", DbType.Int16, o.USER_ID); AddParameter(cmd, "@ORDER_DATE", DbType.DateTime, o.ORDER_DATE); AddParameter(cmd, "@ADS_DATE", DbType.DateTime, o.ADS_DATE); AddParameter(cmd, "@FOLDER_NAME", DbType.String, 50, o.FOLDER_NAME); AddParameter(cmd, "@PAGES", DbType.Int16, o.PAGES); AddParameter(cmd, "@ALBUM_TYPE", DbType.Int16, o.ALBUM_TYPE); AddParameter(cmd, "@ALBUM_STYLE", DbType.Int16, o.ALBUM_STYLE); AddParameter(cmd, "@ALBUM_SIZE", DbType.Int16, o.ALBUM_SIZE); AddParameter(cmd, "@ORIGINAL_ALBUM_ID", DbType.Int16, o.ORIGINAL_ALBUM_ID); AddParameter(cmd, "@ALBUM_ID", DbType.Int16, o.ALBUM_ID); AddParameter(cmd, "@IMAGES", DbType.Int16, o.IMAGES); AddParameter(cmd, "@ALBUM_NAME", DbType.String, 50, o.ALBUM_NAME); AddParameter(cmd, "@ORDER_STATUS", DbType.Int16, o.ORDER_STATUS); AddParameter(cmd, "@ALBUM_RATING", DbType.Int16, o.ALBUM_RATING); AddParameter(cmd, "@COMMENTS", DbType.String, 50, o.COMMENTS); AddParameter(cmd, "@SPECIAL_INSTRUCTIONS", DbType.String, 50, o.SPECIAL_INSTRUCTIONS); AddParameter(cmd, "@ACTION", DbType.Int16, o.ACTION); AddParameter(cmd, "@GENERALGUIDELINES", DbType.String, 50, o.GENERALGUIDELINES); AddParameter(cmd, "@INSTRUCTION_ID", DbType.String, 50, o.INSTRUCTION_ID); AddParameter(cmd, "@PRODUCT_NAME", DbType.String, 50, o.PRODUCT_NAME); AddParameter(cmd, "@PRIORITY", DbType.Int16, o.PRIORITY); AddParameter(cmd, "@RELEASE_STATUS", DbType.Int16, o.RELEASE_STATUS); AddParameter(cmd, "@IMAGE_LIST", DbType.String, o.IMAGE_LIST); AddParameter(cmd, "@REDESIGN", DbType.String, 50, o.REDESIGN); }
protected override void DoInsert(AbstractDomain domain) { Status s = domain as Status; DbCommand cmd = CreateCommand("up_STATUS_Insert"); cmd.Connection.Open(); SetModifyParameters(domain, cmd, true); try { //execute the command cmd.ExecuteNonQuery(); s.Id = (int)cmd.Parameters["@STATUS_ID"].Value; } finally { CloseCommand(cmd); } }
protected override void DoInsert(AbstractDomain domain) { OrderHistory o = domain as OrderHistory; DbCommand cmd = CreateCommand("UP_ORDERHISTORY_INSERT"); cmd.Connection.Open(); SetModifyParameters(domain, cmd, true); try { //execute the command cmd.ExecuteNonQuery(); o.Id = (int)cmd.Parameters["@ORDERHIS_ID"].Value; } finally { CloseCommand(cmd); } }
protected abstract void SetModifyParameters(AbstractDomain domain, DbCommand cmd, bool SetOutputParameter);
protected abstract void DoInsert(AbstractDomain domain);
public void Load(AbstractDomain domain) { Load(domain.Id, domain); }
protected abstract void DoUpdate(AbstractDomain domain);
protected abstract void DoDelete(AbstractDomain domain);