Int64 IACItemAccountMapDataAccess.Add(ACItemAccountMapEntity aCItemAccountMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(aCItemAccountMapEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(aCItemAccountMapEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 AddTran(ACItemAccountMapEntity aCItemAccountMapEntity, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACItemAccountMap_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddNullPrimaryKeyParameter(cmd, "ItemAccountMapID", db); db.AddInParameter(cmd, "@ItemID", DbType.Int64, aCItemAccountMapEntity.ItemID); db.AddInParameter(cmd, "@DimensionID", DbType.Int64, aCItemAccountMapEntity.DimensionID); db.AddInParameter(cmd, "@SalesAccountID", DbType.Int64, aCItemAccountMapEntity.SalesAccountID); db.AddInParameter(cmd, "@InventoryAccountID", DbType.Int64, aCItemAccountMapEntity.InventoryAccountID); db.AddInParameter(cmd, "@COGSAccountID", DbType.Int64, aCItemAccountMapEntity.COGSAccountID); db.AddInParameter(cmd, "@InventoryAdjustmentsAccountID", DbType.Int64, aCItemAccountMapEntity.InventoryAdjustmentsAccountID); db.AddInParameter(cmd, "@AssetType", DbType.String, aCItemAccountMapEntity.AssetType); db.AddInParameter(cmd, "@PurchaseDate", DbType.DateTime, aCItemAccountMapEntity.PurchaseDate); db.AddInParameter(cmd, "@PurchasePrice", DbType.Decimal, aCItemAccountMapEntity.PurchasePrice); db.AddInParameter(cmd, "@DepreciationRate", DbType.Decimal, aCItemAccountMapEntity.DepreciationRate); db.AddInParameter(cmd, "@DepreciationMethodID", DbType.Int64, aCItemAccountMapEntity.DepreciationMethodID); db.AddInParameter(cmd, "@DepreciationAccountID", DbType.Int64, aCItemAccountMapEntity.DepreciationAccountID); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { returnCode = db.ExecuteNonQuery(cmd, transaction); returnCode = GetReturnCodeFromParameter(cmd, db); if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private void PrepareEditView() { ACItemAccountMapEntity aCItemAccountMapEntity = CurrentACItemAccountMapEntity; if (!aCItemAccountMapEntity.IsNew) { if (ddlItemID.Items.Count > 0 && aCItemAccountMapEntity.ItemID != null) { ddlItemID.SelectedValue = aCItemAccountMapEntity.ItemID.ToString(); } if (ddlDimensionID.Items.Count > 0 && aCItemAccountMapEntity.DimensionID != null) { ddlDimensionID.SelectedValue = aCItemAccountMapEntity.DimensionID.ToString(); } if (ddlSalesAccountID.Items.Count > 0 && aCItemAccountMapEntity.SalesAccountID != null) { ddlSalesAccountID.SelectedValue = aCItemAccountMapEntity.SalesAccountID.ToString(); } if (ddlInventoryAccountID.Items.Count > 0 && aCItemAccountMapEntity.InventoryAccountID != null) { ddlInventoryAccountID.SelectedValue = aCItemAccountMapEntity.InventoryAccountID.ToString(); } if (ddlCOGSAccountID.Items.Count > 0 && aCItemAccountMapEntity.COGSAccountID != null) { ddlCOGSAccountID.SelectedValue = aCItemAccountMapEntity.COGSAccountID.ToString(); } if (ddlInventoryAdjustmentsAccountID.Items.Count > 0 && aCItemAccountMapEntity.InventoryAdjustmentsAccountID != null) { ddlInventoryAdjustmentsAccountID.SelectedValue = aCItemAccountMapEntity.InventoryAdjustmentsAccountID.ToString(); } txtAssetType.Text = aCItemAccountMapEntity.AssetType.ToString(); txtPurchaseDate.Text = aCItemAccountMapEntity.PurchaseDate.ToStringDefault(); txtPurchasePrice.Text = aCItemAccountMapEntity.PurchasePrice.ToString(); txtDepreciationRate.Text = aCItemAccountMapEntity.DepreciationRate.ToString(); if (ddlDepreciationMethodID.Items.Count > 0 && aCItemAccountMapEntity.DepreciationMethodID != null) { ddlDepreciationMethodID.SelectedValue = aCItemAccountMapEntity.DepreciationMethodID.ToString(); } if (ddlDepreciationAccountID.Items.Count > 0 && aCItemAccountMapEntity.DepreciationAccountID != null) { ddlDepreciationAccountID.SelectedValue = aCItemAccountMapEntity.DepreciationAccountID.ToString(); } btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private void SaveACItemAccountMapEntity() { if (IsValid) { try { ACItemAccountMapEntity aCItemAccountMapEntity = BuildACItemAccountMapEntity(); Int64 result = -1; if (aCItemAccountMapEntity.IsNew) { result = FCCACItemAccountMap.GetFacadeCreate().Add(aCItemAccountMapEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACItemAccountMapEntity.FLD_NAME_ItemAccountMapID, aCItemAccountMapEntity.ItemAccountMapID.ToString(), SQLMatchType.Equal); result = FCCACItemAccountMap.GetFacadeCreate().Update(aCItemAccountMapEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _ItemAccountMapID = 0; _ACItemAccountMapEntity = new ACItemAccountMapEntity(); PrepareInitialView(); BindACItemAccountMapList(); if (aCItemAccountMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "A CItem Account Map Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "A CItem Account Map Information has been updated successfully.", false); } } else { if (aCItemAccountMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add A CItem Account Map Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update A CItem Account Map Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvACItemAccountMap_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 ItemAccountMapID; Int64.TryParse(e.CommandArgument.ToString(), out ItemAccountMapID); if (ItemAccountMapID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _ItemAccountMapID = ItemAccountMapID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(ACItemAccountMapEntity.FLD_NAME_ItemAccountMapID, ItemAccountMapID.ToString(), SQLMatchType.Equal); ACItemAccountMapEntity aCItemAccountMapEntity = new ACItemAccountMapEntity(); result = FCCACItemAccountMap.GetFacadeCreate().Delete(aCItemAccountMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _ItemAccountMapID = 0; _ACItemAccountMapEntity = new ACItemAccountMapEntity(); PrepareInitialView(); BindACItemAccountMapList(); MiscUtil.ShowMessage(lblMessage, "A CItem Account Map has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete A CItem Account Map.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 Update(ACItemAccountMapEntity aCItemAccountMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACItemAccountMap_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@ItemAccountMapID", DbType.Int64, aCItemAccountMapEntity.ItemAccountMapID); Database.AddInParameter(cmd, "@ItemID", DbType.Int64, aCItemAccountMapEntity.ItemID); Database.AddInParameter(cmd, "@DimensionID", DbType.Int64, aCItemAccountMapEntity.DimensionID); Database.AddInParameter(cmd, "@SalesAccountID", DbType.Int64, aCItemAccountMapEntity.SalesAccountID); Database.AddInParameter(cmd, "@InventoryAccountID", DbType.Int64, aCItemAccountMapEntity.InventoryAccountID); Database.AddInParameter(cmd, "@COGSAccountID", DbType.Int64, aCItemAccountMapEntity.COGSAccountID); Database.AddInParameter(cmd, "@InventoryAdjustmentsAccountID", DbType.Int64, aCItemAccountMapEntity.InventoryAdjustmentsAccountID); Database.AddInParameter(cmd, "@AssetType", DbType.String, aCItemAccountMapEntity.AssetType); Database.AddInParameter(cmd, "@PurchaseDate", DbType.DateTime, aCItemAccountMapEntity.PurchaseDate); Database.AddInParameter(cmd, "@PurchasePrice", DbType.Decimal, aCItemAccountMapEntity.PurchasePrice); Database.AddInParameter(cmd, "@DepreciationRate", DbType.Decimal, aCItemAccountMapEntity.DepreciationRate); Database.AddInParameter(cmd, "@DepreciationMethodID", DbType.Int64, aCItemAccountMapEntity.DepreciationMethodID); Database.AddInParameter(cmd, "@DepreciationAccountID", DbType.Int64, aCItemAccountMapEntity.DepreciationAccountID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("ACItemAccountMapEntity already exists. Please specify another ACItemAccountMapEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACItemAccountMapEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACItemAccountMapEntity already exists. Please specify another ACItemAccountMapEntity."); } } } } return(returnCode); }
private Int64 DeleteTran(ACItemAccountMapEntity aCItemAccountMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACItemAccountMap_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private Int64 Delete(ACItemAccountMapEntity aCItemAccountMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACItemAccountMap_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("ACItemAccountMapEntity already exists. Please specify another ACItemAccountMapEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACItemAccountMapEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACItemAccountMapEntity already exists. Please specify another ACItemAccountMapEntity."); } } } } return(returnCode); }
protected void btnAddNew_Click(object sender, EventArgs e) { _ItemAccountMapID = 0; _ACItemAccountMapEntity = new ACItemAccountMapEntity(); PrepareInitialView(); }
private ACItemAccountMapEntity BuildACItemAccountMapEntity() { ACItemAccountMapEntity aCItemAccountMapEntity = CurrentACItemAccountMapEntity; if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { } else { aCItemAccountMapEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); } } if (ddlDimensionID.Items.Count > 0) { if (ddlDimensionID.SelectedValue == "0") { aCItemAccountMapEntity.DimensionID = null; } else { aCItemAccountMapEntity.DimensionID = Int64.Parse(ddlDimensionID.SelectedValue); } } if (ddlSalesAccountID.Items.Count > 0) { if (ddlSalesAccountID.SelectedValue == "0") { aCItemAccountMapEntity.SalesAccountID = null; } else { aCItemAccountMapEntity.SalesAccountID = Int64.Parse(ddlSalesAccountID.SelectedValue); } } if (ddlInventoryAccountID.Items.Count > 0) { if (ddlInventoryAccountID.SelectedValue == "0") { aCItemAccountMapEntity.InventoryAccountID = null; } else { aCItemAccountMapEntity.InventoryAccountID = Int64.Parse(ddlInventoryAccountID.SelectedValue); } } if (ddlCOGSAccountID.Items.Count > 0) { if (ddlCOGSAccountID.SelectedValue == "0") { aCItemAccountMapEntity.COGSAccountID = null; } else { aCItemAccountMapEntity.COGSAccountID = Int64.Parse(ddlCOGSAccountID.SelectedValue); } } if (ddlInventoryAdjustmentsAccountID.Items.Count > 0) { if (ddlInventoryAdjustmentsAccountID.SelectedValue == "0") { aCItemAccountMapEntity.InventoryAdjustmentsAccountID = null; } else { aCItemAccountMapEntity.InventoryAdjustmentsAccountID = Int64.Parse(ddlInventoryAdjustmentsAccountID.SelectedValue); } } aCItemAccountMapEntity.AssetType = txtAssetType.Text.Trim(); if (txtPurchaseDate.Text.Trim().IsNotNullOrEmpty()) { aCItemAccountMapEntity.PurchaseDate = MiscUtil.ParseToDateTime(txtPurchaseDate.Text); } else { aCItemAccountMapEntity.PurchaseDate = null; } if (!txtPurchasePrice.Text.Trim().IsNullOrEmpty()) { aCItemAccountMapEntity.PurchasePrice = Decimal.Parse(txtPurchasePrice.Text.Trim()); } else { aCItemAccountMapEntity.PurchasePrice = null; } if (!txtDepreciationRate.Text.Trim().IsNullOrEmpty()) { aCItemAccountMapEntity.DepreciationRate = Decimal.Parse(txtDepreciationRate.Text.Trim()); } else { aCItemAccountMapEntity.DepreciationRate = null; } if (ddlDepreciationMethodID.Items.Count > 0) { if (ddlDepreciationMethodID.SelectedValue == "0") { aCItemAccountMapEntity.DepreciationMethodID = null; } else { aCItemAccountMapEntity.DepreciationMethodID = Int64.Parse(ddlDepreciationMethodID.SelectedValue); } } if (ddlDepreciationAccountID.Items.Count > 0) { if (ddlDepreciationAccountID.SelectedValue == "0") { aCItemAccountMapEntity.DepreciationAccountID = null; } else { aCItemAccountMapEntity.DepreciationAccountID = Int64.Parse(ddlDepreciationAccountID.SelectedValue); } } return(aCItemAccountMapEntity); }
Int64 IACItemAccountMapFacade.Delete(ACItemAccountMapEntity aCItemAccountMapEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACItemAccountMapDataAccess().Delete(aCItemAccountMapEntity, filterExpression, option, reqTran)); }
Int64 IACItemAccountMapFacade.Add(ACItemAccountMapEntity aCItemAccountMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACItemAccountMapDataAccess().Add(aCItemAccountMapEntity, option, reqTran)); }