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(); } }