public static void KWSLogKFileActivity(FileActivity_UpdateModel activityUpdateModel)
{
var genericInfo = new
{
FileType = activityUpdateModel.WsFileType.ToString(),
FileIn = activityUpdateModel.FileIn.ToString(),
FileUniqueId = activityUpdateModel.FileUniqueId,
NonAuditFlag = activityUpdateModel.NonAuditFlag,
IsPage_Act = activityUpdateModel.IsPage_Act,
};
var info = new
{
GenericInfo = JsonConvert.SerializeObject(genericInfo),
};
var serInfo = JsonConvert.SerializeObject(info);
using (var client = new WebClient())
{
client.UseDefaultCredentials = true;
var values = new NameValueCollection
{
{ "EngNum", activityUpdateModel.EngNum },
{ "FileNum", activityUpdateModel.FileNum.ToString() },
{ "KFileActivityType", activityUpdateModel.WsActivityType.ToString().Replace("Activity_", "") },
{ "Comment", activityUpdateModel.Comment },
{ "Info", serInfo },
};
var result = client.UploadValues(string.Format("{0}{1}KWSLogKFileActivity", ConfigUtility.GetKWebAppBaseUrl, LogController), values);
// TODO: do something with the results returned by the controller action
}
}
public static string UpdateFileActivity(FileActivity_UpdateModel activityUpdateModel)
{
string returnStatus = null;
if (activityUpdateModel.FileIn == FileIn.S2)
{
using (var db = new S2DbContext())
{
if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Reprocess)
{
WsActivity.CallEmailActivities("RepreocessServer2RETFile", "ReprocessRequested_14",
activityUpdateModel.FileUniqueId, 0, activityUpdateModel.Comment);
}
if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge && activityUpdateModel.NonAuditFlag.HasValue
? activityUpdateModel.NonAuditFlag.Value : false)
{
var relatedEngFiles = WsOperation.GetRelated_S2_YrEnd_Audit_EngDoc_Num(activityUpdateModel.FileNum);
relatedEngFiles.ForEach(x => Workspace.Move_YrEnd_Audit_RET_N_ENG_To_ElecWp(activityUpdateModel.FileNum, x, activityUpdateModel.EngNum));
}
SqlParameter p1 = new SqlParameter("@WorkbookReviewId", activityUpdateModel.FileUniqueId);
SqlParameter p2 = new SqlParameter("@Status", (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge)
? "Acknowledged" : "Removed");
SqlParameter p3 = new SqlParameter("@UpdatedBy", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs);
SqlParameter p4;
if (activityUpdateModel.NonAuditFlag.HasValue)
{ p4 = new SqlParameter("@NonAuditFlag", activityUpdateModel.NonAuditFlag.Value); }
else
{ p4 = new SqlParameter("@NonAuditFlag", DBNull.Value); }
SqlParameter p5 = new SqlParameter("@docNum", activityUpdateModel.FileNum);
db.Database.ExecuteSqlCommand("EXEC [S2CLR].spUpdateReviewStatus @WorkbookReviewId, @Status, @UpdatedBy, @NonAuditFlag, @docNum", p1, p2, p3, p4, p5);
}
var docStatus = AuditManager.Rep.Workspace.GetFileStatus_S2(new List<int> { (int)activityUpdateModel.FileNum });
returnStatus = docStatus.FirstOrDefault().Status;
}
else if (activityUpdateModel.FileIn == FileIn.SSC)
{
if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge
|| activityUpdateModel.WsActivityType == WsActivityType.Activity_Reprocess)
{
using (var db = new SSCDbContext())
{
SqlParameter p1 = new SqlParameter("@FAId", activityUpdateModel.FileUniqueId);
SqlParameter p2 = new SqlParameter("@success", (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge));
SqlParameter p3;
if (string.IsNullOrWhiteSpace(activityUpdateModel.Comment))
{ p3 = new SqlParameter("@comments", DBNull.Value); }
else
{ p3 = new SqlParameter("@comments", activityUpdateModel.Comment); }
SqlParameter p4 = new SqlParameter("@activityEndDate", DateTime.Now.ToUniversalTime());
SqlParameter p5 = new SqlParameter("@userId", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs);
SqlParameter p6 = new SqlParameter("@docNum", activityUpdateModel.FileNum);
db.Database.ExecuteSqlCommand("spCloseActivity @FAId, @success, @comments, @activityEndDate, @userId", p1, p2, p3, p4, p5);
}
}
else if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Remove)
{
using (var db = new SSCDbContext())
{
SqlParameter p1 = new SqlParameter("@FAId", activityUpdateModel.FileUniqueId);
SqlParameter p2;
if (string.IsNullOrWhiteSpace(activityUpdateModel.Comment))
{ p2 = new SqlParameter("@comments", DBNull.Value); }
else
{ p2 = new SqlParameter("@comments", activityUpdateModel.Comment); }
SqlParameter p3 = new SqlParameter("@userId", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs);
SqlParameter p4 = new SqlParameter("@docNum", activityUpdateModel.FileNum);
db.Database.ExecuteSqlCommand("spRemoveActivity @FAId, @comments, @userId", p1, p2, p3);
}
}
var docStatus = AuditManager.Rep.Workspace.GetFileStatus_SSC(new List<int> { (int)activityUpdateModel.FileNum });
returnStatus = docStatus.FirstOrDefault().Status;
}
IM.Mgr.WsUtility.SaveActivityInfo(activityUpdateModel, returnStatus);
return returnStatus;
}
