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