public bool AddMeasurementUnit(MeasurementUnitBO measurementUnit)
        {
            DBEgine objDbAccess = new DBEgine();
            bool result = false;
            try
            {
                SqlParameter[] parms = new SqlParameter[4];

                SqlParameter parmUnitID = new SqlParameter();
                parmUnitID.Value = measurementUnit.UnitID;
                parmUnitID.SqlDbType = SqlDbType.Int;
                parmUnitID.Direction = ParameterDirection.Input;
                parmUnitID.ParameterName = "@UnitID";
                parms[0] = parmUnitID;

                SqlParameter parmUnitDescription = new SqlParameter();
                parmUnitDescription.Value = measurementUnit.UnitDescription;
                parmUnitDescription.SqlDbType = SqlDbType.VarChar;
                parmUnitDescription.Direction = ParameterDirection.Input;
                parmUnitDescription.ParameterName = "@UnitDescription";
                parms[1] = parmUnitDescription;

                SqlParameter parmIsActive = new SqlParameter();
                parmIsActive.Value = measurementUnit.IsActive;
                parmIsActive.SqlDbType = SqlDbType.Bit;
                parmIsActive.Direction = ParameterDirection.Input;
                parmIsActive.ParameterName = "@IsActive";
                parms[2] = parmIsActive;

                SqlParameter parmCreatedUser = new SqlParameter();
                parmCreatedUser.Value = measurementUnit.CreatedUser;
                parmCreatedUser.SqlDbType = SqlDbType.Int;
                parmCreatedUser.Direction = ParameterDirection.Input;
                parmCreatedUser.ParameterName = "@CreatedUser";
                parms[3] = parmCreatedUser;

                objDbAccess.DBOpen();

                if (objDbAccess.ExecNonQueryStoredProc("Inventory.SaveMeasurementUnit", parms) > 0)
                {
                    result = true;
                }

                return result;

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objDbAccess.DBClose();
            }
        }
        private void buttonSave_Click(object sender, EventArgs e)
        {
            try
            {

                if (MeasuringUnit > 0 && !ScreenFunctions.Update)
                {
                    MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false);
                    return;
                }

                var measurementUnit = new MeasurementUnitBO();

                measurementUnit.UnitID = MeasuringUnit;
                measurementUnit.UnitDescription = textBoxMesurementUnit.Text.Trim();
                measurementUnit.IsActive = true;
                measurementUnit.CreatedUser = Common.User.UserId;

               var result = new MeasurementUnitDAL().AddMeasurementUnit(measurementUnit);

               if (result)
               {
                   MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_011"), false);
               }
               else
               {
                   MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_010"), false);
               }
            }
            catch
            {
                MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_010"), true);
            }
        }