// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_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["repair_point_id"] == null) || ((string)Request.QueryString["work_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_size.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfRepairPointId.Value = Convert.ToString(Request.QueryString["repair_point_id"]);
hdfWorkId.Value = Convert.ToString(Request.QueryString["work_id"]);
hdfUpdate.Value = "yes";
Session.Remove("sizeInformationNewDummy");
Session.Remove("sizeInformation");
// If comming from
// ... pr_edit.aspx
if (Request.QueryString["source_page"] == "pr_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Load size to edit
pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"];
sizeInformationTDS = new SizeInformationTDS();
SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS);
sizeInformationGateway.Load(Int32.Parse(hdfCompanyId.Value.Trim()));
// ... Store datasets
Session["sizeInformationTDS"] = sizeInformationTDS;
Session["sizeInformation"] = sizeInformationTDS.SizeInformation;
}
}
else
{
// Restore datasets
pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"];
sizeInformationTDS = (SizeInformationTDS)Session["sizeInformationTDS"];
sizeInformation = sizeInformationTDS.SizeInformation;
}
}
protected void cvSizeEdit_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
string originalSize = ((HiddenField)grdSize.Rows[grdSize.EditIndex].Cells[2].FindControl("hdfSizeEdit")).Value;
if (originalSize != args.Value.Trim())
{
SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS);
if (sizeInformationGateway.Table.Rows.Count > 0)
{
foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationGateway.Table)
{
if (row.Size_ == args.Value.Trim())
{
args.IsValid = false;
}
}
}
}
}
protected void cvSizeNew_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS);
if (sizeInformationGateway.Table.Rows.Count > 0)
{
foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationGateway.Table)
{
if (row.Size_ == args.Value.Trim())
{
args.IsValid = false;
}
}
}
}
/// <summary>
/// Save all size to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
SizeInformationTDS sizeInformationChanges = (SizeInformationTDS)Data.GetChanges();
if (sizeInformationChanges != null)
{
if (sizeInformationChanges.SizeInformation.Rows.Count > 0)
{
SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationChanges);
foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationChanges.SizeInformation)
{
// Insert new size
if ((!row.Deleted) && (!row.InDatabase))
{
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway();
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSizeGateway.LoadAllBySize_(row.Size_, row.COMPANY_ID);
if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0)
{
workPointRepairsRepairPointSize.InsertDirect(row.Size_, row.COMPANY_ID, row.Deleted);
}
else
{
workPointRepairsRepairPointSize.UnDeleteDirect(row.Size_, row.COMPANY_ID);
}
}
// Update size
if ((!row.Deleted) && (row.InDatabase))
{
string originalSize_ = row.NewSize_;
string newSize_ = row.Size_;
int originalCompanyId = companyId;
WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway();
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSizeGateway.LoadAllBySize_(newSize_, companyId);
if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0)
{
workPointRepairsRepairPointSize.InsertDirect(newSize_, originalCompanyId, false);
}
else
{
workPointRepairsRepairPointSize.UnDeleteDirect(newSize_, originalCompanyId);
}
if (workPointRepairsRepairPointSizeGateway.IsUsedInPointRepair(originalSize_, companyId))
{
WorkPointRepairsRepairGateway workPointRepairsRepairGateway = new WorkPointRepairsRepairGateway(null);
workPointRepairsRepairGateway.UpdateSize(originalSize_, companyId, newSize_, companyId);
}
workPointRepairsRepairPointSize.DeleteDirect(originalSize_, companyId);
}
// Delete size
if ((row.Deleted) && (row.InDatabase))
{
WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null);
workPointRepairsRepairPointSize.DeleteDirect(row.Size_, row.COMPANY_ID);
}
}
}
}
}
