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