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