public ActionResult GridData(int page, int rows, string[] _search, string sidx, string sord)
{
string[] ReqParams = { "DDPVersionNum", "MessageId", "MessageType", "Originator", "Test", "MsgInOut", "TimeStamp" };
List <string> columns = new List <string>();
List <string> querys = new List <string>();
string tstamp = "-";
var fromDate = new DateTime(2000, 1, 1);
var toDate = new DateTime(2200, 1, 1);
for (int i = 0; i < ReqParams.Count(); i++)
{
if (ReqParams[i].Contains("TimeStamp"))
{
tstamp = Request.Params[ReqParams[i]];
if (tstamp != null)
{
var dates = tstamp.Split('-');
fromDate = DateTime.Parse(dates[0]);
if (dates.Length == 1)
{
toDate = fromDate.AddDays(1);
}
else
{
toDate = DateTime.Parse(dates[1]);
}
}
continue;
}
var tempValue = Request.Params[ReqParams[i]];
if (tempValue != null)
{
columns.Add(ReqParams[i]);
querys.Add(tempValue);
}
}
var lda = new PricingRequestSentDataAccess(context);
var logs = lda.GetAllBetween(fromDate, toDate);
var model = from entity in logs.OrderBy(sidx + " " + sord)
select new
{
DDPVersionNum = entity.DDPVersionNum,
MessageId = entity.MessageId,
MessageType = entity.MessageType,
Originator = entity.Originator,
Test = entity.test,
MsgInOut = entity.MsgInOut.InOut,
TimeStamp = entity.TimeStamp.ToString()
};
return(Json(model.ToJqGridData(page, rows, null, querys.ToArray(), columns.ToArray())));
}
private string SendPricingRequest(Message msg)
{
DataCenterLogic.DataCenterTypesIDE.PricingRequestType pricingRequest = (DataCenterLogic.DataCenterTypesIDE.PricingRequestType)(msg.Body);
//Send to IDE
if (System.Configuration.ConfigurationManager.AppSettings["send2servers"] != "False")
{
pricingRequest.test = DataCenterLogic.DataCenterTypesIDE.testType.Item0;
ideClient.PricingRequest(pricingRequest);
log.Info("SendPricingRequest: pricingRequest sent to IDE");
}
//Guarda el mensaje en la base de datos
using (var dao = new PricingRequestSentDataAccess())
{
dao.Create(TypeHelper.Map2DB(pricingRequest), 1);
}
log.Info("pricingRequest stored");
return(pricingRequest.MessageId);
}
