// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_MATERIALS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_MATERIALS_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["material_state"] == null) || ((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["material_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in materials_state.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfMaterialId.Value = Request.QueryString["material_id"];
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
// Prepare initial data
// ... for material title
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int materialId = Int32.Parse(hdfMaterialId.Value);
MaterialsGateway materialsGateway = new MaterialsGateway();
materialsGateway.LoadByMaterialId(materialId, companyId);
lblTitleMaterial.Text = "Material: " + materialsGateway.GetDescription(materialId);
// If coming from materials_summary.aspx
if ((string)Request.QueryString["source_page"] == "materials_summary.aspx")
{
// Store Navigator State and Update control
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Get project record
materialsInformationTDS = (MaterialsInformationTDS)Session["materialsInformationTDS"];
MaterialsInformationBasicInformationGateway materialsInformationBasicInformationGateway = new MaterialsInformationBasicInformationGateway(materialsInformationTDS);
materialsInformationBasicInformationGateway.LoadByMaterialId(materialId, companyId);
// Store datasets
Session["materialsInformationTDS"] = materialsInformationTDS;
}
}
else
{
// Restore dataset
materialsInformationTDS = (MaterialsInformationTDS)Session["materialsInformationTDS"];
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_MATERIALS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_MATERIALS_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["material_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in materials_edit.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfResourceType.Value = "Materials";
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfCurrentMaterialId.Value = Request.QueryString["material_id"];
// Prepare initial data
Session.Remove("materialsNotesDummy");
Session.Remove("materialsCostsDummy");
Session.Remove("materialsCostsExceptionsDummy");
Session.Remove("costIdSelected");
// ... for team member title
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int materialId = Int32.Parse(hdfCurrentMaterialId.Value);
MaterialsGateway materialsGateway = new MaterialsGateway();
materialsGateway.LoadByMaterialId(materialId, companyId);
lblTitleMaterials.Text = "Material: " + materialsGateway.GetDescription(materialId);
// If coming from
string resourceType = hdfResourceType.Value;
// ... materials_navigator2.aspx or materials_add.aspx
if ((Request.QueryString["source_page"] == "materials_navigator2.aspx")|| (Request.QueryString["source_page"] == "materials_add.aspx"))
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedMaterials"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
materialsInformationTDS = new MaterialsInformationTDS();
materialsTDS = new MaterialsTDS();
MaterialsInformationBasicInformation materialsInformationBasicInformation = new MaterialsInformationBasicInformation(materialsInformationTDS);
materialsInformationBasicInformation.LoadByMaterialId(materialId, companyId);
MaterialsInformationCostHistoryInformation materialsInformationCostHistoryInformation = new MaterialsInformationCostHistoryInformation(materialsInformationTDS);
materialsInformationCostHistoryInformation.LoadAllByMaterialId(materialId, companyId);
MaterialsInformationCostHistoryExceptionsInformation materialsInformationCostHistoryExceptionsInformation = new MaterialsInformationCostHistoryExceptionsInformation(materialsInformationTDS);
materialsInformationCostHistoryExceptionsInformation.LoadAllByMaterialId(materialId, companyId);
MaterialsInformationNoteInformation materialsInformationNoteInformationForEdit = new MaterialsInformationNoteInformation(materialsInformationTDS);
materialsInformationNoteInformationForEdit.LoadAllByMaterialId(materialId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabMaterials"];
// Restore datasets
materialsTDS = (MaterialsTDS)Session["materialsTDS"];
materialsInformationTDS = (MaterialsInformationTDS)Session["materialsInformationTDS"];
}
// ... Store dataset
Session["materialsInformationTDS"] = materialsInformationTDS;
Session["materialsTDS"] = materialsTDS;
}
// ... materials_summary.aspx or materials_edit
if ((Request.QueryString["source_page"] == "materials_summary.aspx") || (Request.QueryString["source_page"] == "materials_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
materialsTDS = (MaterialsTDS)Session["materialsTDS"];
materialsInformationTDS = (MaterialsInformationTDS)Session["materialsInformationTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedMaterials"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabMaterials"];
}
if (ViewState["update"].ToString().Trim() == "yes")
{
MaterialsInformationBasicInformation materialsInformationBasicInformation = new MaterialsInformationBasicInformation(materialsInformationTDS);
materialsInformationBasicInformation.LoadByMaterialId(materialId, companyId);
MaterialsInformationCostHistoryInformation materialsInformationCostHistoryInformation = new MaterialsInformationCostHistoryInformation(materialsInformationTDS);
materialsInformationCostHistoryInformation.LoadAllByMaterialId(materialId, companyId);
MaterialsInformationCostHistoryExceptionsInformation materialsInformationCostHistoryExceptionsInformation = new MaterialsInformationCostHistoryExceptionsInformation(materialsInformationTDS);
materialsInformationCostHistoryExceptionsInformation.LoadAllByMaterialId(materialId, companyId);
MaterialsInformationNoteInformation materialsInformationNoteInformationForEdit = new MaterialsInformationNoteInformation(materialsInformationTDS);
materialsInformationNoteInformationForEdit.LoadAllByMaterialId(materialId, companyId);
// ... Store dataset
Session["materialsInformationTDS"] = materialsInformationTDS;
Session["materialsTDS"] = materialsTDS;
}
}
Session["costIdSelected"] = 0;
grdCostsExceptions.ShowFooter = false;
string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0);
odsCostsExceptions.FilterExpression = filterOptions;
// Prepare initial data
// ... Set initial tab
int activeTabMaterials = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTabMaterials;
// ... Data for current material
LoadData(companyId);
// Databind
Page.DataBind();
}
else
{
// Restore datasets
materialsTDS = (MaterialsTDS)Session["materialsTDS"];
materialsInformationTDS = (MaterialsInformationTDS)Session["materialsInformationTDS"];
// Set initial tab
int activeTabMaterials = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTabMaterials;
}
}
/// <summary>
/// Update material (direct to DB)
/// </summary>
/// <param name="originalMaterialId">originalMaterialId</param>
/// <param name="originalDescription">originalDescription</param>
/// <param name="originalSize">originalSize</param>
/// <param name="originalLength">originalLength</param>
/// <param name="originalThickness">originalThickness</param>
/// <param name="originalType">originalType</param>
/// <param name="originalState">originalState</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
///
/// <param name="newDescription">newDescription</param>
/// <param name="newSize">newSize</param>
/// <param name="newLength">newLength</param>
/// <param name="newThickness">newThickness</param>
/// <param name="newType">newType</param>
/// <param name="newState">newState</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
public void UpdateDirect(int originalMaterialId, string originalDescription, string originalSize, string originalLength, string originalThickness, string originalType, string originalState, bool originalDeleted, int originalCompanyId, int newMaterialId, string newDescription, string newSize, string newLength, string newThickness, string newType, string newState, bool newDeleted, int newCompanyId)
{
MaterialsGateway materialsGateway = new MaterialsGateway(null);
materialsGateway.Update(originalMaterialId, originalDescription, originalSize, originalLength, originalThickness, originalType, originalState, originalDeleted, originalCompanyId, newMaterialId, newDescription, newSize, newLength, newThickness, newType, newState, newDeleted, newCompanyId);
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Insert a new material (direct to DB)
/// </summary>
/// <param name="materialId">materialId</param>
/// <param name="description">description</param>
/// <param name="size">size</param>
/// <param name="length">length</param>
/// <param name="thickness">thickness</param>
/// <param name="type">type</param>
/// <param name="state">state</param>
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
public void InsertDirect(int materialId, string description, string size, string length, string thickness, string type, string state, bool deleted, int companyId)
{
MaterialsGateway materialsGateway = new MaterialsGateway(null);
materialsGateway.Insert(materialId, description, size, length, thickness, type, state, deleted, companyId);
}
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="originalMaterialId">originalMaterialId</param>
public void DeleteDirect(int originalMaterialId)
{
MaterialsGateway materialsGateway = new MaterialsGateway(null);
materialsGateway.Delete(originalMaterialId);
}
/// <summary>
/// GetCostUsd
/// </summary>
/// <param name="startDate">startDate</param>
/// <param name="endDate">endDate</param>
/// <param name="description">description</param>
/// <param name="work_">work_</param>
/// <param name="companyId">companyId</param>
/// <returns>cost</returns>
private decimal GetCostUsd(DateTime startDate, DateTime endDate, string description, string work_, int companyId)
{
decimal cost = 0;
MaterialsGateway materialsGateway = new MaterialsGateway();
materialsGateway.LoadByDescription(description, companyId);
if (materialsGateway.Table.Rows.Count > 0)
{
int materialId = materialsGateway.GetMaterialId(description);
ProjectCostingSheetAddMaterialListGateway projectCostingSheetAddMaterialListGateway = new ProjectCostingSheetAddMaterialListGateway();
projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialIdWork_(startDate, endDate, materialId, work_);
if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0)
{
projectCostingSheetAddMaterialListGateway.LoadByStartDateEndDateMaterialId(startDate, endDate, materialId);
if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0)
{
projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialIdWork_(startDate, materialId, work_);
if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0)
{
projectCostingSheetAddMaterialListGateway.LoadByStartDateMaterialId(startDate, materialId);
if (projectCostingSheetAddMaterialListGateway.Table.Rows.Count <= 0)
{
projectCostingSheetAddMaterialListGateway.LoadByMaterialId(materialId);
}
}
}
}
DataRow materialRow = projectCostingSheetAddMaterialListGateway.GetRow(materialId);
cost = (decimal)materialRow["CostUsd"];
}
return cost;
}