public IEnumerable <PipelineStatusDTO> GetPipelineStatus(int pipelineId)
{
List <PipelineStatusDTO> pipeStatusList = new List <PipelineStatusDTO>();
try
{
DateTime dateTo = DateTime.Now.Date.AddDays(-30);
//List<TPWBrowserTestResult> browserTestResultList = new List<TPWBrowserTestResult>();
//browserTestResultList = nomEntity.TPWBrowserTestResult.Where(a => a.PipelineID == pipelineId && a.CreatedDate >= dateTo).ToList();
do
{
bool isOacyRec = false;
bool isUnscRec = false;
bool isSwntRec = false;
using (var ctx = new NomEntities())
{
isOacyRec = ctx.OACYPerTransaction.Any(a => a.PipelineID == pipelineId && DbFunctions.TruncateTime(a.CreatedDate) == dateTo.Date);
isUnscRec = ctx.UnscPerTransaction.Any(a => a.PipelineID == pipelineId && DbFunctions.TruncateTime(a.CreatedDate) == dateTo.Date);
isSwntRec = ctx.SwntPerTransaction.Any(a => a.PipelineId == pipelineId && DbFunctions.TruncateTime(a.CreatedDate) == dateTo.Date);
}
PipelineStatusDTO pipeStatus = new PipelineStatusDTO();
pipeStatus.PipelineId = pipelineId;
pipeStatus.onDate = dateTo;
pipeStatus.IsBrowserTestSuccess = false;
pipeStatus.IsOacyReceive = isOacyRec;
pipeStatus.IsUnscReceive = isUnscRec;
pipeStatus.IsNoticeReceive = isSwntRec;
pipeStatusList.Add(pipeStatus);
dateTo = dateTo.Date.AddDays(1);
} while (DateTime.Now.Date > dateTo);
//foreach (var browserTest in browserTestResultList)
// {
// bool isOacyRec = false;
// bool isUnscRec = false;
// bool isSwntRec = false;
// using (var ctx = nomEntity)
// {
// isOacyRec = ctx.OACYPerTransaction.Any(a => a.PipelineID == browserTest.PipelineID && DbFunctions.TruncateTime(a.CreatedDate) == browserTest.CreatedDate.Date);
// isUnscRec = ctx.UnscPerTransaction.Any(a => a.PipelineID == browserTest.PipelineID && DbFunctions.TruncateTime(a.CreatedDate) == browserTest.CreatedDate.Date);
// isSwntRec = ctx.SwntPerTransaction.Any(a => a.PipelineId == browserTest.PipelineID && DbFunctions.TruncateTime(a.CreatedDate) == browserTest.CreatedDate.Date);
// }
// PipelineStatusDTO pipeStatus = new PipelineStatusDTO();
// pipeStatus.PipelineId = browserTest.PipelineID;
// pipeStatus.onDate = browserTest.CreatedDate;
// pipeStatus.IsBrowserTestSuccess = browserTest.IsWorking.HasValue ? browserTest.IsWorking.Value : false;
// pipeStatus.IsOacyReceive = isOacyRec;
// pipeStatus.IsUnscReceive = isUnscRec;
// pipeStatus.IsNoticeReceive = isSwntRec;
// pipeStatusList.Add(pipeStatus);
// }
}
catch (Exception ex)
{
}
return(pipeStatusList.OrderByDescending(a => a.onDate).ToList());
}
// GET: UserPipelineMapping
public ActionResult Index(String userID = "", string Search = "", string PipeName = "")
{
UserPipelineDTO modal = new UserPipelineDTO();
var context = new NomEntities();
var allUsers = context.Users.ToList();
if (string.IsNullOrEmpty(userID))
{
modal.userPipelineMappingDTO = new List <UserPipelineMappingDTO>();
ViewBag.UsersDropdown = new SelectList(allUsers, "Id", "UserName");
if (modal.ShipperId == null)
{
modal.ShipperId = GetCurrentCompanyID();
}
if (Search != "")
{
modal.userPipelineMappingDTO = modal.userPipelineMappingDTO.Where(t => t.PipeName.ToLower().Contains(PipeName) || t.PipeName.ToUpper().Contains(PipeName)).ToList();
}
return(View(modal));
}
else
{
if (!string.IsNullOrEmpty(userID))
{
var request = new RestRequest(string.Format("GetAllPipelineMappingsByUser?userID=" + userID), Method.GET)
{
RequestFormat = DataFormat.Json
};
request.JsonSerializer = NewtonsoftJsonSerializer.Default;
var response = pipelines.Execute <List <UserPipelineMappingDTO> >(request);
ViewBag.UsersDropdown = new SelectList(allUsers, "Id", "UserName", userID);
modal.ShipperId = GetCurrentCompanyID();
modal.UserId = userID;
modal.userPipelineMappingDTO = response.Data;
if (Search != "")
{
PipeName = PipeName.ToLower();
modal.userPipelineMappingDTO = modal.userPipelineMappingDTO.Where(t => t.PipeName.ToLower().Contains(PipeName)).ToList();
}
}
else
{
modal.userPipelineMappingDTO = new List <UserPipelineMappingDTO>();
}
return(View(modal));
}
}
public string _CounterPartyName(string counteryPartyDuns)
{
//string partialViewName = "_CounterPartyName";
string name = string.Empty;
NomEntities db = new NomEntities();
var counterPartyName = db.CounterParty.Where(a => a.Identifier == counteryPartyDuns).FirstOrDefault();
if (counterPartyName != null)
{
name = counterPartyName.Name;
}
return(name);
}
protected void Application_Start()
{
using (var context = new NomEntities())
SqlConnectionString = context.Database.Connection.ConnectionString;
GlobalConfiguration.Configure(WebApiConfig.Register);
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
JobScheduler.Start();
if (!String.IsNullOrEmpty(SqlConnectionString))
{
SqlDependency.Start(SqlConnectionString);
}
}
public NomEntities Init()
{
return(dbContext ?? (dbContext = new NomEntities()));
}
public PipelineStatusRepository(IDbFactory dbfactory) : base(dbfactory)
{
_dbfactory = dbfactory;
nomEntity = _dbfactory.Init();
}
