/// <summary>
/// Save
/// </summary>
public void Save()
{
UnitsOfMeasurementNavigatorTDS unitOfMeasurementAddChanges = (UnitsOfMeasurementNavigatorTDS)Data.GetChanges();
if (unitOfMeasurementAddChanges != null)
{
if (unitOfMeasurementAddChanges.UnitsOfMeasurementNavigator.Rows.Count > 0)
{
UnitsOfMeasurementNavigatorGateway unitsOfMeasurementNavigatorGateway = new UnitsOfMeasurementNavigatorGateway(unitOfMeasurementAddChanges);
// Update unit of measurement
foreach (UnitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigatorRow row in (UnitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigatorDataTable)unitOfMeasurementAddChanges.UnitsOfMeasurementNavigator)
{
int companyId = row.COMPANY_ID;
// Insert new unit of measurement
if ((!row.Deleted) && (!row.InDataBase))
{
int unitOfMeasurementId = row.UnitOfMeasurementID;
string description = row.Description;
string abreviation = row.Abbreviation;
bool deleted = row.Deleted;
UnitsOfMeasurement unitsOfMeasurement = new UnitsOfMeasurement(null);
unitsOfMeasurement.InsertDirect(unitOfMeasurementId, description, abreviation, deleted, companyId);
}
// Update unit of measurement
if ((!row.Deleted) && (row.InDataBase))
{
int unitOfMeasurementId = row.UnitOfMeasurementID;
bool originalDeleted = false;
int originalCompanyId = companyId;
// Original values
string originalDescription = unitsOfMeasurementNavigatorGateway.GetDescriptionOriginal(unitOfMeasurementId);
string originalAbbreviation = unitsOfMeasurementNavigatorGateway.GetAbbreviationOriginal(unitOfMeasurementId);
// New values
string newDescription = unitsOfMeasurementNavigatorGateway.GetDescription(unitOfMeasurementId);
string newAbbreviation = unitsOfMeasurementNavigatorGateway.GetAbbreviation(unitOfMeasurementId);
UnitsOfMeasurement unitsOfMeasurement = new UnitsOfMeasurement(null);
unitsOfMeasurement.UpdateDirect(unitOfMeasurementId, originalDescription, originalAbbreviation, originalDeleted, originalCompanyId, unitOfMeasurementId, newDescription, newAbbreviation, originalDeleted, originalCompanyId);
}
// Delete unit of measurement
if ((row.Deleted) && (row.InDataBase))
{
UnitsOfMeasurement unitsOfMeasurement = new UnitsOfMeasurement(null);
unitsOfMeasurement.DeleteDirect(row.UnitOfMeasurementID, row.COMPANY_ID);
}
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// INITIAL EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if ((!Convert.ToBoolean(Session["sgLFS_RESOURCES_UNITSOFMEASUREMENT_VIEW"])) && (!Convert.ToBoolean(Session["sgLFS_RESOURCES_UNITSOFMEASUREMENT_ADD"])) && (!Convert.ToBoolean(Session["sgLFS_RESOURCES_UNITSOFMEASUREMENT_EDIT"])) && (!Convert.ToBoolean(Session["sgLFS_RESOURCES_UNITSOFMEASUREMENT_DELETE"])) )
{
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)
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in unitsOfMeasurement_navigator.aspx");
}
// Tag Page
Session.Remove("unitOfMeasurementDummy");
hdfCompanyId.Value = Session["companyID"].ToString();
// If coming from out
if (((string)Request.QueryString["source_page"] == "out") || ((string)Request.QueryString["source_page"] == "unitsOfMeasurement_navigator.aspx"))
{
unitsOfMeasurementNavigatorTDS = new UnitsOfMeasurementNavigatorTDS();
// Get unitsOfMeasurement records
int companyId = Int32.Parse(hdfCompanyId.Value);
UnitsOfMeasurementNavigatorGateway unitsOfMeasurementNavigatorGateway = new UnitsOfMeasurementNavigatorGateway(unitsOfMeasurementNavigatorTDS);
unitsOfMeasurementNavigatorGateway.LoadAll(companyId);
// Store dataset
Session["unitsOfMeasurementNavigatorTDS"] = unitsOfMeasurementNavigatorTDS;
Session["unitsOfMeasurementNavigator"] = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator;
unitsOfMeasurementNavigator = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator;
}
// Databind
Page.DataBind();
}
else
{
// Restore dataset
unitsOfMeasurementNavigatorTDS = (UnitsOfMeasurementNavigatorTDS)Session["unitsOfMeasurementNavigatorTDS"];
unitsOfMeasurementNavigator = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator;
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAll
/// </summary>
/// <param name="companyId">companyId</param>
public void LoadAll(int companyId)
{
UnitsOfMeasurementNavigatorGateway unitsOfMeasurementNavigatorGateway = new UnitsOfMeasurementNavigatorGateway(Data);
unitsOfMeasurementNavigatorGateway.LoadAll(companyId);
}