protected override void New()
{
TransactionDefinition td = (TransactionDefinition)request.TransactionEntityList[0];
td.CreateDate = DateTime.Now;
td.CreatedUser = Context.UserName;
if (TransactionCache.Instance.Get(td.TranCode, false) != null)
{
throw new Exception(string.Format("Trancode `{0}` exists", td.TranCode));
}
SpCall spCall = new SpCall("COR.TRANSACTION_DEFINITION_INSERT");
spCall.SetVarchar("@TRAN_CODE", td.TranCode);
spCall.SetVarchar("@TRAN_DESCRIPTION", td.TranDescription);
spCall.SetBit("@IS_CANCELLABLE", td.IsCancellable);
spCall.SetInt("@MENU_ID", td.MenuId);
spCall.SetVarchar("@GROUP_CODE", td.GroupCode);
spCall.SetBit("@QB_RELATED", td.IsQbRelated);
spCall.SetVarchar("@CODE_BASE", td.CodeBase);
spCall.SetDateTime("@CREATE_DATE", td.CreateDate);
spCall.SetVarchar("@CREATE_USER", td.CreatedUser);
long id = db.ExecuteScalar <long>(spCall);
td.Id = id;
Context.TransactionObject = td;
}
public void InsertNewItem(MaestroProduct product)
{
SpCall call = new SpCall("DAT.PRODUCT_INSERT");
call.SetVarchar("@PRODUCT_NAME", product.Name);
call.SetVarchar("@PRODUCT_DESCRIPTION", product.Description);
call.SetVarchar("@QB_PRODUCT_ID", product.QuickBooksProductId);
call.SetDecimal("@PRICE", product.Price);
call.SetInt("@MINIMUM_ORDER_QUANTITY", product.MinimumOrderQuantity);
call.SetBigInt("@UNIT_TYPE_ID", product.UnitType.Id);
call.SetBigInt("@PRODUCT_GROUP_ID", product.GroupId);
call.SetDecimal("@COST_BASE", product.CostBase);
call.SetDateTime("@CREATE_DATE", product.CreateDate);
call.SetVarchar("@CREATE_USER", product.CreatedUser);
product.Id = db.ExecuteScalar <long>(call);
}
public void UpdateOrderItem(OrderItem item)
{
item.UpdateDate = DateTime.Now;
item.UpdatedUser = context.UserName;
SpCall spCall = new SpCall("DAT.ORDER_ITEM_UPDATE");
spCall.SetBigInt("@ID", item.Id);
spCall.SetBigInt("@ORDER_ID", item.OrderId);
spCall.SetBigInt("@PRODUCT_ID", item.Product.Id);
spCall.SetInt("@QUANTITY", item.Quantity);
spCall.SetBigInt("@UNIT_ID", item.Unit.Id);
spCall.SetBigInt("@QB_PRODUCT_MAP_ID", item.QbProductMap.Id);
spCall.SetDecimal("@PRICE", item.Price);
spCall.SetDateTime("@UPDATE_DATE", item.UpdateDate);
spCall.SetVarchar("@UPDATE_USER", context.UserName);
spCall.SetDecimal("@AMOUNT", item.Amount);
db.ExecuteNonQuery(spCall);
}
public void Update(MaestroProduct product)
{
SpCall call = new SpCall("DAT.PRODUCT_UPDATE");
call.SetBigInt("@ID", product.Id);
call.SetVarchar("@PRODUCT_NAME", product.Name);
call.SetVarchar("@PRODUCT_DESCRIPTION", product.Description);
call.SetVarchar("@QB_PRODUCT_ID", product.QuickBooksProductId);
call.SetDecimal("@PRICE", product.Price);
call.SetInt("@MINIMUM_ORDER_QUANTITY", product.MinimumOrderQuantity);
call.SetBigInt("@UNIT_TYPE_ID", product.UnitType.Id);
call.SetBigInt("@PRODUCT_GROUP_ID", product.GroupId);
call.SetDecimal("@COST_BASE", product.CostBase);
call.SetDateTime("@UPDATE_DATE", DateTime.Now);
call.SetVarchar("@UPDATE_USER", context.UserName);
db.ExecuteNonQuery(call);
}
void InsertExecutionLog(DateTime startDate)
{
DateTime endDate = DateTime.Now;
double duration = endDate.Subtract(startDate).TotalMilliseconds;
OnLogEventHandler(string.Format("Inserting execution log for Task `{0}`, duration:{1} miliseconds", taskName, duration), null);
using (Database db = new Database())
{
SpCall call = new SpCall("COR.TASK_SCHEDULER_LOG_INSERT");
call.SetVarchar("@TASK_NAME", taskName);
call.SetDateTime("@START_DATE", startDate);
call.SetDateTime("@END_DATE", endDate);
call.SetInt("@INTERVALL", intervall);
call.SetVarchar("@INTERVALL_UNIT", intervallUnit.ToString());
call.SetDecimal("@DURATION", Convert.ToDecimal(duration));
call.SetDateTime("@CREATE_DATE", DateTime.Now);
db.ExecuteNonQuery(call);
}
this.lastExecution = endDate;
}
protected override void Update()
{
TransactionDefinition td = (TransactionDefinition)request.TransactionEntityList[0];
td.UpdateDate = DateTime.Now;
td.UpdatedUser = Context.UserName;
SpCall spCall = new SpCall("COR.TRANSACTION_DEFINITION_UPDATE");
spCall.SetBigInt("ID", td.Id);
spCall.SetVarchar("@TRAN_CODE", td.TranCode);
spCall.SetVarchar("@TRAN_DESCRIPTION", td.TranDescription);
spCall.SetBit("@IS_CANCELLABLE", td.IsCancellable);
spCall.SetInt("@MENU_ID", td.MenuId);
spCall.SetVarchar("@GROUP_CODE", td.GroupCode);
spCall.SetBit("@QB_RELATED", td.IsQbRelated);
spCall.SetVarchar("@CODE_BASE", td.CodeBase);
spCall.SetDateTime("@UPDATE_DATE", td.UpdateDate);
spCall.SetVarchar("@UPDATE_USER", td.UpdatedUser);
db.ExecuteNonQuery(spCall);
Context.TransactionObject = td;
}
