public bool JobStatus(string JobId, string action, string Token)
{
var job = ctx.Jobs.Where(ab => ab.JobId == JobId).FirstOrDefault();
job.Status = action;
try
{
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Job status",
Service = "Jobs Service",
Description = "Change a job's status."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public bool UpdateJobBid(JobBids jobBid, string Token)
{
try
{
ctx.Entry(jobBid).State = EntityState.Modified;
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Update Bid",
Service = "Jobs Service",
Description = "Update a job bid."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
// Job Management
public void CreateJob(Jobs job, string Token)
{
job.JobId = GenerateJobId();
try
{
ctx.Jobs.Add(job);
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Create Job",
Service = "Jobs Service",
Description = "Create a new job."
};
createTrail(trail);
}
}
catch
{
return;
}
}
public bool JobBidDeleteStatus(int BidId, bool action, string Token)
{
var job = ctx.JobBids.Where(ab => ab.Id == BidId).FirstOrDefault();
job.Deleted = action;
try
{
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Delete Bid",
Service = "Jobs Service",
Description = "Delete a job bid."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public bool UpdateSuccessfulBidder(string JobId, string UserId, string Token)
{
var job = ctx.Jobs.FirstOrDefault(ab => ab.JobId == JobId);
job.SuccessfulBidder = UserId;
try
{
ctx.Entry(job).State = EntityState.Modified;
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Update Bid",
Service = "Jobs Service",
Description = "Update successful bidder."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public void CreateRating(Ratings rating, string token)
{
try
{
ctx.Ratings.Add(rating);
ctx.SaveChanges();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Create User Rating",
Service = "Users Service",
Description = "Create a user rating."
};
createTrail(trail);
}
}
catch
{
return;
}
}
public bool RatingDeleteStatus(int Id, bool action, string token)
{
var rtn = ctx.Ratings.Where(ab => ab.Id == Id).FirstOrDefault();
rtn.Deleted = action;
try
{
ctx.SaveChanges();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Delete User Rating",
Service = "Users Service",
Description = "Delete a user rating."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public double GetUserRating(string UserId, string token)
{
var ratings = ctx.Ratings.Where(ab => ab.UserRefer == UserId && !ab.Deleted);
var rt = new List <int>();
foreach (var r in ratings)
{
rt.Add(r.Rating);
}
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get User Rating",
Service = "Users Service",
Description = "Get a user rating."
};
createTrail(trail);
}
if (rt.Count > 0)
{
return(rt.Average());
}
else
{
return(0);
}
}
public MyResponse GetPagiatedJobs(int page, int size, string Token)
{
var jobs = from j in ctx.Jobs.Where(ab => !ab.Deleted)
.OrderBy(cd => cd.DatePosted)
.Skip(page * size)
.Take(size)
select j;
var count = ctx.Jobs.Where(ab => !ab.Deleted).Count();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Jobs",
Service = "Jobs Service",
Description = "Get paginated list of jobs."
};
createTrail(trail);
}
var response = new MyResponse()
{
totalElements = count,
content = jobs,
totalPages = (int)(count / size),
currentPage = page + 1
};
return(response);
}
public void CreateAuditTrail(string Action, int KeyFieldID, string keyValue, Object OldValue, Object NewValue, string username)
{
CompareLogic compLogic = new CompareLogic();
compLogic.Config.MaxDifferences = 99;
ComparisonResult compResult = compLogic.Compare(OldValue, NewValue);
List <AuditTrailsTemp.AuditDelta> deltaList = new List <AuditTrailsTemp.AuditDelta>();
foreach (var change in compResult.Differences)
{
AuditTrailsTemp.AuditDelta delta = new AuditTrailsTemp.AuditDelta();
if (change.PropertyName.Substring(0, 1) == ".")
{
delta.FieldName = change.PropertyName.Substring(1, change.PropertyName.Length - 1);
}
delta.ValueBefore = change.Object1Value;
delta.ValueAfter = change.Object2Value;
deltaList.Add(delta);
}
AuditTrails audit = new AuditTrails();
audit.AuditAction = Action;
audit.DataModel = this.GetType().Name;
audit.DateTimeStamp = DateTime.Now;
audit.KeyFieldID = KeyFieldID;
audit.Desc = keyValue;
audit.ValueBefore = JsonConvert.SerializeObject(OldValue);
audit.ValueAfter = JsonConvert.SerializeObject(NewValue);
audit.Changes = JsonConvert.SerializeObject(deltaList);
audit.Username = username;
db.AuditTrails.Add(audit);
db.SaveChanges();
}
public MyResponse GetPaginatedClientUsers(int page, int size, string token)
{
var users = from u in ctx.Users.Where(ab => !ab.Deleted && ab.UserType != "Admin")
.OrderBy(cd => cd.Id)
.Skip(page * size)
.Take(size)
select u;
var count = ctx.Users.Where(bd => !bd.Deleted && bd.UserType != "Admin").Count();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Users",
Service = "Users Service",
Description = "Get paginated list of Client users."
};
createTrail(trail);
}
var response = new MyResponse()
{
totalElements = count,
content = users,
totalPages = (int)(count / size),
currentPage = page + 1
};
return(response);
}
public bool UserStatus(string UserId, string action, string token)
{
var user = ctx.Users.Where(ab => ab.UserId == UserId).FirstOrDefault();
var syUser = ctx.SystemUsers.Where(cd => cd.UserRefe == UserId).FirstOrDefault();
user.Status = action;
syUser.Status = action;
try
{
ctx.SaveChanges();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "User Status",
Service = "Users Service",
Description = "Change user status."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public bool ReOpenJob(string JobId, string Token)
{
var job = ctx.Jobs.Where(ab => ab.JobId == JobId).FirstOrDefault();
job.Renewed = "true";
try
{
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Reopen Job",
Service = "Jobs Service",
Description = "Reopen a job."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public void CreateJobBid(JobBids bid, string Token)
{
try
{
ctx.JobBids.Add(bid);
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Create Bid",
Service = "Jobs Service",
Description = "Create a job bid."
};
createTrail(trail);
}
}
catch
{
return;
}
}
public bool UpdateUser(Users user, string token)
{
try
{
ctx.Entry(user).State = EntityState.Modified;
ctx.SaveChanges();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Update User",
Service = "Users Service",
Description = "Update a user's details."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public JobBids GetJobBid(int Id, string Token)
{
var bid = ctx.JobBids.Where(ab => ab.Id == Id).FirstOrDefault();
var obid = bid;
if (bid != null && !bid.Viewed)
{
bid.Viewed = true;
ctx.Entry(bid).State = EntityState.Modified;
}
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Bid",
Service = "Jobs Service",
Description = "Get job bid details."
};
createTrail(trail);
}
return(obid);
}
public void CreateUser(Users user, string token)
{
user.UserId = GenerateUserId();
try
{
ctx.Users.Add(user);
ctx.SaveChanges();
var syUser = new SystemUsers()
{
UserType = user.UserType,
Username = user.Username,
Password = GenerateUserPassword(),
Status = "active",
Hash = "-",
Deleted = false,
UserRefe = user.UserId,
ResetRequest = "-"
};
try
{
ctx.SystemUsers.Add(syUser);
ctx.SaveChanges();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Create User",
Service = "Users Service",
Description = "Creation of a new user."
};
createTrail(trail);
}
SendEmail(user.Email);
}
catch
{
return;
}
}
catch
{
return;
}
}
// post Trail
public bool createTrail(AuditTrails trail)
{
try
{
ctx.AuditTrail.Add(trail);
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public void Submit(string comment)
{
AssertOperation(Current, OperationCode.Submit);
//提交时不进行权限验证，后面可能要加上，某些用户可能不具备提交特定流程的权限
//AssertPrivilege(Current);
var action = GetCurrentAction(Current, OperationCode.Submit);
//判断是否本节点回环
if (action.Transit.ActivityTemplateId != Current.ActivityTemplate.ActivityTemplateId)
{
//非本节点回环，创建下个节点实例
var nextActivityInstance = NewActivityInstance(action.Transit);
//标记该Activity已完成
_originateActivityInstance = Current;
_originateActivityInstance.MarkFinish();
//_originateActivityInstance.Tail.MarkFinished();
//替换当前节点
Current = nextActivityInstance;
}
//相应的创建Action实例
var actionRecord = new ActionRecord()
{
ActivityInstanceId = Current.ActivityInstanceId,
RequiredRole = Current.ActivityTemplate.RequiredRole.Id
};
Current.AddAction(actionRecord);
//当前节点替换
var auditTrail = new AuditTrailEntry()
{
IsNew = true
};
//添加审核日志
AuditTrails.Add(auditTrail);
_isDirty = true;
}
public JsonResult UploadApprovalLetter(string appid, UploadApprovalLetterViewModel uploadApprovalLetterViewModel)
{
string[] arr = Session["UserData"] as string[];
uploadApprovalLetterViewModel.Comment.ERApplicationId = uploadApprovalLetterViewModel.ForwardApplication.ERApplicationId;
uploadApprovalLetterViewModel.Comment.UserAccountId = arr[0];
uploadApprovalLetterViewModel.ForwardApplication.CommentRefId = uploadApprovalLetterViewModel.Comment.Id;
uploadApprovalLetterViewModel.ForwardApplication.Sender = arr[0];
uploadApprovalLetterViewModel.ForwardApplication.Reciever = AuditTrailsContext.Collection().Where(x => x.ERApplicationId == appid && x.Is_Active == true && x.StatusId == "S101").FirstOrDefault().SenderId;
uploadApprovalLetterViewModel.ForwardApplication.FileStatus = FileStatus.ApprovalLetter;
uploadApprovalLetterViewModel.ForwardApplication.Is_Active = true;
AuditTrails auditTrails = new AuditTrails()
{
SenderId = arr[0],
ReceiverId = uploadApprovalLetterViewModel.ForwardApplication.Reciever,
FileRefId = uploadApprovalLetterViewModel.ForwardApplication.FileRef,
ERApplicationId = appid,
Is_Active = true,
StatusId = "S116"
};
AuditTrailsContext.Insert(auditTrails);
ForwardApplicationContext.Insert(uploadApprovalLetterViewModel.ForwardApplication);
commentContext.Insert(uploadApprovalLetterViewModel.Comment);
if (TryValidateModel(uploadApprovalLetterViewModel))
{
using (TransactionScope scope = new TransactionScope())
{
commentContext.Commit();
ForwardApplicationContext.Commit();
AuditTrailsContext.Commit();
scope.Complete();
return(Json("Successfully Approval Letter Uploaded", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("Something Went Wrong! Try Again Later"));
}
}
public Users GetUser(string UserId, string token)
{
var user = ctx.Users.Where(ab => ab.UserId == UserId).FirstOrDefault();
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get User",
Service = "Users Service",
Description = "Get a user's details."
};
createTrail(trail);
}
return(user);
}
public Ratings GetRating(int Id, string token)
{
var rating = ctx.Ratings.FirstOrDefault(ab => ab.Id == Id);
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get User Rating",
Service = "Users Service",
Description = "Get a user rating."
};
createTrail(trail);
}
return(rating);
}
public Jobs GetJob(string JobId, string Token)
{
var job = ctx.Jobs.Where(ab => ab.JobId == JobId).FirstOrDefault();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Job",
Service = "Jobs Service",
Description = "Get job details."
};
createTrail(trail);
}
return(job);
}
// Job Bids Management
public IEnumerable <JobBids> GetJobBids(string JobId, string Token)
{
var bids = from j in ctx.JobBids.Where(ab => ab.JobRef == JobId && !ab.Deleted && ab.Status == "active")
select j;
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Bids",
Service = "Jobs Service",
Description = "Get a list of job bids."
};
createTrail(trail);
}
return(bids);
}
// Manage User Ratings.
public IEnumerable <Ratings> GetUserRatings(string UserId, string token)
{
var ratings = from r in ctx.Ratings.Where(ab => ab.UserRefer == UserId && !ab.Deleted)
select r;
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get User Ratings",
Service = "Users Service",
Description = "Get a list of user ratings."
};
createTrail(trail);
}
return(ratings);
}
public IEnumerable <Users> GetDeletedUsers(string token)
{
var users = from u in ctx.Users.Where(ab => ab.Deleted)
select u;
if (token != null)
{
var rec = getUsername(token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Deleted Users",
Service = "Users Service",
Description = "Get a list of all deleted users."
};
createTrail(trail);
}
return(users);
}
public IEnumerable <Jobs> GetUserSuccessfulJobBids(string UserId, string Token)
{
var jobs = from j in ctx.Jobs.Where(ab => !ab.Deleted && ab.SuccessfulBidder == UserId)
select j;
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Bids",
Service = "Jobs Service",
Description = "Get a list of user successful bids."
};
createTrail(trail);
}
return(jobs);
}
public IEnumerable <Jobs> GetDeletedJobs(string Token)
{
var jobs = from j in ctx.Jobs.Where(ab => ab.Deleted)
select j;
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Get Jobs",
Service = "Jobs Service",
Description = "Get a list of deleted jobs."
};
createTrail(trail);
}
return(jobs);
}
public bool JobBidStatus(string JobId, string action, string Token)
{
var bids = ctx.JobBids.Where(ab => ab.Status == "active" && ab.JobRef == JobId && !ab.Deleted);
try
{
foreach (var bid in bids)
{
bid.Status = action;
ctx.Entry(bid).State = EntityState.Modified;
}
ctx.SaveChanges();
if (Token != null)
{
var rec = getUsername(Token);
var trail = new AuditTrails()
{
UserRefere = rec.Item2,
Username = rec.Item1,
Action = "Bid Status",
Service = "Jobs Service",
Description = "Change job bids status."
};
createTrail(trail);
}
return(true);
}
catch
{
return(false);
}
}
public ActionResult SubmitERProposal(OperatorERProposalViewModel _ERApplication, string FileRef)
{
ViewBag.Title = "Submit Proposal";
string[] userdata = Session["UserData"] as string[];
string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace(" ", "");
_ERApplication.ERApplications.AppId = "ERAPPID" + dt;
_ERApplication.ERApplications.ERScreeningDetail.ReportDocumentPath = FileRef;
if (!string.IsNullOrEmpty(_ERApplication.EGRTechniqueId))
{
_ERApplication.ERApplications.ERTechniquesId = _ERApplication.EGRTechniqueId;
}
else if (!string.IsNullOrEmpty(_ERApplication.EORTechniqueId))
{
_ERApplication.ERApplications.ERTechniquesId = _ERApplication.EORTechniqueId;
}
else
{
_ERApplication.ERApplications.ERTechniquesId = null;
}
_ERApplication.ERApplications.MassiveFracking = MassiveUHC.AcidFracking;
if (!TryValidateModel(_ERApplication.ERApplications))
{
ViewBag.RefId = FileRef;
_ERApplication.FieldTypes = FieldTypeContext.Collection().ToList();
_ERApplication.UHCProductionMethods = UHCProductionMethodContext.Collection().ToList();
_ERApplication.eRScreeningInstitutes = ERScreeningInstituteContext.Collection().ToList();
_ERApplication.eRTechniques = ERTechniquesContext.Collection().ToList();
return(View(_ERApplication));
}
ERApplicationContext.Insert(_ERApplication.ERApplications);
string auditstatus = StatusMasterContext.Collection().Where(status => status.Status == "Application Submitted").FirstOrDefault().CustStatusId;
string CERuserrole = UserRoleType.ConsultantEnhancedRecovery.GetDisplayName();
string CER = UserAccountContext.Collection().Where(x => x.UserRole == CERuserrole).FirstOrDefault().Id;
AuditTrails auditTrails = new AuditTrails()
{
ERApplicationId = _ERApplication.ERApplications.Id,
FileRefId = FileRef,
StatusId = auditstatus,
SenderId = userdata[0],
//ReceiverId = CER, // Consultant Enhanced Recovery
Is_Active = true,
};
List <string> lst = new List <string>()
{
userdata[0],
CER // Consultant Enhanced Recovery
};
foreach (string x in lst)
{
ERAppActiveUsers eRAppActiveUsers = new ERAppActiveUsers()
{
ERApplicationId = _ERApplication.ERApplications.Id,
UserAccountId = x,
Dept_Id = null,
Is_Active = true,
Status = null
};
ERAppActiveUsersContext.Insert(eRAppActiveUsers);
}
AuditTrailContext.Insert(auditTrails);
using (TransactionScope scope = new TransactionScope())
{
ERApplicationContext.Commit();
ERAppActiveUsersContext.Commit();
AuditTrailContext.Commit();
scope.Complete();
}
return(Json("Application Ref. No :" + _ERApplication.ERApplications.AppId, JsonRequestBehavior.AllowGet));
}
