public bool InsertProduction(int productionID, DateTime?productiondate, int?shift, int?item, float?quantity, int?machine, DateTime?startTime, DateTime?stopTime, float?packers)
{
SPG.ProductionDataTable production = new SPG.ProductionDataTable();
SPG.ProductionRow productionRecord = production.NewProductionRow();
productionRecord.ProdMainID = productionID;
productionRecord.ProdMainDate = Convert.ToDateTime(productiondate);
productionRecord.ProdMainShift = shift.Value;
productionRecord.ProdMainItemID = item.Value;
productionRecord.ProdMainQuantity = quantity.Value;
productionRecord.ProdMainMachineLine = machine.Value;
productionRecord.ProdMainTimeStart = startTime.Value;
productionRecord.ProdMainTimeStop = stopTime.Value;
if (!packers.HasValue)
{
productionRecord.ProdMainPackers = 0;
}
else
{
productionRecord.ProdMainPackers = packers.Value;
}
productionRecord.strEnteredBy = Properties.Settings.Default.UserName;
productionRecord.dtmEnteredOn = DateTime.Now;
production.AddProductionRow(productionRecord);
int rowsAffected = Adapter.Update(production);
return(rowsAffected == 1);
}
private void UpdateAuditTrail(SPG.ProductionRow ModifiedRecord, object[] originalRecord)
{
StringBuilder builder = new StringBuilder(string.Empty);
int recordFields = (ModifiedRecord.ItemArray.Length - 1);
int i = 0;
while (i <= recordFields)
{
try
{
if (Convert.IsDBNull(originalRecord[i]))
{
if (!Convert.IsDBNull(ModifiedRecord[i]))
{
builder.Append(string.Format("{0}:{1}({2}); ", ModifiedRecord.Table.Columns[i].ColumnName, "NULL", ModifiedRecord[i]));
}
}
else if (Convert.IsDBNull(ModifiedRecord[i]))
{
if (!Convert.IsDBNull(originalRecord[i]))
{
builder.Append(string.Format("{0}:{1}({2}); ", ModifiedRecord.Table.Columns[i].ColumnName, originalRecord[i], "NULL"));
}
}
else if (ModifiedRecord[i] != originalRecord[i])
{
builder.Append(string.Format("{0}:{1}({2}); ", ModifiedRecord.Table.Columns[i].ColumnName, originalRecord[i], ModifiedRecord[i]));
}
}
catch
{
}
i += 1;
}
if (builder.Length > 2)
{
builder.Length = (builder.Length - 2);
AuditTrailBLL.AddTrailEntry(Properties.Settings.Default.UserName, Convert.ToInt32(ModifiedRecord[0]), "Production", builder.ToString());
}
}
public bool UpdateProduction(int productionID, DateTime?productionDate, int?shift, int?item, float?quantity, int?machine, DateTime?startTime, DateTime?stopTime, float?packers)
{
SPG.ProductionDataTable production = Adapter.GetProductionByID(productionID);
if (production.Count() == 0)
{
//It is a new Production Record
return(InsertProduction(productionID, productionDate, shift, item, quantity, machine, startTime, stopTime, packers));
}
SPG.ProductionRow productionRecord = production[0];
object[] originalRecord = productionRecord.ItemArray;
productionRecord.ProdMainDate = Convert.ToDateTime(productionDate);
productionRecord.ProdMainShift = shift.Value;
productionRecord.ProdMainItemID = item.Value;
productionRecord.ProdMainQuantity = quantity.Value;
productionRecord.ProdMainMachineLine = machine.Value;
productionRecord.ProdMainTimeStart = startTime.Value;
productionRecord.ProdMainTimeStop = stopTime.Value;
if (!packers.HasValue)
{
productionRecord.ProdMainPackers = 0;
}
else
{
productionRecord.ProdMainPackers = packers.Value;
}
if (!(originalRecord == null))
{
UpdateAuditTrail(productionRecord, originalRecord);
}
int rowsAffected = Adapter.Update(productionRecord);
return(rowsAffected == 1);
}
