/// <summary>
/// UpdateCommentsHistoryForSummaryEdit
/// </summary>
public void UpdateCommentsHistoryForSummaryEdit()
{
FlatSectionJlinerJuntionLiner2CommentGateway flatSectionJlinerJuntionLiner2CommentGateway = new FlatSectionJlinerJuntionLiner2CommentGateway();
FlatSectionJlinerJuntionLiner2Comment jlinerComments = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerJuntionLiner2CommentGateway.Data);
FlatSectionJlinerJuntionLiner2HistoryGateway flatSectionJlinerJuntionLiner2HistoryGateway = new FlatSectionJlinerJuntionLiner2HistoryGateway();
FlatSectionJlinerJuntionLiner2History jlinerHistory = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerJuntionLiner2HistoryGateway.Data);
foreach (FlatSectionJlinerTDS.FlatSectionJlinerRow row in (FlatSectionJlinerTDS.FlatSectionJlinerDataTable)Table)
{
flatSectionJlinerJuntionLiner2CommentGateway.LoadByIdRefId(row.ID, row.RefID, row.COMPANY_ID);
row.Comments = jlinerComments.GetAllComments(row.ID, row.RefID, row.COMPANY_ID, flatSectionJlinerJuntionLiner2CommentGateway.Table.Rows.Count, "\n");
flatSectionJlinerJuntionLiner2HistoryGateway.LoadByIdRefId(row.ID, row.RefID, row.COMPANY_ID);
row.History = jlinerHistory.GetAllHistory(row.ID, row.RefID, row.COMPANY_ID, flatSectionJlinerJuntionLiner2HistoryGateway.Table.Rows.Count, "\n");
}
}
private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
Guid id = new Guid(hdfId.Value);
int refId = Int32.Parse(hdfRefId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
// Save Comments
FlatSectionJlinerJuntionLiner2Comment flatSectionJlinerJuntionLiner2Comment = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2Comment.Save(id, companyId);
// Save History
FlatSectionJlinerJuntionLiner2History flatSectionJlinerJuntionLiner2History = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2History.Save(id, companyId);
// Save jliner
FlatSectionJliner flatSectionJlinerUpdateCommentsHistory = new FlatSectionJliner();
flatSectionJlinerUpdateCommentsHistory.LoadByIdRefId(id, refId, companyId);
flatSectionJlinerUpdateCommentsHistory.UpdateComments(id.ToString());
flatSectionJlinerUpdateCommentsHistory.UpdateHistory(id.ToString());
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
flatSectionJlinerUpdateCommentsHistory.Save(companyId);
// Update FlatSectionJliner for new Comments
FlatSectionJliner flatSectionJlinerForCommentsHistory = new FlatSectionJliner(flatSectionJlinerTDS);
flatSectionJlinerForCommentsHistory.UpdateCommentsHistoryForSummaryEdit();
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
/// <summary>
/// Transfer to History
/// </summary>
/// <param name="loginId">loginId</param>
/// <param name="adminPermission">admin Permission</param>
/// <param name="jlinerHistory">jlinerHistory</param>
public void transferToHistory(int loginId, bool adminPermission, FlatSectionJlinerJuntionLiner2History jlinerHistory)
{
foreach (FlatSectionJlinerTDS.JuntionLiner2CommentRow commentRow in (FlatSectionJlinerTDS.JuntionLiner2CommentDataTable)Table)
{
if (adminPermission)
{
if ((commentRow.toHistory) && (!commentRow.Deleted))
{
// Insert to history
jlinerHistory.Insert(commentRow.ID, commentRow.RefID, commentRow.COMPANY_ID, commentRow.DateTime_, commentRow.LoginID, commentRow.Comment, commentRow.Deleted, false, false);
// Delete from comments
commentRow.Deleted = true;
}
}
else
{
if (commentRow.LoginID == loginId)
{
if ((commentRow.toHistory) && (!commentRow.Deleted))
{
// Insert to history
jlinerHistory.Insert(commentRow.ID, commentRow.RefID, commentRow.COMPANY_ID, commentRow.DateTime_, commentRow.LoginID, commentRow.Comment, commentRow.Deleted, false, false);
// Delete from comments
commentRow.Deleted = true;
}
}
}
}
}
private void TransferToHistory()
{
int loginId = Convert.ToInt32(hdfLoginId.Value);
bool adminPermission = Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]);
FlatSectionJlinerJuntionLiner2Comment flatSectionJlinerJuntionLiner2Comment = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerTDS);
FlatSectionJlinerJuntionLiner2History flatSectionJlinerJuntionLiner2History = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2Comment.transferToHistory(loginId, adminPermission, flatSectionJlinerJuntionLiner2History);
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
}
private void GrdHistoryAdd()
{
if (ValidateHistoryFooter())
{
Page.Validate("commentsDataAdd");
if (Page.IsValid)
{
Guid id = new Guid(hdfId.Value);
int refId = Convert.ToInt32(hdfRefId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
DateTime dateTime_ = DateTime.Now;
bool inDatabase = false;
bool deleted = false;
string newComment = ((TextBox)grdHistory.FooterRow.FindControl("tbxHistoryNew")).Text.Trim();
bool toComments = ((CheckBox)grdHistory.FooterRow.FindControl("ckbxToCommentsNew")).Checked;
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string userFullName = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
FlatSectionJlinerJuntionLiner2History model = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS);
model.Insert(id, refId, companyId, dateTime_, loginId, newComment, deleted, toComments, inDatabase);
Session.Remove("historyDummy");
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
Session["history"] = flatSectionJlinerTDS.JuntionLiner2History;
grdHistory.DataBind();
grdHistory.PageIndex = grdHistory.PageCount - 1;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_APP_VIEW"]) && Convert.ToBoolean(Session["sgLFS_APP_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"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in flat_section_jliner_edit.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfId.Value = Convert.ToString(Request.QueryString["rowId"]);
hdfRefId.Value = Convert.ToString(Request.QueryString["rowRefId"]);
hdfCompanyId.Value = Convert.ToString(Request.QueryString["rowCompanyId"]);
hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]).ToString();
hdfUpdate.Value = "yes";
// Prepare initial data
Session.Remove("historyDummy");
// ... Names for UserList
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 comming from
// ... flat_section_jliner_summary.aspx
if (Request.QueryString["source_page"] == "flat_section_jliner_summary.aspx" || Request.QueryString["source_page"] == "flat_section_jliner_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
Session["rowFocus"] = Convert.ToInt32(Request.QueryString["rowFocus"].ToString());
// ... Load history to edit
sectionTDS = new SectionTDS();
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
SectionGateway sectionGateway = new SectionGateway(sectionTDS);
sectionGateway.LoadById(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value));
JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS);
jlinerGateway.LoadByIdCompanyIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value), Convert.ToInt32(hdfRefId.Value));
FlatSectionJlinerJuntionLiner2HistoryGateway flatSectionJlinerJuntionLiner2HistoryGateway = new FlatSectionJlinerJuntionLiner2HistoryGateway(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2HistoryGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value));
FlatSectionJlinerJuntionLiner2History flatSectionJlinerJuntionLiner2History = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerJuntionLiner2HistoryGateway.Data);
flatSectionJlinerJuntionLiner2History.UpdateForProcess();
// ... Load comments for transfers
FlatSectionJlinerJuntionLiner2CommentGateway flatSectionJlinerJuntionLiner2CommentGateway = new FlatSectionJlinerJuntionLiner2CommentGateway(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2CommentGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value));
// ... Store datasets
Session["sectionTDS"] = sectionTDS;
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
history = flatSectionJlinerTDS.JuntionLiner2History;
Session["history"] = history;
}
}
else
{
// Restore datasets
sectionTDS = (SectionTDS)Session["sectionTDS"];
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
history = flatSectionJlinerTDS.JuntionLiner2History;
Session["history"] = history;
}
}
protected void grdHistory_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("commentsDataEdit");
if (Page.IsValid)
{
Guid id = new Guid(((Label)grdHistory.Rows[e.RowIndex].Cells[0].FindControl("lblId")).Text);
int refId = Int32.Parse(((Label)grdHistory.Rows[e.RowIndex].Cells[1].FindControl("lblRefID")).Text);
int companyId = Int32.Parse(hdfCompanyId.Value);
int historyId = Int32.Parse(((Label)grdHistory.Rows[e.RowIndex].Cells[2].FindControl("lblHistoryID")).Text);
int loginId = Convert.ToInt32(Session["loginID"]);
bool adminPermission = Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_ADMIN"]);
string newHistory = ((TextBox)grdHistory.Rows[e.RowIndex].Cells[5].FindControl("tbxHistoryEdit")).Text.Trim();
bool toComments = ((CheckBox)grdHistory.Rows[e.RowIndex].Cells[4].FindControl("ckbxToCommentsEdit")).Checked;
// Update data
FlatSectionJlinerJuntionLiner2History model = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS);
model.Update(id, refId, companyId, historyId, loginId, newHistory, false, adminPermission, toComments);
// Store dataset
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
Session["history"] = flatSectionJlinerTDS.JuntionLiner2History;
}
else
{
e.Cancel = true;
}
}
protected void grdHistory_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Comments Gridview, if the gridview is edition mode
if (grdHistory.EditIndex >= 0)
{
grdHistory.UpdateRow(grdHistory.EditIndex, true);
}
// Delete history
Guid id = new Guid(((Label)grdHistory.Rows[e.RowIndex].Cells[0].FindControl("lblId")).Text);
int refId = Int32.Parse(((Label)grdHistory.Rows[e.RowIndex].Cells[1].FindControl("lblRefID")).Text);
int companyId = Int32.Parse(hdfCompanyId.Value);
int historyId = Int32.Parse(((Label)grdHistory.Rows[e.RowIndex].Cells[2].FindControl("lblHistoryID")).Text);
int loginId = Convert.ToInt32(hdfLoginId.Value);
bool adminPermission = Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_ADMIN"]);
FlatSectionJlinerJuntionLiner2History model = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS);
model.Delete(id, refId, companyId, historyId, loginId, adminPermission);
// Store dataset
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
}