public List <OrderMaster> ListMergeOrders(string invoiceGroup)
{
List <OrderMaster> result = new List <OrderMaster>();
string status = "CR";
SpCall spCall = new SpCall("DAT.ORDER_MASTER_MERGE_LIST");
spCall.SetVarchar("@STATUS", status);
spCall.SetVarchar("@INVOICE_GROUP", invoiceGroup);
DataSet ds = db.ExecuteDataSet(spCall);
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].AsEnumerable().ToList().ForEach(omRow =>
{
OrderMaster om = ReadOrderMaster(omRow);
om.OrderItems = new List <OrderItem>();
ds.Tables[1].AsEnumerable().Where(itemRow =>
itemRow.Field <long>("ORDER_ID") == om.Id).ToList().ForEach(itemRow =>
om.OrderItems.Add(InitOrderItem(itemRow)));
ds.Tables[2].AsEnumerable().Where(logRow => logRow.Field <long>("ORDER_ID") == om.Id).ToList().ForEach(
logRow => om.InvoiceLog = qm.InitLog(logRow));
result.Add(om);
});
}
return(result);
}
public void InsertOrder(OrderMaster orderMaster)
{
orderMaster.CreateDate = DateTime.Now;
SpCall spCall = new SpCall("DAT.ORDER_MASTER_INSERT");
spCall.SetBigInt("@ID", orderMaster.Id);
spCall.SetBigInt("@CUSTOMER_ID", orderMaster.Customer.Id);
spCall.SetDateTime("@ORDER_DATE", orderMaster.OrderDate);
spCall.SetDateTime("@DELIVERY_DATE", orderMaster.DeliveryDate);
spCall.SetVarchar("@PAYMENT_TYPE", orderMaster.PaymentType);
spCall.SetVarchar("@NOTES", orderMaster.Notes);
spCall.SetVarchar("@ORDER_STATUS", orderMaster.OrderStatus);
spCall.SetDateTime("@CREATE_DATE", orderMaster.CreateDate);
spCall.SetVarchar("@CREATE_USER", orderMaster.CreatedUser);
spCall.SetBigInt("@SHIP_ADDRESS", orderMaster.ShippingAddressId);
orderMaster.UpdatedUser = orderMaster.CreatedUser;
orderMaster.UpdateDate = orderMaster.CreateDate;
db.ExecuteNonQuery(spCall);
DataTable dt = PrepareOrderItemsTable(orderMaster.OrderItems);
db.ExecuteBulkInsert(dt);
}
public void InsertNewItem(MaestroProductGroup productGroup)
{
SpCall call = new SpCall("DAT.PRODUCT_GROUP_INSERT");
call.SetVarchar("@PRODUCT_GROUP_NAME", productGroup.Name);
call.SetVarchar("@GROUP_DESCRIPTION", productGroup.GroupDescription);
call.SetDateTime("@CREATE_DATE", productGroup.CreateDate);
call.SetVarchar("@CREATE_USER", productGroup.CreatedUser);
productGroup.Id = db.ExecuteScalar <long>(call);
}
public void InsertNewItem(MaestroUnitType item)
{
SpCall call = new SpCall("DAT.UNIT_TYPE_INSERT");
call.SetVarchar("@UNIT_TYPE_NAME", item.Name);
call.SetVarchar("@UNIT_TYPE_DESCRIPTION", item.Description);
call.SetBit("@CAN_HAVE_UNITS", item.CanHaveUnits);
call.SetDateTime("@CREATE_DATE", DateTime.Now);
call.SetVarchar("@CREATE_USER", context.UserName);
item.Id = db.ExecuteScalar <long>(call);
}
public void Update(MaestroProductGroup productGroup)
{
SpCall call = new SpCall("DAT.PRODUCT_GROUP_UPDATE");
call.SetBigInt("@ID", productGroup.Id);
call.SetVarchar("@PRODUCT_GROUP_NAME", productGroup.Name);
call.SetVarchar("@GROUP_DESCRIPTION", productGroup.GroupDescription);
call.SetDateTime("@UPDATE_DATE", DateTime.Now);
call.SetVarchar("@UPDATE_USER", context.UserName);
db.ExecuteNonQuery(call);
}
protected override void Update()
{
MaestroUnit item = (MaestroUnit)request.TransactionEntityList[0];
Context.TransactionObject = item;
SpCall call = new SpCall("DAT.UNIT_UPDATE");
call.SetBigInt("@ID", item.Id);
call.SetBigInt("@UNIT_TYPE_ID", item.UnitType.Id);
call.SetVarchar("@UNIT_NAME", item.Name);
call.SetVarchar("@QB_UNIT", item.QuickBooksUnit);
call.SetDateTime("@UPDATE_DATE", DateTime.Now);
call.SetVarchar("@UPDATE_USER", Context.UserName);
db.ExecuteNonQuery(call);
}
protected override void New()
{
MaestroRegion region = (MaestroRegion)request.TransactionEntityList[0];
SpCall call = new SpCall("DAT.REGION_INSERT");
call.SetVarchar("@POSTAL_CODE", region.PostalCode);
call.SetVarchar("@REGION_NAME", region.Name);
call.SetVarchar("@REGION_DESCRIPTION", region.Description);
call.SetVarchar("@GREATER_REGION", region.GreaterRegion);
call.SetDateTime("@CREATE_DATE", DateTime.Now);
call.SetVarchar("@CREATE_USER", Context.UserName);
region.Id = db.ExecuteScalar <long>(call);
response.TransactionResult = region;
}
public static void InsertCacheRegistryInfo(CacheRegistryInfo cacheRegistryInfo)
{
SpCall sp = new SpCall("CACHE.CACHE_REGISTRY_INSERT");
sp.SetVarchar("@GLOBAL_CACHE_NAME", cacheRegistryInfo.CacheId);
sp.SetVarchar("@CACHE_ID", cacheRegistryInfo.CacheId);
sp.SetVarchar("@APPLICATION_CODE", "MAESTRO");
sp.SetVarchar("@CACHE_HOST_NAME", cacheRegistryInfo.HostName);
sp.SetDateTime("@UPDATE_DATE", DateTime.Now);
sp.SetVarchar("@RECORD_STATUS", "A");
using (Database db = new Database())
{
db.ExecuteNonQuery(sp);
}
}
protected override void Update()
{
MaestroRegion region = (MaestroRegion)request.TransactionEntityList[0];
SpCall call = new SpCall("DAT.REGION_UPDATE");
call.SetBigInt("@ID", region.Id);
call.SetVarchar("@POSTAL_CODE", region.PostalCode);
call.SetVarchar("@REGION_NAME", region.Name);
call.SetVarchar("@REGION_DESCRIPTION", region.Description);
call.SetVarchar("@GREATER_REGION", region.GreaterRegion);
call.SetDateTime("@UPDATE_DATE", DateTime.Now);
call.SetVarchar("@UPDATE_USER", Context.UserName);
db.ExecuteNonQuery(call);
Context.TransactionObject = region;
RegionCache.Instance.Reload(true);
}
void UpdateOrderInternal(OrderMaster orderMaster, bool cleanItems)
{
orderMaster.UpdateDate = DateTime.Now;
SpCall spCall = new SpCall("DAT.ORDER_MASTER_UPDATE");
spCall.SetBigInt("@ID", orderMaster.Id);
spCall.SetBigInt("@CUSTOMER_ID", orderMaster.Customer.Id);
spCall.SetDateTime("@ORDER_DATE", orderMaster.OrderDate);
spCall.SetDateTime("@DELIVERY_DATE", orderMaster.DeliveryDate);
spCall.SetVarchar("@PAYMENT_TYPE", orderMaster.PaymentType);
spCall.SetVarchar("@NOTES", orderMaster.Notes);
spCall.SetVarchar("@ORDER_STATUS", orderMaster.OrderStatus);
spCall.SetDateTime("@UPDATE_DATE", orderMaster.UpdateDate);
spCall.SetVarchar("@UPDATE_USER", orderMaster.UpdatedUser);
spCall.SetBit("@CLEAN_ORDERITEMS", cleanItems);
spCall.SetBigInt("@SHIP_ADDRESS", orderMaster.ShippingAddressId);
db.ExecuteNonQuery(spCall);
}
protected override void BackUp()
{
string guid = Guid.NewGuid().ToString();
SpCall call = new SpCall("BCK.BACK_UP_CUSTOMER");
call.SetVarchar("@BATCH_ID", guid);
call.SetDateTime("@BATCH_DATE", DateTime.Now);
db.ExecuteNonQuery(call);
response.TransactionResult = guid;
response.ResultMessage = string.Format("Backup created with batch id `{0}`", guid) + Environment.NewLine;
}
public List <TransactionLog> List(TransactionLogQuery logQuery)
{
List <TransactionLog> result = new List <TransactionLog>();
SpCall call = new SpCall("COR.TRANSACTION_LOG_LIST");
call.SetBigInt("@ID", logQuery.Id);
call.SetVarchar("@TRAN_CODE", logQuery.TransactionCode);
call.SetVarchar("@TRANSACTION_STATUS", logQuery.Status);
call.SetDateTime("@BEGIN_DATE", logQuery.BeginDate);
call.SetDateTime("@END_DATE", logQuery.EndDate);
call.SetVarchar("@CREATE_USER", logQuery.User);
using (SqlReader reader = db.ExecuteReader(call))
{
while (reader.Read())
{
TransactionLog log = new TransactionLog()
{
Id = reader.GetInt64("ID"),
CreateDate = reader.GetDateTime("CREATE_DATE"),
CreatedUser = reader.GetString("CREATE_USER"),
Log = reader.GetValue <byte[]>("TRANSACTION_LOG"),
LogJson = reader.GetString("TRANSACTION_JSON"),
RecordStatus = reader.GetString("RECORD_STATUS"),
Status = reader.GetString("TRANSACTION_STATUS"),
TransactionCode = reader.GetString("TRAN_CODE"),
LogObjectId = reader.GetInt64("TRANSACTION_OBJECT_ID"),
ActionType = reader.GetString("ACTION_TYPE"),
RequestType = reader.GetString("REQUEST_TYPE"),
UpdateDate = reader.GetDateTime("UPDATE_DATE"),
UpdatedUser = reader.GetString("UPDATE_USER"),
Duration = reader.GetInt32("DURATION")
};
SetDisplayProperties(log);
result.Add(log);
}
}
return(result);
}
void DeleteOrderItem(OrderItem item)
{
item.UpdateDate = DateTime.Now;
item.UpdatedUser = context.UserName;
SpCall spCall = new SpCall("DAT.ORDER_ITEM_DELETE");
spCall.SetBigInt("@ID", item.Id);
spCall.SetDateTime("@UPDATE_DATE", item.UpdateDate);
spCall.SetVarchar("@UPDATE_USER", context.UserName);
db.ExecuteNonQuery(spCall);
}
protected override void Delete()
{
long id = ValidateEntityIdFromDataExtension();
Context.TransactionObject = CustomerProductUnitCache.Instance[id];
SpCall spCall = new SpCall("DAT.CUSTOMER_PRODUCT_UNIT_DELETE");
spCall.SetBigInt("@ID", id);
spCall.SetDateTime("@UPDATE_DATE", DateTime.Now);
spCall.SetVarchar("@UPDATE_USER", Context.UserName);
db.ExecuteNonQuery(spCall);
}
