private void PrepareEditView() { PRMPreBOQEntity pRMPreBOQEntity = CurrentPRMPreBOQEntity; if (!pRMPreBOQEntity.IsNew) { txtStartDate.Text = pRMPreBOQEntity.StartDate.ToString(UIConstants.SHORT_DATE_FORMAT); if (ddlPreparedByMemberID.Items.Count > 0 && pRMPreBOQEntity.PreparedByMemberID != null) { ddlPreparedByMemberID.SelectedValue = pRMPreBOQEntity.PreparedByMemberID.ToString(); } txtRemarks.Text = pRMPreBOQEntity.Remarks.ToString(); if (ddlPreBOQStatusID.Items.Count > 0 && pRMPreBOQEntity.PreBOQStatusID != null) { ddlPreBOQStatusID.SelectedValue = pRMPreBOQEntity.PreBOQStatusID.ToString(); } chkIsRemoved.Checked = pRMPreBOQEntity.IsRemoved; btnSubmit.Text = "Update"; } FormLock(pRMPreBOQEntity.IsLocked); }
Int64 IPRMPreBOQDataAccess.Add(PRMPreBOQEntity pRMPreBOQEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(pRMPreBOQEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(pRMPreBOQEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
Int64 IPRMPreBOQDataAccess.Delete(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(pRMPreBOQEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(pRMPreBOQEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMPreBOQ_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@PreBOQID", DbType.Int64, pRMPreBOQEntity.PreBOQID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMPreBOQEntity.ProjectID); db.AddInParameter(cmd, "@StartDate", DbType.DateTime, pRMPreBOQEntity.StartDate); db.AddInParameter(cmd, "@PreparedByMemberID", DbType.Int64, pRMPreBOQEntity.PreparedByMemberID); db.AddInParameter(cmd, "@Remarks", DbType.String, pRMPreBOQEntity.Remarks); db.AddInParameter(cmd, "@PreBOQStatusID", DbType.Int64, pRMPreBOQEntity.PreBOQStatusID); db.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, pRMPreBOQEntity.IsRemoved); db.AddInParameter(cmd, "@IsLocked", DbType.Boolean, pRMPreBOQEntity.IsLocked); 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 PRMPreBOQEntity BuildPRMPreBOQEntity() { PRMPreBOQEntity PRMpreBOQEntity = new PRMPreBOQEntity(); PRMpreBOQEntity.ProjectID = OverviewProjectID; PRMpreBOQEntity.StartDate = System.DateTime.Now; PRMpreBOQEntity.PreparedByMemberID = 1; PRMpreBOQEntity.PreBOQStatusID = 1; return(PRMpreBOQEntity); }
private void SavePRMPreBOQEntity() { if (IsValid) { try { PRMPreBOQEntity pRMPreBOQEntity = BuildPRMPreBOQEntity(); Int64 result = -1; if (pRMPreBOQEntity.IsNew) { result = FCCPRMPreBOQ.GetFacadeCreate().Add(pRMPreBOQEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_PreBOQID, pRMPreBOQEntity.PreBOQID.ToString(), SQLMatchType.Equal); result = FCCPRMPreBOQ.GetFacadeCreate().Update(pRMPreBOQEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { PrepareInitialView(); PrepareEditView(); if (pRMPreBOQEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "BOQ Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "BOQ Information has been updated successfully.", false); } } else { if (pRMPreBOQEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add BOQ Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update BOQ Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 DeleteTran(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMPreBOQ_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 Update(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMPreBOQ_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@PreBOQID", DbType.Int64, pRMPreBOQEntity.PreBOQID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMPreBOQEntity.ProjectID); Database.AddInParameter(cmd, "@StartDate", DbType.DateTime, pRMPreBOQEntity.StartDate); Database.AddInParameter(cmd, "@PreparedByMemberID", DbType.Int64, pRMPreBOQEntity.PreparedByMemberID); Database.AddInParameter(cmd, "@Remarks", DbType.String, pRMPreBOQEntity.Remarks); Database.AddInParameter(cmd, "@PreBOQStatusID", DbType.Int64, pRMPreBOQEntity.PreBOQStatusID); Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, pRMPreBOQEntity.IsRemoved); Database.AddInParameter(cmd, "@IsLocked", DbType.Boolean, pRMPreBOQEntity.IsLocked); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("PRMPreBOQEntity already exists. Please specify another PRMPreBOQEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMPreBOQEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMPreBOQEntity already exists. Please specify another PRMPreBOQEntity."); } } } } return(returnCode); }
private PRMPreBOQEntity BuildPRMPreBOQEntity() { PRMPreBOQEntity pRMPreBOQEntity = CurrentPRMPreBOQEntity; pRMPreBOQEntity.ProjectID = this.OverviewProjectID; if (txtStartDate.Text.Trim().IsNotNullOrEmpty()) { pRMPreBOQEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text); } if (ddlPreparedByMemberID.Items.Count > 0) { if (ddlPreparedByMemberID.SelectedValue == "0") { } else { pRMPreBOQEntity.PreparedByMemberID = Int64.Parse(ddlPreparedByMemberID.SelectedValue); } } pRMPreBOQEntity.Remarks = txtRemarks.Text.Trim(); if (ddlPreBOQStatusID.Items.Count > 0) { if (ddlPreBOQStatusID.SelectedValue == "0") { } else { pRMPreBOQEntity.PreBOQStatusID = Int64.Parse(ddlPreBOQStatusID.SelectedValue); } } pRMPreBOQEntity.IsRemoved = chkIsRemoved.Checked; pRMPreBOQEntity.IsLocked = false; return(pRMPreBOQEntity); }
private void SavePRMPreBOQEntity() { if (IsValid) { try { Int64 result = 0; IList <PreBOQtoBOQMigration_CustomEntity> list = FCCPreBOQtoBOQMigration_Custom.GetFacadeCreate().GetIL(CurrentPRMPreBOQEntity.PreBOQID, this.CurrentMember.MemberID); if (list != null && list.Count > 0) { if (list[0].BOQID != null) { result = list[0].BOQID.Value; } } if (result > 0) { PRMPreBOQEntity _pRMPreBOQEntity = CurrentPRMPreBOQEntity; _pRMPreBOQEntity.PreBOQStatusID = MasterDataConstants.PreBOQStatus.COMPLETED; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_PreBOQID, CurrentPRMPreBOQEntity.PreBOQID.ToString(), SQLMatchType.Equal); FCCPRMPreBOQ.GetFacadeCreate().Update(_pRMPreBOQEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); PrepareInitialView(); MiscUtil.ShowMessage(lblMessage, "BOQ to Project Cost migration is successful.", UIConstants.MessageType.GREEN); } else { MiscUtil.ShowMessage(lblMessage, "BOQ to Project Cost migration Failed.", UIConstants.MessageType.RED); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, UIConstants.MessageType.RED); } } }
private Int64 Delete(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMPreBOQ_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("PRMPreBOQEntity already exists. Please specify another PRMPreBOQEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMPreBOQEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMPreBOQEntity already exists. Please specify another PRMPreBOQEntity."); } } } } return(returnCode); }
Int64 IPRMPreBOQFacade.Delete(PRMPreBOQEntity pRMPreBOQEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMPreBOQDataAccess().Delete(pRMPreBOQEntity, filterExpression, option, reqTran)); }
Int64 IPRMPreBOQFacade.Add(PRMPreBOQEntity pRMPreBOQEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMPreBOQDataAccess().Add(pRMPreBOQEntity, option, reqTran)); }
protected void btnPnlSaveAdditionalQty_Click(object sender, EventArgs e) { PRMPreBOQDetailEntity pRMBOQDetailEntity = FCCPRMPreBOQDetail.GetFacadeCreate().GetByID(_CurrentPreBOQDetailIDPopup); if (pRMBOQDetailEntity != null && pRMBOQDetailEntity.PreBOQDetailID > 0) { Decimal additionalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out additionalQty); PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = false; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = _CurrentPreBOQDetailIDPopup; pRMAvailableBOQQtyForRequisitionEntity.ItemID = pRMBOQDetailEntity.ItemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = additionalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); PRMPreBOQEntity pRMPreBOQEntity = FCCPRMPreBOQ.GetFacadeCreate().GetByID(pRMBOQDetailEntity.PreBOQID); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = pRMPreBOQEntity.ProjectID; Int64 result = -1; result = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQDetailID, _CurrentPreBOQDetailIDPopup.ToString(), SQLMatchType.Equal); pRMBOQDetailEntity.TotalQty = pRMBOQDetailEntity.TotalQty + additionalQty; FCCPRMPreBOQDetail.GetFacadeCreate().Update(pRMBOQDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); IList <ListViewDataItem> list = lvPRMPreBOQDetail.Items; if (list != null && list.Count > 0) { Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { DataKey currentDataKey = lvPRMPreBOQDetail.DataKeys[tempDataItemIndex++]; Int64 PreBOQDetailID = (Int64)currentDataKey["PreBOQDetailID"]; if (_CurrentPreBOQDetailIDPopup == PreBOQDetailID) { TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtTotalQtyLV"); txtTotalQtyLV.Text = pRMBOQDetailEntity.TotalQty.ToString(); } } } BindPRMPreBOQDetailList(); #region PreBOQ Floor Detail String fe_projectFloor = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQFloorDetailEntity.FLD_NAME_PreBOQDetailID, _CurrentPreBOQDetailIDPopup.ToString(), SQLMatchType.Equal); IList <PRMPreBOQFloorDetailEntity> lstPRMPreBOQFloorDetail = FCCPRMPreBOQFloorDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_projectFloor, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMPreBOQFloorDetail != null && lstPRMPreBOQFloorDetail.Count > 0) { Int64 totalfloorCount = lstPRMPreBOQFloorDetail.Count; Decimal avgQty = pRMBOQDetailEntity.TotalQty / totalfloorCount; foreach (PRMPreBOQFloorDetailEntity ent in lstPRMPreBOQFloorDetail) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQFloorDetailEntity.FLD_NAME_PreBOQFloorDetailID, ent.PreBOQFloorDetailID.ToString(), SQLMatchType.Equal); ent.Qty = avgQty; FCCPRMPreBOQFloorDetail.GetFacadeCreate().Update(ent, fe1, DatabaseOperationType.Update, TransactionRequired.No); } } #endregion this.ModalPopupExtender1.Hide(); } } }