Int64 IPRMAvailableBOQQtyForRequisitionDataAccess.Add(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(pRMAvailableBOQQtyForRequisitionEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(pRMAvailableBOQQtyForRequisitionEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMAvailableBOQQtyForRequisition_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, "@AvailableBOQQtyForRequisitionID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.AvailableBOQQtyForRequisitionID); db.AddInParameter(cmd, "@IsBOQ", DbType.Boolean, pRMAvailableBOQQtyForRequisitionEntity.IsBOQ); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.ProjectID); db.AddInParameter(cmd, "@PreBOQOrBOQDetailID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID); db.AddInParameter(cmd, "@ItemID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.ItemID); db.AddInParameter(cmd, "@Qty", DbType.Decimal, pRMAvailableBOQQtyForRequisitionEntity.Qty); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, pRMAvailableBOQQtyForRequisitionEntity.CreateDate); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID); 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 DeleteTran(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMAvailableBOQQtyForRequisition_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(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMAvailableBOQQtyForRequisition_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@AvailableBOQQtyForRequisitionID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.AvailableBOQQtyForRequisitionID); Database.AddInParameter(cmd, "@IsBOQ", DbType.Boolean, pRMAvailableBOQQtyForRequisitionEntity.IsBOQ); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.ProjectID); Database.AddInParameter(cmd, "@PreBOQOrBOQDetailID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID); Database.AddInParameter(cmd, "@ItemID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.ItemID); Database.AddInParameter(cmd, "@Qty", DbType.Decimal, pRMAvailableBOQQtyForRequisitionEntity.Qty); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, pRMAvailableBOQQtyForRequisitionEntity.CreateDate); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("PRMAvailableBOQQtyForRequisitionEntity already exists. Please specify another PRMAvailableBOQQtyForRequisitionEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMAvailableBOQQtyForRequisitionEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMAvailableBOQQtyForRequisitionEntity already exists. Please specify another PRMAvailableBOQQtyForRequisitionEntity."); } } } } return(returnCode); }
private Int64 Delete(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMAvailableBOQQtyForRequisition_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("PRMAvailableBOQQtyForRequisitionEntity already exists. Please specify another PRMAvailableBOQQtyForRequisitionEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMAvailableBOQQtyForRequisitionEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMAvailableBOQQtyForRequisitionEntity already exists. Please specify another PRMAvailableBOQQtyForRequisitionEntity."); } } } } return(returnCode); }
protected void btnPnlSaveAdditionalQty_Click(object sender, EventArgs e) { PRMBOQDetailEntity pRMBOQDetailEntity = FCCPRMBOQDetail.GetFacadeCreate().GetByID(_CurrentBOQDetailIDPopup); if (pRMBOQDetailEntity != null && pRMBOQDetailEntity.BOQDetailID > 0) { Decimal additionalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out additionalQty); PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = _CurrentBOQDetailIDPopup; pRMAvailableBOQQtyForRequisitionEntity.ItemID = pRMBOQDetailEntity.ItemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = additionalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); PRMBOQEntity pRMBOQEntity = FCCPRMBOQ.GetFacadeCreate().GetByID(pRMBOQDetailEntity.BOQID); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = pRMBOQEntity.ProjectID; Int64 result = -1; result = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal); pRMBOQDetailEntity.TotalQty = pRMBOQDetailEntity.TotalQty + additionalQty; FCCPRMBOQDetail.GetFacadeCreate().Update(pRMBOQDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); IList <ListViewDataItem> list = lvPRMBOQDetail.Items; if (list != null && list.Count > 0) { Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++]; Int64 intBOQDetailID = (Int64)currentDataKey["BOQDetailID"]; if (_CurrentBOQDetailIDPopup == intBOQDetailID) { TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtTotalQtyLV"); txtTotalQtyLV.Text = pRMBOQDetailEntity.TotalQty.ToString(); } } } BindPRMBOQDetailList(); #region BOQ Floor Detail String fe_projectFloor = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal); IList <PRMBOQFloorDetailEntity> lstPRMBOQFloorDetail = FCCPRMBOQFloorDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_projectFloor, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQFloorDetail != null && lstPRMBOQFloorDetail.Count > 0) { Int64 totalfloorCount = lstPRMBOQFloorDetail.Count; Decimal avgQty = pRMBOQDetailEntity.TotalQty / totalfloorCount; foreach (PRMBOQFloorDetailEntity ent in lstPRMBOQFloorDetail) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, ent.BOQFloorDetailID.ToString(), SQLMatchType.Equal); ent.Qty = avgQty; FCCPRMBOQFloorDetail.GetFacadeCreate().Update(ent, fe1, DatabaseOperationType.Update, TransactionRequired.No); } } #endregion this.ModalPopupExtender1.Hide(); } } }
protected void btnAddToProject_Click(object sender, EventArgs e) { if (ddlProjectID.Items.Count > 0 && ddlProjectID.SelectedValue != "0") { Int64 itemID = 0; if (ViewState["LastUpdatedItemID"] != null) { itemID = (Int64)ViewState["LastUpdatedItemID"]; } if (itemID > 0) { String fe_itemDefault = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal); IList <MDItemDefaultEntity> lstmDItemDefaultEntity = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemDefault, DatabaseOperationType.LoadWithFilterExpression); String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (preBOQList != null && preBOQList.Count > 0) { Int64 preBOQID = preBOQList[0].PreBOQID; Decimal totalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out totalQty); Decimal currentPrice = MiscUtil.GetCurrentPrice(itemID, lstmDItemDefaultEntity[0].BrandID, lstmDItemDefaultEntity[0].SupplierID, lstmDItemDefaultEntity[0].RegionID, lstmDItemDefaultEntity[0].CountryID); switch (preBOQList[0].IsLocked) { case true: #region Add Item to BOQ try { String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQ != null && lstPRMBOQ.Count > 0) { PRMBOQDetailEntity pRMBOQDeatEntity = new PRMBOQDetailEntity(); pRMBOQDeatEntity.BOQID = lstPRMBOQ[0].BOQID; pRMBOQDeatEntity.ItemID = itemID; pRMBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMBOQDeatEntity.Remarks = "Directly Added From Item"; pRMBOQDeatEntity.IsRemoved = false; pRMBOQDeatEntity.Rate = currentPrice; pRMBOQDeatEntity.EntryDate = System.DateTime.Now; pRMBOQDeatEntity.TotalQty = totalQty; Int64 result_boq = -1; result_boq = FCCPRMBOQDetail.GetFacadeCreate().Add(pRMBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_boq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_boq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to Project Cost.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; case false: #region Add Item to Pre-BOQ try { String fe_preBOQ = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> lstPRMPreBOQ = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQ, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMPreBOQ != null && lstPRMPreBOQ.Count > 0) { PRMPreBOQDetailEntity pRMPreBOQDeatEntity = new PRMPreBOQDetailEntity(); pRMPreBOQDeatEntity.PreBOQID = lstPRMPreBOQ[0].PreBOQID; pRMPreBOQDeatEntity.ItemID = itemID; pRMPreBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMPreBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMPreBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMPreBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMPreBOQDeatEntity.TotalQty = totalQty; pRMPreBOQDeatEntity.Remarks = "Directly Added From Item"; pRMPreBOQDeatEntity.IsRemoved = false; pRMPreBOQDeatEntity.Rate = currentPrice; pRMPreBOQDeatEntity.EntryDate = System.DateTime.Now; Int64 result_preboq = -1; result_preboq = FCCPRMPreBOQDetail.GetFacadeCreate().Add(pRMPreBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_preboq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = false; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_preboq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to BOQ.", false); } } } catch (Exception) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; default: break; } } } } }
Int64 IPRMAvailableBOQQtyForRequisitionFacade.Delete(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMAvailableBOQQtyForRequisitionDataAccess().Delete(pRMAvailableBOQQtyForRequisitionEntity, filterExpression, option, reqTran)); }
Int64 IPRMAvailableBOQQtyForRequisitionFacade.Add(PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMAvailableBOQQtyForRequisitionDataAccess().Add(pRMAvailableBOQQtyForRequisitionEntity, option, reqTran)); }