Ejemplo n.º 1
0
        Int64 IINVTransferItemDataAccess.Add(INVTransferItemEntity iNVTransferItemEntity, DatabaseOperationType option, TransactionRequired reqTran)
        {
            try
            {
                long retValues = -99;

                switch (reqTran)
                {
                case TransactionRequired.No:
                {
                    retValues = Add(iNVTransferItemEntity, option);
                    break;
                }

                case TransactionRequired.Yes:
                {
                    retValues = AddTran(iNVTransferItemEntity, option);
                    break;
                }

                default:
                {
                    retValues = -99;
                    break;
                }
                }

                return(retValues);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 2
0
        private void AddItemToINVTransferItemEntity()
        {
            try
            {
                INVTransferItemEntity iNVTransferItemEntity = CurrentINVTransferItemEntity;

                iNVTransferItemEntity.TransferID = INVTransferID;
                iNVTransferItemEntity.ItemID     = Int64.Parse(hdEmpID.Value);

                String fe_StoreUnitID   = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnit.StoreID", CurrentINVTransferEntity.TransferFromStoreID.ToString(), SQLMatchType.Equal);
                String fe_ItemID        = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem.ItemID", iNVTransferItemEntity.ItemID.ToString(), SQLMatchType.Equal);
                String fe_StoreUnitItem = SqlExpressionBuilder.PrepareFilterExpression(fe_StoreUnitID, SQLJoinType.AND, fe_ItemID);
                IList <INVStoreUnitItem_DetailedEntity> lst = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_StoreUnitItem);

                if (lst != null && lst.Count > 0)
                {
                    iNVTransferItemEntity.BrandID   = lst[0].BrandID;
                    iNVTransferItemEntity.RegionID  = lst[0].RegionID;
                    iNVTransferItemEntity.CountryID = lst[0].CountryID;
                }

                iNVTransferItemEntity.RequestQty = 0;

                Int64 result = -1;

                result = FCCINVTransferItem.GetFacadeCreate().Add(iNVTransferItemEntity, DatabaseOperationType.Add, TransactionRequired.No);

                BindList();
            }

            catch (Exception ex)
            {
            }
        }
Ejemplo n.º 3
0
        Int64 IINVTransferItemDataAccess.Delete(INVTransferItemEntity iNVTransferItemEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
        {
            try
            {
                long retValues = -99;

                switch (reqTran)
                {
                case TransactionRequired.No:
                {
                    retValues = Delete(iNVTransferItemEntity, filterExpression, option);
                    break;
                }

                case TransactionRequired.Yes:
                {
                    retValues = DeleteTran(iNVTransferItemEntity, filterExpression, option);
                    break;
                }

                default:
                {
                    retValues = -99;
                    break;
                }
                }

                return(retValues);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 4
0
        private Int64 UpdateTran(INVTransferItemEntity iNVTransferItemEntity, String filterExpression, DatabaseOperationType option)
        {
            long         returnCode = -99;
            const string SP         = "dbo.INVTransferItem_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, "@TransferItemID", DbType.Int64, iNVTransferItemEntity.TransferItemID);
                db.AddInParameter(cmd, "@TransferID", DbType.Int64, iNVTransferItemEntity.TransferID);
                db.AddInParameter(cmd, "@ItemID", DbType.Int64, iNVTransferItemEntity.ItemID);
                db.AddInParameter(cmd, "@BrandID", DbType.Int64, iNVTransferItemEntity.BrandID);
                db.AddInParameter(cmd, "@RegionID", DbType.Int64, iNVTransferItemEntity.RegionID);
                db.AddInParameter(cmd, "@CountryID", DbType.Int64, iNVTransferItemEntity.CountryID);
                db.AddInParameter(cmd, "@RequestQty", DbType.Decimal, iNVTransferItemEntity.RequestQty);
                db.AddInParameter(cmd, "@Remarks", DbType.String, iNVTransferItemEntity.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);
        }
Ejemplo n.º 5
0
        private void UpdateAllINVTransferItemEntity()
        {
            try
            {
                IList <ListViewDataItem> list = lvINVTransferItem.Items;

                if (list != null && list.Count > 0)
                {
                    Int32 tempDataItemIndex = 0;

                    foreach (ListViewDataItem lvdi in list)
                    {
                        DataKey currentDataKey    = lvINVTransferItem.DataKeys[tempDataItemIndex++];
                        Int64   intTransferItemID = (Int64)currentDataKey["TransferItemID"];

                        TextBox txtRequestQtyLV = (TextBox)lvdi.FindControl("txtRequestQtyLV");
                        TextBox txtRemarksLV    = (TextBox)lvdi.FindControl("txtRemarksLV");

                        Decimal requestedQty;

                        Decimal.TryParse(txtRequestQtyLV.Text.Trim(), out requestedQty);

                        INVTransferItemEntity _INVTransferItem = FCCINVTransferItem.GetFacadeCreate().GetByID(intTransferItemID);

                        _INVTransferItem.RequestQty = requestedQty;

                        if (txtRemarksLV.Text.IsNotNullOrEmpty())
                        {
                            _INVTransferItem.Remarks = txtRemarksLV.Text.Trim().ToString();
                        }
                        else
                        {
                            _INVTransferItem.Remarks = null;
                        }

                        String fe = SqlExpressionBuilder.PrepareFilterExpression(INVTransferItemEntity.FLD_NAME_TransferItemID, intTransferItemID.ToString(), SQLMatchType.Equal);

                        FCCINVTransferItem.GetFacadeCreate().Update(_INVTransferItem, fe, DatabaseOperationType.Update, TransactionRequired.No);
                    }

                    MiscUtil.ShowMessage(lblMessage, "Transfer Item Information has been updated successfully.", false);
                    BindList();
                }
            }

            catch (Exception ex)
            {
                MiscUtil.ShowMessage(lblMessage, "Failed to to update Transfer Item Information.", true);
            }
        }
Ejemplo n.º 6
0
        private Int64 Update(INVTransferItemEntity iNVTransferItemEntity, String filterExpression, DatabaseOperationType option)
        {
            long         returnCode = -99;
            const string SP         = "dbo.INVTransferItem_SET";

            using (DbCommand cmd = Database.GetStoredProcCommand(SP))
            {
                AddOptionParameter(cmd, option);
                AddOutputParameter(cmd);
                AddFilterExpressionParameter(cmd, filterExpression);

                Database.AddInParameter(cmd, "@TransferItemID", DbType.Int64, iNVTransferItemEntity.TransferItemID);
                Database.AddInParameter(cmd, "@TransferID", DbType.Int64, iNVTransferItemEntity.TransferID);
                Database.AddInParameter(cmd, "@ItemID", DbType.Int64, iNVTransferItemEntity.ItemID);
                Database.AddInParameter(cmd, "@BrandID", DbType.Int64, iNVTransferItemEntity.BrandID);
                Database.AddInParameter(cmd, "@RegionID", DbType.Int64, iNVTransferItemEntity.RegionID);
                Database.AddInParameter(cmd, "@CountryID", DbType.Int64, iNVTransferItemEntity.CountryID);
                Database.AddInParameter(cmd, "@RequestQty", DbType.Decimal, iNVTransferItemEntity.RequestQty);
                Database.AddInParameter(cmd, "@Remarks", DbType.String, iNVTransferItemEntity.Remarks);

                using (IDataReader reader = Database.ExecuteReader(cmd))
                {
                    returnCode = GetReturnCodeFromParameter(cmd);

                    switch (returnCode)
                    {
                    case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
                    {
                        throw new ArgumentException("INVTransferItemEntity already exists. Please specify another INVTransferItemEntity.");
                    }

                    case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
                    {
                        throw new ArgumentException("INVTransferItemEntity data already updated from different session.");
                    }

                    case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
                    {
                        throw new ArgumentException("INVTransferItemEntity already exists. Please specify another INVTransferItemEntity.");
                    }
                    }
                }
            }

            return(returnCode);
        }
Ejemplo n.º 7
0
        protected void lvINVTransferItem_ItemCommand(object sender, ListViewCommandEventArgs e)
        {
            Int64 TransferItemID;

            Int64.TryParse(e.CommandArgument.ToString(), out TransferItemID);

            if (TransferItemID > 0)
            {
                if (string.Equals(e.CommandName, "DeleteItem"))
                {
                    try
                    {
                        Int64 result = -1;

                        String fe = SqlExpressionBuilder.PrepareFilterExpression(INVTransferItemEntity.FLD_NAME_TransferItemID, TransferItemID.ToString(), SQLMatchType.Equal);

                        INVTransferItemEntity iNVTransferItemEntity = new INVTransferItemEntity();


                        result = FCCINVTransferItem.GetFacadeCreate().Delete(iNVTransferItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);

                        if (result == 0)
                        {
                            _TransferItemID        = 0;
                            _INVTransferItemEntity = new INVTransferItemEntity();
                            PrepareInitialView();
                            BindINVTransferItemList();

                            MiscUtil.ShowMessage(lblMessage, "Transfer Item has been successfully deleted.", true);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to delete Transfer Item.", true);
                        }
                    }
                    catch (Exception ex)
                    {
                        MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                    }
                }
            }
        }
Ejemplo n.º 8
0
 Int64 IINVTransferItemFacade.Delete(INVTransferItemEntity iNVTransferItemEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
 {
     return(DataAccessFactory.CreateINVTransferItemDataAccess().Delete(iNVTransferItemEntity, filterExpression, option, reqTran));
 }
Ejemplo n.º 9
0
 Int64 IINVTransferItemFacade.Add(INVTransferItemEntity iNVTransferItemEntity, DatabaseOperationType option, TransactionRequired reqTran)
 {
     return(DataAccessFactory.CreateINVTransferItemDataAccess().Add(iNVTransferItemEntity, option, reqTran));
 }