public bool AddLocationByPipeline(List <LocationsDTO> locList)
{
foreach (var item in locList)
{
Location loc = new Location()
{
CreatedDate = DateTime.Now,//item.CreatedDate,
Name = item.Name,
Identifier = item.Identifier,
PropCode = item.PropCode,
RDUsageID = item.RDUsageID,
PipelineID = item.PipelineID,
IsActive = true,
CreatedBy = item.CreatedBy,
ModifiedBy = item.ModifiedBy,
ModifiedDate = DateTime.Now, //item.ModifiedDate,
PipeDuns = item.PipelineDuns, // adding pipeduns is pending
TransactionTypeId = 0
};
DbContext.Locations.Add(loc);
}
DbContext.SaveChanges();
return(true);
}
public bool SaveUserPermissions(UserPipelineDTO userMapping)
{
string userID = (userMapping.userPipelineMappingDTO.Count > 0 && !string.IsNullOrEmpty(userMapping.userPipelineMappingDTO.Select(u => u.UserId).FirstOrDefault()) ? userMapping.userPipelineMappingDTO[0].UserId : userMapping.UserId);
var userPipelineMapping = factory.Parse(userMapping);
if (userMapping != null)
{
var deleteUser = dbcontext.UserPipelineMappings.Where(a => a.userId == userID).Select(a => a).ToList();
var Delete = dbcontext.UserPipelineMappings.RemoveRange(deleteUser);
dbcontext.SaveChanges();
var OnlyNomsOrUprd = userPipelineMapping
.Where(a => a.IsNoms == true || a.IsUPRD == true)
.Select(a => a).ToList();
var result = dbcontext.UserPipelineMappings.AddRange(OnlyNomsOrUprd);
var Success = dbcontext.SaveChanges();
if (Success > 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public void AppLogManager(string source, string type, string errMsg)
{
ApplicationLog log = new ApplicationLog();
log.Source = source.ToString();
log.Type = type;
log.Description = errMsg.ToString();
log.CreatedDate = DateTime.Now;
DbContext.ApplicationLogs.Add(log);
DbContext.SaveChanges();
}
public int AddWatchListRule(int watchListId, WatchListRule watchListRule)
{
WatchlistRule newRule = new WatchlistRule()
{
WatchlistId = watchListId,
ColumnId = watchListRule.PropertyId,
OperatorId = watchListRule.ComparatorsId,
RuleValue = watchListRule.value,
PipelineDuns = watchListRule.PipelineDuns,
LocationIdentifier = watchListRule.LocationIdentifier,
IsCriticalNotice = watchListRule.IsCriticalNotice,
AlertSent = watchListRule.AlertSent,
AlertFrequency = (int)watchListRule.AlertFrequency,
UpperRuleValue = watchListRule.UpperValue
};
DbContext.WatchlistRules.Add(newRule);
DbContext.SaveChanges();
return(newRule.Id);
}
public IHttpActionResult PutDashNominationStatu(Guid TransactionId, int statusId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var obj = db.DashNominationStatus.Where(a => a.TransactionId == TransactionId).FirstOrDefault();
if (obj == null)
{
return(BadRequest());
}
obj.StatusId = statusId;
switch (statusId)
{
case 1:
case 2:
case 3:
case 4:
obj.NomStatus = "In-Process";
break;
case 5:
obj.NomStatus = "Submitted";
break;
case 7:
obj.NomStatus = "Accepted";
break;
case 8:
case 9:
obj.NomStatus = "Exception Occured";
break;
case 10:
obj.NomStatus = "Rejected";
break;
case 0:
obj.NomStatus = "GISB Unprocessed";
break;
default:
obj.NomStatus = "Not Defined";
break;
}
db.Entry(obj).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DashNominationStatuExists(TransactionId))
{
ApplicationLog log = new ApplicationLog();
log.CreatedDate = DateTime.Now;
log.Description = "Nomination not found TransactionId:- " + TransactionId;
log.Source = "Update";
log.Type = "Error";
db.ApplicationLogs.Add(log);
db.SaveChanges();
return(NotFound());
}
else
{
return(Ok("fail"));
}
}
return(StatusCode(HttpStatusCode.NoContent));
}