Int64 IREQRequisitionItemDataAccess.Delete(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(rEQRequisitionItemEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(rEQRequisitionItemEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
Int64 IREQRequisitionItemDataAccess.Add(REQRequisitionItemEntity rEQRequisitionItemEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(rEQRequisitionItemEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(rEQRequisitionItemEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private REQRequisitionItemEntity BuildREQRequisitionItemEntity(Int64 requisitionID) { REQRequisitionItemEntity rEQRequisitionItemEntity = new REQRequisitionItemEntity(); rEQRequisitionItemEntity.RequisitionID = requisitionID; if (ddlRequisitionItemID.SelectedValue != "0" && ddlRequisitionItemID != null) { rEQRequisitionItemEntity.ItemID = Int64.Parse(ddlRequisitionItemID.SelectedValue); } rEQRequisitionItemEntity.AccountsCode = "000";// if (txtPrice.Text.IsNotNullOrEmpty()) { rEQRequisitionItemEntity.Rate = Decimal.Parse(txtPrice.Text.ToString()); // } rEQRequisitionItemEntity.TotalRequiredQty = 0; // rEQRequisitionItemEntity.PresentRequiredQty = 1; // rEQRequisitionItemEntity.RequiredDate = DateTime.Now; if (ddlBrandID.SelectedValue != "0" && ddlBrandID != null) { rEQRequisitionItemEntity.BrandID = Int64.Parse(ddlBrandID.SelectedValue); } else { rEQRequisitionItemEntity.BrandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD; } if (ddlSupplierID.SelectedValue != "0" && ddlSupplierID != null) { rEQRequisitionItemEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } else { rEQRequisitionItemEntity.SupplierID = MasterDataConstants.ItemDefaults.DEFAULT_SUPPLIER; } if (ddlRegionID.SelectedValue != "0" && ddlRegionID != null) { rEQRequisitionItemEntity.RegionID = Int64.Parse(ddlRegionID.SelectedValue); } else { rEQRequisitionItemEntity.RegionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION; } if (ddlCountryID.SelectedValue != "0" && ddlCountryID != null) { rEQRequisitionItemEntity.CountryID = Int64.Parse(ddlCountryID.SelectedValue); } else { rEQRequisitionItemEntity.CountryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY; } return(rEQRequisitionItemEntity); }
private void SaveREQRequisitionItemEntity() { if (IsValid) { try { REQRequisitionItemEntity rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(); Int64 result = -1; if (rEQRequisitionItemEntity.IsNew) { result = FCCREQRequisitionItem.GetFacadeCreate().Add(rEQRequisitionItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, rEQRequisitionItemEntity.RequisitionItemID.ToString(), SQLMatchType.Equal); result = FCCREQRequisitionItem.GetFacadeCreate().Update(rEQRequisitionItemEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _RequisitionItemID = 0; _REQRequisitionItemEntity = new REQRequisitionItemEntity(); PrepareInitialView(); BindREQRequisitionItemList(); if (rEQRequisitionItemEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "R EQRequisition Item Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "R EQRequisition Item Information has been updated successfully.", false); } } else { if (rEQRequisitionItemEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add R EQRequisition Item Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update R EQRequisition Item Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 Update(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisitionItem_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@RequisitionItemID", DbType.Int64, rEQRequisitionItemEntity.RequisitionItemID); Database.AddInParameter(cmd, "@RequisitionID", DbType.Int64, rEQRequisitionItemEntity.RequisitionID); Database.AddInParameter(cmd, "@AccountsCode", DbType.String, rEQRequisitionItemEntity.AccountsCode); Database.AddInParameter(cmd, "@ItemID", DbType.Int64, rEQRequisitionItemEntity.ItemID); Database.AddInParameter(cmd, "@BrandID", DbType.Int64, rEQRequisitionItemEntity.BrandID); Database.AddInParameter(cmd, "@SupplierID", DbType.Int64, rEQRequisitionItemEntity.SupplierID); Database.AddInParameter(cmd, "@RegionID", DbType.Int64, rEQRequisitionItemEntity.RegionID); Database.AddInParameter(cmd, "@CountryID", DbType.Int64, rEQRequisitionItemEntity.CountryID); Database.AddInParameter(cmd, "@Rate", DbType.Decimal, rEQRequisitionItemEntity.Rate); Database.AddInParameter(cmd, "@TotalRequiredQty", DbType.Decimal, rEQRequisitionItemEntity.TotalRequiredQty); Database.AddInParameter(cmd, "@PurchasedQtyTillToDate", DbType.Decimal, rEQRequisitionItemEntity.PurchasedQtyTillToDate); Database.AddInParameter(cmd, "@PresentRequiredQty", DbType.Decimal, rEQRequisitionItemEntity.PresentRequiredQty); Database.AddInParameter(cmd, "@RequiredDate", DbType.DateTime, rEQRequisitionItemEntity.RequiredDate); Database.AddInParameter(cmd, "@Remarks", DbType.String, rEQRequisitionItemEntity.Remarks); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("REQRequisitionItemEntity already exists. Please specify another REQRequisitionItemEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("REQRequisitionItemEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("REQRequisitionItemEntity already exists. Please specify another REQRequisitionItemEntity."); } } } } return(returnCode); }
private void SaveREQRequisitionItemEntity() { try { IList <ListViewDataItem> list = lvREQRequisitionItem.Items; if (list != null && list.Count > 0) { foreach (ListViewDataItem lvdi in list) { Decimal PresentRequiredQty; Int64 ItemID; Label lblItemID = (Label)lvdi.FindControl("lblItemLV"); Label lblQtyLV = (Label)lvdi.FindControl("lblQtyLV"); Label lblPurchasedQty = (Label)lvdi.FindControl("lblPurchasedQty"); TextBox txtPresentRequiredQty = (TextBox)lvdi.FindControl("txtPresentRequiredQty"); TextBox txtRequiredDate = (TextBox)lvdi.FindControl("txtRequiredDate"); TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV"); if (txtPresentRequiredQty.Enabled != false) { Decimal.TryParse(txtPresentRequiredQty.Text.Trim(), out PresentRequiredQty); Int64.TryParse(lblItemID.Text, out ItemID); String fe1 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionID, REQRequisitionID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <REQRequisitionItemEntity> RequisitionItemList = FCCREQRequisitionItem.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (RequisitionItemList != null && RequisitionItemList.Count > 0) { REQRequisitionItemEntity rEQRequisitionItem = RequisitionItemList[0]; rEQRequisitionItem.RequisitionID = REQRequisitionID; rEQRequisitionItem.PresentRequiredQty = PresentRequiredQty; rEQRequisitionItem.ItemID = ItemID; //Another Entity Item may be added Here. FCCREQRequisitionItem.GetFacadeCreate().Update(rEQRequisitionItem, fe, DatabaseOperationType.Update, TransactionRequired.No); } } } } BindREQRequisitionItemList(); MiscUtil.ShowMessage(lblMessage, "Requisition Item Information has been saved successfully.", false); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Failed to save Requisition Item Information.", true); } }
private Int64 DeleteTran(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisitionItem_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); }
protected void lvREQRequisitionItem_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionItemID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionItemID); if (RequisitionItemID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _RequisitionItemID = RequisitionItemID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, RequisitionItemID.ToString(), SQLMatchType.Equal); REQRequisitionItemEntity rEQRequisitionItemEntity = new REQRequisitionItemEntity(); result = FCCREQRequisitionItem.GetFacadeCreate().Delete(rEQRequisitionItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _RequisitionItemID = 0; _REQRequisitionItemEntity = new REQRequisitionItemEntity(); PrepareInitialView(); BindREQRequisitionItemList(); MiscUtil.ShowMessage(lblMessage, "R EQRequisition Item has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete R EQRequisition Item.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void PrepareEditView() { REQRequisitionItemEntity rEQRequisitionItemEntity = CurrentREQRequisitionItemEntity; if (!rEQRequisitionItemEntity.IsNew) { txtAccountsCode.Text = rEQRequisitionItemEntity.AccountsCode.ToString(); if (ddlItemID.Items.Count > 0 && rEQRequisitionItemEntity.ItemID != null) { ddlItemID.SelectedValue = rEQRequisitionItemEntity.ItemID.ToString(); } if (ddlBrandID.Items.Count > 0 && rEQRequisitionItemEntity.BrandID != null) { ddlBrandID.SelectedValue = rEQRequisitionItemEntity.BrandID.ToString(); } if (ddlSupplierID.Items.Count > 0 && rEQRequisitionItemEntity.SupplierID != null) { ddlSupplierID.SelectedValue = rEQRequisitionItemEntity.SupplierID.ToString(); } if (ddlRegionID.Items.Count > 0 && rEQRequisitionItemEntity.RegionID != null) { ddlRegionID.SelectedValue = rEQRequisitionItemEntity.RegionID.ToString(); } if (ddlCountryID.Items.Count > 0 && rEQRequisitionItemEntity.CountryID != null) { ddlCountryID.SelectedValue = rEQRequisitionItemEntity.CountryID.ToString(); } txtRate.Text = rEQRequisitionItemEntity.Rate.ToString(); txtTotalRequiredQty.Text = rEQRequisitionItemEntity.TotalRequiredQty.ToString(); txtPurchasedQtyTillToDate.Text = rEQRequisitionItemEntity.PurchasedQtyTillToDate.ToString(); txtPresentRequiredQty.Text = rEQRequisitionItemEntity.PresentRequiredQty.ToString(); txtRequiredDate.Text = rEQRequisitionItemEntity.RequiredDate.ToStringDefault(); txtRemarks.Text = rEQRequisitionItemEntity.Remarks.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private Int64 Delete(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisitionItem_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("REQRequisitionItemEntity already exists. Please specify another REQRequisitionItemEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("REQRequisitionItemEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("REQRequisitionItemEntity already exists. Please specify another REQRequisitionItemEntity."); } } } } return(returnCode); }
protected void btnAddNew_Click(object sender, EventArgs e) { _RequisitionItemID = 0; _REQRequisitionItemEntity = new REQRequisitionItemEntity(); PrepareInitialView(); }
private void BindRequisitionItemInfo() { try { IList <ListViewDataItem> list = lvRequisitionItem.Items; if (list != null && list.Count > 0) { foreach (ListViewDataItem lvdi in list) { CheckBox chbxState = (CheckBox)lvdi.FindControl("chbxState"); if (chbxState.Checked == true) { REQRequisitionItemEntity ent = new REQRequisitionItemEntity(); Decimal TotalRequiredQty; Int64 ItemID; Decimal PurchasedQty; Decimal PresentRequiredQty; Decimal RateLV; TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtQtyLV"); TextBox txtPurchasedQty = (TextBox)lvdi.FindControl("txtPurchasedQty"); TextBox txtPresentRequiredQty = (TextBox)lvdi.FindControl("txtPresentRequiredQty"); TextBox txtRequiredDate = (TextBox)lvdi.FindControl("txtRequiredDate"); TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV"); TextBox txtAccountsCodeLV = (TextBox)lvdi.FindControl("txtAccountsCodeLV"); Label lblItemLV = (Label)lvdi.FindControl("lblItem"); TextBox txtRateLV = (TextBox)lvdi.FindControl("txtRateLV"); Decimal.TryParse(txtTotalQtyLV.Text.Trim(), out TotalRequiredQty); Decimal.TryParse(txtPurchasedQty.Text.Trim(), out PurchasedQty); Decimal.TryParse(txtPresentRequiredQty.Text.Trim(), out PresentRequiredQty); Decimal.TryParse(txtRateLV.Text.Trim(), out RateLV); Int64.TryParse(lblItemLV.Text, out ItemID); ent.ItemID = ItemID; ent.TotalRequiredQty = TotalRequiredQty; ent.PurchasedQtyTillToDate = PurchasedQty; ent.PresentRequiredQty = PresentRequiredQty; ent.Remarks = txtRemarksLV.Text.Trim(); ent.AccountsCode = txtAccountsCodeLV.Text.ToString(); ent.Rate = RateLV; if (txtRequiredDate.Text.Trim().IsNotNullOrEmpty()) { ent.RequiredDate = MiscUtil.ParseToDateTime(txtRequisitionDate.Text); } else { ent.RequiredDate = MiscUtil.ParseToDateTime(System.DateTime.Now.ToStringDefault()); } //Check Existing Item var itemList = (from s in REQRequisitionItemList where s.ItemID == ItemID select s); if (itemList == null || itemList.Count() <= 0) { REQRequisitionItemList.Add(ent); } } else if (chbxState.Checked == false) { Int64 ItemID; Label lblItemLV = (Label)lvdi.FindControl("lblItem"); Int64.TryParse(lblItemLV.Text, out ItemID); var item = from s in REQRequisitionItemList where s.ItemID == ItemID select s; if (item != null && item.Count() > 0) { REQRequisitionItemEntity di = (from d in REQRequisitionItemList where d.ItemID == ItemID select d).First(); if (di != null) { REQRequisitionItemList.Remove(di); } } } } } } catch (Exception ex) { } }
protected void lvREQRequisitionItem_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionItemID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionItemID); if (RequisitionItemID > 0) { LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit"); TextBox txtPresentRequiredQty = (TextBox)e.Item.FindControl("txtPresentRequiredQty"); if (string.Equals(e.CommandName, "EditItem") && txtPresentRequiredQty.Enabled == true) { txtPresentRequiredQty.Text = ItemQty.ToString(); txtPresentRequiredQty.Enabled = false; lnkBtnEdit.Text = "Edit"; } else if (string.Equals(e.CommandName, "EditItem") && txtPresentRequiredQty.Enabled == false) { _RequisitionItemID = RequisitionItemID; PrepareEditView(); txtPresentRequiredQty.Enabled = true; ItemQty = Decimal.Parse(txtPresentRequiredQty.Text); lnkBtnEdit.Text = "Cancel"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe1 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, RequisitionItemID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionItemEntity.FLD_NAME_RequisitionID, REQRequisitionID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); REQRequisitionItemEntity rEQRequisitionItemEntity = new REQRequisitionItemEntity(); result = FCCREQRequisitionItem.GetFacadeCreate().Delete(rEQRequisitionItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _RequisitionItemID = 0; _REQRequisitionItemEntity = new REQRequisitionItemEntity(); PrepareInitialView(); BindREQRequisitionItemList(); MiscUtil.ShowMessage(lblMessage, "Requisition Item has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Requisition Item.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void BuildINVStoreIssueNoteItemMapEntity(Int64 sinID, Int64 projectID) { try { String fe_itemMap = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveID, ddlMaterialReceiveID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMMaterialReceiveItemMapEntity> lst = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemMap, DatabaseOperationType.LoadWithFilterExpression); if (lst != null && lst.Count > 0) { foreach (PRMMaterialReceiveItemMapEntity ent in lst) { INVStoreIssueNoteItemMapEntity iNVStoreIssueNoteItemMapEntity = new INVStoreIssueNoteItemMapEntity(); REQRequisitionItemEntity rEQRequisitionItemEntity = FCCREQRequisitionItem.GetFacadeCreate().GetByID(ent.RequisitionItemID); if (rEQRequisitionItemEntity != null && rEQRequisitionItemEntity.ItemID > 0) { iNVStoreIssueNoteItemMapEntity.StoreIssueNoteID = sinID; iNVStoreIssueNoteItemMapEntity.ItemID = rEQRequisitionItemEntity.ItemID; iNVStoreIssueNoteItemMapEntity.FolioNo = String.Empty; iNVStoreIssueNoteItemMapEntity.RequestQty = ent.ReceiveQty; iNVStoreIssueNoteItemMapEntity.IssueQty = ent.ReceiveQty; } String fe_transaction1 = SqlExpressionBuilder.PrepareFilterExpression(INVTransactionEntity.FLD_NAME_ItemID, rEQRequisitionItemEntity.ItemID.ToString(), SQLMatchType.Equal); String fe_transaction2 = SqlExpressionBuilder.PrepareFilterExpression(INVTransactionEntity.FLD_NAME_MRRNumber, ddlMaterialReceiveID.Text.ToString(), SQLMatchType.Equal); String fe_transaction = SqlExpressionBuilder.PrepareFilterExpression(fe_transaction1, SQLJoinType.AND, fe_transaction2); IList <INVTransactionEntity> lstINVTransactionEntity = FCCINVTransaction.GetFacadeCreate().GetIL(null, null, String.Empty, fe_transaction, DatabaseOperationType.LoadWithFilterExpression); if (lstINVTransactionEntity != null && lstINVTransactionEntity.Count > 0) { iNVStoreIssueNoteItemMapEntity.BatchNo = lstINVTransactionEntity[0].BatchNumber; } // iNVStoreIssueNoteItemMapEntity.BatchNo = txtBatchNo.Text.Trim(); String fe_store1 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_ProjectID, projectID.ToString(), SQLMatchType.Equal); String fe_store2 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_IsDefault, "1", SQLMatchType.Equal); String fe_store = SqlExpressionBuilder.PrepareFilterExpression(fe_store1, SQLJoinType.AND, fe_store2); IList <INVStoreEntity> lstINVStoreEntity = FCCINVStore.GetFacadeCreate().GetIL(null, null, String.Empty, fe_store, DatabaseOperationType.LoadWithFilterExpression); if (lstINVStoreEntity != null && lstINVStoreEntity.Count > 0) { iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = lstINVStoreEntity[0].StoreID; String fe_storeUnit1 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitEntity.FLD_NAME_StoreID, lstINVStoreEntity[0].StoreID.ToString(), SQLMatchType.Equal); String fe_storeUnit2 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitEntity.FLD_NAME_IsDefault, "1", SQLMatchType.Equal); String fe_storeUnit = SqlExpressionBuilder.PrepareFilterExpression(fe_storeUnit1, SQLJoinType.AND, fe_storeUnit2); IList <INVStoreUnitEntity> lstINVStoreUnitEntity = FCCINVStoreUnit.GetFacadeCreate().GetIL(null, null, String.Empty, fe_storeUnit, DatabaseOperationType.LoadWithFilterExpression); if (lstINVStoreUnitEntity != null && lstINVStoreUnitEntity.Count > 0) { iNVStoreIssueNoteItemMapEntity.IssuedFromStoreUnitID = lstINVStoreUnitEntity[0].StoreUnitID; } } iNVStoreIssueNoteItemMapEntity.ReceivedDate = System.DateTime.Now; iNVStoreIssueNoteItemMapEntity.ReceivedByEmployeeID = 168; iNVStoreIssueNoteItemMapEntity.ReturnQty = null; iNVStoreIssueNoteItemMapEntity.ReturnDate = null; iNVStoreIssueNoteItemMapEntity.ReturnToStoreID = null; iNVStoreIssueNoteItemMapEntity.ReturnToStoreUnitID = null; iNVStoreIssueNoteItemMapEntity.ReturnedByEmployeeID = null; iNVStoreIssueNoteItemMapEntity.ActualUse = null; iNVStoreIssueNoteItemMapEntity.Amount = ent.WOItemTotalRate / ent.ReceiveQty; iNVStoreIssueNoteItemMapEntity.PurposeOfWorks = "Adjustment Entry"; INVStoreEntity storeEntity = INVManager.GetDefaultStore(projectID); INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeEntity.StoreID); iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = storeEntity.StoreID; iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = storeUnitEntity.StoreUnitID; FCCINVStoreIssueNoteItemMap.GetFacadeCreate().Add(iNVStoreIssueNoteItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); #region Inventory String batchNumber = String.Empty; Decimal transactionQty = 0; Boolean invResult = false; invResult = INVManager.RemoveItemsFromStoreUnit(rEQRequisitionItemEntity.ItemID, rEQRequisitionItemEntity.BrandID, rEQRequisitionItemEntity.RegionID, rEQRequisitionItemEntity.CountryID, lstINVTransactionEntity[0].BatchNumber, Int64.Parse(transactionQty.ToString()), MiscUtil.GetLocalIP(), MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember), 0, String.Empty, String.Empty, String.Empty, "", projectID, storeEntity.StoreID, storeUnitEntity.StoreUnitID); #endregion } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured " + ex.Message, true); } }
private REQRequisitionItemEntity BuildREQRequisitionItemEntity() { REQRequisitionItemEntity rEQRequisitionItemEntity = CurrentREQRequisitionItemEntity; rEQRequisitionItemEntity.RequisitionID = REQRequisitionID; rEQRequisitionItemEntity.AccountsCode = txtAccountsCode.Text.Trim(); if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { } else { rEQRequisitionItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); } } if (ddlBrandID.Items.Count > 0) { if (ddlBrandID.SelectedValue == "0") { } else { rEQRequisitionItemEntity.BrandID = Int64.Parse(ddlBrandID.SelectedValue); } } if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { rEQRequisitionItemEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlRegionID.Items.Count > 0) { if (ddlRegionID.SelectedValue == "0") { } else { rEQRequisitionItemEntity.RegionID = Int64.Parse(ddlRegionID.SelectedValue); } } if (ddlCountryID.Items.Count > 0) { if (ddlCountryID.SelectedValue == "0") { } else { rEQRequisitionItemEntity.CountryID = Int64.Parse(ddlCountryID.SelectedValue); } } if (!txtRate.Text.Trim().IsNullOrEmpty()) { rEQRequisitionItemEntity.Rate = Decimal.Parse(txtRate.Text.Trim()); } if (!txtTotalRequiredQty.Text.Trim().IsNullOrEmpty()) { rEQRequisitionItemEntity.TotalRequiredQty = Decimal.Parse(txtTotalRequiredQty.Text.Trim()); } if (!txtPurchasedQtyTillToDate.Text.Trim().IsNullOrEmpty()) { rEQRequisitionItemEntity.PurchasedQtyTillToDate = Decimal.Parse(txtPurchasedQtyTillToDate.Text.Trim()); } else { rEQRequisitionItemEntity.PurchasedQtyTillToDate = null; } if (!txtPresentRequiredQty.Text.Trim().IsNullOrEmpty()) { rEQRequisitionItemEntity.PresentRequiredQty = Decimal.Parse(txtPresentRequiredQty.Text.Trim()); } if (txtRequiredDate.Text.Trim().IsNotNullOrEmpty()) { rEQRequisitionItemEntity.RequiredDate = MiscUtil.ParseToDateTime(txtRequiredDate.Text); } rEQRequisitionItemEntity.Remarks = txtRemarks.Text.Trim(); return(rEQRequisitionItemEntity); }
private Int64 UpdateTran(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.REQRequisitionItem_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, "@RequisitionItemID", DbType.Int64, rEQRequisitionItemEntity.RequisitionItemID); db.AddInParameter(cmd, "@RequisitionID", DbType.Int64, rEQRequisitionItemEntity.RequisitionID); db.AddInParameter(cmd, "@AccountsCode", DbType.String, rEQRequisitionItemEntity.AccountsCode); db.AddInParameter(cmd, "@ItemID", DbType.Int64, rEQRequisitionItemEntity.ItemID); db.AddInParameter(cmd, "@BrandID", DbType.Int64, rEQRequisitionItemEntity.BrandID); db.AddInParameter(cmd, "@SupplierID", DbType.Int64, rEQRequisitionItemEntity.SupplierID); db.AddInParameter(cmd, "@RegionID", DbType.Int64, rEQRequisitionItemEntity.RegionID); db.AddInParameter(cmd, "@CountryID", DbType.Int64, rEQRequisitionItemEntity.CountryID); db.AddInParameter(cmd, "@Rate", DbType.Decimal, rEQRequisitionItemEntity.Rate); db.AddInParameter(cmd, "@TotalRequiredQty", DbType.Decimal, rEQRequisitionItemEntity.TotalRequiredQty); db.AddInParameter(cmd, "@PurchasedQtyTillToDate", DbType.Decimal, rEQRequisitionItemEntity.PurchasedQtyTillToDate); db.AddInParameter(cmd, "@PresentRequiredQty", DbType.Decimal, rEQRequisitionItemEntity.PresentRequiredQty); db.AddInParameter(cmd, "@RequiredDate", DbType.DateTime, rEQRequisitionItemEntity.RequiredDate); db.AddInParameter(cmd, "@Remarks", DbType.String, rEQRequisitionItemEntity.Remarks); 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); }
Int64 IREQRequisitionItemFacade.Delete(REQRequisitionItemEntity rEQRequisitionItemEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateREQRequisitionItemDataAccess().Delete(rEQRequisitionItemEntity, 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); } } }
Int64 IREQRequisitionItemFacade.Add(REQRequisitionItemEntity rEQRequisitionItemEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateREQRequisitionItemDataAccess().Add(rEQRequisitionItemEntity, option, reqTran)); }