public async Task <int> UpdateAsync(POSRequest request)
{
using var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));
connection.Open();
string sQuery = $"UPDATE dbPOSPortal.dbo.Requests SET MerchantName = '{request.MerchantName}',RCNumber='{request.RCNumber}',TerminalLocation='{request.TerminalLocation}',NumberOfTerminals='{request.NumberOfTerminals}',AccountNumber='{request.AccountNumber}',City='{request.City}',LGA='{request.LGA}',State='{request.State}',NearestBusStop='{request.NearestBusStop}',Landmark='{request.Landmark}',BusinessStartDate='{request.BusinessStartDate}',TradeName='{request.TradeName}',CorporateAddress='{request.CorporateAddress}',ReceiptHeader='{request.ReceiptHeader}',ReceiptFooter='{request.ReceiptFooter}',BusinessSegment='{request.BusinessSegment}',PrincipalContactName='{request.PrincipalContactName}',PrincipalContactAddress='{request.PrincipalContactAddress}',PrincipalContactEmail='{request.PrincipalContactEmail}',PrincipalContactStateOfOrigin='{request.PrincipalContactStateOfOrigin}',PrincipalContactPosition='{request.PrincipalContactPosition}'," +
$"PrincipalContactPhoneNo='{request.PrincipalContactPhoneNo}',ContactNameAtTerminalLocation='{request.ContactNameAtTerminalLocation}',ContactAddressAtTerminalLocation='{request.ContactAddressAtTerminalLocation}',ContactPositionAtTerminalLocation='{request.ContactPositionAtTerminalLocation}',ContactPhoneNoAtTerminalLocation='{request.ContactPhoneNoAtTerminalLocation}',Declaration='{request.Declaration}',Agreement='{request.Agreement}',Status='{request.Status}',Comments='{request.Comments}', DateUpdated='{DateTime.Now}' WHERE RequestId = '{request.RequestId}'";
var result = await connection.ExecuteAsync(sQuery);
return(result);
}
public POSResponse Post([FromBody] POSRequest request)
{
var response = new POSResponse()
{
ApprovedAmount = 123,
DCCAccepted = true,
MaskedCardNumber = "1234*****5678",
ExpiryDate = DateTime.Now.AddYears(2).ToLongDateString(),
MerchantReferenceCode = "ABC",
message = "MESSAGE",
NameOnCard = "AVPM Card",
TokenExpiration = DateTime.Now.AddDays(1),
ErrorCode = 0,
Decision = "ABC",
Token = "ABC123"
};
return(response);
}
public override void ProcessActivity(POSRequest request, POSResponse response)
{
var user = UMC.Security.Identity.Current;
var attr = new AttributeNames(response.Ticket);
this._editer = request.IsCashier;
var designId = UMC.Data.Utility.Guid(this.AsyncDialog("Id", g => new Web.UITextDialog()), true).Value;
if (request.SendValues == null)
{
var builder2 = new UIDataSource(request.Model, request.Command, new UMC.Web.WebMeta().Put("Id", designId), "CMSImage");
var item = UMC.Retail.Entities.Utility.Database.ObjectEntity <UMC.Retail.Entities.Store_Design_Item>()
.Where.And().Equal(new Store_Design_Item {
design_id = designId, Type = StoreDesignType.Banners, for_id = Guid.Empty
}).Entities.Single();
if (item == null)
{
item = new Store_Design_Item {
Id = Guid.NewGuid(), Type = StoreDesignType.Banners, for_id = Guid.Empty, design_id = designId
};
UMC.Retail.Entities.Utility.Database.ObjectEntity <UMC.Retail.Entities.Store_Design_Item>().Insert(item);
}
this.Context.Send(new UMC.Web.WebMeta().Put("type", "DataSource").Put("title", "广告图").Put("menu", new object[] { new UIClick(new UMC.Web.WebMeta().Put("Id", item.Id.ToString(), "Type", "Banners"))
{
Command = "Design", Model = "Store", Text = "新建"
} }).Put("DataSource", new object[] { builder2 }).Put("model", "Cells").Put("RefreshEvent", "Design"), true);
}
var items = new List <Store_Design_Item>();
var itemEntity = UMC.Retail.Entities.Utility.Database.ObjectEntity <UMC.Retail.Entities.Store_Design_Item>()
.Where.And().Equal(new Store_Design_Item {
design_id = designId
}).Entities;
itemEntity.Order.Asc(new Store_Design_Item {
Seq = 0
}).Entities.Query(dr =>
{
items.Add(dr);
});
if (items.Count == 0 && this._editer)
{
items.Add(new Store_Design_Item {
Id = Guid.NewGuid(), Type = StoreDesignType.Banners, for_id = Guid.Empty, design_id = designId
});
itemEntity.Insert(items.ToArray());
}
var groups = items.FindAll(g => g.for_id == Guid.Empty);
var parent = groups.Find(g => g.Type == StoreDesignType.Banners) ?? new Store_Design_Item()
{
Id = Guid.NewGuid()
};
var list = new List <Object>();
var webr = UMC.Data.WebResource.Instance();
foreach (var b in items.FindAll(g => g.for_id == parent.Id))
{
var slider = new UISlider();
slider.Src = webr.ResolveUrl(String.Format("{1}{0}/1/0.jpg!slider", b.Id, UMC.Data.WebResource.ImageResource));
if (_editer)
{
slider.Click = new UIClick(new UMC.Web.WebMeta().Put("Id", b.Id))
{
Command = "Design", Model = "Store"
};
}
else
{
if (String.IsNullOrEmpty(b.Click) == false)
{
slider.Click = UMC.Data.JSON.Deserialize <UIClick>(b.Click);
}
}
list.Add(slider);
}
response.Redirect(new UMC.Web.WebMeta().Put("data", list));
//var items = new List<Store_Design_Item>();
//var itemEntity = WebADNuke.Retail.Entities.Utility.Database.ObjectEntity<WebADNuke.Retail.Entities.Store_Design_Item>()
// .Where.And().Equal(new Store_Design_Item { design_id = designId }).Entities;
//itemEntity.Order.Asc(new Store_Design_Item { Seq = 0 }).Entities.Query(dr =>
//{
// items.Add(dr);
//});
//if (items.Count == 0 && this._editer)
//{
// items.Add(new Store_Design_Item { Id = Guid.NewGuid(), Type = StoreDesignType.Banners, for_id = Guid.Empty, design_id = designId });
// itemEntity.Insert(items.ToArray());
//}
//var groups = items.FindAll(g => g.for_id == Guid.Empty);
//var b = groups.Find(g => g.Type == StoreDesignType.Banners) ?? new Store_Design_Item() { Id = Guid.NewGuid() };
//response.Redirect(this.Sliders(b.Id.Value, items.FindAll(g => g.for_id == b.Id)));
}
