public static void Insert(EpTransaction epTran, PurchaseOrderItemText entity)
{
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
connection = DataManager.GetConnection();
else
connection = epTran.GetSqlConnection();
if (connection.State != System.Data.ConnectionState.Open) connection.Open();
cm.Connection = connection;
//set transaction
if (epTran != null)
cm.Transaction = epTran.GetSqlTransaction();
//Check whether record exists
PurchaseOrderItemText checkEntity = RetrieveByKey(epTran, entity.OrderNumber, entity.ItemSequenceNumber, entity.TextSerialNumber);
if (checkEntity != null)
{
throw new Exception("Record already exists.");
}
//Insert
cm.CommandText = "INSERT INTO puitxt ([EBELN],[EBELP],[TXTITM],[LTXT],[RECSTS]) VALUES(@EBELN,@EBELP,@TXTITM,@LTXT,@RECSTS)";
SqlParameter p1 = new SqlParameter("@LTXT", SqlDbType.NVarChar, 255);
cm.Parameters.Add(p1);
p1.Value = entity.LongText;
SqlParameter p2 = new SqlParameter("@RECSTS", SqlDbType.Char, 1);
cm.Parameters.Add(p2);
p2.Value = entity.RecordStatus;
SqlParameter p3 = new SqlParameter("@EBELN", SqlDbType.Char, 10);
cm.Parameters.Add(p3);
p3.Value = entity.OrderNumber;
SqlParameter p4 = new SqlParameter("@TXTITM", SqlDbType.Char, 5);
cm.Parameters.Add(p4);
p4.Value = entity.TextSerialNumber;
SqlParameter p5 = new SqlParameter("@EBELP", SqlDbType.Char, 5);
cm.Parameters.Add(p5);
p5.Value = entity.ItemSequenceNumber;
cm.ExecuteNonQuery();
if (epTran == null)
if (connection.State != System.Data.ConnectionState.Closed) connection.Close();
}
public static PurchaseOrderItemText RetrieveByKey(EpTransaction epTran, string orderNumber, string itemSequenceNumber, string textSerialNumber)
{
PurchaseOrderItemText entity = null;
string whereClause = " EBELN='" + DataManager.EscapeSQL(orderNumber) + "' ";
whereClause += "AND EBELP='" + DataManager.EscapeSQL(itemSequenceNumber) + "' ";
whereClause += "AND TXTITM='" + DataManager.EscapeSQL(textSerialNumber) + "'";
Collection <PurchaseOrderItemText> entities = Retrieve(epTran, whereClause, "");
if (entities.Count > 0)
{
entity = entities[0];
}
return(entity);
}
public static void Insert(EpTransaction epTran, PurchaseOrderItemText entity)
{
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
{
connection = DataManager.GetConnection();
}
else
{
connection = epTran.GetSqlConnection();
}
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
cm.Connection = connection;
//set transaction
if (epTran != null)
{
cm.Transaction = epTran.GetSqlTransaction();
}
//Check whether record exists
PurchaseOrderItemText checkEntity = RetrieveByKey(epTran, entity.OrderNumber, entity.ItemSequenceNumber, entity.TextSerialNumber);
if (checkEntity != null)
{
throw new Exception("Record already exists.");
}
//Insert
cm.CommandText = "INSERT INTO puitxt ([EBELN],[EBELP],[TXTITM],[LTXT],[RECSTS]) VALUES(@EBELN,@EBELP,@TXTITM,@LTXT,@RECSTS)";
SqlParameter p1 = new SqlParameter("@LTXT", SqlDbType.NVarChar, 255);
cm.Parameters.Add(p1);
p1.Value = entity.LongText;
SqlParameter p2 = new SqlParameter("@RECSTS", SqlDbType.Char, 1);
cm.Parameters.Add(p2);
p2.Value = entity.RecordStatus;
SqlParameter p3 = new SqlParameter("@EBELN", SqlDbType.Char, 10);
cm.Parameters.Add(p3);
p3.Value = entity.OrderNumber;
SqlParameter p4 = new SqlParameter("@TXTITM", SqlDbType.Char, 5);
cm.Parameters.Add(p4);
p4.Value = entity.TextSerialNumber;
SqlParameter p5 = new SqlParameter("@EBELP", SqlDbType.Char, 5);
cm.Parameters.Add(p5);
p5.Value = entity.ItemSequenceNumber;
cm.ExecuteNonQuery();
if (epTran == null)
{
if (connection.State != System.Data.ConnectionState.Closed)
{
connection.Close();
}
}
}
public static void Insert(PurchaseOrderItemText entity)
{
Insert(null, entity);
}
private static Collection <PurchaseOrderItemText> Retrieve(EpTransaction epTran, string whereClause, string sortClaues)
{
Collection <PurchaseOrderItemText> entities = new Collection <PurchaseOrderItemText>();
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
{
connection = DataManager.GetConnection();
}
else
{
connection = epTran.GetSqlConnection();
}
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
cm.Connection = connection;
//set transaction
if (epTran != null)
{
cm.Transaction = epTran.GetSqlTransaction();
}
//Retrieve Data
string selectCommand = "SELECT [EBELN],[EBELP],[TXTITM],[LTXT],[RECSTS] FROM puitxt";
if (!string.IsNullOrEmpty(whereClause))
{
selectCommand += " where " + whereClause;
}
if (!string.IsNullOrEmpty(sortClaues))
{
selectCommand += " order by " + sortClaues;
}
cm.CommandText = selectCommand;
SqlDataReader rd = cm.ExecuteReader();
while (rd.Read())
{
PurchaseOrderItemText entity = new PurchaseOrderItemText();
entity.OrderNumber = rd["EBELN"].ToString();
entity.ItemSequenceNumber = rd["EBELP"].ToString();
entity.TextSerialNumber = rd["TXTITM"].ToString();
entity.LongText = rd["LTXT"].ToString();
entity.RecordStatus = rd["RECSTS"].ToString();
entities.Add(entity);
}
// close reader
rd.Close();
if (epTran == null)
{
if (connection.State != System.Data.ConnectionState.Closed)
{
connection.Close();
}
}
return(entities);
}
public static void Delete(EpTransaction epTran, PurchaseOrderItemText entity)
{
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
{
connection = DataManager.GetConnection();
}
else
{
connection = epTran.GetSqlConnection();
}
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
cm.Connection = connection;
//set transaction
if (epTran != null)
{
cm.Transaction = epTran.GetSqlTransaction();
}
//Check whether record exists
PurchaseOrderItemText checkEntity = RetrieveByKey(epTran, entity.OrderNumber, entity.ItemSequenceNumber, entity.TextSerialNumber);
if (checkEntity == null)
{
throw new Exception("Record doesn't exist.");
}
//Update
cm.CommandText = "DELETE FROM puitxt WHERE EBELN=@EBELN AND EBELP=@EBELP AND TXTITM=@TXTITM";
SqlParameter p3 = new SqlParameter("@EBELN", SqlDbType.Char, 10);
cm.Parameters.Add(p3);
p3.Value = entity.OrderNumber;
SqlParameter p4 = new SqlParameter("@TXTITM", SqlDbType.Char, 5);
cm.Parameters.Add(p4);
p4.Value = entity.TextSerialNumber;
SqlParameter p5 = new SqlParameter("@EBELP", SqlDbType.Char, 5);
cm.Parameters.Add(p5);
p5.Value = entity.ItemSequenceNumber;
cm.ExecuteNonQuery();
if (epTran == null)
{
if (connection.State != System.Data.ConnectionState.Closed)
{
connection.Close();
}
}
}
public static void Delete(PurchaseOrderItemText entity)
{
Delete(null, entity);
}
public static void Update(PurchaseOrderItemText entity)
{
Update(null, entity);
}
public static void Insert(PurchaseOrderItemText entity)
{
Insert(null, entity);
}
private static Collection<PurchaseOrderItemText> Retrieve(EpTransaction epTran, string whereClause, string sortClaues)
{
Collection<PurchaseOrderItemText> entities = new Collection<PurchaseOrderItemText>();
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
connection = DataManager.GetConnection();
else
connection = epTran.GetSqlConnection();
if (connection.State != System.Data.ConnectionState.Open) connection.Open();
cm.Connection = connection;
//set transaction
if (epTran != null)
cm.Transaction = epTran.GetSqlTransaction();
//Retrieve Data
string selectCommand = "SELECT [EBELN],[EBELP],[TXTITM],[LTXT],[RECSTS] FROM puitxt";
if (!string.IsNullOrEmpty(whereClause)) selectCommand += " where " + whereClause;
if (!string.IsNullOrEmpty(sortClaues)) selectCommand += " order by " + sortClaues;
cm.CommandText = selectCommand;
SqlDataReader rd = cm.ExecuteReader();
while (rd.Read())
{
PurchaseOrderItemText entity = new PurchaseOrderItemText();
entity.OrderNumber = rd["EBELN"].ToString();
entity.ItemSequenceNumber = rd["EBELP"].ToString();
entity.TextSerialNumber = rd["TXTITM"].ToString();
entity.LongText = rd["LTXT"].ToString();
entity.RecordStatus = rd["RECSTS"].ToString();
entities.Add(entity);
}
// close reader
rd.Close();
if (epTran == null)
if (connection.State != System.Data.ConnectionState.Closed) connection.Close();
return entities;
}
public static void Delete(EpTransaction epTran, PurchaseOrderItemText entity)
{
SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
//set connection
SqlConnection connection;
if (epTran == null)
connection = DataManager.GetConnection();
else
connection = epTran.GetSqlConnection();
if (connection.State != System.Data.ConnectionState.Open) connection.Open();
cm.Connection = connection;
//set transaction
if (epTran != null)
cm.Transaction = epTran.GetSqlTransaction();
//Check whether record exists
PurchaseOrderItemText checkEntity = RetrieveByKey(epTran, entity.OrderNumber,entity.ItemSequenceNumber,entity.TextSerialNumber);
if (checkEntity == null)
{
throw new Exception("Record doesn't exist.");
}
//Update
cm.CommandText = "DELETE FROM puitxt WHERE EBELN=@EBELN AND EBELP=@EBELP AND TXTITM=@TXTITM";
SqlParameter p3 = new SqlParameter("@EBELN", SqlDbType.Char, 10);
cm.Parameters.Add(p3);
p3.Value = entity.OrderNumber;
SqlParameter p4 = new SqlParameter("@TXTITM", SqlDbType.Char, 5);
cm.Parameters.Add(p4);
p4.Value = entity.TextSerialNumber;
SqlParameter p5 = new SqlParameter("@EBELP", SqlDbType.Char, 5);
cm.Parameters.Add(p5);
p5.Value = entity.ItemSequenceNumber;
cm.ExecuteNonQuery();
if (epTran == null)
if (connection.State != System.Data.ConnectionState.Closed) connection.Close();
}
public static void Delete(PurchaseOrderItemText entity)
{
Delete(null, entity);
}
public static void Update(PurchaseOrderItemText entity)
{
Update(null, entity);
}