private void SetInventoryLine(SqlCommand cm, IInventoryLine il)
{
cm.Parameters.AddWithValue("@ProductID", il.ProductId);
cm.Parameters.AddWithValue("@DocumentDateTime", il.DocumentDateTime);
cm.Parameters.AddWithValue("@Quantity", il.Quantity);
cm.Parameters.AddWithValue("@IsVoided", il.IsVoided);
}
private void UpdateInventoryLine(IInventoryLine il, string tbl, SqlTransaction sqltransaction)
{
string sql = String.Format("UPDATE {0} SET [ProductID] = @ProductID, [DocumentDateTime] = @DocumentDateTime, [Quantity] = @Quantity,", tbl);
sql += "[IsVoided] = @IsVoided [IsVoided] = @IsVoided WHERE [LineID] = @LineID";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
DatabaseHelper.InsertInt32Param("@LineID", cm, il.LineId);
SetInventoryLine(cm, il);
cm.ExecuteNonQuery();
}
}
private int SaveInventoryLine(IInventoryLine il, string tbl, SqlTransaction sqltransaction)
{
string sql = String.Format("INSERT INTO {0} ([DocumentLineID], [ProductID], [DocumentDateTime], [Quantity], [IsVoided]) ", tbl);
sql += "VALUES (@DocumentLineID, @ProductID, @DocumentDateTime, @Quantity, @IsVoided) SELECT @@identity";
int id;
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
cm.Parameters.AddWithValue("@DocumentLineID", il.DocumentLineId);
SetInventoryLine(cm, il);
id = int.Parse(cm.ExecuteScalar().ToString());
}
return(id);
}
