public MaestroRegion GetUnknownItem()
{
MaestroRegion region = RegionCache.Instance.GetByName(MaestroApplication.Instance.UNKNOWN_ITEM_NAME);
if (region == null)
{
region = new MaestroRegion()
{
PostalCode = "",
GreaterRegion = string.Empty,
Name = MaestroApplication.Instance.UNKNOWN_ITEM_NAME,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
CreatedUser = "******",
UpdatedUser = "******",
Description = ""
};
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", region.CreateDate);
call.SetVarchar("@CREATE_USER", "MAESTRO");
region.Id = db.ExecuteScalar <long>(call);
RegionCache.Instance.Reload(true);
}
return(region);
}
public static ResponseMessage Add(string name, string postalCode)
{
MaestroRegion item = new MaestroRegion()
{
Description = "Region description",
Name = name,
PostalCode = postalCode
};
RequestMessage request = MessagePrepareAgent.GetRequest(action, tranCode, "", new List <ITransactionEntity>(new ITransactionEntity[] { item }));
return(new MessageBroker().Execute(request));
}
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 override void Deserialize(JToken token)
{
MaestroRegion resultObj = new MaestroRegion();
JObject entityObj = JObject.Parse(token.ToString());
resultObj.Id = entityObj["Id"].ToObject <long>();
resultObj.Name = entityObj["Name"].ToString();
resultObj.PostalCode = entityObj["PostalCode"].ToString();
resultObj.Description = entityObj["Description"].ToString();
resultObj.GreaterRegion = entityObj["GreaterRegion"].ToString();
Context.TransactionObject = resultObj;
}
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);
}
public override void Deserialize(JToken token)
{
MaestroCustomer resultObj = new MaestroCustomer();
JObject entityObj = JObject.Parse(token.ToString());
resultObj.Id = entityObj["Id"].ToObject <long>();
resultObj.Address = entityObj["Address"].ToString();
resultObj.DefaultPaymentType = entityObj["DefaultPaymentType"].ToString();
resultObj.Email = entityObj["Email"].ToString();
resultObj.Name = entityObj["Name"].ToString();
resultObj.Phone = entityObj["Phone"].ToString();
resultObj.Title = entityObj["Title"].ToString();
resultObj.QuickBooksId = entityObj["QuickBooksId"].ToString();
resultObj.QuickBoosCompany = entityObj["QuickBoosCompany"].ToString();
resultObj.CustomerGroup = entityObj["CustomerGroup"].ToString();
resultObj.ReportGroup = entityObj["ReportGroup"].ToString();
resultObj.InvoiceGroup = entityObj["InvoiceGroup"].ToString();
MaestroRegion region = null;
if (entityObj.ContainsKey("MaestroRegion"))
{
JObject regionObj = JObject.Parse(entityObj["MaestroRegion"].ToString());
if (regionObj.ContainsKey("Id"))
{
long regionId = 0;
long.TryParse(regionObj["Id"].ToString(), out regionId);
if (regionId > 0)
{
region = RegionCache.Instance[regionId];
}
if (region == null)
{
region = RegionCache.Instance.GetByName(MaestroApplication.Instance.UNKNOWN_ITEM_NAME);
}
}
}
resultObj.Region = region;
Context.TransactionObject = resultObj;
}
MaestroRegion GetRegion(IAddress addressData)
{
MaestroRegion region = null;
if (addressData != null)
{
string pk = ReadString(addressData.PostalCode).Replace(" ", "");
if (!string.IsNullOrWhiteSpace(pk))
{
region = RegionCache.Instance.GetByPostalCode(pk);
}
}
if (region == null)
{
region = new RegionManager(context).GetUnknownItem();
}
return(region);
}
