private void LoadAssetNavigation()
{
//Update selected asset id
DatabaseUtilities.UpdateAssetSearchSelectedAsset(QS_ASSET_SEARCH_ID, QS_ASSET_ID);
//Get Asset Search Info Dataset
DataSet ds = DatabaseUtilities.DsGetAssetSearchForNavigation(QS_ASSET_SEARCH_ID, QS_ASSET_ID);
btnFirst.Enabled = false;
btnPrevious.Enabled = false;
btnNext.Enabled = false;
btnLast.Enabled = false;
if (ds.Tables[0].Rows.Count > 0)
{
string current_sort_order = ds.Tables[0].Rows[0]["Selected_Sort_Order"].ToString();
string totalcount = ds.Tables[0].Rows[0]["Total"].ToString();
string prev_asset_id = ds.Tables[0].Rows[0]["Previous_Asset_ID"].ToString();
string next_asset_id = ds.Tables[0].Rows[0]["Next_Asset_ID"].ToString();
string last_asset_id = ds.Tables[0].Rows[0]["Last_Asset_ID"].ToString();
string first_asset_id = ds.Tables[0].Rows[0]["First_Asset_ID"].ToString();
//Asset List button text
string sOutOf = "";
if (!isNull(current_sort_order) && !isNull(totalcount))
{
sOutOf = " (" + current_sort_order + " of " + totalcount + ")";
}
btnReturn.Text = "Asset List" + sOutOf;
//First
if (!isNull(first_asset_id) && !QS_ASSET_ID.Equals(first_asset_id))
{
btnFirst.Enabled = true;
btnFirst.Attributes["Asset_ID"] = first_asset_id;
}
//Previous
if (!isNull(prev_asset_id))
{
btnPrevious.Enabled = true;
btnPrevious.Attributes["Asset_ID"] = prev_asset_id;
}
//Next
if (!isNull(next_asset_id))
{
btnNext.Enabled = true;
btnNext.Attributes["Asset_ID"] = next_asset_id;
}
//Last
if (!isNull(last_asset_id) && !QS_ASSET_ID.Equals(last_asset_id))
{
btnLast.Enabled = true;
btnLast.Attributes["Asset_ID"] = last_asset_id;
}
}
}
private void SaveAsset()
{
Utilities.Assert(!QS_ASSET_ID.Equals("-1"), "Cannot insert Asset");
if (!isNull(QS_ASSET_ID))
{
string p_ID = QS_ASSET_ID;
string p_Tag_ID = txtTagIDEdit.Text;
string p_Serial_Number = txtSerialNumberEdit.Text;
string p_PurchaseDate = txtPurchaseDate.Text;
if (Utilities.isNull(p_PurchaseDate))
{
p_PurchaseDate = Constants.MCSDBNULL;
}
string p_Leased_Term_Days = Utilities.ConvertStringToDBNull(txtLeasedTermDays.Text);
string p_Warranty_Term_Days = Utilities.ConvertStringToDBNull(txtWarrantyTerm.Text);
string p_Asset_Condition_ID = ddlCondition.SelectedValue;
string p_Is_Active = Constants.MCSDBNOPARAM;
if (chkIsActiveEdit.Enabled)
{
p_Is_Active = "0";
if (chkIsActiveEdit.Checked)
{
p_Is_Active = "1";
}
}
string p_Modified_By_Emp_ID = Utilities.GetEmployeeIdByLoggedOn(LoggedOnUser);
string p_Date_Modified = DateTime.Now.ToString();
DatabaseUtilities.Upsert_Asset(
QS_ASSET_ID,
p_Tag_ID,
Constants.MCSDBNOPARAM,
p_Asset_Condition_ID,
Constants.MCSDBNOPARAM,
Constants.MCSDBNOPARAM,
p_Serial_Number,
p_PurchaseDate,
p_Leased_Term_Days,
p_Warranty_Term_Days,
Constants.MCSDBNOPARAM,
p_Is_Active,
Constants.MCSDBNOPARAM,
Constants.MCSDBNOPARAM,
p_Modified_By_Emp_ID,
p_Date_Modified
);
}
}
