// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["work_id"] == null) || ((string)Request.QueryString["asset_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_comments.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_ADMIN"]).ToString();
hdfWorkType.Value = "Rehab Assessment";
hdfWorkId.Value = Request.QueryString["work_id"].ToString();
hdfAssetId.Value = Request.QueryString["asset_id"].ToString();
hdfUpdate.Value = "yes";
// Prepare initial data
Session.Remove("rehabAssessmentCommentDetailsDummy");
// ... Names for UserList
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value),companyId);
hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreationDateTime.Value = DateTime.Now.ToString();
// If coming from
// ... ra_summary.aspx or ra_edit.aspx
if (Request.QueryString["source_page"] == "ra_summary.aspx" || Request.QueryString["source_page"] == "ra_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// For RA
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value.Trim());
if (workId != 0)
{
// ... update comments
RehabAssessmentCommentDetailsGateway rehabAssessmentCommentDetailsGateway = new RehabAssessmentCommentDetailsGateway(rehabAssessmentTDS);
rehabAssessmentCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, workType);
RehabAssessmentCommentDetails rehabAssessmentCommentDetails = new RehabAssessmentCommentDetails(rehabAssessmentCommentDetailsGateway.Data);
rehabAssessmentCommentDetails.UpdateForProcess();
}
// For FLL
int workIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId);
hdfWorkIdFll.Value = workIdFll.ToString();
if (workIdFll != 0)
{
// ... update comments
FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway();
fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workIdFll, companyId, "Full Length Lining");
FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data);
fullLengthLiningCommentDetails.UpdateForProcess();
}
// ... Store datasets
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
Session["rehabAssessmentCommentDetails"] = rehabAssessmentTDS.CommentDetails;
}
}
else
{
// Restore datasets
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
rehabAssessmentCommentDetails = rehabAssessmentTDS.CommentDetails;
}
}
private void workUpdate()
{
// Get general variables
int workId = Int32.Parse(hdfWorkId.Value.Trim());
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
// Update comments for rehab assessment
// Get original variables
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
string originalWorkType = workGateway.GetWorkTypeOriginal(workId);
int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId);
string originalComment = workGateway.GetCommentsOriginal(workId);
string originalHistory = workGateway.GetHistoryOriginal(workId);
//Get all new rehab assessment comments
RehabAssessmentCommentDetailsGateway rehabAssessmentCommentDetailsGateway = new RehabAssessmentCommentDetailsGateway(rehabAssessmentTDS);
rehabAssessmentCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, workType);
RehabAssessmentCommentDetails rehabAssessmentCommentDetails = new RehabAssessmentCommentDetails(rehabAssessmentCommentDetailsGateway.Data);
string newComment = rehabAssessmentCommentDetails.GetAllRehabAssessmentComments(workId, companyId, rehabAssessmentCommentDetailsGateway.Table.Rows.Count, "\n");
Work work = new Work(null);
work.UpdateDirect(workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComment, originalHistory);
// Update comments for full length lining
int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim());
if (workIdFll != 0)
{
WorkGateway workGatewayForFll = new WorkGateway();
workGatewayForFll.LoadByWorkId(workIdFll, companyId);
string originalWorkTypeForFll = workGatewayForFll.GetWorkTypeOriginal(workIdFll);
int? originalLibraryCategoriesIdForFll = workGatewayForFll.GetLibraryCategoriesIdOriginal(workIdFll);
string originalCommentForFll = workGatewayForFll.GetCommentsOriginal(workIdFll);
string originalHistoryForFll = workGatewayForFll.GetHistoryOriginal(workIdFll);
//Get all new fulllengthlining comments
FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway();
fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workIdFll, companyId, "Full Length Lining");
FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data);
string newCommentForFll = fullLengthLiningCommentDetails.GetAllFullLengthLiningComments(workIdFll, companyId, fullLengthLiningCommentDetailsGateway.Table.Rows.Count, "\n");
// Save comments
Work workForFll = new Work(null);
workForFll.UpdateDirect(workIdFll, projectId, assetId, originalWorkTypeForFll, originalLibraryCategoriesIdForFll, false, companyId, originalCommentForFll, originalHistoryForFll, workIdFll, projectId, assetId, originalWorkTypeForFll, originalLibraryCategoriesIdForFll, false, companyId, newCommentForFll, originalHistoryForFll);
}
}
//// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// GetNewRefId
/// </summary>
/// <returns>New ID</returns>
private int GetNewRefId(string type, int workId, int companyId)
{
int newRefId = 0;
if (type == "Rehab Assessment")
{
foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table)
{
if (newRefId < row.RefID)
{
newRefId = row.RefID;
}
}
}
else
{
int maxRefIdFll = 0;
FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway();
fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, "Full Length Lining");
foreach (FullLengthLiningTDS.CommentDetailsRow row in (FullLengthLiningTDS.CommentDetailsDataTable)fullLengthLiningCommentDetailsGateway.Table)
{
if (maxRefIdFll < row.RefID)
{
maxRefIdFll = row.RefID;
}
}
foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table)
{
if (row.Type != "Rehab Assessment")
{
if (maxRefIdFll < row.RefID)
{
maxRefIdFll = row.RefID;
}
}
}
newRefId = maxRefIdFll;
}
newRefId++;
return newRefId;
}