private void AddToAssetList()
{
try
{
if (CheeckToBlankInput())
{
AssetEntryBO objAssetBO = new AssetEntryBO();
objAssetBO.AssetName = ddlAssetList.Text;
objAssetBO.AssetQuantity = Int32.Parse(txtQuantity.Text);
objAssetBO.PurchaseDate = dtpPurchaseDate.Value;
objAssetBO.ServicesDate = dtpServicesDate.Value;
objAssetBO.PurchasePrice = float.Parse(txtPurchasePrice.Text);
objAssetBO.SalvageValue = float.Parse(txtSalvageValue.Text);
objAssetBO.LifeTime = GetTotalTotalDays(Int32.Parse(nudYear.Value.ToString()), Int32.Parse(nudMonth.Value.ToString()), Int32.Parse(nudDays.Value.ToString()));
lblDays.Text = objAssetBO.LifeTime.ToString();
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
objAssetInfoBal.InsertIntoDataBase(objAssetBO);
MessageBox.Show("Data Secessfully Saved.", "Asset Entry", MessageBoxButtons.OK,
MessageBoxIcon.Information);
ShowAssetInfo();
RefreshToDialogBox();
ShowAssetList();
GetRecordInfo();
}
}
catch (Exception)
{
throw;
}
}
public void UpdateAssetInfo(AssetEntryBO objAssetBO, int AssetId)
{
string queryString = "";
queryString = "UPDATE SBP_Capex_Asset SET AssetName='" + objAssetBO.AssetName + "',Quantity=" + objAssetBO.AssetQuantity + ",PurcshaseDate='" + objAssetBO.PurchaseDate + "',ServicesDate='" + objAssetBO.ServicesDate + "',PurchasePrice=" + objAssetBO.PurchasePrice + ",SalvageValue=" + objAssetBO.SalvageValue + ",LifeTime=" + objAssetBO.LifeTime + " WHERE AssetID=" + AssetId + ";";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void InsertIntoDataBase(AssetEntryBO objAssetEntryBO)
{
string queryString = "";
queryString = "INSERT INTO SBP_Capex_Asset (BranchID,CategoryId,AssetName,Quantity,PurcshaseDate,ServicesDate,PurchasePrice,SalvageValue,LifeTime,Depreciation_Rate,EntryDate) VALUES (" + GlobalVariableBO._branchId + "," + objAssetEntryBO.CatagoryId + ",'" + objAssetEntryBO.AssetName + "'," + objAssetEntryBO.AssetQuantity + ",'" + objAssetEntryBO.PurchaseDate + "','" + objAssetEntryBO.ServicesDate + "'," + objAssetEntryBO.PurchasePrice + "," + objAssetEntryBO.SalvageValue + "," + objAssetEntryBO.LifeTime + "," + objAssetEntryBO.DeprceiationRate + ",CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) )";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
}
