private REQRequisitionEntity BuildREQRequisitionEntity() { REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { rEQRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } rEQRequisitionEntity.RequisitionNo = txtRequisitionNo.Text.Trim(); if (txtRequisitionDate.Text.Trim().IsNotNullOrEmpty()) { rEQRequisitionEntity.RequisitionDate = MiscUtil.ParseToDateTime(txtRequisitionDate.Text); } rEQRequisitionEntity.Remarks = txtRemarks.Text.Trim(); if (ddlRequisitionStatusID.Items.Count > 0) { if (ddlRequisitionStatusID.SelectedValue == "0") { } else { rEQRequisitionEntity.RequisitionStatusID = Int64.Parse(ddlRequisitionStatusID.SelectedValue); } } return(rEQRequisitionEntity); }
Int64 IREQRequisitionDataAccess.Add(REQRequisitionEntity rEQRequisitionEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(rEQRequisitionEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(rEQRequisitionEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
Int64 IREQRequisitionDataAccess.Delete(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(rEQRequisitionEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(rEQRequisitionEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void PrepareEditView() { REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; if (!rEQRequisitionEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && rEQRequisitionEntity.ProjectID != null) { ddlProjectID.SelectedValue = rEQRequisitionEntity.ProjectID.ToString(); } txtRequisitionNo.Text = rEQRequisitionEntity.RequisitionNo.ToString(); txtRequisitionDate.Text = rEQRequisitionEntity.RequisitionDate.ToStringDefault(); txtRemarks.Text = rEQRequisitionEntity.Remarks.ToString(); if (ddlRequisitionStatusID.Items.Count > 0 && rEQRequisitionEntity.RequisitionStatusID != null) { ddlRequisitionStatusID.SelectedValue = rEQRequisitionEntity.RequisitionStatusID.ToString(); } txtRequisitionNo.ToolTip = "Please Write Updated Requisiton No; By Default It's Current Requisiton No!"; btnSubmit.Text = "Update & Edit Details"; chkIsCashPayment.Checked = rEQRequisitionEntity.IsCashPayment; chkIsRCS.Checked = rEQRequisitionEntity.IsRCS; btnAddNew.Visible = true; } }
private Int64 UpdateTran(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisition_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, "@RequisitionID", DbType.Int64, rEQRequisitionEntity.RequisitionID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, rEQRequisitionEntity.ProjectID); db.AddInParameter(cmd, "@RequisitionNo", DbType.String, rEQRequisitionEntity.RequisitionNo); db.AddInParameter(cmd, "@RequisitionDate", DbType.DateTime, rEQRequisitionEntity.RequisitionDate); db.AddInParameter(cmd, "@Remarks", DbType.String, rEQRequisitionEntity.Remarks); db.AddInParameter(cmd, "@RequisitionStatusID", DbType.Int64, rEQRequisitionEntity.RequisitionStatusID); db.AddInParameter(cmd, "@PreparedByMemberID", DbType.Int64, rEQRequisitionEntity.PreparedByMemberID); db.AddInParameter(cmd, "@IsCashPayment", DbType.Boolean, rEQRequisitionEntity.IsCashPayment); db.AddInParameter(cmd, "@IsAccountsMadePayment", DbType.Boolean, rEQRequisitionEntity.IsAccountsMadePayment); db.AddInParameter(cmd, "@IsRCS", DbType.Boolean, rEQRequisitionEntity.IsRCS); 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); }
//Implemented Sequence //private void GetNextREQRequisitionNo() //{ // try // { // #region Common_DA // //DataTable dt = FCCCommonDA_SP.GetFacadeCreate().GetDT(String.Empty, CommonConstants.NEXT_REQUSITION_NO); // //Int32 nextRequsitionNo= 999; // //if (dt.Rows.Count > 0) // //{ // // nextRequsitionNo = (Int32)dt.Rows[0]["MaxID"]; // //} // //txtRequisitionNo.Text = nextRequsitionNo.ToString(); // #endregion // IList<REQRequisitionEntity> requisitonList = FCCREQRequisition.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load); // if (requisitonList != null && requisitonList.Count > 0) // { // Int64 x = (from c in requisitonList // select Convert.ToInt64(c.RequisitionNo)).Max() + 1; // txtRequisitionNo.Text = x.ToString(); // } // else // { // txtRequisitionNo.Text = "62501"; // } // } // catch (Exception ex) // { // txtRequisitionNo.Text = "62501"; // } //} private void SaveREQRequisitionEntity() { if (IsValid) { try { REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity(); Int64 result = -1; if (rEQRequisitionEntity.IsNew) { //Prepared By Employee ID changes only for performing Save Option; not for performing Update Option. rEQRequisitionEntity.PreparedByMemberID = this.CurrentMember.MemberID; result = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionID, rEQRequisitionEntity.RequisitionID.ToString(), SQLMatchType.Equal); result = FCCREQRequisition.GetFacadeCreate().Update(rEQRequisitionEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); if (rEQRequisitionEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Requisition Information has been added successfully.", false); String NavigationUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, REQRequisitionEntity.FLD_NAME_RequisitionID, result.ToString()).ToString(); Response.Redirect(NavigationUrl); } else { MiscUtil.ShowMessage(lblMessage, "Requisition Information has been updated successfully.", false); String NavigationUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, REQRequisitionEntity.FLD_NAME_RequisitionID, result.ToString()).ToString(); Response.Redirect(NavigationUrl); } } else { if (rEQRequisitionEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Requisition Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Requisition Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private REQRequisitionEntity BuildREQRequisitionEntity() { REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; if (rEQRequisitionEntity.IsNew) { if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { rEQRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } } BDProjectEntity _bDProjectEntity = FCCBDProject.GetFacadeCreate().GetByID(rEQRequisitionEntity.ProjectID); if (_bDProjectEntity != null && txtRequisitionNo.Text.ToString() == MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED) { rEQRequisitionEntity.RequisitionNo = _bDProjectEntity.ProjectCode; } else if (_bDProjectEntity != null && txtRequisitionNo.Text.ToString() != MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED) { rEQRequisitionEntity.RequisitionNo = txtRequisitionNo.Text.ToString(); } if (txtRequisitionDate.Text.Trim().IsNotNullOrEmpty()) { rEQRequisitionEntity.RequisitionDate = MiscUtil.ParseToDateTime(txtRequisitionDate.Text); } rEQRequisitionEntity.Remarks = txtRemarks.Text.Trim(); if (ddlRequisitionStatusID.Items.Count > 0) { if (ddlRequisitionStatusID.SelectedValue == "0") { } else { rEQRequisitionEntity.RequisitionStatusID = Int64.Parse(ddlRequisitionStatusID.SelectedValue); } } rEQRequisitionEntity.IsCashPayment = chkIsCashPayment.Checked; rEQRequisitionEntity.IsAccountsMadePayment = false; rEQRequisitionEntity.IsRCS = chkIsRCS.Checked; return(rEQRequisitionEntity); }
protected void lvREQRequisition_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionID); if (RequisitionID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _RequisitionID = RequisitionID; PrepareEditView(); } else if (string.Equals(e.CommandName, "ReportRequisition")) { } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionID, RequisitionID.ToString(), SQLMatchType.Equal); REQRequisitionEntity rEQRequisitionEntity = new REQRequisitionEntity(); result = FCCREQRequisition.GetFacadeCreate().Delete(rEQRequisitionEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); PrepareInitialView(); BindREQRequisitionList(); MiscUtil.ShowMessage(lblMessage, "Requisition has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Requisition.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisition_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(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisition_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@RequisitionID", DbType.Int64, rEQRequisitionEntity.RequisitionID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, rEQRequisitionEntity.ProjectID); Database.AddInParameter(cmd, "@RequisitionNo", DbType.String, rEQRequisitionEntity.RequisitionNo); Database.AddInParameter(cmd, "@RequisitionDate", DbType.DateTime, rEQRequisitionEntity.RequisitionDate); Database.AddInParameter(cmd, "@Remarks", DbType.String, rEQRequisitionEntity.Remarks); Database.AddInParameter(cmd, "@RequisitionStatusID", DbType.Int64, rEQRequisitionEntity.RequisitionStatusID); Database.AddInParameter(cmd, "@PreparedByMemberID", DbType.Int64, rEQRequisitionEntity.PreparedByMemberID); Database.AddInParameter(cmd, "@IsCashPayment", DbType.Boolean, rEQRequisitionEntity.IsCashPayment); Database.AddInParameter(cmd, "@IsAccountsMadePayment", DbType.Boolean, rEQRequisitionEntity.IsAccountsMadePayment); Database.AddInParameter(cmd, "@IsRCS", DbType.Boolean, rEQRequisitionEntity.IsRCS); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("REQRequisitionEntity already exists. Please specify another REQRequisitionEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("REQRequisitionEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("REQRequisitionEntity already exists. Please specify another REQRequisitionEntity."); } } } } return(returnCode); }
protected void lvREQRequisition_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionID); if (RequisitionID > 0) { if (string.Equals(e.CommandName, "CancelItem")) { try { _RequisitionID = RequisitionID; Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionID, RequisitionID.ToString(), SQLMatchType.Equal); REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity;//FCCREQRequisition.GetFacadeCreate().GetByID(_RequisitionID); rEQRequisitionEntity.RequisitionStatusID = MasterDataConstants.RequisitionStatus.CANCELED; result = FCCREQRequisition.GetFacadeCreate().Update(rEQRequisitionEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); if (result > 0) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); PrepareInitialView(); BindREQRequisitionList(); MiscUtil.ShowMessage(lblMessage, "Requisition has been successfully Rejected.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to Requisition Rejected", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void PrepareEditView() { REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; if (!rEQRequisitionEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && rEQRequisitionEntity.ProjectID != null) { ddlProjectID.SelectedValue = rEQRequisitionEntity.ProjectID.ToString(); } txtRequisitionNo.Text = rEQRequisitionEntity.RequisitionNo.ToString(); txtRequisitionDate.Text = rEQRequisitionEntity.RequisitionDate.ToString(UIConstants.SHORT_DATE_FORMAT); txtRemarks.Text = rEQRequisitionEntity.Remarks.ToString(); if (ddlRequisitionStatusID.Items.Count > 0 && rEQRequisitionEntity.RequisitionStatusID != null) { ddlRequisitionStatusID.SelectedValue = rEQRequisitionEntity.RequisitionStatusID.ToString(); } String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionID, _RequisitionID.ToString(), SQLMatchType.Equal); UpdatedMappedRequisitionItem = FCCREQRequisitionItem.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (UpdatedMappedRequisitionItem != null && UpdatedMappedRequisitionItem.Count > 0) { REQRequisitionItemList = UpdatedMappedRequisitionItem; } else { UpdatedMappedRequisitionItem = new List <REQRequisitionItemEntity>(); } BindREQRequisitionList(); } if (_ProjectID > 0) { if (ddlProjectID.Items.Count > 0) { ddlProjectID.SelectedValue = this.OverviewProjectID.ToString(); ddlProjectID.Enabled = false; } } }
private REQRequisitionEntity BuildREQRequisitionEntity() { REQRequisitionEntity rEQRequisitionEntity = new REQRequisitionEntity(); if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { rEQRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } rEQRequisitionEntity.RequisitionNo = "BL-" + txtRequisition.Text.Trim(); rEQRequisitionEntity.RequisitionDate = DateTime.Now; rEQRequisitionEntity.Remarks = "Automatic Created Requisition (Approved Before ERP System) From MRR."; rEQRequisitionEntity.RequisitionStatusID = MasterDataConstants.RequisitionStatus.APPROVED; rEQRequisitionEntity.PreparedByMemberID = this.CurrentMember.MemberID; return(rEQRequisitionEntity); }
protected void lvREQRequisition_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionID); if (string.Equals(e.CommandName, "UpdateItem")) { try { _RequisitionID = RequisitionID; REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; rEQRequisitionEntity.IsAccountsMadePayment = true; Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionID, RequisitionID.ToString(), SQLMatchType.Equal); result = FCCREQRequisition.GetFacadeCreate().Update(rEQRequisitionEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); if (result > 0) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); BindREQRequisitionList(); //MiscUtil.ShowMessage(lblMessage, "Requisition has been successfully Updated.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to Update Requisition.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 Delete(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisition_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("REQRequisitionEntity already exists. Please specify another REQRequisitionEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("REQRequisitionEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("REQRequisitionEntity already exists. Please specify another REQRequisitionEntity."); } } } } return(returnCode); }
private void SaveREQRequisitionEntity() { if (IsValid) { try { REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity(); Int64 result = -1; if (rEQRequisitionEntity.IsNew) { //Prepared By ID Only for Save Operation; not for Update. rEQRequisitionEntity.PreparedByMemberID = this.CurrentMember.MemberID; result = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionID, rEQRequisitionEntity.RequisitionID.ToString(), SQLMatchType.Equal); result = FCCREQRequisition.GetFacadeCreate().Update(rEQRequisitionEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } BindRequisitionItemInfo(); IList <REQRequisitionItemEntity> deleteList = UpdatedMappedRequisitionItem.Except(REQRequisitionItemList, new CustomerComparer()).ToList(); IList <REQRequisitionItemEntity> addNewList = REQRequisitionItemList.Except(UpdatedMappedRequisitionItem, new CustomerComparer()).ToList(); foreach (REQRequisitionItemEntity ent in deleteList) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); FCCREQRequisitionItem.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No); } StringBuilder xmlStr = new StringBuilder(); String subXmlStr = String.Empty; xmlStr.Append("<m>"); foreach (REQRequisitionItemEntity ent in addNewList) { subXmlStr = subXmlStr + "<i><a>" + result + "</a><b>" + ent.AccountsCode + "</b><c>" + ent.ItemID + "</c><d>" + ent.TotalRequiredQty + "</d><e>" + ent.PurchasedQtyTillToDate + "</e><f>" + ent.PresentRequiredQty + "</f><g>" + ent.RequiredDate + "</g><h>" + ent.Remarks + "</h><j>" + ent.Rate + "</j></i>"; } xmlStr.Append(subXmlStr.ToString()); xmlStr.Append("</m>"); FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.RequisitionItemInfo); if (result > 0) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); PrepareInitialView(); ClearAllRequisitionItem(); if (rEQRequisitionEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Requisition Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Requisition Information has been updated successfully.", false); } } else { if (rEQRequisitionEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Requisition Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Requisition Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void btnAddNew_Click(object sender, EventArgs e) { _RequisitionID = 0; _REQRequisitionEntity = new REQRequisitionEntity(); PrepareInitialView(); }
private void PrepareEditView() { REQRequisitionEntity rEQRequisitionEntity = CurrentREQRequisitionEntity; }
private void SavePRMMaterialReceiveEntity() { if (IsValid) { try { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity(); #region Requisition String RequisitionNo = String.Empty; if (txtRequisition.Text.IsNotNullOrEmpty()) { RequisitionNo = "BL-" + txtRequisition.Text.ToString(); } Int64 resultRequisition = -1; Int64 resultRequisitionItem = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionNo, RequisitionNo, SQLMatchType.Equal); IList <REQRequisitionEntity> lstRequisition = FCCREQRequisition.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); REQRequisitionItemEntity rEQRequisitionItemEntity = null; if (lstRequisition != null && lstRequisition.Count > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(lstRequisition[0].RequisitionID); pRMMaterialReceiveEntity.RequisitionID = lstRequisition[0].RequisitionID; } else { REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity(); resultRequisition = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); pRMMaterialReceiveEntity.RequisitionID = resultRequisition; if (resultRequisition > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(resultRequisition); } } if (rEQRequisitionItemEntity != null) { resultRequisitionItem = FCCREQRequisitionItem.GetFacadeCreate().Add(rEQRequisitionItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } #endregion #region MRR Int64 resultOne = -1; if (pRMMaterialReceiveEntity.IsNew) { resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } #endregion if (resultOne > 0 && resultRequisitionItem > 0) { #region Material Receive Item Map Int64 resultTwo = -1; PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = BuildPRMMaterialReceiveItemMapEntity(resultOne, resultRequisitionItem); resultTwo = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Add(pRMMaterialReceiveItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); #endregion try { #region Inventory Int64 _employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); Int64 _projectID = Int64.Parse(ddlProjectID.SelectedValue); INVStoreEntity storeEntity = INVManager.GetDefaultStore(_projectID); Int64 storeID = storeEntity.StoreID; INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeID); Int64 storeUnitID = storeUnitEntity.StoreUnitID; String fe_requisitionItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, resultRequisitionItem.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisitionItem); Int64 _itemID = 0; Decimal _rate = 0; Int64 brandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD; Int64 regionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION; Int64 countryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY; if (lst != null && lst.Count > 0) { _itemID = lst[0].ItemID; brandID = (Int64)lst[0].BrandID; regionID = (Int64)lst[0].RegionID; countryID = (Int64)lst[0].CountryID; _rate = lst[0].Rate; } Boolean invResult = INVManager.AddItemsToStoreUnit(_itemID, brandID, regionID, countryID, "", Int64.Parse(txtReceiveQty.Text.ToString()), MiscUtil.GetLocalIP(), _employeeID, _rate, txtRequisition.Text, ddlWorkOrderID.SelectedItem.Text, resultOne.ToString(), "", Int64.Parse(ddlProjectID.SelectedValue), storeID, storeUnitID); #endregion } catch (Exception ex) { } _MaterialReceiveID = resultOne; PrepareInitialViewSave(); btnAddNew.Visible = true; if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been updated successfully.", false); } } else { if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Material Receive Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Material Receive Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
Int64 IREQRequisitionFacade.Add(REQRequisitionEntity rEQRequisitionEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateREQRequisitionDataAccess().Add(rEQRequisitionEntity, option, reqTran)); }
Int64 IREQRequisitionFacade.Delete(REQRequisitionEntity rEQRequisitionEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateREQRequisitionDataAccess().Delete(rEQRequisitionEntity, filterExpression, option, reqTran)); }