Int64 IPRMMaterialReceiveDataAccess.Add(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(pRMMaterialReceiveEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(pRMMaterialReceiveEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private PRMMaterialReceiveEntity BuildPRMMaterialReceiveEntity() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } pRMMaterialReceiveEntity.MRRNo = txtMRRNo.Text.Trim(); if (txtMRRDate.Text.Trim().IsNotNullOrEmpty()) { pRMMaterialReceiveEntity.MRRDate = MiscUtil.ParseToDateTime(txtMRRDate.Text); } pRMMaterialReceiveEntity.Remarks = txtRemarks.Text.Trim(); pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID = MasterDataConstants.MDMaterialReceiveApprovalStatus.INITIATED; pRMMaterialReceiveEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(pRMMaterialReceiveEntity); }
private void PrepareEditView() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (!pRMMaterialReceiveEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && pRMMaterialReceiveEntity.ProjectID != null) { ddlProjectID.SelectedValue = pRMMaterialReceiveEntity.ProjectID.ToString(); } if (ddlSupplierID.Items.Count > 0 && pRMMaterialReceiveEntity.SupplierID != null) { ddlSupplierID.SelectedValue = pRMMaterialReceiveEntity.SupplierID.ToString(); } //Requisition Login need to implement if (ddlWorkOrderID.Items.Count > 0 && pRMMaterialReceiveEntity.WorkOrderID != null) { ddlWorkOrderID.SelectedValue = pRMMaterialReceiveEntity.WorkOrderID.ToString(); } txtMRRNo.Text = pRMMaterialReceiveEntity.MRRNo.ToString(); txtMRRDate.Text = pRMMaterialReceiveEntity.MRRDate.ToStringDefault(); txtRemarks.Text = pRMMaterialReceiveEntity.Remarks.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private Int64 UpdateTran(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMMaterialReceive_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, "@MaterialReceiveID", DbType.Int64, pRMMaterialReceiveEntity.MaterialReceiveID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMMaterialReceiveEntity.ProjectID); db.AddInParameter(cmd, "@SupplierID", DbType.Int64, pRMMaterialReceiveEntity.SupplierID); db.AddInParameter(cmd, "@RequisitionID", DbType.Int64, pRMMaterialReceiveEntity.RequisitionID); db.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, pRMMaterialReceiveEntity.WorkOrderID); db.AddInParameter(cmd, "@MRRNo", DbType.String, pRMMaterialReceiveEntity.MRRNo); db.AddInParameter(cmd, "@MRRDate", DbType.DateTime, pRMMaterialReceiveEntity.MRRDate); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, pRMMaterialReceiveEntity.CreatedByEmployeeID); db.AddInParameter(cmd, "@Remarks", DbType.String, pRMMaterialReceiveEntity.Remarks); db.AddInParameter(cmd, "@MaterialReceiveApprovalStatusID", DbType.Int64, pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID); 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 PRMMaterialReceiveEntity BuildPRMMaterialReceiveEntity() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } pRMMaterialReceiveEntity.MRRNo = txtMRRNo.Text.Trim(); if (txtMRRDate.Text.Trim().IsNotNullOrEmpty()) { pRMMaterialReceiveEntity.MRRDate = MiscUtil.ParseToDateTime(txtMRRDate.Text); } pRMMaterialReceiveEntity.Remarks = txtRemarks.Text.Trim(); return(pRMMaterialReceiveEntity); }
private void SavePRMMaterialReceiveEntity() { if (IsValid) { try { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity(); Int64 result = -1; if (pRMMaterialReceiveEntity.IsNew) { result = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); result = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { // BuildPRMMaterialReceiveItemEntity(result, pRMMaterialReceiveEntity); _MaterialReceiveID = 0; _PRMMaterialReceiveEntity = new PRMMaterialReceiveEntity(); PrepareInitialView(); 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); } } }
private void PrepareEditView() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (!pRMMaterialReceiveEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && pRMMaterialReceiveEntity.ProjectID != null) { ddlProjectID.SelectedValue = pRMMaterialReceiveEntity.ProjectID.ToString(); } BindRequisitonAndWOByProject(); if (ddlSupplierID.Items.Count > 0 && pRMMaterialReceiveEntity.SupplierID != null) { ddlSupplierID.SelectedValue = pRMMaterialReceiveEntity.SupplierID.ToString(); } BindRequisitionBySupplier(); if (ddlRequisitionID.Items.Count > 0 && pRMMaterialReceiveEntity.RequisitionID != null) { ddlRequisitionID.SelectedValue = pRMMaterialReceiveEntity.RequisitionID.ToString(); } BindWorkorderByRequisition(); if (ddlWorkOrderID.Items.Count > 0 && pRMMaterialReceiveEntity.WorkOrderID != null) { ddlWorkOrderID.SelectedValue = pRMMaterialReceiveEntity.WorkOrderID.ToString(); } txtMRRNo.Text = pRMMaterialReceiveEntity.MRRNo.ToString(); txtMRRDate.Text = pRMMaterialReceiveEntity.MRRDate.ToStringDefault(); txtRemarks.Text = pRMMaterialReceiveEntity.Remarks.ToString(); String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveID, _MaterialReceiveID.ToString(), SQLMatchType.Equal); UpdatedMappedPRMMaterialReceiveEntity = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (UpdatedMappedPRMMaterialReceiveEntity != null && UpdatedMappedPRMMaterialReceiveEntity.Count > 0) { PRMMaterialReceiveItemMapList = UpdatedMappedPRMMaterialReceiveEntity; } else { UpdatedMappedPRMMaterialReceiveEntity = new List <PRMMaterialReceiveItemMapEntity>(); } BindPRMWorkOrderItemMapList(); btnSubmit.Text = "Update"; btnAddNew.Visible = false; } }
private Int64 DeleteTran(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMMaterialReceive_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 PRMMaterialReceiveEntity BuildPRMMaterialReceiveEntity() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { pRMMaterialReceiveEntity.WorkOrderID = MasterDataConstants.ItemDefaults.DEFAULT_WORKORDER; } else { pRMMaterialReceiveEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } pRMMaterialReceiveEntity.MRRNo = txtMRRNo.Text.Trim(); if (txtMRRDate.Text.Trim().IsNotNullOrEmpty()) { pRMMaterialReceiveEntity.MRRDate = MiscUtil.ParseToDateTime(txtMRRDate.Text); } pRMMaterialReceiveEntity.Remarks = txtRemarks.Text.Trim(); pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID = MasterDataConstants.MDMaterialReceiveApprovalStatus.APPROVED_BL; return(pRMMaterialReceiveEntity); }
private Int64 Update(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMMaterialReceive_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@MaterialReceiveID", DbType.Int64, pRMMaterialReceiveEntity.MaterialReceiveID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, pRMMaterialReceiveEntity.ProjectID); Database.AddInParameter(cmd, "@SupplierID", DbType.Int64, pRMMaterialReceiveEntity.SupplierID); Database.AddInParameter(cmd, "@RequisitionID", DbType.Int64, pRMMaterialReceiveEntity.RequisitionID); Database.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, pRMMaterialReceiveEntity.WorkOrderID); Database.AddInParameter(cmd, "@MRRNo", DbType.String, pRMMaterialReceiveEntity.MRRNo); Database.AddInParameter(cmd, "@MRRDate", DbType.DateTime, pRMMaterialReceiveEntity.MRRDate); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, pRMMaterialReceiveEntity.CreatedByEmployeeID); Database.AddInParameter(cmd, "@Remarks", DbType.String, pRMMaterialReceiveEntity.Remarks); Database.AddInParameter(cmd, "@MaterialReceiveApprovalStatusID", DbType.Int64, pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("PRMMaterialReceiveEntity already exists. Please specify another PRMMaterialReceiveEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMMaterialReceiveEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMMaterialReceiveEntity already exists. Please specify another PRMMaterialReceiveEntity."); } } } } return(returnCode); }
private INVStoreIssueNoteEntity BuildINVStoreIssueNoteEntity() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = FCCPRMMaterialReceive.GetFacadeCreate().GetByID(Int64.Parse(ddlMaterialReceiveID.SelectedValue)); INVStoreIssueNoteEntity iNVStoreIssueNoteEntity = new INVStoreIssueNoteEntity(); iNVStoreIssueNoteEntity.ProjectID = pRMMaterialReceiveEntity.ProjectID; iNVStoreIssueNoteEntity.SRFNo = "Adjustment"; iNVStoreIssueNoteEntity.RequestedByEmployeeID = 168;//Need to change here; will come from mrr created employee ID iNVStoreIssueNoteEntity.RequestDate = System.DateTime.Now; iNVStoreIssueNoteEntity.Remarks = "MRR Adjustment Entry"; iNVStoreIssueNoteEntity.StoreIssueNoteApprovalStatusID = MasterDataConstants.INVStoreIssueNoteApprovalStatus.ISSUED; iNVStoreIssueNoteEntity.IsRemoved = false; return(iNVStoreIssueNoteEntity); }
private Int64 Delete(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.PRMMaterialReceive_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("PRMMaterialReceiveEntity already exists. Please specify another PRMMaterialReceiveEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("PRMMaterialReceiveEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("PRMMaterialReceiveEntity already exists. Please specify another PRMMaterialReceiveEntity."); } } } } return(returnCode); }
Int64 IPRMMaterialReceiveFacade.Delete(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMMaterialReceiveDataAccess().Delete(pRMMaterialReceiveEntity, filterExpression, option, reqTran)); }
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); } } }
protected void lvPRMMaterialReceive_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 MaterialReceiveID; Int64.TryParse(e.CommandArgument.ToString(), out MaterialReceiveID); if (MaterialReceiveID > 0) { if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, MaterialReceiveID.ToString(), SQLMatchType.Equal); PRMMaterialReceiveEntity pRMMaterialReceiveEntity = new PRMMaterialReceiveEntity(); result = FCCPRMMaterialReceive.GetFacadeCreate().Delete(pRMMaterialReceiveEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _MaterialReceiveID = 0; _PRMMaterialReceiveEntity = new PRMMaterialReceiveEntity(); PrepareInitialView(); BindPRMMaterialReceiveList(); MiscUtil.ShowMessage(lblMessage, "Material Receive has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Material Receive.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } else if (string.Equals(e.CommandName, "ResetAP")) { try { #region Approval Process Boolean apResult = APRobot.ResetApprovalProcessForMRR(MaterialReceiveID); if (apResult == true) { MiscUtil.ShowMessage(lblMessage, "Approval Process has been reset successfully.", UIConstants.MessageType.GREEN); } else { MiscUtil.ShowMessage(lblMessage, "Failed to reset approval process.", UIConstants.MessageType.RED); } BindList(); #endregion } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void BuildPRMMaterialReceiveItemEntity(Int64 result, PRMMaterialReceiveEntity pRMMaterialReceiveEntity) { IList <ListViewDataItem> list = lvPRMWorkOrderItemMap.Items; if (list != null && list.Count > 0) { foreach (ListViewDataItem lvdi in list) { Decimal ReceiveQty, rateLV, totalWOItemAmount; Int64 requisitionItemID; Label lblRequisitonItemIDLV = (Label)lvdi.FindControl("lblRequisitonItemIDLV"); TextBox txtQtyLV = (TextBox)lvdi.FindControl("txtReceiveQtyLV"); TextBox txtChallanNoLV = (TextBox)lvdi.FindControl("txtChallanNoLV"); TextBox txtReceiveDateLV = (TextBox)lvdi.FindControl("txtReceiveDateLV"); Label lblRateLV = (Label)lvdi.FindControl("lblRateLV"); Decimal.TryParse(txtQtyLV.Text.Trim(), out ReceiveQty); Decimal.TryParse(lblRateLV.Text.Trim(), out rateLV); totalWOItemAmount = ReceiveQty * rateLV; if (ReceiveQty <= 0) { continue; } Int64.TryParse(lblRequisitonItemIDLV.Text, out requisitionItemID); PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMap = new PRMMaterialReceiveItemMapEntity(); pRMMaterialReceiveItemMap.MaterialReceiveID = result; pRMMaterialReceiveItemMap.RequisitionItemID = requisitionItemID; pRMMaterialReceiveItemMap.ReceiveQty = ReceiveQty; pRMMaterialReceiveItemMap.ItemRate = rateLV; pRMMaterialReceiveItemMap.WOItemTotalRate = totalWOItemAmount; pRMMaterialReceiveItemMap.ChallanNo = txtChallanNoLV.Text.ToString(); if (txtReceiveDateLV.Text.Trim().IsNotNullOrEmpty()) { pRMMaterialReceiveItemMap.ReceiveDate = MiscUtil.ParseToDateTime(txtReceiveDateLV.Text); } if (pRMMaterialReceiveEntity.IsNew) { FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Add(pRMMaterialReceiveItemMap, DatabaseOperationType.Add, TransactionRequired.No); } else { String fe; String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_RequisitionItemID, requisitionItemID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Update(pRMMaterialReceiveItemMap, fe, DatabaseOperationType.Update, TransactionRequired.No); } //#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, requisitionItemID.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 = 0; //Int64 regionID = 0; //Int64 countryID = 0; //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; // String fe_WOItemID = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_RequisitionItemID, lst[0].RequisitionItemID.ToString(), SQLMatchType.Equal); // String fe_WOID = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, ddlWorkOrderID.SelectedValue.ToString(), SQLMatchType.Equal); // String fe_WOItemMap = SqlExpressionBuilder.PrepareFilterExpression(fe_WOItemID, SQLJoinType.AND, fe_WOID); // IList<PRMWorkOrderItemMapEntity> lstWOItem = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_WOItemMap, DatabaseOperationType.LoadWithFilterExpression); // if (lstWOItem != null && lstWOItem.Count > 0) // { // Decimal.TryParse(lstWOItem[0].Rate.ToString(),out _rate); // } //} //Boolean invResult = INVManager.AddItemsToStoreUnit(_itemID,brandID,regionID,countryID, "", Int64.Parse(ReceiveQty.ToString()), MiscUtil.GetLocalIP(), _employeeID, _rate, ddlRequisitionID.SelectedItem.Text, ddlWorkOrderID.SelectedItem.Text, result.ToString(), "", Int64.Parse(ddlProjectID.SelectedValue), storeID, storeUnitID); //#endregion } } }
private void SavePRMMaterialReceiveEntity() { if (IsValid) { try { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity(); Int64 result = -1; if (pRMMaterialReceiveEntity.IsNew) { result = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); result = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { BuildPRMMaterialReceiveItemEntity(result, pRMMaterialReceiveEntity); #region Approval Process Boolean apResult = APRobot.CreateApprovalProcessForNewMRR(result, Int64.Parse(ddlAPPanelID.SelectedValue)); if (apResult == true) { MiscUtil.ShowMessage(lblMessage, "Approval Process Submited successfully.", UIConstants.MessageType.GREEN); } else { MiscUtil.ShowMessage(lblMessage, "Failed to Submit Approval Process.", UIConstants.MessageType.RED); } #endregion _MaterialReceiveID = 0; _PRMMaterialReceiveEntity = new PRMMaterialReceiveEntity(); PrepareInitialView(); 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); } } }
protected void btnAddNew_Click(object sender, EventArgs e) { _MaterialReceiveID = 0; _PRMMaterialReceiveEntity = new PRMMaterialReceiveEntity(); PrepareInitialView(); }
Int64 IPRMMaterialReceiveFacade.Add(PRMMaterialReceiveEntity pRMMaterialReceiveEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreatePRMMaterialReceiveDataAccess().Add(pRMMaterialReceiveEntity, option, reqTran)); }